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:
106:
107: IF c_index_lease_num%ISOPEN
108: THEN
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:
374: IF c_lease_name%ISOPEN
375: THEN
376: CLOSE c_lease_name;
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:
497: IF c_location_code%ISOPEN
498: THEN
499: CLOSE c_location_code;
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:
584: IF c_index%ISOPEN
585: THEN
586: CLOSE c_index;
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:
676: IF c_user%ISOPEN
677: THEN
678: CLOSE c_user;
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:
757: IF c_currency_code%ISOPEN
758: THEN
759: CLOSE c_currency_code;
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:
861: IF c_lookup%ISOPEN
862: THEN
863: CLOSE c_lookup;
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:
971: IF c_termtemp%ISOPEN
972: THEN
973: CLOSE c_termtemp;