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 386: fnd_message.set_name('ASO', 'ASO_QTE_MISSING_CONV_TYPE');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
1863: END IF;
1864: ELSE

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

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

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

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;
1987: END IF;
1988: ELSE

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

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

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

2655: IF cust_acct_site_status <> 'A' OR cust_site_use_status <> 'A' THEN
2656: l_site_use_id := NULL;
2657: x_return_status := FND_API.G_RET_STS_ERROR;
2658: IF p_acct_site_type = 'BILL_TO' THEN
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;

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

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

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

2880: IF (cust_role%NOTFOUND) THEN
2881: l_cust_account_role_id := NULL;
2882: x_return_status := FND_API.G_RET_STS_ERROR;
2883: IF p_acct_site_type = 'BILL_TO' THEN
2884: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_ROLE_INACTIVE');
2885: ELSIF p_acct_site_type = 'END_USER' THEN
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');

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

2882: x_return_status := FND_API.G_RET_STS_ERROR;
2883: IF p_acct_site_type = 'BILL_TO' THEN
2884: FND_MESSAGE.Set_Name('ASO','ASO_INV_CUST_ROLE_INACTIVE');
2885: ELSIF p_acct_site_type = 'END_USER' THEN
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
3014: END IF;
3015: raise FND_API.G_EXC_ERROR;
3016: END IF;

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

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