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.AS_BUSINESS_EVENT_PUB dependencies on FND_MSG_PUB

Line 67: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

63: ) IS
64:
65: l_api_name CONSTANT VARCHAR2(30) := 'Before_Oppty_Update';
66: l_api_version_number CONSTANT NUMBER := 2.0;
67: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
68: l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Before_Oppty_Update';
69:
70: BEGIN
71: -- Standard Start of API savepoint

Line 85: FND_MSG_PUB.initialize;

81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF FND_API.to_Boolean( p_init_msg_list )
84: THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87:
88: -- Debug Message
89: IF l_debug THEN

Line 90: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

86: END IF;
87:
88: -- Debug Message
89: IF l_debug THEN
90: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
91: 'Public API: ' || l_api_name || 'start');
92: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
93: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
94: END IF;

Line 92: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

88: -- Debug Message
89: IF l_debug THEN
90: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
91: 'Public API: ' || l_api_name || 'start');
92: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
93: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
94: END IF;
95:
96: -- Initialize API return status to SUCCESS

Line 104: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

100: -- API body
101: --
102:
103: IF l_debug THEN
104: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
105: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Before_Oppty_Update');
106: END IF;
107:
108: AS_BUSINESS_EVENT_PVT.Before_Oppty_Update

Line 132: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

128:
129:
130: -- Debug Message
131: IF l_debug THEN
132: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
133: 'Public API: ' || l_api_name || 'end');
134:
135: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
136: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 135: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

131: IF l_debug THEN
132: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
133: 'Public API: ' || l_api_name || 'end');
134:
135: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
136: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
137: END IF;
138:
139:

Line 140: FND_MSG_PUB.Count_And_Get

136: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
137: END IF;
138:
139:
140: FND_MSG_PUB.Count_And_Get
141: ( p_count => x_msg_count,
142: p_data => x_msg_data
143: );
144:

Line 151: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

147: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
148: P_MODULE => l_module
149: ,P_API_NAME => L_API_NAME
150: ,P_PKG_NAME => G_PKG_NAME
151: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
152: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
153: ,X_MSG_COUNT => X_MSG_COUNT
154: ,X_MSG_DATA => X_MSG_DATA
155: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 162: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

158: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
159: P_MODULE => l_module
160: ,P_API_NAME => L_API_NAME
161: ,P_PKG_NAME => G_PKG_NAME
162: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
163: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
164: ,X_MSG_COUNT => X_MSG_COUNT
165: ,X_MSG_DATA => X_MSG_DATA
166: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 230: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

226: ) IS
227:
228: l_api_name CONSTANT VARCHAR2(30) := 'Update_oppty_post_event';
229: l_api_version_number CONSTANT NUMBER := 2.0;
230: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
231: l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Update_oppty_post_event';
232:
233: BEGIN
234: -- Standard Start of API savepoint

Line 248: FND_MSG_PUB.initialize;

244:
245: -- Initialize message list if p_init_msg_list is set to TRUE.
246: IF FND_API.to_Boolean( p_init_msg_list )
247: THEN
248: FND_MSG_PUB.initialize;
249: END IF;
250:
251: -- Debug Message
252: IF l_debug THEN

Line 253: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

249: END IF;
250:
251: -- Debug Message
252: IF l_debug THEN
253: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
254: 'Public API: ' || l_api_name || 'start');
255: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
256: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
257: END IF;

Line 255: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

251: -- Debug Message
252: IF l_debug THEN
253: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
254: 'Public API: ' || l_api_name || 'start');
255: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
256: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
257: END IF;
258:
259: -- Initialize API return status to SUCCESS

Line 267: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

263: -- API body
264: --
265:
266: IF l_debug THEN
267: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
268: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Update_oppty_post_event');
269: END IF;
270:
271: AS_BUSINESS_EVENT_PVT.Update_oppty_post_event

Line 295: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

291:
292:
293: -- Debug Message
294: IF l_debug THEN
295: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
296: 'Public API: ' || l_api_name || 'end');
297:
298: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
299: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 298: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

294: IF l_debug THEN
295: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
296: 'Public API: ' || l_api_name || 'end');
297:
298: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
299: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
300: END IF;
301:
302:

Line 303: FND_MSG_PUB.Count_And_Get

299: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
300: END IF;
301:
302:
303: FND_MSG_PUB.Count_And_Get
304: ( p_count => x_msg_count,
305: p_data => x_msg_data
306: );
307:

Line 314: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

310: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
311: P_MODULE => l_module
312: ,P_API_NAME => L_API_NAME
313: ,P_PKG_NAME => G_PKG_NAME
314: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
315: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
316: ,X_MSG_COUNT => X_MSG_COUNT
317: ,X_MSG_DATA => X_MSG_DATA
318: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 325: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

321: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
322: P_MODULE => l_module
323: ,P_API_NAME => L_API_NAME
324: ,P_PKG_NAME => G_PKG_NAME
325: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
326: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
327: ,X_MSG_COUNT => X_MSG_COUNT
328: ,X_MSG_DATA => X_MSG_DATA
329: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 398: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

394: ) IS
395:
396: l_api_name CONSTANT VARCHAR2(30) := 'Before_Opp_Lines_Update';
397: l_api_version_number CONSTANT NUMBER := 2.0;
398: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
399: l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Before_Opp_Lines_Update';
400:
401: BEGIN
402: -- Standard Start of API savepoint

Line 416: FND_MSG_PUB.initialize;

412:
413: -- Initialize message list if p_init_msg_list is set to TRUE.
414: IF FND_API.to_Boolean( p_init_msg_list )
415: THEN
416: FND_MSG_PUB.initialize;
417: END IF;
418:
419: -- Debug Message
420: IF l_debug THEN

Line 421: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

417: END IF;
418:
419: -- Debug Message
420: IF l_debug THEN
421: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
422: 'Public API: ' || l_api_name || 'start');
423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
424: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
425: END IF;

Line 423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

419: -- Debug Message
420: IF l_debug THEN
421: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
422: 'Public API: ' || l_api_name || 'start');
423: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
424: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
425: END IF;
426:
427: -- Initialize API return status to SUCCESS

Line 435: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

431: -- API body
432: --
433:
434: IF l_debug THEN
435: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
436: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Before_Opp_Lines_Update');
437: END IF;
438:
439: AS_BUSINESS_EVENT_PVT.Before_Opp_Lines_Update

Line 463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

459:
460:
461: -- Debug Message
462: IF l_debug THEN
463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
464: 'Public API: ' || l_api_name || 'end');
465:
466: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
467: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 466: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

462: IF l_debug THEN
463: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
464: 'Public API: ' || l_api_name || 'end');
465:
466: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
467: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
468: END IF;
469:
470:

Line 471: FND_MSG_PUB.Count_And_Get

467: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
468: END IF;
469:
470:
471: FND_MSG_PUB.Count_And_Get
472: ( p_count => x_msg_count,
473: p_data => x_msg_data
474: );
475:

Line 482: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

478: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
479: P_MODULE => l_module
480: ,P_API_NAME => L_API_NAME
481: ,P_PKG_NAME => G_PKG_NAME
482: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
483: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
484: ,X_MSG_COUNT => X_MSG_COUNT
485: ,X_MSG_DATA => X_MSG_DATA
486: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

489: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
490: P_MODULE => l_module
491: ,P_API_NAME => L_API_NAME
492: ,P_PKG_NAME => G_PKG_NAME
493: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
494: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
495: ,X_MSG_COUNT => X_MSG_COUNT
496: ,X_MSG_DATA => X_MSG_DATA
497: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 561: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

557: ) IS
558:
559: l_api_name CONSTANT VARCHAR2(30) := 'Upd_Opp_Lines_post_event';
560: l_api_version_number CONSTANT NUMBER := 2.0;
561: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
562: l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Upd_Opp_Lines_post_event';
563:
564: BEGIN
565: -- Standard Start of API savepoint

Line 579: FND_MSG_PUB.initialize;

575:
576: -- Initialize message list if p_init_msg_list is set to TRUE.
577: IF FND_API.to_Boolean( p_init_msg_list )
578: THEN
579: FND_MSG_PUB.initialize;
580: END IF;
581:
582: -- Debug Message
583: IF l_debug THEN

Line 584: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

580: END IF;
581:
582: -- Debug Message
583: IF l_debug THEN
584: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
585: 'Public API: ' || l_api_name || 'start');
586: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
587: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
588: END IF;

Line 586: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

582: -- Debug Message
583: IF l_debug THEN
584: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
585: 'Public API: ' || l_api_name || 'start');
586: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
587: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
588: END IF;
589:
590: -- Initialize API return status to SUCCESS

Line 598: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

594: -- API body
595: --
596:
597: IF l_debug THEN
598: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
599: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Upd_Opp_Lines_post_event');
600: END IF;
601:
602: AS_BUSINESS_EVENT_PVT.Upd_Opp_Lines_post_event

Line 626: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

622:
623:
624: -- Debug Message
625: IF l_debug THEN
626: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
627: 'Public API: ' || l_api_name || 'end');
628:
629: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
630: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 629: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

625: IF l_debug THEN
626: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
627: 'Public API: ' || l_api_name || 'end');
628:
629: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
630: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
631: END IF;
632:
633:

Line 634: FND_MSG_PUB.Count_And_Get

630: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
631: END IF;
632:
633:
634: FND_MSG_PUB.Count_And_Get
635: ( p_count => x_msg_count,
636: p_data => x_msg_data
637: );
638:

Line 645: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

641: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
642: P_MODULE => l_module
643: ,P_API_NAME => L_API_NAME
644: ,P_PKG_NAME => G_PKG_NAME
645: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
646: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
647: ,X_MSG_COUNT => X_MSG_COUNT
648: ,X_MSG_DATA => X_MSG_DATA
649: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 656: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

652: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
653: P_MODULE => l_module
654: ,P_API_NAME => L_API_NAME
655: ,P_PKG_NAME => G_PKG_NAME
656: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
657: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
658: ,X_MSG_COUNT => X_MSG_COUNT
659: ,X_MSG_DATA => X_MSG_DATA
660: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 729: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

725: ) IS
726:
727: l_api_name CONSTANT VARCHAR2(30) := 'Before_Opp_STeam_Update';
728: l_api_version_number CONSTANT NUMBER := 2.0;
729: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
730: l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Before_Opp_STeam_Update';
731:
732: BEGIN
733: -- Standard Start of API savepoint

Line 747: FND_MSG_PUB.initialize;

743:
744: -- Initialize message list if p_init_msg_list is set to TRUE.
745: IF FND_API.to_Boolean( p_init_msg_list )
746: THEN
747: FND_MSG_PUB.initialize;
748: END IF;
749:
750: -- Debug Message
751: IF l_debug THEN

Line 752: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

748: END IF;
749:
750: -- Debug Message
751: IF l_debug THEN
752: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
753: 'Public API: ' || l_api_name || 'start');
754: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
755: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
756: END IF;

Line 754: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

750: -- Debug Message
751: IF l_debug THEN
752: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
753: 'Public API: ' || l_api_name || 'start');
754: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
755: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
756: END IF;
757:
758: -- Initialize API return status to SUCCESS

Line 766: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

762: -- API body
763: --
764:
765: IF l_debug THEN
766: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
767: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Before_Opp_STeam_Update');
768: END IF;
769:
770: AS_BUSINESS_EVENT_PVT.Before_Opp_STeam_Update

Line 794: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

790:
791:
792: -- Debug Message
793: IF l_debug THEN
794: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
795: 'Public API: ' || l_api_name || 'end');
796:
797: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
798: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 797: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

793: IF l_debug THEN
794: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
795: 'Public API: ' || l_api_name || 'end');
796:
797: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
798: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
799: END IF;
800:
801:

Line 802: FND_MSG_PUB.Count_And_Get

798: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
799: END IF;
800:
801:
802: FND_MSG_PUB.Count_And_Get
803: ( p_count => x_msg_count,
804: p_data => x_msg_data
805: );
806:

Line 813: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

809: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
810: P_MODULE => l_module
811: ,P_API_NAME => L_API_NAME
812: ,P_PKG_NAME => G_PKG_NAME
813: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
814: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
815: ,X_MSG_COUNT => X_MSG_COUNT
816: ,X_MSG_DATA => X_MSG_DATA
817: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 824: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

820: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
821: P_MODULE => l_module
822: ,P_API_NAME => L_API_NAME
823: ,P_PKG_NAME => G_PKG_NAME
824: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
825: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
826: ,X_MSG_COUNT => X_MSG_COUNT
827: ,X_MSG_DATA => X_MSG_DATA
828: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 892: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

888: ) IS
889:
890: l_api_name CONSTANT VARCHAR2(30) := 'Upd_Opp_STeam_post_event';
891: l_api_version_number CONSTANT NUMBER := 2.0;
892: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
893: l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Upd_Opp_STeam_post_event';
894:
895: BEGIN
896: -- Standard Start of API savepoint

Line 910: FND_MSG_PUB.initialize;

906:
907: -- Initialize message list if p_init_msg_list is set to TRUE.
908: IF FND_API.to_Boolean( p_init_msg_list )
909: THEN
910: FND_MSG_PUB.initialize;
911: END IF;
912:
913: -- Debug Message
914: IF l_debug THEN

Line 915: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

911: END IF;
912:
913: -- Debug Message
914: IF l_debug THEN
915: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
916: 'Public API: ' || l_api_name || 'start');
917: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
918: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
919: END IF;

Line 917: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

913: -- Debug Message
914: IF l_debug THEN
915: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
916: 'Public API: ' || l_api_name || 'start');
917: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
918: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
919: END IF;
920:
921: -- Initialize API return status to SUCCESS

Line 929: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

925: -- API body
926: --
927:
928: IF l_debug THEN
929: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
930: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Upd_Opp_STeam_post_event');
931: END IF;
932:
933: AS_BUSINESS_EVENT_PVT.Upd_Opp_STeam_post_event

Line 957: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

953:
954:
955: -- Debug Message
956: IF l_debug THEN
957: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
958: 'Public API: ' || l_api_name || 'end');
959:
960: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
961: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 960: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

956: IF l_debug THEN
957: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
958: 'Public API: ' || l_api_name || 'end');
959:
960: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
961: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
962: END IF;
963:
964:

Line 965: FND_MSG_PUB.Count_And_Get

961: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
962: END IF;
963:
964:
965: FND_MSG_PUB.Count_And_Get
966: ( p_count => x_msg_count,
967: p_data => x_msg_data
968: );
969:

Line 976: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

972: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
973: P_MODULE => l_module
974: ,P_API_NAME => L_API_NAME
975: ,P_PKG_NAME => G_PKG_NAME
976: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
977: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
978: ,X_MSG_COUNT => X_MSG_COUNT
979: ,X_MSG_DATA => X_MSG_DATA
980: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 987: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

983: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
984: P_MODULE => l_module
985: ,P_API_NAME => L_API_NAME
986: ,P_PKG_NAME => G_PKG_NAME
987: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
988: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
989: ,X_MSG_COUNT => X_MSG_COUNT
990: ,X_MSG_DATA => X_MSG_DATA
991: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1060: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1056: ) IS
1057:
1058: l_api_name CONSTANT VARCHAR2(30) := 'Before_Cust_STeam_Update';
1059: l_api_version_number CONSTANT NUMBER := 2.0;
1060: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1061: l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Before_Cust_STeam_Update';
1062:
1063: BEGIN
1064: -- Standard Start of API savepoint

Line 1078: FND_MSG_PUB.initialize;

1074:
1075: -- Initialize message list if p_init_msg_list is set to TRUE.
1076: IF FND_API.to_Boolean( p_init_msg_list )
1077: THEN
1078: FND_MSG_PUB.initialize;
1079: END IF;
1080:
1081: -- Debug Message
1082: IF l_debug THEN

Line 1083: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1079: END IF;
1080:
1081: -- Debug Message
1082: IF l_debug THEN
1083: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1084: 'Public API: ' || l_api_name || 'start');
1085: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1086: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1087: END IF;

Line 1085: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1081: -- Debug Message
1082: IF l_debug THEN
1083: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1084: 'Public API: ' || l_api_name || 'start');
1085: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1086: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1087: END IF;
1088:
1089: -- Initialize API return status to SUCCESS

Line 1097: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1093: -- API body
1094: --
1095:
1096: IF l_debug THEN
1097: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1098: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Before_Cust_STeam_Update');
1099: END IF;
1100:
1101: AS_BUSINESS_EVENT_PVT.Before_Cust_STeam_Update

Line 1125: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1121:
1122:
1123: -- Debug Message
1124: IF l_debug THEN
1125: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1126: 'Public API: ' || l_api_name || 'end');
1127:
1128: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1129: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 1128: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

1124: IF l_debug THEN
1125: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1126: 'Public API: ' || l_api_name || 'end');
1127:
1128: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1129: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1130: END IF;
1131:
1132:

Line 1133: FND_MSG_PUB.Count_And_Get

1129: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1130: END IF;
1131:
1132:
1133: FND_MSG_PUB.Count_And_Get
1134: ( p_count => x_msg_count,
1135: p_data => x_msg_data
1136: );
1137:

Line 1144: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1140: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1141: P_MODULE => l_module
1142: ,P_API_NAME => L_API_NAME
1143: ,P_PKG_NAME => G_PKG_NAME
1144: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1145: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1146: ,X_MSG_COUNT => X_MSG_COUNT
1147: ,X_MSG_DATA => X_MSG_DATA
1148: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1155: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1151: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1152: P_MODULE => l_module
1153: ,P_API_NAME => L_API_NAME
1154: ,P_PKG_NAME => G_PKG_NAME
1155: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1156: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1157: ,X_MSG_COUNT => X_MSG_COUNT
1158: ,X_MSG_DATA => X_MSG_DATA
1159: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1223: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

1219: ) IS
1220:
1221: l_api_name CONSTANT VARCHAR2(30) := 'Upd_Cust_STeam_post_event';
1222: l_api_version_number CONSTANT NUMBER := 2.0;
1223: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1224: l_module CONSTANT VARCHAR2(255) := 'as.plsql.bevpb.Upd_Cust_STeam_post_event';
1225:
1226: BEGIN
1227: -- Standard Start of API savepoint

Line 1241: FND_MSG_PUB.initialize;

1237:
1238: -- Initialize message list if p_init_msg_list is set to TRUE.
1239: IF FND_API.to_Boolean( p_init_msg_list )
1240: THEN
1241: FND_MSG_PUB.initialize;
1242: END IF;
1243:
1244: -- Debug Message
1245: IF l_debug THEN

Line 1246: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1242: END IF;
1243:
1244: -- Debug Message
1245: IF l_debug THEN
1246: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1247: 'Public API: ' || l_api_name || 'start');
1248: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1249: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1250: END IF;

Line 1248: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1244: -- Debug Message
1245: IF l_debug THEN
1246: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1247: 'Public API: ' || l_api_name || 'start');
1248: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1249: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1250: END IF;
1251:
1252: -- Initialize API return status to SUCCESS

Line 1260: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1256: -- API body
1257: --
1258:
1259: IF l_debug THEN
1260: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1261: 'Public API: Calling AS_BUSINESS_EVENT_PVT.Upd_Cust_STeam_post_event');
1262: END IF;
1263:
1264: AS_BUSINESS_EVENT_PVT.Upd_Cust_STeam_post_event

Line 1288: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1284:
1285:
1286: -- Debug Message
1287: IF l_debug THEN
1288: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1289: 'Public API: ' || l_api_name || 'end');
1290:
1291: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1292: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 1291: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'

1287: IF l_debug THEN
1288: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1289: 'Public API: ' || l_api_name || 'end');
1290:
1291: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'End time:'
1292: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1293: END IF;
1294:
1295:

Line 1296: FND_MSG_PUB.Count_And_Get

1292: || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1293: END IF;
1294:
1295:
1296: FND_MSG_PUB.Count_And_Get
1297: ( p_count => x_msg_count,
1298: p_data => x_msg_data
1299: );
1300:

Line 1307: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1303: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1304: P_MODULE => l_module
1305: ,P_API_NAME => L_API_NAME
1306: ,P_PKG_NAME => G_PKG_NAME
1307: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1308: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1309: ,X_MSG_COUNT => X_MSG_COUNT
1310: ,X_MSG_DATA => X_MSG_DATA
1311: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 1318: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1314: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1315: P_MODULE => l_module
1316: ,P_API_NAME => L_API_NAME
1317: ,P_PKG_NAME => G_PKG_NAME
1318: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1319: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PUB
1320: ,X_MSG_COUNT => X_MSG_COUNT
1321: ,X_MSG_DATA => X_MSG_DATA
1322: ,X_RETURN_STATUS => X_RETURN_STATUS);