743:
744:
745: EXCEPTION
746: WHEN others THEN
747: po_message_s.sql_error('validate_po_dist', X_progress, sqlcode);
748: raise;
749:
750: END validate_po_dist;
751:
819: return x_valid_flag;
820: WHEN OTHERS THEN
821: x_valid_flag := 'N';
822: return x_valid_flag;
823: po_message_s.sql_error('validate_destination_type_code',X_progress, sqlcode);
824: RAISE;
825:
826: END validate_destination_type_code;
827:
856: return x_valid_flag;
857: WHEN OTHERS THEN
858: x_valid_flag := 'N';
859: return x_valid_flag;
860: po_message_s.sql_error('validate_deliver_to_person_id',X_progress, sqlcode);
861: RAISE;
862:
863: END validate_deliver_to_person_id;
864:
908: return x_valid_flag;
909: WHEN OTHERS THEN
910: x_valid_flag := 'N';
911: return x_valid_flag;
912: po_message_s.sql_error('validate_deliver_to_loc_id',X_progress, sqlcode);
913: RAISE;
914:
915: END validate_deliver_to_loc_id;
916:
963: return x_valid_flag;
964: WHEN OTHERS THEN
965: x_valid_flag := 'N';
966: return x_valid_flag;
967: po_message_s.sql_error('validate_dest_subinventory',X_progress, sqlcode);
968: RAISE;
969:
970: END validate_dest_subinventory;
971:
998: return x_valid;
999: WHEN OTHERS THEN
1000: x_valid := 'N';
1001: return x_valid;
1002: po_message_s.sql_error('validate_org',X_progress, sqlcode);
1003: RAISE;
1004:
1005: END validate_org;
1006:
1066: return x_valid;
1067: WHEN OTHERS THEN
1068: x_valid := 'N';
1069: return x_valid;
1070: po_message_s.sql_error('validate_wip',X_progress, sqlcode);
1071: RAISE;
1072:
1073: END validate_wip;
1074:
1110: return x_valid;
1111: WHEN OTHERS THEN
1112: x_valid := 'N';
1113: return x_valid;
1114: po_message_s.sql_error('validate_account',X_progress, sqlcode);
1115: RAISE;
1116:
1117: END validate_account;
1118:
1345: return x_valid;
1346: WHEN OTHERS THEN
1347: x_valid := 'N';
1348: return x_valid;
1349: po_message_s.sql_error('validate_project_info',X_progress, sqlcode);
1350: RAISE;
1351:
1352: end validate_project_info;
1353: