DBA Data[Home] [Help]

APPS.CSD_GEN_ERRMSGS_PVT dependencies on FND_API

Line 33: /* fnd_api.g_ret_sts_success (success) */

29: /* 'TASK', */
30: /* 'WIP', */
31: /* p_source_entity_id_2 NUMBER Required source entity_id 2. */
32: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
33: /* fnd_api.g_ret_sts_success (success) */
34: /* fnd_api.g_ret_sts_error (error) */
35: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
36: /* x_msg_count NUMBER Number of messages in the message stack */
37: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 34: /* fnd_api.g_ret_sts_error (error) */

30: /* 'WIP', */
31: /* p_source_entity_id_2 NUMBER Required source entity_id 2. */
32: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
33: /* fnd_api.g_ret_sts_success (success) */
34: /* fnd_api.g_ret_sts_error (error) */
35: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
36: /* x_msg_count NUMBER Number of messages in the message stack */
37: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
38: /*-----------------------------------------------------------------------------------------------------------*/

Line 35: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

31: /* p_source_entity_id_2 NUMBER Required source entity_id 2. */
32: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
33: /* fnd_api.g_ret_sts_success (success) */
34: /* fnd_api.g_ret_sts_error (error) */
35: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
36: /* x_msg_count NUMBER Number of messages in the message stack */
37: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
38: /*-----------------------------------------------------------------------------------------------------------*/
39: PROCEDURE save_fnd_msgs (

Line 77: IF NOT fnd_api.compatible_api_call (l_api_version_number,

73: END IF;
74:
75:
76: -- Standard call to check for call compatibility.
77: IF NOT fnd_api.compatible_api_call (l_api_version_number,
78: p_api_version,
79: l_api_name,
80: g_pkg_name
81: )

Line 83: RAISE fnd_api.g_exc_unexpected_error;

79: l_api_name,
80: g_pkg_name
81: )
82: THEN
83: RAISE fnd_api.g_exc_unexpected_error;
84: END IF;
85:
86: -- initialize return status
87: x_return_status := fnd_api.g_ret_sts_success;

Line 87: x_return_status := fnd_api.g_ret_sts_success;

83: RAISE fnd_api.g_exc_unexpected_error;
84: END IF;
85:
86: -- initialize return status
87: x_return_status := fnd_api.g_ret_sts_success;
88:
89: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
90: THEN
91: fnd_log.STRING (fnd_log.level_statement,

Line 157: RAISE fnd_api.g_exc_error;

153: IF (NOT validate_module_code (p_module => p_module_code))
154: THEN
155: fnd_message.set_name ('CSD', 'CSD_INVALID_MSG_MODULE');
156: fnd_msg_pub.ADD;
157: RAISE fnd_api.g_exc_error;
158: END IF;
159:
160: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
161: THEN

Line 186: l_msg := fnd_msg_pub.get_detail (p_encoded => fnd_api.g_true);

182:
183: -- To get the message type from the message in the stack we need
184: -- to use the get_detail api. The message type should have been
185: -- added by the add_detail API.
186: l_msg := fnd_msg_pub.get_detail (p_encoded => fnd_api.g_true);
187:
188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
189: THEN
190: fnd_log.STRING (fnd_log.level_statement,

Line 306: WHEN fnd_api.g_exc_error

302: 'Leaving SAVE_FND_MSGS'
303: );
304: END IF;
305: EXCEPTION
306: WHEN fnd_api.g_exc_error
307: THEN
308: x_return_status := fnd_api.g_ret_sts_error;
309: ROLLBACK; --TO SP_Save_Fnd_Msgs;
310: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 308: x_return_status := fnd_api.g_ret_sts_error;

304: END IF;
305: EXCEPTION
306: WHEN fnd_api.g_exc_error
307: THEN
308: x_return_status := fnd_api.g_ret_sts_error;
309: ROLLBACK; --TO SP_Save_Fnd_Msgs;
310: fnd_msg_pub.count_and_get (p_count => x_msg_count,
311: p_data => x_msg_data
312: );

Line 321: WHEN fnd_api.g_exc_unexpected_error

317: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.SAVE_FND_MSGS',
318: 'EXC_ERROR[' || x_msg_data || ']'
319: );
320: END IF;
321: WHEN fnd_api.g_exc_unexpected_error
322: THEN
323: x_return_status := fnd_api.g_ret_sts_unexp_error;
324: ROLLBACK; --TO SP_Save_Fnd_Msgs;
325: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 323: x_return_status := fnd_api.g_ret_sts_unexp_error;

319: );
320: END IF;
321: WHEN fnd_api.g_exc_unexpected_error
322: THEN
323: x_return_status := fnd_api.g_ret_sts_unexp_error;
324: ROLLBACK; --TO SP_Save_Fnd_Msgs;
325: fnd_msg_pub.count_and_get (p_count => x_msg_count,
326: p_data => x_msg_data
327: );

Line 338: x_return_status := fnd_api.g_ret_sts_unexp_error;

334: );
335: END IF;
336: WHEN OTHERS
337: THEN
338: x_return_status := fnd_api.g_ret_sts_unexp_error;
339: ROLLBACK; --TO SP_Save_Fnd_Msgs;
340:
341: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
342: THEN

Line 366: /* fnd_api.g_ret_sts_success (success) */

362: /* Called from : */
363: /* Input Parm : p_api_version NUMBER Required Api Version number */
364: /* p_generic_errmsgs_id NUMBER Required KEy field for the messages table */
365: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
366: /* fnd_api.g_ret_sts_success (success) */
367: /* fnd_api.g_ret_sts_error (error) */
368: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
369: /* x_msg_count NUMBER Number of messages in the message stack */
370: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 367: /* fnd_api.g_ret_sts_error (error) */

363: /* Input Parm : p_api_version NUMBER Required Api Version number */
364: /* p_generic_errmsgs_id NUMBER Required KEy field for the messages table */
365: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
366: /* fnd_api.g_ret_sts_success (success) */
367: /* fnd_api.g_ret_sts_error (error) */
368: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
369: /* x_msg_count NUMBER Number of messages in the message stack */
370: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
371: /*-----------------------------------------------------------------------------------------------------------*/

Line 368: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

364: /* p_generic_errmsgs_id NUMBER Required KEy field for the messages table */
365: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
366: /* fnd_api.g_ret_sts_success (success) */
367: /* fnd_api.g_ret_sts_error (error) */
368: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
369: /* x_msg_count NUMBER Number of messages in the message stack */
370: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
371: /*-----------------------------------------------------------------------------------------------------------*/
372: PROCEDURE purge_msg (

Line 395: IF NOT fnd_api.compatible_api_call (l_api_version_number,

391: );
392: END IF;
393:
394: -- Standard call to check for call compatibility.
395: IF NOT fnd_api.compatible_api_call (l_api_version_number,
396: p_api_version,
397: l_api_name,
398: g_pkg_name
399: )

Line 401: RAISE fnd_api.g_exc_unexpected_error;

397: l_api_name,
398: g_pkg_name
399: )
400: THEN
401: RAISE fnd_api.g_exc_unexpected_error;
402: END IF;
403:
404: -- initialize return status
405: x_return_status := fnd_api.g_ret_sts_success;

Line 405: x_return_status := fnd_api.g_ret_sts_success;

401: RAISE fnd_api.g_exc_unexpected_error;
402: END IF;
403:
404: -- initialize return status
405: x_return_status := fnd_api.g_ret_sts_success;
406:
407: BEGIN
408: DELETE FROM csd_generic_errmsgs
409: WHERE generic_errmsgs_id = p_generic_errmsgs_id;

Line 415: RAISE fnd_api.g_exc_error;

411: WHEN NO_DATA_FOUND
412: THEN
413: fnd_message.set_name ('CSD', 'CSD_INVALID_ERRMSGS_ID');
414: fnd_msg_pub.ADD;
415: RAISE fnd_api.g_exc_error;
416: WHEN OTHERS
417: THEN
418: RAISE fnd_api.g_exc_unexpected_error;
419: END;

Line 418: RAISE fnd_api.g_exc_unexpected_error;

414: fnd_msg_pub.ADD;
415: RAISE fnd_api.g_exc_error;
416: WHEN OTHERS
417: THEN
418: RAISE fnd_api.g_exc_unexpected_error;
419: END;
420:
421: COMMIT;
422:

Line 435: WHEN fnd_api.g_exc_error

431: 'Leaving Purge_Msg'
432: );
433: END IF;
434: EXCEPTION
435: WHEN fnd_api.g_exc_error
436: THEN
437: x_return_status := fnd_api.g_ret_sts_error;
438: ROLLBACK TO sp_purge_msg;
439: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 437: x_return_status := fnd_api.g_ret_sts_error;

433: END IF;
434: EXCEPTION
435: WHEN fnd_api.g_exc_error
436: THEN
437: x_return_status := fnd_api.g_ret_sts_error;
438: ROLLBACK TO sp_purge_msg;
439: fnd_msg_pub.count_and_get (p_count => x_msg_count,
440: p_data => x_msg_data
441: );

Line 450: WHEN fnd_api.g_exc_unexpected_error

446: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_MSG',
447: 'EXC_ERROR[' || x_msg_data || ']'
448: );
449: END IF;
450: WHEN fnd_api.g_exc_unexpected_error
451: THEN
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: ROLLBACK TO sp_purge_msg;
454: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 452: x_return_status := fnd_api.g_ret_sts_unexp_error;

448: );
449: END IF;
450: WHEN fnd_api.g_exc_unexpected_error
451: THEN
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: ROLLBACK TO sp_purge_msg;
454: fnd_msg_pub.count_and_get (p_count => x_msg_count,
455: p_data => x_msg_data
456: );

Line 467: x_return_status := fnd_api.g_ret_sts_unexp_error;

463: );
464: END IF;
465: WHEN OTHERS
466: THEN
467: x_return_status := fnd_api.g_ret_sts_unexp_error;
468: ROLLBACK TO sp_purge_msg;
469:
470: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
471: THEN

Line 505: /* fnd_api.g_ret_sts_success (success) */

501: /* 'TASK', */
502: /* 'WIP', */
503: /* p_source_entity_id_2 NUMBER Optional source entity_id 2. */
504: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
505: /* fnd_api.g_ret_sts_success (success) */
506: /* fnd_api.g_ret_sts_error (error) */
507: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
508: /* x_msg_count NUMBER Number of messages in the message stack */
509: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 506: /* fnd_api.g_ret_sts_error (error) */

502: /* 'WIP', */
503: /* p_source_entity_id_2 NUMBER Optional source entity_id 2. */
504: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
505: /* fnd_api.g_ret_sts_success (success) */
506: /* fnd_api.g_ret_sts_error (error) */
507: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
508: /* x_msg_count NUMBER Number of messages in the message stack */
509: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
510: /*-----------------------------------------------------------------------------------------------------------*/

Line 507: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

503: /* p_source_entity_id_2 NUMBER Optional source entity_id 2. */
504: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
505: /* fnd_api.g_ret_sts_success (success) */
506: /* fnd_api.g_ret_sts_error (error) */
507: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
508: /* x_msg_count NUMBER Number of messages in the message stack */
509: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
510: /*-----------------------------------------------------------------------------------------------------------*/
511: PROCEDURE purge_entity_msgs (

Line 537: IF NOT fnd_api.compatible_api_call (l_api_version_number,

533: );
534: END IF;
535:
536: -- Standard call to check for call compatibility.
537: IF NOT fnd_api.compatible_api_call (l_api_version_number,
538: p_api_version,
539: l_api_name,
540: g_pkg_name
541: )

Line 543: RAISE fnd_api.g_exc_unexpected_error;

539: l_api_name,
540: g_pkg_name
541: )
542: THEN
543: RAISE fnd_api.g_exc_unexpected_error;
544: END IF;
545:
546: -- initialize return status
547: x_return_status := fnd_api.g_ret_sts_success;

Line 547: x_return_status := fnd_api.g_ret_sts_success;

543: RAISE fnd_api.g_exc_unexpected_error;
544: END IF;
545:
546: -- initialize return status
547: x_return_status := fnd_api.g_ret_sts_success;
548: -- Check for required parameters
549: csd_process_util.check_reqd_param (p_param_value => p_module_code,
550: p_param_name => 'p_module_code',
551: p_api_name => l_api_name

Line 572: RAISE fnd_api.g_exc_unexpected_error;

568: THEN
569: NULL;
570: WHEN OTHERS
571: THEN
572: RAISE fnd_api.g_exc_unexpected_error;
573: END;
574:
575: COMMIT;
576:

Line 590: WHEN fnd_api.g_exc_error

586: 'Leaving PURGE_ENTITY_MSGS'
587: );
588: END IF;
589: EXCEPTION
590: WHEN fnd_api.g_exc_error
591: THEN
592: x_return_status := fnd_api.g_ret_sts_error;
593: ROLLBACK; --TO SP_PURGE_ENTITY_MSGS;
594: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 592: x_return_status := fnd_api.g_ret_sts_error;

588: END IF;
589: EXCEPTION
590: WHEN fnd_api.g_exc_error
591: THEN
592: x_return_status := fnd_api.g_ret_sts_error;
593: ROLLBACK; --TO SP_PURGE_ENTITY_MSGS;
594: fnd_msg_pub.count_and_get (p_count => x_msg_count,
595: p_data => x_msg_data
596: );

Line 606: WHEN fnd_api.g_exc_unexpected_error

602: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.PURGE_ENTITY_MSGS',
603: 'EXC_ERROR[' || x_msg_data || ']'
604: );
605: END IF;
606: WHEN fnd_api.g_exc_unexpected_error
607: THEN
608: x_return_status := fnd_api.g_ret_sts_unexp_error;
609: ROLLBACK; --TO SP_PURGE_ENTITY_MSGS;
610: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 608: x_return_status := fnd_api.g_ret_sts_unexp_error;

604: );
605: END IF;
606: WHEN fnd_api.g_exc_unexpected_error
607: THEN
608: x_return_status := fnd_api.g_ret_sts_unexp_error;
609: ROLLBACK; --TO SP_PURGE_ENTITY_MSGS;
610: fnd_msg_pub.count_and_get (p_count => x_msg_count,
611: p_data => x_msg_data
612: );

Line 624: x_return_status := fnd_api.g_ret_sts_unexp_error;

620: );
621: END IF;
622: WHEN OTHERS
623: THEN
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625: ROLLBACK; --TO SP_PURGE_ENTITY_MSGS;
626:
627: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
628: THEN

Line 652: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */

648: /* description : This API will retrieve the messages from the table, populates the message data structure */
649: /* and returns the messages data structures.
650: /* Called from : */
651: /* Input Parm : p_api_version NUMBER Required Api Version number */
652: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
653: /* default value is fnd_api.g_false */
654: /* p_module_code VARCHAR2 Required module which is saving the message. */
655: /* p_source_entity_id_1 NUMBER optional source entity_id 1. */
656: /* This is usually the repair line id. */

Line 653: /* default value is fnd_api.g_false */

649: /* and returns the messages data structures.
650: /* Called from : */
651: /* Input Parm : p_api_version NUMBER Required Api Version number */
652: /* p_init_msg_list VARCHAR2 Optional Initializes message stack if fnd_api.g_true, */
653: /* default value is fnd_api.g_false */
654: /* p_module_code VARCHAR2 Required module which is saving the message. */
655: /* p_source_entity_id_1 NUMBER optional source entity_id 1. */
656: /* This is usually the repair line id. */
657: /* p_source_entity_type_code VARCHAR2 Optional Seeded entity type code. */

Line 667: /* fnd_api.g_ret_sts_success (success) */

663: /* 'WIP', */
664: /* p_source_entity_id_2 NUMBER Optional source entity_id 2. */
665: /* Output Parm : x_errmsgs_tbl CSD_ERRMSGS_TBL table of message records */
666: /* x_return_status VARCHAR2 Return status after the call. The status can be*/
667: /* fnd_api.g_ret_sts_success (success) */
668: /* fnd_api.g_ret_sts_error (error) */
669: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
670: /* x_msg_count NUMBER Number of messages in the message stack */
671: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */

Line 668: /* fnd_api.g_ret_sts_error (error) */

664: /* p_source_entity_id_2 NUMBER Optional source entity_id 2. */
665: /* Output Parm : x_errmsgs_tbl CSD_ERRMSGS_TBL table of message records */
666: /* x_return_status VARCHAR2 Return status after the call. The status can be*/
667: /* fnd_api.g_ret_sts_success (success) */
668: /* fnd_api.g_ret_sts_error (error) */
669: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
670: /* x_msg_count NUMBER Number of messages in the message stack */
671: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
672: /*-----------------------------------------------------------------------------------------------------------*/

Line 669: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

665: /* Output Parm : x_errmsgs_tbl CSD_ERRMSGS_TBL table of message records */
666: /* x_return_status VARCHAR2 Return status after the call. The status can be*/
667: /* fnd_api.g_ret_sts_success (success) */
668: /* fnd_api.g_ret_sts_error (error) */
669: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
670: /* x_msg_count NUMBER Number of messages in the message stack */
671: /* x_msg_data VARCHAR2 Message text if x_msg_count >= 1 */
672: /*-----------------------------------------------------------------------------------------------------------*/
673: PROCEDURE get_errmsgs (

Line 771: IF fnd_api.to_boolean (p_init_msg_list)

767: 'Entered GET_ERRMSGS'
768: );
769: END IF;
770:
771: IF fnd_api.to_boolean (p_init_msg_list)
772: THEN
773: -- initialize message list
774: fnd_msg_pub.initialize;
775: END IF;

Line 778: IF NOT fnd_api.compatible_api_call (l_api_version_number,

774: fnd_msg_pub.initialize;
775: END IF;
776:
777: -- Standard call to check for call compatibility.
778: IF NOT fnd_api.compatible_api_call (l_api_version_number,
779: p_api_version,
780: l_api_name,
781: g_pkg_name
782: )

Line 784: RAISE fnd_api.g_exc_unexpected_error;

780: l_api_name,
781: g_pkg_name
782: )
783: THEN
784: RAISE fnd_api.g_exc_unexpected_error;
785: END IF;
786:
787: -- initialize return status
788: x_return_status := fnd_api.g_ret_sts_success;

Line 788: x_return_status := fnd_api.g_ret_sts_success;

784: RAISE fnd_api.g_exc_unexpected_error;
785: END IF;
786:
787: -- initialize return status
788: x_return_status := fnd_api.g_ret_sts_success;
789:
790: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
791: THEN
792: fnd_log.STRING (fnd_log.level_statement,

Line 972: WHEN fnd_api.g_exc_error

968: -- Standard call to get message count and IF count is get message info.
969: fnd_msg_pub.count_and_get (p_count => x_msg_count,
970: p_data => x_msg_data);
971: EXCEPTION
972: WHEN fnd_api.g_exc_error
973: THEN
974: x_return_status := fnd_api.g_ret_sts_error;
975: fnd_msg_pub.count_and_get (p_count => x_msg_count,
976: p_data => x_msg_data

Line 974: x_return_status := fnd_api.g_ret_sts_error;

970: p_data => x_msg_data);
971: EXCEPTION
972: WHEN fnd_api.g_exc_error
973: THEN
974: x_return_status := fnd_api.g_ret_sts_error;
975: fnd_msg_pub.count_and_get (p_count => x_msg_count,
976: p_data => x_msg_data
977: );
978:

Line 986: WHEN fnd_api.g_exc_unexpected_error

982: 'CSD.PLSQL.CSD_GEN_ERRMSGS_PVT.GET_ERRMSGS',
983: 'EXC_ERROR[' || x_msg_data || ']'
984: );
985: END IF;
986: WHEN fnd_api.g_exc_unexpected_error
987: THEN
988: x_return_status := fnd_api.g_ret_sts_unexp_error;
989: fnd_msg_pub.count_and_get (p_count => x_msg_count,
990: p_data => x_msg_data

Line 988: x_return_status := fnd_api.g_ret_sts_unexp_error;

984: );
985: END IF;
986: WHEN fnd_api.g_exc_unexpected_error
987: THEN
988: x_return_status := fnd_api.g_ret_sts_unexp_error;
989: fnd_msg_pub.count_and_get (p_count => x_msg_count,
990: p_data => x_msg_data
991: );
992:

Line 1002: x_return_status := fnd_api.g_ret_sts_unexp_error;

998: );
999: END IF;
1000: WHEN OTHERS
1001: THEN
1002: x_return_status := fnd_api.g_ret_sts_unexp_error;
1003:
1004: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1005: THEN
1006: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1038: /* fnd_api.g_ret_sts_success (success) */

1034: /* 'TASK', */
1035: /* 'WIP', */
1036: /* p_source_entity_id_2 NUMBER Optional source entity_id 2. */
1037: /* Output Parm : errbuf VARCHAR2 Return status after the call. The status can be*/
1038: /* fnd_api.g_ret_sts_success (success) */
1039: /* fnd_api.g_ret_sts_error (error) */
1040: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1041: /* retcode NUMBER Number of messages in the message stack */
1042: /*-----------------------------------------------------------------------------------------------------------*/

Line 1039: /* fnd_api.g_ret_sts_error (error) */

1035: /* 'WIP', */
1036: /* p_source_entity_id_2 NUMBER Optional source entity_id 2. */
1037: /* Output Parm : errbuf VARCHAR2 Return status after the call. The status can be*/
1038: /* fnd_api.g_ret_sts_success (success) */
1039: /* fnd_api.g_ret_sts_error (error) */
1040: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1041: /* retcode NUMBER Number of messages in the message stack */
1042: /*-----------------------------------------------------------------------------------------------------------*/
1043: PROCEDURE purge_entity_msgs_cp (

Line 1040: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

1036: /* p_source_entity_id_2 NUMBER Optional source entity_id 2. */
1037: /* Output Parm : errbuf VARCHAR2 Return status after the call. The status can be*/
1038: /* fnd_api.g_ret_sts_success (success) */
1039: /* fnd_api.g_ret_sts_error (error) */
1040: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
1041: /* retcode NUMBER Number of messages in the message stack */
1042: /*-----------------------------------------------------------------------------------------------------------*/
1043: PROCEDURE purge_entity_msgs_cp (
1044: errbuf OUT NOCOPY VARCHAR2,

Line 1077: IF (l_return_status <> fnd_api.g_ret_sts_success)

1073: x_msg_count => l_msg_count,
1074: x_msg_data => l_msg_data
1075: );
1076:
1077: IF (l_return_status <> fnd_api.g_ret_sts_success)
1078: THEN
1079: FOR l_index IN 1 .. l_msg_count
1080: LOOP
1081: fnd_msg_pub.get (p_msg_index => l_index,

Line 1082: p_encoded => fnd_api.g_false,

1078: THEN
1079: FOR l_index IN 1 .. l_msg_count
1080: LOOP
1081: fnd_msg_pub.get (p_msg_index => l_index,
1082: p_encoded => fnd_api.g_false,
1083: p_data => l_msg_data,
1084: p_msg_index_out => l_msg_index_out
1085: );
1086: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level)