eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on FND_MSG_PUB

Line 385: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

381:
382: IF (l_functional_currency <> p_qte_rec.currency_code) THEN
383:
384: IF (l_conversion_type is NULL) THEN
385: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
386: fnd_message.set_name('ASO', 'ASO_QTE_MISSING_CONV_TYPE');
387: FND_MSG_PUB.Add;
388: END IF;
389: RAISE FND_API.G_EXC_ERROR;

Line 387: FND_MSG_PUB.Add;

383:
384: IF (l_conversion_type is NULL) THEN
385: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
386: fnd_message.set_name('ASO', 'ASO_QTE_MISSING_CONV_TYPE');
387: FND_MSG_PUB.Add;
388: END IF;
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391:

Line 398: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

394: l_header_rec.conversion_rate_date := FND_API.G_MISS_DATE;
395: ELSE
396: IF (p_qte_rec.exchange_rate is NULL OR
397: p_qte_rec.exchange_rate = FND_API.G_MISS_NUM) THEN
398: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
399: fnd_message.set_name('ASO', 'ASO_QTE_MISSING_CONV_RATE');
400: fnd_message.set_token('CURRENCY_CODE', p_qte_rec.currency_code, FALSE);
401: FND_MSG_PUB.Add;
402: END IF;

Line 401: FND_MSG_PUB.Add;

397: p_qte_rec.exchange_rate = FND_API.G_MISS_NUM) THEN
398: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
399: fnd_message.set_name('ASO', 'ASO_QTE_MISSING_CONV_RATE');
400: fnd_message.set_token('CURRENCY_CODE', p_qte_rec.currency_code, FALSE);
401: FND_MSG_PUB.Add;
402: END IF;
403: RAISE FND_API.G_EXC_ERROR;
404: END IF;
405: l_header_rec.conversion_rate := p_qte_rec.exchange_rate;

Line 453: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

449: IF aso_debug_pub.g_debug_flag = 'Y' THEN
450: aso_debug_pub.add(' done validating customer.return status = ' || l_return_status ,1, 'Y');
451: END IF;
452: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
453: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
454: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
455: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT_ID', FALSE);
456: FND_MSG_PUB.ADD;
457: END IF;

Line 456: FND_MSG_PUB.ADD;

452: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
453: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
454: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
455: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT_ID', FALSE);
456: FND_MSG_PUB.ADD;
457: END IF;
458: raise FND_API.G_EXC_ERROR;
459: END IF;
460: ELSE

Line 477: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

473: x_msg_count => l_msg_count,
474: x_msg_data => l_msg_data);
475:
476: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
477: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
478: THEN
479: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
480: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
481: FND_MSG_PUB.ADD;

Line 481: FND_MSG_PUB.ADD;

477: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
478: THEN
479: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
480: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
481: FND_MSG_PUB.ADD;
482: END IF;
483: raise FND_API.G_EXC_ERROR;
484: END IF;
485: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 514: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

510: aso_debug_pub.add('after query = ' || l_header_rec.sold_to_org_id, 1, 'Y');
511: END IF;
512: CLOSE get_cust_account_id;
513: IF l_header_rec.sold_to_org_id is NULL THEN
514: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
515: -- fnd_message.set_name('ASO', 'MISSING_CUST_ACCOUNT_ID');
516: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
517: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT_ID', FALSE);
518: FND_MSG_PUB.Add;

Line 518: FND_MSG_PUB.Add;

514: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
515: -- fnd_message.set_name('ASO', 'MISSING_CUST_ACCOUNT_ID');
516: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');
517: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT_ID', FALSE);
518: FND_MSG_PUB.Add;
519: END IF;
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522: END IF;

Line 585: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

581: IF aso_debug_pub.g_debug_flag = 'Y' THEN
582: aso_debug_pub.add('after get org contact. sold_to_contact_id = ' || l_header_rec.sold_to_contact_id ,1, 'N');
583: END IF;
584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
585: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
586: THEN
587: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_ORG_CON_ACT_CRS');
588: FND_MSG_PUB.ADD;
589: END IF;

Line 588: FND_MSG_PUB.ADD;

584: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
585: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
586: THEN
587: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_ORG_CON_ACT_CRS');
588: FND_MSG_PUB.ADD;
589: END IF;
590: raise FND_API.G_EXC_ERROR;
591: END IF;
592:

Line 612: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

608: IF aso_debug_pub.g_debug_flag = 'Y' THEN
609: aso_debug_pub.add('after create contact role. sold_to_contact_id = ' || l_header_rec.sold_to_contact_id ,1, 'Y');
610: END IF;
611: IF L_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
612: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
613: THEN
614: FND_MESSAGE.Set_Name('ASO', 'ASO_ORG_CONTACT');
615: FND_MESSAGE.Set_Token('ID', to_char(p_qte_rec.org_contact_id), FALSE);
616: FND_MSG_PUB.ADD;

Line 616: FND_MSG_PUB.ADD;

612: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
613: THEN
614: FND_MESSAGE.Set_Name('ASO', 'ASO_ORG_CONTACT');
615: FND_MESSAGE.Set_Token('ID', to_char(p_qte_rec.org_contact_id), FALSE);
616: FND_MSG_PUB.ADD;
617: END IF;
618: raise FND_API.G_EXC_ERROR;
619: END IF;
620: END IF;

Line 662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

658: aso_debug_pub.add('site_use_id after deriving invoice = ' || l_header_rec.invoice_to_org_id,1,'Y');
659: aso_debug_pub.add('inv_acct_site after deriving invoice = ' || l_hd_inv_cust_acct_site,1,'Y');
660: END IF;
661: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
663: THEN
664: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
665: FND_MSG_PUB.ADD;
666: END IF;

Line 665: FND_MSG_PUB.ADD;

661: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
662: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
663: THEN
664: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
665: FND_MSG_PUB.ADD;
666: END IF;
667: raise FND_API.G_EXC_ERROR;
668: END IF;
669:

Line 741: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

737: aso_debug_pub.add('site_use_id after deriving End_Customer = ' || l_header_rec.End_Customer_Site_Use_Id,1,'Y');
738: aso_debug_pub.add('inv_acct_site after deriving End_Customer = ' || l_hd_end_cust_acct_site,1,'Y');
739: END IF;
740: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
741: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
742: THEN
743: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');
744: FND_MSG_PUB.ADD;
745: END IF;

Line 744: FND_MSG_PUB.ADD;

740: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
741: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
742: THEN
743: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');
744: FND_MSG_PUB.ADD;
745: END IF;
746: raise FND_API.G_EXC_ERROR;
747: END IF;
748:

Line 852: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

848: aso_debug_pub.add('ship to org after deriving = ' || l_header_rec.ship_to_org_id, 1, 'N');
849: aso_debug_pub.add('ship acct site after deriving = ' || l_hd_shp_cust_acct_site, 1, 'N');
850: END IF;
851: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
852: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
853: THEN
854: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_SITE_AC_CRS');
855: FND_MSG_PUB.ADD;
856: END IF;

Line 855: FND_MSG_PUB.ADD;

851: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
852: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
853: THEN
854: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_SITE_AC_CRS');
855: FND_MSG_PUB.ADD;
856: END IF;
857: raise FND_API.G_EXC_ERROR;
858: END IF;
859:

Line 973: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

969: --l_header_rec.salesrep_id := l_default_person_id_prof;
970:
971: ELSE
972: IF l_validate_salesrep_prof = 'Y' THEN
973: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
974: FND_MESSAGE.Set_Name('ASO', 'ASO_SALESREP');
975: FND_MSG_PUB.Add;
976: END IF;
977: END IF;

Line 975: FND_MSG_PUB.Add;

971: ELSE
972: IF l_validate_salesrep_prof = 'Y' THEN
973: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
974: FND_MESSAGE.Set_Name('ASO', 'ASO_SALESREP');
975: FND_MSG_PUB.Add;
976: END IF;
977: END IF;
978: END IF;
979: END IF;

Line 991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

987: IF (l_header_rec.salesrep_id IS NULL OR
988: l_header_rec.salesrep_id = FND_API.G_MISS_NUM) AND
989: l_om_defaulting_prof = 'N' AND
990: l_validate_salesrep_prof = 'N' THEN
991: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
992:
993: -- Created new message to display the error message more appropriately - Girish Bug 4654938
994: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
995: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);

Line 999: FND_MSG_PUB.Add;

995: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);
996: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_DEFAULT_VALUE');
997: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
998:
999: FND_MSG_PUB.Add;
1000: END IF;
1001: ELSE
1002: IF l_om_defaulting_prof = 'Y' AND
1003: (l_header_rec.salesrep_id IS NULL OR

Line 1069: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1065:
1066: IF (l_om_defaulting_prof = 'N') THEN
1067: l_quote_source := 'CRM Apps';
1068: ELSE
1069: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1070: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1071: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_SOURCE_CODE', FALSE);
1072: FND_MSG_PUB.ADD;
1073: END IF;

Line 1072: FND_MSG_PUB.ADD;

1068: ELSE
1069: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1070: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');
1071: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_SOURCE_CODE', FALSE);
1072: FND_MSG_PUB.ADD;
1073: END IF;
1074: END IF;
1075: -- p_qte_rec.quote_source_code := 'CRM Apps';
1076:

Line 1535: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1531: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).invoice_to_org_id: '||l_line_tbl(i).invoice_to_org_id,1,'N');
1532: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_inv_cust_acct_site: '||l_ln_inv_cust_acct_site,1,'N');
1533: END IF;
1534: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1535: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1536: THEN
1537: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
1538: FND_MSG_PUB.ADD;
1539: END IF;

Line 1538: FND_MSG_PUB.ADD;

1534: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1535: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1536: THEN
1537: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
1538: FND_MSG_PUB.ADD;
1539: END IF;
1540: raise FND_API.G_EXC_ERROR;
1541: END IF;
1542:

Line 1610: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

1606: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).End_Customer_site_use_id: '||l_line_tbl(i).End_Customer_site_use_id,1,'N');
1607: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_end_cust_acct_site: '||l_ln_end_cust_acct_site,1,'N');
1608: END IF;
1609: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1610: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1611: THEN
1612: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');
1613: FND_MSG_PUB.ADD;
1614: END IF;

Line 1613: FND_MSG_PUB.ADD;

1609: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1610: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1611: THEN
1612: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');
1613: FND_MSG_PUB.ADD;
1614: END IF;
1615: raise FND_API.G_EXC_ERROR;
1616: END IF;
1617:

Line 1858: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1854: IF (p_qte_line_dtl_tbl(l).return_reason_code IS NULL OR
1855: p_qte_line_dtl_tbl(l).return_reason_code = FND_API.G_MISS_CHAR) THEN
1856: IF(l_ret_reason_code_prof IS NULL) THEN
1857: l_return_status := FND_API.G_RET_STS_ERROR;
1858: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1859: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
1860: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_REASON_CODE', FALSE);
1861: FND_MSG_PUB.ADD;
1862: RAISE FND_API.G_EXC_ERROR;

Line 1861: FND_MSG_PUB.ADD;

1857: l_return_status := FND_API.G_RET_STS_ERROR;
1858: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1859: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
1860: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_REASON_CODE', FALSE);
1861: FND_MSG_PUB.ADD;
1862: RAISE FND_API.G_EXC_ERROR;
1863: END IF;
1864: ELSE
1865: l_line_tbl(i).return_reason_code := l_ret_reason_code_prof;

Line 1982: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1978: IF (l_line_tbl(i).return_reason_code IS NULL OR
1979: l_line_tbl(i).return_reason_code = FND_API.G_MISS_CHAR) THEN
1980: IF(l_ret_reason_code_prof IS NULL) THEN
1981: l_return_status := FND_API.G_RET_STS_ERROR;
1982: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1983: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
1984: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_REASON_CODE', FALSE);
1985: FND_MSG_PUB.ADD;
1986: RAISE FND_API.G_EXC_ERROR;

Line 1985: FND_MSG_PUB.ADD;

1981: l_return_status := FND_API.G_RET_STS_ERROR;
1982: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1983: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
1984: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_REASON_CODE', FALSE);
1985: FND_MSG_PUB.ADD;
1986: RAISE FND_API.G_EXC_ERROR;
1987: END IF;
1988: ELSE
1989: l_line_tbl(i).return_reason_code := l_ret_reason_code_prof;

Line 2141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

2137: aso_debug_pub.add('mapq line: after cust_acct_site:l_line_tbl(i).ship_to_org_id: '||l_line_tbl(i).ship_to_org_id,1,'N');
2138: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_shp_cust_acct_site: '||l_ln_shp_cust_acct_site,1,'N');
2139: END IF;
2140: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2142: THEN
2143: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
2144: FND_MSG_PUB.ADD;
2145: END IF;

Line 2144: FND_MSG_PUB.ADD;

2140: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2142: THEN
2143: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
2144: FND_MSG_PUB.ADD;
2145: END IF;
2146: raise FND_API.G_EXC_ERROR;
2147: END IF;
2148:

Line 2663: FND_MSG_PUB.ADD;

2659: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2660: ELSE
2661: FND_MESSAGE.Set_Name('ASO','ASO_SHIP_CUST_SITE_INACTIVE');
2662: END IF;
2663: FND_MSG_PUB.ADD;
2664: END IF;
2665: END IF;
2666: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2667: aso_debug_pub.add('site_use_id in get_acct_site_uses = ' || l_site_use_id,1,'N');

Line 2890: FND_MSG_PUB.ADD;

2886: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_ROLE_INACTIVE');
2887: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2888: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_ROLE_INACTIVE');
2889: END IF;
2890: FND_MSG_PUB.ADD;
2891: END IF;
2892: CLOSE cust_role;
2893: END IF;
2894: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2973: FND_MSG_PUB.ADD;

2969:
2970: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2971: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
2972: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
2973: FND_MSG_PUB.ADD;
2974: raise FND_API.G_EXC_ERROR;
2975: END IF;
2976:
2977: ELSIF l_party_type = 'PARTY_RELATIONSHIP' THEN

Line 2991: FND_MSG_PUB.ADD;

2987: CLOSE account_user_cur;
2988: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2989: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
2990: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
2991: FND_MSG_PUB.ADD;
2992: raise FND_API.G_EXC_ERROR;
2993: END IF;
2994: END IF;
2995:

Line 3009: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

3005: ,x_acct_id => cust_account_id
3006: );
3007:
3008: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3009: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3010: THEN
3011: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3012: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
3013: FND_MSG_PUB.ADD;

Line 3013: FND_MSG_PUB.ADD;

3009: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3010: THEN
3011: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3012: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
3013: FND_MSG_PUB.ADD;
3014: END IF;
3015: raise FND_API.G_EXC_ERROR;
3016: END IF;
3017:

Line 3107: FND_MSG_PUB.ADD;

3103: -- this means there are ONLY inactive contacts
3104: x_cust_account_role_id := NULL;
3105: x_return_status := FND_API.G_RET_STS_ERROR;
3106: FND_MESSAGE.Set_Name('ASO','ASO_SOLD_CUST_ROLE_INACTIVE');
3107: FND_MSG_PUB.ADD;
3108: ELSE
3109: -- this means there are no contacts
3110: x_cust_account_role_id := NULL;
3111: END IF;