DBA Data[Home] [Help]

APPS.ASO_ORDER_INT dependencies on FND_MESSAGE

Line 254: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');

250: END IF;
251:
252: l_len_sqlerrm := Length(x_msg_data) ;
253: WHILE l_len_sqlerrm >= i LOOP
254: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
255: FND_MESSAGE.Set_token('MSG_TXT' , substr(x_msg_data,i,240));
256: i := i + 240;
257: FND_MSG_PUB.ADD;
258: END LOOP;

Line 255: FND_MESSAGE.Set_token('MSG_TXT' , substr(x_msg_data,i,240));

251:
252: l_len_sqlerrm := Length(x_msg_data) ;
253: WHILE l_len_sqlerrm >= i LOOP
254: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR');
255: FND_MESSAGE.Set_token('MSG_TXT' , substr(x_msg_data,i,240));
256: i := i + 240;
257: FND_MSG_PUB.ADD;
258: END LOOP;
259:

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

394: FETCH resource_id INTO x_header_sales_credit_TBL(i).RESOURCE_ID;
395: IF (resource_id%NOTFOUND) THEN
396: CLOSE resource_id;
397: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
398: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
399: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
400: FND_MSG_PUB.ADD;
401: END IF;
402: ELSE

Line 399: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);

395: IF (resource_id%NOTFOUND) THEN
396: CLOSE resource_id;
397: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
398: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
399: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
400: FND_MSG_PUB.ADD;
401: END IF;
402: ELSE
403: CLOSE resource_id;

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

458: FETCH resource_id into x_line_sales_credit_TBL(i).RESOURCE_ID;
459: IF (resource_id%NOTFOUND) THEN
460: CLOSE resource_id;
461: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
462: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
463: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
464: FND_MSG_PUB.ADD;
465: END IF;
466: ELSE

Line 463: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);

459: IF (resource_id%NOTFOUND) THEN
460: CLOSE resource_id;
461: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
462: FND_MESSAGE.Set_Name('ASO', 'API_INVALID_ID');
463: FND_MESSAGE.Set_Token('COLUMN', 'RESOURCE ID', FALSE);
464: FND_MSG_PUB.ADD;
465: END IF;
466: ELSE
467: CLOSE resource_id;

Line 1024: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

1020: IF FND_GLOBAL.User_Id IS NULL
1021: THEN
1022: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1023: THEN
1024: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1025: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1026: FND_MSG_PUB.ADD;
1027: END IF;
1028: RAISE FND_API.G_EXC_ERROR;

Line 1025: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

1021: THEN
1022: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1023: THEN
1024: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1025: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1026: FND_MSG_PUB.ADD;
1027: END IF;
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;

Line 1210: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

1206: IF FND_GLOBAL.User_Id IS NULL
1207: THEN
1208: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1209: THEN
1210: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1211: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1212: FND_MSG_PUB.ADD;
1213: END IF;
1214: RAISE FND_API.G_EXC_ERROR;

Line 1211: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

1207: THEN
1208: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1209: THEN
1210: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1211: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1212: FND_MSG_PUB.ADD;
1213: END IF;
1214: RAISE FND_API.G_EXC_ERROR;
1215: END IF;

Line 1462: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

1458: IF FND_GLOBAL.User_Id IS NULL
1459: THEN
1460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1461: THEN
1462: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1463: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1464: FND_MSG_PUB.ADD;
1465: END IF;
1466: RAISE FND_API.G_EXC_ERROR;

Line 1463: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

1459: THEN
1460: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1461: THEN
1462: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1463: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1464: FND_MSG_PUB.ADD;
1465: END IF;
1466: RAISE FND_API.G_EXC_ERROR;
1467: END IF;

Line 1825: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

1821: IF FND_GLOBAL.User_Id IS NULL
1822: THEN
1823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1824: THEN
1825: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1826: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1827: FND_MSG_PUB.ADD;
1828: END IF;
1829: RAISE FND_API.G_EXC_ERROR;

Line 1826: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

1822: THEN
1823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1824: THEN
1825: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1826: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1827: FND_MSG_PUB.ADD;
1828: END IF;
1829: RAISE FND_API.G_EXC_ERROR;
1830: END IF;

Line 1850: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');

1846:
1847: IF (l_split_pay_prof = 'N') THEN
1848: IF p_header_payment_tbl.count > 1 THEN
1849: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1850: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
1851: FND_MSG_PUB.ADD;
1852: END IF;
1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSIF p_header_payment_tbl.count = 1 THEN

Line 1857: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');

1853: RAISE FND_API.G_EXC_ERROR;
1854: ELSIF p_header_payment_tbl.count = 1 THEN
1855: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN
1856: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1857: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
1858: FND_MSG_PUB.ADD;
1859: END IF;
1860: RAISE FND_API.G_EXC_ERROR;
1861: END IF;

Line 1872: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');

1868: IF p_header_payment_tbl.count > 1 THEN
1869: FOR i IN 1..p_header_payment_tbl.count LOOP
1870: IF p_header_payment_tbl(i).payment_option <> 'SPLIT' THEN
1871: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1872: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
1873: FND_MSG_PUB.ADD;
1874: END IF;
1875: RAISE FND_API.G_EXC_ERROR;
1876: END IF;

Line 2061: FND_MESSAGE.Set_Name('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');

2057: FOR UPDATE OF QUOTE_STATUS_ID NOWAIT;
2058:
2059: IF SQL%NOTFOUND THEN
2060: aso_debug_pub.add('Create_OrderSQL%NOTFOUND ASO_API_QUOTE_ORDER_PROGRESS ');
2061: FND_MESSAGE.Set_Name('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');
2062: FND_MSG_PUB.ADD;
2063: RAISE FND_API.G_EXC_ERROR;
2064: End if;
2065: End If;

Line 2077: FND_MESSAGE.SET_NAME('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');

2073: Null;
2074:
2075: WHEN OTHERS THEN
2076: aso_debug_pub.add('In others ASO_API_QUOTE_ORDER_PROGRESS ');
2077: FND_MESSAGE.SET_NAME('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');
2078: FND_MSG_PUB.ADD;
2079: RAISE FND_API.G_EXC_ERROR;
2080: END;
2081: End If; */

Line 2154: FND_MESSAGE.SET_NAME('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');

2150: aso_debug_pub.add('SQLERRM : '|| SQLERRM, 1, 'N');
2151: End If;
2152:
2153: If FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) Then
2154: FND_MESSAGE.SET_NAME('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');
2155: FND_MSG_PUB.ADD;
2156: END If;
2157: RAISE FND_API.G_EXC_ERROR;
2158: END;

Line 2244: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');

2240: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2241: -- retrieve_oe_messages;
2242: IF x_msg_count > 0 THEN
2243: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2244: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2245: FND_MSG_PUB.ADD;
2246: END IF;
2247: END IF;
2248:

Line 2266: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');

2262: l_action_request_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS)
2263: THEN
2264: if x_msg_count > 0 then
2265: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2266: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2267: FND_MSG_PUB.ADD;
2268: END IF;
2269: end if;
2270: retrieve_oe_messages;

Line 2383: FND_MESSAGE.SET_NAME('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');

2379: WHEN OTHERS THEN
2380: null;
2381: /*** Start : Code change done for Bug 14358079 ***/
2382: IF SQLCODE = -54 THEN
2383: FND_MESSAGE.SET_NAME('ASO', 'ASO_API_QUOTE_ORDER_PROGRESS');
2384: FND_MSG_PUB.ADD;
2385: RAISE FND_API.G_EXC_ERROR;
2386: -- X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
2387: END IF;

Line 2594: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');

2590: IF FND_GLOBAL.User_Id IS NULL
2591: THEN
2592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2593: THEN
2594: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
2595: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2596: FND_MSG_PUB.ADD;
2597: END IF;
2598: RAISE FND_API.G_EXC_ERROR;

Line 2595: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);

2591: THEN
2592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2593: THEN
2594: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
2595: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2596: FND_MSG_PUB.ADD;
2597: END IF;
2598: RAISE FND_API.G_EXC_ERROR;
2599: END IF;

Line 2616: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');

2612: p_qte_rec.order_id = FND_API.G_MISS_NUM THEN
2613:
2614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2615: THEN
2616: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
2617: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_ID', FALSE);
2618: FND_MSG_PUB.ADD;
2619: END IF;
2620: raise FND_API.G_EXC_ERROR;

Line 2617: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_ID', FALSE);

2613:
2614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2615: THEN
2616: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
2617: FND_MESSAGE.Set_Token('COLUMN', 'ORDER_ID', FALSE);
2618: FND_MSG_PUB.ADD;
2619: END IF;
2620: raise FND_API.G_EXC_ERROR;
2621: END IF;

Line 2630: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');

2626:
2627: IF (l_split_pay_prof = 'N') THEN
2628: IF p_header_payment_tbl.count > 1 THEN
2629: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2630: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
2631: FND_MSG_PUB.ADD;
2632: END IF;
2633: RAISE FND_API.G_EXC_ERROR;
2634: ELSIF p_header_payment_tbl.count = 1 THEN

Line 2637: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');

2633: RAISE FND_API.G_EXC_ERROR;
2634: ELSIF p_header_payment_tbl.count = 1 THEN
2635: IF p_header_payment_tbl(1).payment_option = 'SPLIT' THEN
2636: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2637: FND_MESSAGE.Set_Name('ASO', 'ASO_API_SPLIT_PAYMENT');
2638: FND_MSG_PUB.ADD;
2639: END IF;
2640: RAISE FND_API.G_EXC_ERROR;
2641: END IF;

Line 2651: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');

2647: IF p_header_payment_tbl.count > 1 THEN
2648: FOR i IN 1..p_header_payment_tbl.count LOOP
2649: IF p_header_payment_tbl(i).payment_option <> 'SPLIT' THEN
2650: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2651: FND_MESSAGE.Set_Name('ASO', 'ASO_API_TOO_MANY_PAYMENTS');
2652: FND_MSG_PUB.ADD;
2653: END IF;
2654: RAISE FND_API.G_EXC_ERROR;
2655: END IF;

Line 2893: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');

2889:
2890: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2891: IF x_msg_count > 0 THEN
2892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2893: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2894: FND_MSG_PUB.ADD;
2895: END IF;
2896: END IF;
2897:

Line 2913: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');

2909: p_control_rec.book_flag = FND_API.G_TRUE AND
2910: l_request_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2911: if x_msg_count > 0 then
2912: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2913: FND_MESSAGE.Set_Name('ASO', 'ASO_OM_ERROR_MSG');
2914: FND_MSG_PUB.ADD;
2915: END IF;
2916: end if;
2917: retrieve_oe_messages;

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

3429:
3430: CLOSE C_get_cust_id_from_party_id;
3431:
3432: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3433: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
3434: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
3435: FND_MSG_PUB.ADD;
3436: raise FND_API.G_EXC_ERROR;
3437: END IF;

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

3430: CLOSE C_get_cust_id_from_party_id;
3431:
3432: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3433: FND_MESSAGE.Set_Name('ASO', 'ASO_MULTIPLE_CUST_ACCOUNT');
3434: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
3435: FND_MSG_PUB.ADD;
3436: raise FND_API.G_EXC_ERROR;
3437: END IF;
3438:

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

3450:
3451: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3453: THEN
3454: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3455: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
3456: FND_MSG_PUB.ADD;
3457: END IF;
3458: raise FND_API.G_EXC_ERROR;

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

3451: IF l_Return_Status <> FND_API.G_RET_STS_SUCCESS THEN
3452: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3453: THEN
3454: FND_MESSAGE.Set_Name('ASO', 'ASO_CUST_ACCOUNT');
3455: FND_MESSAGE.Set_Token('ID', to_char( p_qte_rec.party_id), FALSE);
3456: FND_MSG_PUB.ADD;
3457: END IF;
3458: raise FND_API.G_EXC_ERROR;
3459: END IF;