DBA Data[Home] [Help]

APPS.ASO_RESERVATION_INT dependencies on FND_MSG_PUB

Line 67: FND_MSG_PUB.initialize;

63: END IF;
64: -- Initialize message list if p_init_msg_list is set to TRUE.
65: IF FND_API.to_Boolean( p_init_msg_list )
66: THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69:
70: -- initialize G_Debug_Flag
71: ASO_DEBUG_PUB.G_Debug_Flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

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

84:
85: l_rsv.organization_id :=
86: fnd_profile.value(name => 'ASO_SHIP_FROM_ORG_ID');
87: If l_rsv.organization_id IS NULL Then
88: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
89: select user_profile_option_name
90: into l_profile_name
91: from fnd_profile_options_vl
92: where profile_option_name = 'ASO_SHIP_FROM_ORG_ID';

Line 96: FND_MSG_PUB.ADD;

92: where profile_option_name = 'ASO_SHIP_FROM_ORG_ID';
93:
94: FND_MESSAGE.Set_Name('ASO', 'ASO_API_NO_PROFILE_VALUE');
95: fnd_message.set_token('PROFILE', l_profile_name);
96: FND_MSG_PUB.ADD;
97: END IF;
98: raise FND_API.G_EXC_ERROR;
99: End If;
100:

Line 104: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

100:
101: l_rsv.inventory_item_id := p_line_rec.inventory_item_id;
102: l_rsv.demand_source_type_id := FND_PROFILE.Value('ASO_TRX_SOURCE_TYPES');
103: If l_rsv.demand_source_type_id IS NULL Then
104: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
105: -- THEN
106: FND_MESSAGE.Set_Name('ASO', 'ASO_SOURCE_TYPE_NOT_DEFINED');
107: FND_MSG_PUB.ADD;
108: -- END IF;

Line 107: FND_MSG_PUB.ADD;

103: If l_rsv.demand_source_type_id IS NULL Then
104: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
105: -- THEN
106: FND_MESSAGE.Set_Name('ASO', 'ASO_SOURCE_TYPE_NOT_DEFINED');
107: FND_MSG_PUB.ADD;
108: -- END IF;
109: RAISE FND_API.G_EXC_ERROR;
110: End If;
111:

Line 190: FND_MSG_PUB.Count_And_Get

186: END IF;
187:
188:
189: -- Standard call to get message count and if count is 1, get message info.
190: FND_MSG_PUB.Count_And_Get
191: ( p_count => x_msg_count,
192: p_data => x_msg_data );
193:
194: EXCEPTION

Line 199: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

195: WHEN FND_API.G_EXC_ERROR THEN
196: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
197: P_API_NAME => L_API_NAME
198: ,P_PKG_NAME => G_PKG_NAME
199: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
200: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
201: ,X_MSG_COUNT => X_MSG_COUNT
202: ,X_MSG_DATA => X_MSG_DATA
203: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

204: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
205: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
206: P_API_NAME => L_API_NAME
207: ,P_PKG_NAME => G_PKG_NAME
208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
209: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
210: ,X_MSG_COUNT => X_MSG_COUNT
211: ,X_MSG_DATA => X_MSG_DATA
212: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 269: FND_MSG_PUB.initialize;

265: END IF;
266: -- Initialize message list if p_init_msg_list is set to TRUE.
267: IF FND_API.to_Boolean( p_init_msg_list )
268: THEN
269: FND_MSG_PUB.initialize;
270: END IF;
271:
272:
273: -- initialize G_Debug_Flag

Line 283: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

279: l_rsv_old.inventory_item_id := p_line_rec.inventory_item_id;
280: l_rsv_old.demand_source_type_id :=
281: FND_PROFILE.Value('ASO_TRX_SOURCE_TYPES');
282: If l_rsv_old.demand_source_type_id IS NULL Then
283: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
284: -- THEN
285: FND_MESSAGE.Set_Name('ASO', 'ASO_SOURCE_TYPE_NOT_DEFINED');
286: FND_MSG_PUB.ADD;
287: -- END IF;

Line 286: FND_MSG_PUB.ADD;

282: If l_rsv_old.demand_source_type_id IS NULL Then
283: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
284: -- THEN
285: FND_MESSAGE.Set_Name('ASO', 'ASO_SOURCE_TYPE_NOT_DEFINED');
286: FND_MSG_PUB.ADD;
287: -- END IF;
288: RAISE FND_API.G_EXC_ERROR;
289: End If;
290:

Line 326: FND_MSG_PUB.Count_And_Get

322: COMMIT WORK;
323: END IF;
324:
325: -- Standard call to get message count and if count is 1, get message info.
326: FND_MSG_PUB.Count_And_Get
327: ( p_count => x_msg_count,
328: p_data => x_msg_data );
329: EXCEPTION
330: WHEN FND_API.G_EXC_ERROR THEN

Line 334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

330: WHEN FND_API.G_EXC_ERROR THEN
331: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
332: P_API_NAME => L_API_NAME
333: ,P_PKG_NAME => G_PKG_NAME
334: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
335: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
336: ,X_MSG_COUNT => X_MSG_COUNT
337: ,X_MSG_DATA => X_MSG_DATA
338: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 343: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

339: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
340: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
341: P_API_NAME => L_API_NAME
342: ,P_PKG_NAME => G_PKG_NAME
343: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
344: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
345: ,X_MSG_COUNT => X_MSG_COUNT
346: ,X_MSG_DATA => X_MSG_DATA
347: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 398: FND_MSG_PUB.initialize;

394: END IF;
395: -- Initialize message list if p_init_msg_list is set to TRUE.
396: IF FND_API.to_Boolean( p_init_msg_list )
397: THEN
398: FND_MSG_PUB.initialize;
399: END IF;
400:
401:
402: -- initialize G_Debug_Flag

Line 412: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

408: l_rsv.inventory_item_id := p_line_rec.inventory_item_id;
409: l_rsv.demand_source_type_id :=
410: FND_PROFILE.Value('ASO_TRX_SOURCE_TYPES');
411: If l_rsv.demand_source_type_id IS NULL Then
412: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
413: -- THEN
414: FND_MESSAGE.Set_Name('ASO', 'ASO_SOURCE_TYPE_NOT_DEFINED');
415: FND_MSG_PUB.ADD;
416: -- END IF;

Line 415: FND_MSG_PUB.ADD;

411: If l_rsv.demand_source_type_id IS NULL Then
412: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
413: -- THEN
414: FND_MESSAGE.Set_Name('ASO', 'ASO_SOURCE_TYPE_NOT_DEFINED');
415: FND_MSG_PUB.ADD;
416: -- END IF;
417: RAISE FND_API.G_EXC_ERROR;
418: End If;
419:

Line 446: FND_MSG_PUB.Count_And_Get

442: COMMIT WORK;
443: END IF;
444:
445: -- Standard call to get message count and if count is 1, get message info.
446: FND_MSG_PUB.Count_And_Get
447: ( p_count => x_msg_count,
448: p_data => x_msg_data );
449: EXCEPTION
450: WHEN FND_API.G_EXC_ERROR THEN

Line 454: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

450: WHEN FND_API.G_EXC_ERROR THEN
451: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
452: P_API_NAME => L_API_NAME
453: ,P_PKG_NAME => G_PKG_NAME
454: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
455: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
456: ,X_MSG_COUNT => X_MSG_COUNT
457: ,X_MSG_DATA => X_MSG_DATA
458: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 463: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
461: P_API_NAME => L_API_NAME
462: ,P_PKG_NAME => G_PKG_NAME
463: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
464: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
465: ,X_MSG_COUNT => X_MSG_COUNT
466: ,X_MSG_DATA => X_MSG_DATA
467: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 521: FND_MSG_PUB.initialize;

517: END IF;
518: -- Initialize message list if p_init_msg_list is set to TRUE.
519: IF FND_API.to_Boolean( p_init_msg_list )
520: THEN
521: FND_MSG_PUB.initialize;
522: END IF;
523:
524:
525: -- initialize G_Debug_Flag

Line 536: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

532: l_rsv_old.inventory_item_id := p_line_rec.inventory_item_id;
533: l_rsv_old.demand_source_type_id :=
534: FND_PROFILE.Value('ASO_TRX_SOURCE_TYPES');
535: If l_rsv_old.demand_source_type_id IS NULL Then
536: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
537: -- THEN
538: FND_MESSAGE.Set_Name('ASO', 'ASO_SOURCE_TYPE_NOT_DEFINED');
539: FND_MSG_PUB.ADD;
540: -- END IF;

Line 539: FND_MSG_PUB.ADD;

535: If l_rsv_old.demand_source_type_id IS NULL Then
536: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
537: -- THEN
538: FND_MESSAGE.Set_Name('ASO', 'ASO_SOURCE_TYPE_NOT_DEFINED');
539: FND_MSG_PUB.ADD;
540: -- END IF;
541: RAISE FND_API.G_EXC_ERROR;
542: End If;
543:

Line 583: FND_MSG_PUB.Count_And_Get

579:
580: x_new_reservation_id := l_new_rsv_id ;
581:
582: -- Standard call to get message count and if count is 1, get message info.
583: FND_MSG_PUB.Count_And_Get
584: ( p_count => x_msg_count,
585: p_data => x_msg_data );
586: EXCEPTION
587: WHEN FND_API.G_EXC_ERROR THEN

Line 591: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

587: WHEN FND_API.G_EXC_ERROR THEN
588: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
589: P_API_NAME => L_API_NAME
590: ,P_PKG_NAME => G_PKG_NAME
591: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
592: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
593: ,X_MSG_COUNT => X_MSG_COUNT
594: ,X_MSG_DATA => X_MSG_DATA
595: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
597: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
598: P_API_NAME => L_API_NAME
599: ,P_PKG_NAME => G_PKG_NAME
600: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
601: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
602: ,X_MSG_COUNT => X_MSG_COUNT
603: ,X_MSG_DATA => X_MSG_DATA
604: ,X_RETURN_STATUS => X_RETURN_STATUS);