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_API

Line 55: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

51:
52:
53: PROCEDURE Before_Oppty_Update(
54: p_api_version_number IN NUMBER,
55: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
58: p_lead_id IN NUMBER,
59: x_return_status OUT NOCOPY VARCHAR2,

Line 56: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

52:
53: PROCEDURE Before_Oppty_Update(
54: p_api_version_number IN NUMBER,
55: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
58: p_lead_id IN NUMBER,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,

Line 57: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

53: PROCEDURE Before_Oppty_Update(
54: p_api_version_number IN NUMBER,
55: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
58: p_lead_id IN NUMBER,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,

Line 74: IF NOT FND_API.Compatible_API_Call( l_api_version_number,

70: BEGIN
71: -- Standard Start of API savepoint
72: SAVEPOINT BEFORE_OPPTY_UPDATE_PUB;
73: -- Standard call to check for call compatibility.
74: IF NOT FND_API.Compatible_API_Call( l_api_version_number,
75: p_api_version_number,
76: l_api_name,
77: G_PKG_NAME)
78: THEN

Line 79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

75: p_api_version_number,
76: l_api_name,
77: G_PKG_NAME)
78: THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF FND_API.to_Boolean( p_init_msg_list )

Line 83: IF FND_API.to_Boolean( p_init_msg_list )

79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
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:

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
94: END IF;
95:
96: -- Initialize API return status to SUCCESS
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: --
100: -- API body
101: --

Line 114: IF x_return_status = FND_API.G_RET_STS_ERROR then

110: p_lead_id => p_lead_id,
111: x_event_key => x_event_key
112: );
113:
114: IF x_return_status = FND_API.G_RET_STS_ERROR then
115: raise FND_API.G_EXC_ERROR;
116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
117: raise FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;

Line 115: raise FND_API.G_EXC_ERROR;

111: x_event_key => x_event_key
112: );
113:
114: IF x_return_status = FND_API.G_RET_STS_ERROR then
115: raise FND_API.G_EXC_ERROR;
116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
117: raise FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:

Line 116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

112: );
113:
114: IF x_return_status = FND_API.G_RET_STS_ERROR then
115: raise FND_API.G_EXC_ERROR;
116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
117: raise FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: --

Line 117: raise FND_API.G_EXC_UNEXPECTED_ERROR;

113:
114: IF x_return_status = FND_API.G_RET_STS_ERROR then
115: raise FND_API.G_EXC_ERROR;
116: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
117: raise FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: --
121: -- End of API body.

Line 124: IF FND_API.to_Boolean( p_commit )

120: --
121: -- End of API body.
122: --
123:
124: IF FND_API.to_Boolean( p_commit )
125: THEN
126: COMMIT WORK;
127: END IF;
128:

Line 146: WHEN FND_API.G_EXC_ERROR THEN

142: p_data => x_msg_data
143: );
144:
145: EXCEPTION
146: WHEN FND_API.G_EXC_ERROR THEN
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

Line 157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

153: ,X_MSG_COUNT => X_MSG_COUNT
154: ,X_MSG_DATA => X_MSG_DATA
155: ,X_RETURN_STATUS => X_RETURN_STATUS);
156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 218: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

214: -- End of Comments
215:
216: PROCEDURE Update_oppty_post_event(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
219: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
220: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
221: p_lead_id IN NUMBER,
222: p_event_key IN VARCHAR2,

Line 219: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

215:
216: PROCEDURE Update_oppty_post_event(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
219: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
220: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
221: p_lead_id IN NUMBER,
222: p_event_key IN VARCHAR2,
223: x_return_status OUT NOCOPY VARCHAR2,

Line 220: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

216: PROCEDURE Update_oppty_post_event(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
219: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
220: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
221: p_lead_id IN NUMBER,
222: p_event_key IN VARCHAR2,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,

Line 237: IF NOT FND_API.Compatible_API_Call( l_api_version_number,

233: BEGIN
234: -- Standard Start of API savepoint
235: SAVEPOINT UPDATE_OPPTY_POST_EVENT_PUB;
236: -- Standard call to check for call compatibility.
237: IF NOT FND_API.Compatible_API_Call( l_api_version_number,
238: p_api_version_number,
239: l_api_name,
240: G_PKG_NAME)
241: THEN

Line 242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

238: p_api_version_number,
239: l_api_name,
240: G_PKG_NAME)
241: THEN
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244:
245: -- Initialize message list if p_init_msg_list is set to TRUE.
246: IF FND_API.to_Boolean( p_init_msg_list )

Line 246: IF FND_API.to_Boolean( p_init_msg_list )

242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
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:

Line 260: x_return_status := FND_API.G_RET_STS_SUCCESS;

256: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
257: END IF;
258:
259: -- Initialize API return status to SUCCESS
260: x_return_status := FND_API.G_RET_STS_SUCCESS;
261:
262: --
263: -- API body
264: --

Line 277: IF x_return_status = FND_API.G_RET_STS_ERROR then

273: p_lead_id => p_lead_id,
274: p_event_key => p_event_key
275: );
276:
277: IF x_return_status = FND_API.G_RET_STS_ERROR then
278: raise FND_API.G_EXC_ERROR;
279: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
280: raise FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;

Line 278: raise FND_API.G_EXC_ERROR;

274: p_event_key => p_event_key
275: );
276:
277: IF x_return_status = FND_API.G_RET_STS_ERROR then
278: raise FND_API.G_EXC_ERROR;
279: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
280: raise FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:

Line 279: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

275: );
276:
277: IF x_return_status = FND_API.G_RET_STS_ERROR then
278: raise FND_API.G_EXC_ERROR;
279: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
280: raise FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: --

Line 280: raise FND_API.G_EXC_UNEXPECTED_ERROR;

276:
277: IF x_return_status = FND_API.G_RET_STS_ERROR then
278: raise FND_API.G_EXC_ERROR;
279: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
280: raise FND_API.G_EXC_UNEXPECTED_ERROR;
281: END IF;
282:
283: --
284: -- End of API body.

Line 287: IF FND_API.to_Boolean( p_commit )

283: --
284: -- End of API body.
285: --
286:
287: IF FND_API.to_Boolean( p_commit )
288: THEN
289: COMMIT WORK;
290: END IF;
291:

Line 309: WHEN FND_API.G_EXC_ERROR THEN

305: p_data => x_msg_data
306: );
307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
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

Line 320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

316: ,X_MSG_COUNT => X_MSG_COUNT
317: ,X_MSG_DATA => X_MSG_DATA
318: ,X_RETURN_STATUS => X_RETURN_STATUS);
319:
320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 386: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

382:
383:
384: PROCEDURE Before_Opp_Lines_Update(
385: p_api_version_number IN NUMBER,
386: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
388: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
389: p_lead_id IN NUMBER,
390: x_return_status OUT NOCOPY VARCHAR2,

Line 387: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

383:
384: PROCEDURE Before_Opp_Lines_Update(
385: p_api_version_number IN NUMBER,
386: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
388: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
389: p_lead_id IN NUMBER,
390: x_return_status OUT NOCOPY VARCHAR2,
391: x_msg_count OUT NOCOPY NUMBER,

Line 388: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

384: PROCEDURE Before_Opp_Lines_Update(
385: p_api_version_number IN NUMBER,
386: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
388: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
389: p_lead_id IN NUMBER,
390: x_return_status OUT NOCOPY VARCHAR2,
391: x_msg_count OUT NOCOPY NUMBER,
392: x_msg_data OUT NOCOPY VARCHAR2,

Line 405: IF NOT FND_API.Compatible_API_Call( l_api_version_number,

401: BEGIN
402: -- Standard Start of API savepoint
403: SAVEPOINT BEFORE_OPP_LINES_UPDATE_PUB;
404: -- Standard call to check for call compatibility.
405: IF NOT FND_API.Compatible_API_Call( l_api_version_number,
406: p_api_version_number,
407: l_api_name,
408: G_PKG_NAME)
409: THEN

Line 410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

406: p_api_version_number,
407: l_api_name,
408: G_PKG_NAME)
409: THEN
410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411: END IF;
412:
413: -- Initialize message list if p_init_msg_list is set to TRUE.
414: IF FND_API.to_Boolean( p_init_msg_list )

Line 414: IF FND_API.to_Boolean( p_init_msg_list )

410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411: END IF;
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:

Line 428: x_return_status := FND_API.G_RET_STS_SUCCESS;

424: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
425: END IF;
426:
427: -- Initialize API return status to SUCCESS
428: x_return_status := FND_API.G_RET_STS_SUCCESS;
429:
430: --
431: -- API body
432: --

Line 445: IF x_return_status = FND_API.G_RET_STS_ERROR then

441: p_lead_id => p_lead_id,
442: x_event_key => x_event_key
443: );
444:
445: IF x_return_status = FND_API.G_RET_STS_ERROR then
446: raise FND_API.G_EXC_ERROR;
447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
448: raise FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;

Line 446: raise FND_API.G_EXC_ERROR;

442: x_event_key => x_event_key
443: );
444:
445: IF x_return_status = FND_API.G_RET_STS_ERROR then
446: raise FND_API.G_EXC_ERROR;
447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
448: raise FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:

Line 447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

443: );
444:
445: IF x_return_status = FND_API.G_RET_STS_ERROR then
446: raise FND_API.G_EXC_ERROR;
447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
448: raise FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:
451: --

Line 448: raise FND_API.G_EXC_UNEXPECTED_ERROR;

444:
445: IF x_return_status = FND_API.G_RET_STS_ERROR then
446: raise FND_API.G_EXC_ERROR;
447: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
448: raise FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:
451: --
452: -- End of API body.

Line 455: IF FND_API.to_Boolean( p_commit )

451: --
452: -- End of API body.
453: --
454:
455: IF FND_API.to_Boolean( p_commit )
456: THEN
457: COMMIT WORK;
458: END IF;
459:

Line 477: WHEN FND_API.G_EXC_ERROR THEN

473: p_data => x_msg_data
474: );
475:
476: EXCEPTION
477: WHEN FND_API.G_EXC_ERROR THEN
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

Line 488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

484: ,X_MSG_COUNT => X_MSG_COUNT
485: ,X_MSG_DATA => X_MSG_DATA
486: ,X_RETURN_STATUS => X_RETURN_STATUS);
487:
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 549: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

545: -- End of Comments
546:
547: PROCEDURE Upd_Opp_Lines_post_event(
548: p_api_version_number IN NUMBER,
549: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
550: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
551: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
552: p_lead_id IN NUMBER,
553: p_event_key IN VARCHAR2,

Line 550: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

546:
547: PROCEDURE Upd_Opp_Lines_post_event(
548: p_api_version_number IN NUMBER,
549: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
550: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
551: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
552: p_lead_id IN NUMBER,
553: p_event_key IN VARCHAR2,
554: x_return_status OUT NOCOPY VARCHAR2,

Line 551: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

547: PROCEDURE Upd_Opp_Lines_post_event(
548: p_api_version_number IN NUMBER,
549: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
550: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
551: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
552: p_lead_id IN NUMBER,
553: p_event_key IN VARCHAR2,
554: x_return_status OUT NOCOPY VARCHAR2,
555: x_msg_count OUT NOCOPY NUMBER,

Line 568: IF NOT FND_API.Compatible_API_Call( l_api_version_number,

564: BEGIN
565: -- Standard Start of API savepoint
566: SAVEPOINT UPD_OPP_LINES_POST_EVENT_PUB;
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call( l_api_version_number,
569: p_api_version_number,
570: l_api_name,
571: G_PKG_NAME)
572: THEN

Line 573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

569: p_api_version_number,
570: l_api_name,
571: G_PKG_NAME)
572: THEN
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END IF;
575:
576: -- Initialize message list if p_init_msg_list is set to TRUE.
577: IF FND_API.to_Boolean( p_init_msg_list )

Line 577: IF FND_API.to_Boolean( p_init_msg_list )

573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END IF;
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:

Line 591: x_return_status := FND_API.G_RET_STS_SUCCESS;

587: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
588: END IF;
589:
590: -- Initialize API return status to SUCCESS
591: x_return_status := FND_API.G_RET_STS_SUCCESS;
592:
593: --
594: -- API body
595: --

Line 608: IF x_return_status = FND_API.G_RET_STS_ERROR then

604: p_lead_id => p_lead_id,
605: p_event_key => p_event_key
606: );
607:
608: IF x_return_status = FND_API.G_RET_STS_ERROR then
609: raise FND_API.G_EXC_ERROR;
610: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
611: raise FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;

Line 609: raise FND_API.G_EXC_ERROR;

605: p_event_key => p_event_key
606: );
607:
608: IF x_return_status = FND_API.G_RET_STS_ERROR then
609: raise FND_API.G_EXC_ERROR;
610: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
611: raise FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613:

Line 610: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

606: );
607:
608: IF x_return_status = FND_API.G_RET_STS_ERROR then
609: raise FND_API.G_EXC_ERROR;
610: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
611: raise FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613:
614: --

Line 611: raise FND_API.G_EXC_UNEXPECTED_ERROR;

607:
608: IF x_return_status = FND_API.G_RET_STS_ERROR then
609: raise FND_API.G_EXC_ERROR;
610: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
611: raise FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613:
614: --
615: -- End of API body.

Line 618: IF FND_API.to_Boolean( p_commit )

614: --
615: -- End of API body.
616: --
617:
618: IF FND_API.to_Boolean( p_commit )
619: THEN
620: COMMIT WORK;
621: END IF;
622:

Line 640: WHEN FND_API.G_EXC_ERROR THEN

636: p_data => x_msg_data
637: );
638:
639: EXCEPTION
640: WHEN FND_API.G_EXC_ERROR THEN
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

Line 651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

647: ,X_MSG_COUNT => X_MSG_COUNT
648: ,X_MSG_DATA => X_MSG_DATA
649: ,X_RETURN_STATUS => X_RETURN_STATUS);
650:
651: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 717: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

713:
714:
715: PROCEDURE Before_Opp_STeam_Update(
716: p_api_version_number IN NUMBER,
717: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
718: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
719: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
720: p_lead_id IN NUMBER,
721: x_return_status OUT NOCOPY VARCHAR2,

Line 718: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

714:
715: PROCEDURE Before_Opp_STeam_Update(
716: p_api_version_number IN NUMBER,
717: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
718: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
719: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
720: p_lead_id IN NUMBER,
721: x_return_status OUT NOCOPY VARCHAR2,
722: x_msg_count OUT NOCOPY NUMBER,

Line 719: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

715: PROCEDURE Before_Opp_STeam_Update(
716: p_api_version_number IN NUMBER,
717: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
718: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
719: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
720: p_lead_id IN NUMBER,
721: x_return_status OUT NOCOPY VARCHAR2,
722: x_msg_count OUT NOCOPY NUMBER,
723: x_msg_data OUT NOCOPY VARCHAR2,

Line 736: IF NOT FND_API.Compatible_API_Call( l_api_version_number,

732: BEGIN
733: -- Standard Start of API savepoint
734: SAVEPOINT BEFORE_OPP_STEAM_UPDATE_PUB;
735: -- Standard call to check for call compatibility.
736: IF NOT FND_API.Compatible_API_Call( l_api_version_number,
737: p_api_version_number,
738: l_api_name,
739: G_PKG_NAME)
740: THEN

Line 741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

737: p_api_version_number,
738: l_api_name,
739: G_PKG_NAME)
740: THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END IF;
743:
744: -- Initialize message list if p_init_msg_list is set to TRUE.
745: IF FND_API.to_Boolean( p_init_msg_list )

Line 745: IF FND_API.to_Boolean( p_init_msg_list )

741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END IF;
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:

Line 759: x_return_status := FND_API.G_RET_STS_SUCCESS;

755: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
756: END IF;
757:
758: -- Initialize API return status to SUCCESS
759: x_return_status := FND_API.G_RET_STS_SUCCESS;
760:
761: --
762: -- API body
763: --

Line 776: IF x_return_status = FND_API.G_RET_STS_ERROR then

772: p_lead_id => p_lead_id,
773: x_event_key => x_event_key
774: );
775:
776: IF x_return_status = FND_API.G_RET_STS_ERROR then
777: raise FND_API.G_EXC_ERROR;
778: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
779: raise FND_API.G_EXC_UNEXPECTED_ERROR;
780: END IF;

Line 777: raise FND_API.G_EXC_ERROR;

773: x_event_key => x_event_key
774: );
775:
776: IF x_return_status = FND_API.G_RET_STS_ERROR then
777: raise FND_API.G_EXC_ERROR;
778: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
779: raise FND_API.G_EXC_UNEXPECTED_ERROR;
780: END IF;
781:

Line 778: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

774: );
775:
776: IF x_return_status = FND_API.G_RET_STS_ERROR then
777: raise FND_API.G_EXC_ERROR;
778: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
779: raise FND_API.G_EXC_UNEXPECTED_ERROR;
780: END IF;
781:
782: --

Line 779: raise FND_API.G_EXC_UNEXPECTED_ERROR;

775:
776: IF x_return_status = FND_API.G_RET_STS_ERROR then
777: raise FND_API.G_EXC_ERROR;
778: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
779: raise FND_API.G_EXC_UNEXPECTED_ERROR;
780: END IF;
781:
782: --
783: -- End of API body.

Line 786: IF FND_API.to_Boolean( p_commit )

782: --
783: -- End of API body.
784: --
785:
786: IF FND_API.to_Boolean( p_commit )
787: THEN
788: COMMIT WORK;
789: END IF;
790:

Line 808: WHEN FND_API.G_EXC_ERROR THEN

804: p_data => x_msg_data
805: );
806:
807: EXCEPTION
808: WHEN FND_API.G_EXC_ERROR THEN
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

Line 819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

815: ,X_MSG_COUNT => X_MSG_COUNT
816: ,X_MSG_DATA => X_MSG_DATA
817: ,X_RETURN_STATUS => X_RETURN_STATUS);
818:
819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 880: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

876: -- End of Comments
877:
878: PROCEDURE Upd_Opp_STeam_post_event(
879: p_api_version_number IN NUMBER,
880: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
881: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
882: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
883: p_lead_id IN NUMBER,
884: p_event_key IN VARCHAR2,

Line 881: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

877:
878: PROCEDURE Upd_Opp_STeam_post_event(
879: p_api_version_number IN NUMBER,
880: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
881: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
882: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
883: p_lead_id IN NUMBER,
884: p_event_key IN VARCHAR2,
885: x_return_status OUT NOCOPY VARCHAR2,

Line 882: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

878: PROCEDURE Upd_Opp_STeam_post_event(
879: p_api_version_number IN NUMBER,
880: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
881: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
882: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
883: p_lead_id IN NUMBER,
884: p_event_key IN VARCHAR2,
885: x_return_status OUT NOCOPY VARCHAR2,
886: x_msg_count OUT NOCOPY NUMBER,

Line 899: IF NOT FND_API.Compatible_API_Call( l_api_version_number,

895: BEGIN
896: -- Standard Start of API savepoint
897: SAVEPOINT UPD_OPP_STEAM_POST_EVENT_PUB;
898: -- Standard call to check for call compatibility.
899: IF NOT FND_API.Compatible_API_Call( l_api_version_number,
900: p_api_version_number,
901: l_api_name,
902: G_PKG_NAME)
903: THEN

Line 904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

900: p_api_version_number,
901: l_api_name,
902: G_PKG_NAME)
903: THEN
904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;
906:
907: -- Initialize message list if p_init_msg_list is set to TRUE.
908: IF FND_API.to_Boolean( p_init_msg_list )

Line 908: IF FND_API.to_Boolean( p_init_msg_list )

904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;
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:

Line 922: x_return_status := FND_API.G_RET_STS_SUCCESS;

918: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
919: END IF;
920:
921: -- Initialize API return status to SUCCESS
922: x_return_status := FND_API.G_RET_STS_SUCCESS;
923:
924: --
925: -- API body
926: --

Line 939: IF x_return_status = FND_API.G_RET_STS_ERROR then

935: p_lead_id => p_lead_id,
936: p_event_key => p_event_key
937: );
938:
939: IF x_return_status = FND_API.G_RET_STS_ERROR then
940: raise FND_API.G_EXC_ERROR;
941: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
942: raise FND_API.G_EXC_UNEXPECTED_ERROR;
943: END IF;

Line 940: raise FND_API.G_EXC_ERROR;

936: p_event_key => p_event_key
937: );
938:
939: IF x_return_status = FND_API.G_RET_STS_ERROR then
940: raise FND_API.G_EXC_ERROR;
941: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
942: raise FND_API.G_EXC_UNEXPECTED_ERROR;
943: END IF;
944:

Line 941: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

937: );
938:
939: IF x_return_status = FND_API.G_RET_STS_ERROR then
940: raise FND_API.G_EXC_ERROR;
941: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
942: raise FND_API.G_EXC_UNEXPECTED_ERROR;
943: END IF;
944:
945: --

Line 942: raise FND_API.G_EXC_UNEXPECTED_ERROR;

938:
939: IF x_return_status = FND_API.G_RET_STS_ERROR then
940: raise FND_API.G_EXC_ERROR;
941: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
942: raise FND_API.G_EXC_UNEXPECTED_ERROR;
943: END IF;
944:
945: --
946: -- End of API body.

Line 949: IF FND_API.to_Boolean( p_commit )

945: --
946: -- End of API body.
947: --
948:
949: IF FND_API.to_Boolean( p_commit )
950: THEN
951: COMMIT WORK;
952: END IF;
953:

Line 971: WHEN FND_API.G_EXC_ERROR THEN

967: p_data => x_msg_data
968: );
969:
970: EXCEPTION
971: WHEN FND_API.G_EXC_ERROR THEN
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

Line 982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

978: ,X_MSG_COUNT => X_MSG_COUNT
979: ,X_MSG_DATA => X_MSG_DATA
980: ,X_RETURN_STATUS => X_RETURN_STATUS);
981:
982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 1048: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1044:
1045:
1046: PROCEDURE Before_Cust_STeam_Update(
1047: p_api_version_number IN NUMBER,
1048: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1049: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1050: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1051: p_cust_id IN NUMBER,
1052: x_return_status OUT NOCOPY VARCHAR2,

Line 1049: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1045:
1046: PROCEDURE Before_Cust_STeam_Update(
1047: p_api_version_number IN NUMBER,
1048: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1049: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1050: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1051: p_cust_id IN NUMBER,
1052: x_return_status OUT NOCOPY VARCHAR2,
1053: x_msg_count OUT NOCOPY NUMBER,

Line 1050: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1046: PROCEDURE Before_Cust_STeam_Update(
1047: p_api_version_number IN NUMBER,
1048: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1049: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1050: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1051: p_cust_id IN NUMBER,
1052: x_return_status OUT NOCOPY VARCHAR2,
1053: x_msg_count OUT NOCOPY NUMBER,
1054: x_msg_data OUT NOCOPY VARCHAR2,

Line 1067: IF NOT FND_API.Compatible_API_Call( l_api_version_number,

1063: BEGIN
1064: -- Standard Start of API savepoint
1065: SAVEPOINT BEFORE_CUST_STEAM_UPDATE_PUB;
1066: -- Standard call to check for call compatibility.
1067: IF NOT FND_API.Compatible_API_Call( l_api_version_number,
1068: p_api_version_number,
1069: l_api_name,
1070: G_PKG_NAME)
1071: THEN

Line 1072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1068: p_api_version_number,
1069: l_api_name,
1070: G_PKG_NAME)
1071: THEN
1072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1073: END IF;
1074:
1075: -- Initialize message list if p_init_msg_list is set to TRUE.
1076: IF FND_API.to_Boolean( p_init_msg_list )

Line 1076: IF FND_API.to_Boolean( p_init_msg_list )

1072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1073: END IF;
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:

Line 1090: x_return_status := FND_API.G_RET_STS_SUCCESS;

1086: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1087: END IF;
1088:
1089: -- Initialize API return status to SUCCESS
1090: x_return_status := FND_API.G_RET_STS_SUCCESS;
1091:
1092: --
1093: -- API body
1094: --

Line 1107: IF x_return_status = FND_API.G_RET_STS_ERROR then

1103: p_cust_id => p_cust_id,
1104: x_event_key => x_event_key
1105: );
1106:
1107: IF x_return_status = FND_API.G_RET_STS_ERROR then
1108: raise FND_API.G_EXC_ERROR;
1109: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1110: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1111: END IF;

Line 1108: raise FND_API.G_EXC_ERROR;

1104: x_event_key => x_event_key
1105: );
1106:
1107: IF x_return_status = FND_API.G_RET_STS_ERROR then
1108: raise FND_API.G_EXC_ERROR;
1109: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1110: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1111: END IF;
1112:

Line 1109: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1105: );
1106:
1107: IF x_return_status = FND_API.G_RET_STS_ERROR then
1108: raise FND_API.G_EXC_ERROR;
1109: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1110: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1111: END IF;
1112:
1113: --

Line 1110: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1106:
1107: IF x_return_status = FND_API.G_RET_STS_ERROR then
1108: raise FND_API.G_EXC_ERROR;
1109: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1110: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1111: END IF;
1112:
1113: --
1114: -- End of API body.

Line 1117: IF FND_API.to_Boolean( p_commit )

1113: --
1114: -- End of API body.
1115: --
1116:
1117: IF FND_API.to_Boolean( p_commit )
1118: THEN
1119: COMMIT WORK;
1120: END IF;
1121:

Line 1139: WHEN FND_API.G_EXC_ERROR THEN

1135: p_data => x_msg_data
1136: );
1137:
1138: EXCEPTION
1139: WHEN FND_API.G_EXC_ERROR THEN
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

Line 1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1146: ,X_MSG_COUNT => X_MSG_COUNT
1147: ,X_MSG_DATA => X_MSG_DATA
1148: ,X_RETURN_STATUS => X_RETURN_STATUS);
1149:
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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

Line 1211: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1207: -- End of Comments
1208:
1209: PROCEDURE Upd_Cust_STeam_post_event(
1210: p_api_version_number IN NUMBER,
1211: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1212: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1213: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1214: p_cust_id IN NUMBER,
1215: p_event_key IN VARCHAR2,

Line 1212: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

1208:
1209: PROCEDURE Upd_Cust_STeam_post_event(
1210: p_api_version_number IN NUMBER,
1211: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1212: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1213: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1214: p_cust_id IN NUMBER,
1215: p_event_key IN VARCHAR2,
1216: x_return_status OUT NOCOPY VARCHAR2,

Line 1213: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

1209: PROCEDURE Upd_Cust_STeam_post_event(
1210: p_api_version_number IN NUMBER,
1211: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1212: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1213: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1214: p_cust_id IN NUMBER,
1215: p_event_key IN VARCHAR2,
1216: x_return_status OUT NOCOPY VARCHAR2,
1217: x_msg_count OUT NOCOPY NUMBER,

Line 1230: IF NOT FND_API.Compatible_API_Call( l_api_version_number,

1226: BEGIN
1227: -- Standard Start of API savepoint
1228: SAVEPOINT UPD_CUST_STEAM_POST_EVENT_PUB;
1229: -- Standard call to check for call compatibility.
1230: IF NOT FND_API.Compatible_API_Call( l_api_version_number,
1231: p_api_version_number,
1232: l_api_name,
1233: G_PKG_NAME)
1234: THEN

Line 1235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1231: p_api_version_number,
1232: l_api_name,
1233: G_PKG_NAME)
1234: THEN
1235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1236: END IF;
1237:
1238: -- Initialize message list if p_init_msg_list is set to TRUE.
1239: IF FND_API.to_Boolean( p_init_msg_list )

Line 1239: IF FND_API.to_Boolean( p_init_msg_list )

1235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1236: END IF;
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:

Line 1253: x_return_status := FND_API.G_RET_STS_SUCCESS;

1249: 'Start time: ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1250: END IF;
1251:
1252: -- Initialize API return status to SUCCESS
1253: x_return_status := FND_API.G_RET_STS_SUCCESS;
1254:
1255: --
1256: -- API body
1257: --

Line 1270: IF x_return_status = FND_API.G_RET_STS_ERROR then

1266: p_cust_id => p_cust_id,
1267: p_event_key => p_event_key
1268: );
1269:
1270: IF x_return_status = FND_API.G_RET_STS_ERROR then
1271: raise FND_API.G_EXC_ERROR;
1272: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1273: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;

Line 1271: raise FND_API.G_EXC_ERROR;

1267: p_event_key => p_event_key
1268: );
1269:
1270: IF x_return_status = FND_API.G_RET_STS_ERROR then
1271: raise FND_API.G_EXC_ERROR;
1272: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1273: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275:

Line 1272: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1268: );
1269:
1270: IF x_return_status = FND_API.G_RET_STS_ERROR then
1271: raise FND_API.G_EXC_ERROR;
1272: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1273: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275:
1276: --

Line 1273: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1269:
1270: IF x_return_status = FND_API.G_RET_STS_ERROR then
1271: raise FND_API.G_EXC_ERROR;
1272: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1273: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275:
1276: --
1277: -- End of API body.

Line 1280: IF FND_API.to_Boolean( p_commit )

1276: --
1277: -- End of API body.
1278: --
1279:
1280: IF FND_API.to_Boolean( p_commit )
1281: THEN
1282: COMMIT WORK;
1283: END IF;
1284:

Line 1302: WHEN FND_API.G_EXC_ERROR THEN

1298: p_data => x_msg_data
1299: );
1300:
1301: EXCEPTION
1302: WHEN FND_API.G_EXC_ERROR THEN
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

Line 1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1309: ,X_MSG_COUNT => X_MSG_COUNT
1310: ,X_MSG_DATA => X_MSG_DATA
1311: ,X_RETURN_STATUS => X_RETURN_STATUS);
1312:
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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