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_MESSAGE

Line 384: fnd_message.set_name('ASO', 'ASO_QTE_MISSING_CONV_TYPE');

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;
388: END IF;

Line 397: fnd_message.set_name('ASO', 'ASO_QTE_MISSING_CONV_RATE');

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;
401: RAISE FND_API.G_EXC_ERROR;

Line 398: fnd_message.set_token('CURRENCY_CODE', p_qte_rec.currency_code, FALSE);

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;
401: RAISE FND_API.G_EXC_ERROR;
402: END IF;

Line 452: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');

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;
456: raise FND_API.G_EXC_ERROR;

Line 453: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT_ID', FALSE);

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;
456: raise FND_API.G_EXC_ERROR;
457: END IF;

Line 477: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');

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;
480: END IF;
481: raise FND_API.G_EXC_ERROR;

Line 478: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);

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;
480: END IF;
481: raise FND_API.G_EXC_ERROR;
482: END IF;

Line 513: -- fnd_message.set_name('ASO', 'MISSING_CUST_ACCOUNT_ID');

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;
517: END IF;

Line 514: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_COLUMN');

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;
517: END IF;
518: RAISE FND_API.G_EXC_ERROR;

Line 515: FND_MESSAGE.Set_Token('COLUMN', 'CUST_ACCOUNT_ID', FALSE);

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;
517: END IF;
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;

Line 585: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_ORG_CON_ACT_CRS');

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;
588: raise FND_API.G_EXC_ERROR;
589: END IF;

Line 612: FND_MESSAGE.Set_Name('ASO', 'ASO_ORG_CONTACT');

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;
615: END IF;
616: raise FND_API.G_EXC_ERROR;

Line 613: FND_MESSAGE.Set_Token('ID', to_char(p_qte_rec.org_contact_id), FALSE);

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;
615: END IF;
616: raise FND_API.G_EXC_ERROR;
617: END IF;

Line 662: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');

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;
665: raise FND_API.G_EXC_ERROR;
666: END IF;

Line 741: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');

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;
744: raise FND_API.G_EXC_ERROR;
745: END IF;

Line 852: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_SHP_SITE_AC_CRS');

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;
855: raise FND_API.G_EXC_ERROR;
856: END IF;

Line 972: FND_MESSAGE.Set_Name('ASO', 'ASO_SALESREP');

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;
976: END IF;

Line 992: -- FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');

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);
994: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_DEFAULT_VALUE');
995: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);
996:

Line 993: -- FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_PERSON_ID', FALSE);

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);
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;

Line 994: FND_MESSAGE.Set_Name('ASO', 'ASO_NO_DEFAULT_VALUE');

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);
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;

Line 995: FND_MESSAGE.Set_Token('PROFILE', 'ASO_DEFAULT_SALESREP', TRUE);

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);
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

Line 1068: FND_MESSAGE.Set_Name('ASO', 'ASO_API_INVALID_ID');

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;
1072: END IF;

Line 1069: FND_MESSAGE.Set_Token('COLUMN', 'QUOTE_SOURCE_CODE', FALSE);

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;
1072: END IF;
1073: -- p_qte_rec.quote_source_code := 'CRM Apps';

Line 1493: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');

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;
1496: raise FND_API.G_EXC_ERROR;
1497: END IF;

Line 1568: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_END_SITE_AC_CRS');

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;
1571: raise FND_API.G_EXC_ERROR;
1572: END IF;

Line 1807: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

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;
1811: END IF;

Line 1808: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_REASON_CODE', FALSE);

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;
1811: END IF;
1812: ELSE

Line 1931: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');

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;
1935: END IF;

Line 1932: FND_MESSAGE.Set_Token('COLUMN', 'RETURN_REASON_CODE', FALSE);

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;
1935: END IF;
1936: ELSE

Line 2091: FND_MESSAGE.Set_Name('ASO', 'ASO_VALIDATE_INV_SITE_AC_CRS');

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;
2094: raise FND_API.G_EXC_ERROR;
2095: END IF;

Line 2603: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_SITE_INACTIVE');

2599: IF cust_acct_site_status <> 'A' OR cust_site_use_status <> 'A' THEN
2600: l_site_use_id := NULL;
2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: IF p_acct_site_type = 'BILL_TO' THEN
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;

Line 2605: FND_MESSAGE.Set_Name('ASO','ASO_SHIP_CUST_SITE_INACTIVE');

2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: IF p_acct_site_type = 'BILL_TO' THEN
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;

Line 2828: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_ROLE_INACTIVE');

2824: IF (cust_role%NOTFOUND) THEN
2825: l_cust_account_role_id := NULL;
2826: x_return_status := FND_API.G_RET_STS_ERROR;
2827: IF p_acct_site_type = 'BILL_TO' THEN
2828: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_ROLE_INACTIVE');
2829: ELSIF p_acct_site_type = 'END_USER' THEN
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');

Line 2830: FND_MESSAGE.Set_Name('ASO','ASO_END_CUST_ROLE_INACTIVE');

2826: x_return_status := FND_API.G_RET_STS_ERROR;
2827: IF p_acct_site_type = 'BILL_TO' THEN
2828: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_ROLE_INACTIVE');
2829: ELSIF p_acct_site_type = 'END_USER' THEN
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;

Line 2832: FND_MESSAGE.Set_Name('ASO','ASO_SHP_CUST_ROLE_INACTIVE');

2828: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_ROLE_INACTIVE');
2829: ELSIF p_acct_site_type = 'END_USER' THEN
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;

Line 2915: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');

2911:
2912: CLOSE C_get_cust_id_from_party_id;
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;

Line 2916: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);

2912: CLOSE C_get_cust_id_from_party_id;
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:

Line 2933: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');

2929: EXIT WHEN C_get_cust_id_from_party_id%NOTFOUND;
2930: END LOOP;
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;

Line 2934: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);

2930: END LOOP;
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;

Line 2955: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');

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;
2958: END IF;
2959: raise FND_API.G_EXC_ERROR;

Line 2956: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);

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;
2958: END IF;
2959: raise FND_API.G_EXC_ERROR;
2960: END IF;

Line 3050: FND_MESSAGE.Set_Name('ASO','ASO_SOLD_CUST_ROLE_INACTIVE');

3046: IF C_inactive_contact%FOUND THEN
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;