95: END IF;
96: EXCEPTION
97: WHEN OTHERS
98: THEN
99: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
100: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
101: fnd_message.set_token ('P_TEXT', l_api_name_full
102: || '-'
103: || SQLERRM);
96: EXCEPTION
97: WHEN OTHERS
98: THEN
99: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
100: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
101: fnd_message.set_token ('P_TEXT', l_api_name_full
102: || '-'
103: || SQLERRM);
104: fnd_msg_pub.ADD;
97: WHEN OTHERS
98: THEN
99: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
100: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
101: fnd_message.set_token ('P_TEXT', l_api_name_full
102: || '-'
103: || SQLERRM);
104: fnd_msg_pub.ADD;
105:
363: END IF;
364: EXCEPTION
365: WHEN OTHERS
366: THEN
367: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
368: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
369: fnd_message.set_token ('P_TEXT', l_api_name_full
370: || '-'
371: || SQLERRM);
364: EXCEPTION
365: WHEN OTHERS
366: THEN
367: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
368: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
369: fnd_message.set_token ('P_TEXT', l_api_name_full
370: || '-'
371: || SQLERRM);
372: fnd_msg_pub.ADD;
365: WHEN OTHERS
366: THEN
367: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
368: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
369: fnd_message.set_token ('P_TEXT', l_api_name_full
370: || '-'
371: || SQLERRM);
372: fnd_msg_pub.ADD;
373:
486: END IF;
487: EXCEPTION
488: WHEN OTHERS
489: THEN
490: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
491: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
492: fnd_message.set_token ('P_TEXT', l_api_name_full
493: || '-'
494: || SQLERRM);
487: EXCEPTION
488: WHEN OTHERS
489: THEN
490: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
491: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
492: fnd_message.set_token ('P_TEXT', l_api_name_full
493: || '-'
494: || SQLERRM);
495: fnd_msg_pub.ADD;
488: WHEN OTHERS
489: THEN
490: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
491: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
492: fnd_message.set_token ('P_TEXT', l_api_name_full
493: || '-'
494: || SQLERRM);
495: fnd_msg_pub.ADD;
496:
573: END IF;
574: EXCEPTION
575: WHEN OTHERS
576: THEN
577: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
578: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
579: fnd_message.set_token ('P_TEXT', l_api_name_full
580: || '-'
581: || SQLERRM);
574: EXCEPTION
575: WHEN OTHERS
576: THEN
577: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
578: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
579: fnd_message.set_token ('P_TEXT', l_api_name_full
580: || '-'
581: || SQLERRM);
582: fnd_msg_pub.ADD;
575: WHEN OTHERS
576: THEN
577: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
578: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
579: fnd_message.set_token ('P_TEXT', l_api_name_full
580: || '-'
581: || SQLERRM);
582: fnd_msg_pub.ADD;
583:
665: END IF;
666: EXCEPTION
667: WHEN OTHERS
668: THEN
669: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
670: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
671: fnd_message.set_token ('P_TEXT', l_api_name_full
672: || '-'
673: || SQLERRM);
666: EXCEPTION
667: WHEN OTHERS
668: THEN
669: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
670: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
671: fnd_message.set_token ('P_TEXT', l_api_name_full
672: || '-'
673: || SQLERRM);
674: fnd_msg_pub.ADD;
667: WHEN OTHERS
668: THEN
669: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
670: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
671: fnd_message.set_token ('P_TEXT', l_api_name_full
672: || '-'
673: || SQLERRM);
674: fnd_msg_pub.ADD;
675:
746: END IF;
747: EXCEPTION
748: WHEN OTHERS
749: THEN
750: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
751: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
752: fnd_message.set_token ('P_TEXT', l_api_name_full
753: || '-'
754: || SQLERRM);
747: EXCEPTION
748: WHEN OTHERS
749: THEN
750: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
751: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
752: fnd_message.set_token ('P_TEXT', l_api_name_full
753: || '-'
754: || SQLERRM);
755: fnd_msg_pub.ADD;
748: WHEN OTHERS
749: THEN
750: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
751: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
752: fnd_message.set_token ('P_TEXT', l_api_name_full
753: || '-'
754: || SQLERRM);
755: fnd_msg_pub.ADD;
756:
850: END IF;
851: EXCEPTION
852: WHEN OTHERS
853: THEN
854: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
855: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
856: fnd_message.set_token ('P_TEXT', l_api_name_full
857: || '-'
858: || SQLERRM);
851: EXCEPTION
852: WHEN OTHERS
853: THEN
854: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
855: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
856: fnd_message.set_token ('P_TEXT', l_api_name_full
857: || '-'
858: || SQLERRM);
859: fnd_msg_pub.ADD;
852: WHEN OTHERS
853: THEN
854: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
855: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
856: fnd_message.set_token ('P_TEXT', l_api_name_full
857: || '-'
858: || SQLERRM);
859: fnd_msg_pub.ADD;
860:
960:
961: EXCEPTION
962: WHEN OTHERS
963: THEN
964: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
965: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
966: fnd_message.set_token ('P_TEXT', l_api_name_full
967: || '-'
968: || SQLERRM);
961: EXCEPTION
962: WHEN OTHERS
963: THEN
964: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
965: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
966: fnd_message.set_token ('P_TEXT', l_api_name_full
967: || '-'
968: || SQLERRM);
969: fnd_msg_pub.ADD;
962: WHEN OTHERS
963: THEN
964: fnd_message.set_name ('PN', 'PN_API_UNKNOWN_ERROR');
965: fnd_message.set_token ('COLUMN', SUBSTR(p_parameter_name,3));
966: fnd_message.set_token ('P_TEXT', l_api_name_full
967: || '-'
968: || SQLERRM);
969: fnd_msg_pub.ADD;
970: