DBA Data[Home] [Help]

APPS.ASO_SERVICE_CONTRACTS_INT dependencies on FND_MSG_PUB

Line 122: FND_MSG_PUB.initialize;

118:
119: -- Initialize message list if p_init_msg_list is set to TRUE.
120: IF FND_API.to_Boolean( p_init_msg_list )
121: THEN
122: FND_MSG_PUB.initialize;
123: END IF;
124:
125: -- Debug Message
126:

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

135: -- Validate Environment
136: -- ******************************************************************
137: IF FND_GLOBAL.User_Id IS NULL
138: THEN
139: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
140: THEN
141: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
142: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
143: FND_MSG_PUB.ADD;

Line 143: FND_MSG_PUB.ADD;

139: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
140: THEN
141: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
142: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
143: FND_MSG_PUB.ADD;
144: END IF;
145: RAISE FND_API.G_EXC_ERROR;
146: END IF;
147: OPEN C_cust_id(P_Qte_Line_rec.quote_header_id);

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

173:
174: IF C_qln%NOTFOUND THEN
175: CLOSE C_qln;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
178: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
179: FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
180: FND_MSG_PUB.Add;
181: END IF;

Line 180: FND_MSG_PUB.Add;

176: x_return_status := FND_API.G_RET_STS_ERROR;
177: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
178: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_INFO');
179: FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
180: FND_MSG_PUB.Add;
181: END IF;
182: raise FND_API.G_EXC_ERROR;
183: ELSE
184: CLOSE C_qln;

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

191:
192: IF C_item1%NOTFOUND OR l_serviceable_flag <> 'Y' THEN
193: CLOSE C_item1;
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
196: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO1');
197: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
198: FND_MSG_PUB.Add;
199: END IF;

Line 198: FND_MSG_PUB.Add;

194: x_return_status := FND_API.G_RET_STS_ERROR;
195: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
196: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO1');
197: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
198: FND_MSG_PUB.Add;
199: END IF;
200: raise FND_API.G_EXC_ERROR;
201:
202: END IF;

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

233: END IF;
234:
235: IF l_Available_YN = 'N' THEN
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
238: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
239: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
240: FND_MSG_PUB.Add;
241: END IF;

Line 240: FND_MSG_PUB.Add;

236: x_return_status := FND_API.G_RET_STS_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
238: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
239: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
240: FND_MSG_PUB.Add;
241: END IF;
242: raise FND_API.G_EXC_ERROR;
243: END IF;
244: END IF;

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

259: FETCH C_cs_item INTO l_inventory_item_id;
260: IF C_cs_item%NOTFOUND THEN
261: CLOSE C_cs_item;
262: x_return_status := FND_API.G_RET_STS_ERROR;
263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
264: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO3');
265: --FND_MESSAGE.Set_Token('COLUMN','INSTALLBASE', FALSE);
266: FND_MSG_PUB.Add;
267: END IF;

Line 266: FND_MSG_PUB.Add;

262: x_return_status := FND_API.G_RET_STS_ERROR;
263: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
264: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO3');
265: --FND_MESSAGE.Set_Token('COLUMN','INSTALLBASE', FALSE);
266: FND_MSG_PUB.Add;
267: END IF;
268: raise FND_API.G_EXC_ERROR;
269: END IF;
270: CLOSE C_cs_item;

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

309: X_Available_YN => l_Available_YN
310: );
311: IF l_Available_YN = 'N' THEN
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
314: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
315: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
316: FND_MSG_PUB.Add;
317: END IF;

Line 316: FND_MSG_PUB.Add;

312: x_return_status := FND_API.G_RET_STS_ERROR;
313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
314: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
315: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
316: FND_MSG_PUB.Add;
317: END IF;
318: raise FND_API.G_EXC_ERROR;
319: END IF;
320: -- END IF;

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

334: FETCH C_ord_item INTO l_inventory_item_id;
335: IF C_ord_item%NOTFOUND THEN
336: CLOSE C_ord_item;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
339: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO3');
340: --FND_MESSAGE.Set_Token('COLUMN','ORDER_LINE_ID', FALSE);
341: FND_MSG_PUB.Add;
342: END IF;

Line 341: FND_MSG_PUB.Add;

337: x_return_status := FND_API.G_RET_STS_ERROR;
338: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
339: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO3');
340: --FND_MESSAGE.Set_Token('COLUMN','ORDER_LINE_ID', FALSE);
341: FND_MSG_PUB.Add;
342: END IF;
343: raise FND_API.G_EXC_ERROR;
344: END IF;
345: CLOSE C_ord_item;

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

356: X_Available_YN => l_Available_YN
357: );
358: IF l_Available_YN = 'N' THEN
359: x_return_status := FND_API.G_RET_STS_ERROR;
360: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
361: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
362: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
363: FND_MSG_PUB.Add;
364: END IF;

Line 363: FND_MSG_PUB.Add;

359: x_return_status := FND_API.G_RET_STS_ERROR;
360: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
361: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
362: --FND_MESSAGE.Set_Token('COLUMN','SERVICE_REF_LINE_ID', FALSE);
363: FND_MSG_PUB.Add;
364: END IF;
365: raise FND_API.G_EXC_ERROR;
366: END IF;
367: --END IF;

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

412: X_Available_YN => l_Available_YN
413: );
414: IF l_Available_YN = 'N' THEN
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
417: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
418: FND_MSG_PUB.Add;
419: END IF;
420: raise FND_API.G_EXC_ERROR;

Line 418: FND_MSG_PUB.Add;

414: IF l_Available_YN = 'N' THEN
415: x_return_status := FND_API.G_RET_STS_ERROR;
416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
417: FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_SRV_INFO2');
418: FND_MSG_PUB.Add;
419: END IF;
420: raise FND_API.G_EXC_ERROR;
421: END IF;
422: /*** End: BugNo 8647883: R12.1.2 Service reference SUN ER ***/

Line 452: FND_MSG_PUB.Count_And_Get

448:
449:
450:
451: -- Standard call to get message count and if count is 1, get message info.
452: FND_MSG_PUB.Count_And_Get
453: ( p_count => x_msg_count,
454: p_data => x_msg_data
455: );
456:

Line 462: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

458: WHEN FND_API.G_EXC_ERROR THEN
459: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
460: P_API_NAME => L_API_NAME
461: ,P_PKG_NAME => G_PKG_NAME
462: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
463: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
464: ,P_SQLCODE => SQLCODE
465: ,P_SQLERRM => SQLERRM
466: ,X_MSG_COUNT => X_MSG_COUNT

Line 474: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
472: P_API_NAME => L_API_NAME
473: ,P_PKG_NAME => G_PKG_NAME
474: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
475: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
476: ,P_SQLCODE => SQLCODE
477: ,P_SQLERRM => SQLERRM
478: ,X_MSG_COUNT => X_MSG_COUNT

Line 541: FND_MSG_PUB.initialize;

537:
538: -- Initialize message list if p_init_msg_list is set to TRUE.
539: IF FND_API.to_Boolean( p_init_msg_list )
540: THEN
541: FND_MSG_PUB.initialize;
542: END IF;
543:
544:
545: -- Initialize API return status to SUCCESS

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

553: -- Validate Environment
554: -- ******************************************************************
555: IF FND_GLOBAL.User_Id IS NULL
556: THEN
557: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
558: THEN
559: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
560: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
561: FND_MSG_PUB.ADD;

Line 561: FND_MSG_PUB.ADD;

557: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
558: THEN
559: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
560: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
561: FND_MSG_PUB.ADD;
562: END IF;
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565:

Line 631: FND_MSG_PUB.Count_And_Get

627:
628:
629:
630: -- Standard call to get message count and if count is 1, get message info.
631: FND_MSG_PUB.Count_And_Get
632: ( p_count => x_msg_count,
633: p_data => x_msg_data
634: );
635:

Line 641: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

637: WHEN FND_API.G_EXC_ERROR THEN
638: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
639: P_API_NAME => L_API_NAME
640: ,P_PKG_NAME => G_PKG_NAME
641: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
642: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
643: ,X_MSG_COUNT => X_MSG_COUNT
644: ,X_MSG_DATA => X_MSG_DATA
645: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
648: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME
650: ,P_PKG_NAME => G_PKG_NAME
651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
652: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
653: ,X_MSG_COUNT => X_MSG_COUNT
654: ,X_MSG_DATA => X_MSG_DATA
655: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 705: FND_MSG_PUB.initialize;

701:
702: -- Initialize message list if p_init_msg_list is set to TRUE.
703: IF FND_API.to_Boolean( p_init_msg_list )
704: THEN
705: FND_MSG_PUB.initialize;
706: END IF;
707:
708:
709: -- Initialize API return status to SUCCESS

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

717: -- Validate Environment
718: -- ******************************************************************
719: IF FND_GLOBAL.User_Id IS NULL
720: THEN
721: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
722: THEN
723: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
724: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
725: FND_MSG_PUB.ADD;

Line 725: FND_MSG_PUB.ADD;

721: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
722: THEN
723: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
724: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
725: FND_MSG_PUB.ADD;
726: END IF;
727: RAISE FND_API.G_EXC_ERROR;
728: END IF;
729:

Line 816: FND_MSG_PUB.Count_And_Get

812: */
813:
814:
815: -- Standard call to get message count and if count is 1, get message info.
816: FND_MSG_PUB.Count_And_Get
817: ( p_count => x_msg_count,
818: p_data => x_msg_data
819: );
820:

Line 826: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

822: WHEN FND_API.G_EXC_ERROR THEN
823: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
824: P_API_NAME => L_API_NAME
825: ,P_PKG_NAME => G_PKG_NAME
826: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
827: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
828: ,X_MSG_COUNT => X_MSG_COUNT
829: ,X_MSG_DATA => X_MSG_DATA
830: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 836: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

832: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
833: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
834: P_API_NAME => L_API_NAME
835: ,P_PKG_NAME => G_PKG_NAME
836: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
837: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
838: ,X_MSG_COUNT => X_MSG_COUNT
839: ,X_MSG_DATA => X_MSG_DATA
840: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 891: FND_MSG_PUB.initialize;

887:
888: -- Initialize message list if p_init_msg_list is set to TRUE.
889: IF FND_API.to_Boolean( p_init_msg_list )
890: THEN
891: FND_MSG_PUB.initialize;
892: END IF;
893:
894:
895: -- Initialize API return status to SUCCESS

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

903: -- Validate Environment
904: -- ******************************************************************
905: IF FND_GLOBAL.User_Id IS NULL
906: THEN
907: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
908: THEN
909: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
910: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
911: FND_MSG_PUB.ADD;

Line 911: FND_MSG_PUB.ADD;

907: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
908: THEN
909: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
910: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
911: FND_MSG_PUB.ADD;
912: END IF;
913: RAISE FND_API.G_EXC_ERROR;
914: END IF;
915:

Line 1001: FND_MSG_PUB.Count_And_Get

997:
998:
999:
1000: -- Standard call to get message count and if count is 1, get message info.
1001: FND_MSG_PUB.Count_And_Get
1002: ( p_count => x_msg_count,
1003: p_data => x_msg_data
1004: );
1005:

Line 1011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1007: WHEN FND_API.G_EXC_ERROR THEN
1008: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1009: P_API_NAME => L_API_NAME
1010: ,P_PKG_NAME => G_PKG_NAME
1011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1012: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1013: ,X_MSG_COUNT => X_MSG_COUNT
1014: ,X_MSG_DATA => X_MSG_DATA
1015: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1021: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1019: P_API_NAME => L_API_NAME
1020: ,P_PKG_NAME => G_PKG_NAME
1021: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1022: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1023: ,X_MSG_COUNT => X_MSG_COUNT
1024: ,X_MSG_DATA => X_MSG_DATA
1025: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1089: FND_MSG_PUB.initialize;

1085:
1086: -- Initialize message list if p_init_msg_list is set to TRUE.
1087: IF FND_API.to_Boolean( p_init_msg_list )
1088: THEN
1089: FND_MSG_PUB.initialize;
1090: END IF;
1091:
1092:
1093: -- Initialize API return status to SUCCESS

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

1101: -- Validate Environment
1102: -- ******************************************************************
1103: IF FND_GLOBAL.User_Id IS NULL
1104: THEN
1105: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1106: THEN
1107: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1108: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1109: FND_MSG_PUB.ADD;

Line 1109: FND_MSG_PUB.ADD;

1105: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1106: THEN
1107: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1108: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1109: FND_MSG_PUB.ADD;
1110: END IF;
1111: RAISE FND_API.G_EXC_ERROR;
1112: END IF;
1113:

Line 1174: FND_MSG_PUB.Count_And_Get

1170: --
1171:
1172:
1173: -- Standard call to get message count and if count is 1, get message info.
1174: FND_MSG_PUB.Count_And_Get
1175: ( p_count => x_msg_count,
1176: p_data => x_msg_data
1177: );
1178:

Line 1184: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1180: WHEN FND_API.G_EXC_ERROR THEN
1181: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1182: P_API_NAME => L_API_NAME
1183: ,P_PKG_NAME => G_PKG_NAME
1184: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1185: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1186: ,X_MSG_COUNT => X_MSG_COUNT
1187: ,X_MSG_DATA => X_MSG_DATA
1188: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1194: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1191: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1192: P_API_NAME => L_API_NAME
1193: ,P_PKG_NAME => G_PKG_NAME
1194: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1195: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1196: ,X_MSG_COUNT => X_MSG_COUNT
1197: ,X_MSG_DATA => X_MSG_DATA
1198: ,X_RETURN_STATUS => X_RETURN_STATUS);