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 383: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 385: FND_MSG_PUB.Add;

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

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

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

Line 399: FND_MSG_PUB.Add;

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

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

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

Line 454: FND_MSG_PUB.ADD;

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

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

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

Line 479: FND_MSG_PUB.ADD;

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

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

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

Line 516: FND_MSG_PUB.Add;

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

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

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

Line 586: FND_MSG_PUB.ADD;

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

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

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

Line 614: FND_MSG_PUB.ADD;

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

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

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

Line 663: FND_MSG_PUB.ADD;

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

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

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

Line 742: FND_MSG_PUB.ADD;

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

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

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

Line 853: FND_MSG_PUB.ADD;

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

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

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

Line 973: FND_MSG_PUB.Add;

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

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

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

Line 997: FND_MSG_PUB.Add;

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

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

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

Line 1070: FND_MSG_PUB.ADD;

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

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

1487: 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');
1488: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_inv_cust_acct_site: '||l_ln_inv_cust_acct_site,1,'N');
1489: END IF;
1490: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1492: THEN
1493: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
1494: FND_MSG_PUB.ADD;
1495: END IF;

Line 1494: FND_MSG_PUB.ADD;

1490: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1491: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1492: THEN
1493: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
1494: FND_MSG_PUB.ADD;
1495: END IF;
1496: raise FND_API.G_EXC_ERROR;
1497: END IF;
1498:

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

1562: 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');
1563: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_end_cust_acct_site: '||l_ln_end_cust_acct_site,1,'N');
1564: END IF;
1565: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1566: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1567: THEN
1568: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');
1569: FND_MSG_PUB.ADD;
1570: END IF;

Line 1569: FND_MSG_PUB.ADD;

1565: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1566: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1567: THEN
1568: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');
1569: FND_MSG_PUB.ADD;
1570: END IF;
1571: raise FND_API.G_EXC_ERROR;
1572: END IF;
1573:

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

1802: IF (p_qte_line_dtl_tbl(l).return_reason_code IS NULL OR
1803: p_qte_line_dtl_tbl(l).return_reason_code = FND_API.G_MISS_CHAR) THEN
1804: IF(l_ret_reason_code_prof IS NULL) THEN
1805: l_return_status := FND_API.G_RET_STS_ERROR;
1806: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1807: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
1808: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_REASON_CODE', FALSE);
1809: FND_MSG_PUB.ADD;
1810: RAISE FND_API.G_EXC_ERROR;

Line 1809: FND_MSG_PUB.ADD;

1805: l_return_status := FND_API.G_RET_STS_ERROR;
1806: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1807: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
1808: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_REASON_CODE', FALSE);
1809: FND_MSG_PUB.ADD;
1810: RAISE FND_API.G_EXC_ERROR;
1811: END IF;
1812: ELSE
1813: l_line_tbl(i).return_reason_code := l_ret_reason_code_prof;

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

1926: IF (l_line_tbl(i).return_reason_code IS NULL OR
1927: l_line_tbl(i).return_reason_code = FND_API.G_MISS_CHAR) THEN
1928: IF(l_ret_reason_code_prof IS NULL) THEN
1929: l_return_status := FND_API.G_RET_STS_ERROR;
1930: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1931: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
1932: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_REASON_CODE', FALSE);
1933: FND_MSG_PUB.ADD;
1934: RAISE FND_API.G_EXC_ERROR;

Line 1933: FND_MSG_PUB.ADD;

1929: l_return_status := FND_API.G_RET_STS_ERROR;
1930: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1931: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
1932: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_REASON_CODE', FALSE);
1933: FND_MSG_PUB.ADD;
1934: RAISE FND_API.G_EXC_ERROR;
1935: END IF;
1936: ELSE
1937: l_line_tbl(i).return_reason_code := l_ret_reason_code_prof;

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

2085: 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');
2086: aso_debug_pub.add('mapq line: after cust_acct_site:l_ln_shp_cust_acct_site: '||l_ln_shp_cust_acct_site,1,'N');
2087: END IF;
2088: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2089: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2090: THEN
2091: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
2092: FND_MSG_PUB.ADD;
2093: END IF;

Line 2092: FND_MSG_PUB.ADD;

2088: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2089: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2090: THEN
2091: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');
2092: FND_MSG_PUB.ADD;
2093: END IF;
2094: raise FND_API.G_EXC_ERROR;
2095: END IF;
2096:

Line 2607: FND_MSG_PUB.ADD;

2603: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');
2604: ELSE
2605: FND_MESSAGE.Set_Name('ASO','ASO_SHIP_CUST_SITE_INACTIVE');
2606: END IF;
2607: FND_MSG_PUB.ADD;
2608: END IF;
2609: END IF;
2610: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2611: aso_debug_pub.add('site_use_id in get_acct_site_uses = ' || l_site_use_id,1,'N');

Line 2834: FND_MSG_PUB.ADD;

2830: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_ROLE_INACTIVE');
2831: ELSIF p_acct_site_type = 'SHIP_TO' THEN
2832: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_ROLE_INACTIVE');
2833: END IF;
2834: FND_MSG_PUB.ADD;
2835: END IF;
2836: CLOSE cust_role;
2837: END IF;
2838: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2917: FND_MSG_PUB.ADD;

2913:
2914: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2915: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
2916: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
2917: FND_MSG_PUB.ADD;
2918: raise FND_API.G_EXC_ERROR;
2919: END IF;
2920:
2921: ELSIF l_party_type = 'PARTY_RELATIONSHIP' THEN

Line 2935: FND_MSG_PUB.ADD;

2931: CLOSE account_user_cur;
2932: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2933: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
2934: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
2935: FND_MSG_PUB.ADD;
2936: raise FND_API.G_EXC_ERROR;
2937: END IF;
2938: END IF;
2939:

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

2949: ,x_acct_id => cust_account_id
2950: );
2951:
2952: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
2953: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2954: THEN
2955: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2956: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
2957: FND_MSG_PUB.ADD;

Line 2957: FND_MSG_PUB.ADD;

2953: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2954: THEN
2955: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
2956: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
2957: FND_MSG_PUB.ADD;
2958: END IF;
2959: raise FND_API.G_EXC_ERROR;
2960: END IF;
2961:

Line 3051: FND_MSG_PUB.ADD;

3047: -- this means there are ONLY inactive contacts
3048: x_cust_account_role_id := NULL;
3049: x_return_status := FND_API.G_RET_STS_ERROR;
3050: FND_MESSAGE.Set_Name('ASO','ASO_SOLD_CUST_ROLE_INACTIVE');
3051: FND_MSG_PUB.ADD;
3052: ELSE
3053: -- this means there are no contacts
3054: x_cust_account_role_id := NULL;
3055: END IF;