452: retcode := 0;
453:
454: /* Setting concurrent program values */
455:
456: l_n_request_id := fnd_global.conc_request_id;
457: l_n_prog_appl_id := fnd_global.prog_appl_id;
458: l_n_prog_id := fnd_global.conc_program_id;
459: l_d_prog_upd_dt := SYSDATE;
460: IF l_n_request_id = -1 THEN
453:
454: /* Setting concurrent program values */
455:
456: l_n_request_id := fnd_global.conc_request_id;
457: l_n_prog_appl_id := fnd_global.prog_appl_id;
458: l_n_prog_id := fnd_global.conc_program_id;
459: l_d_prog_upd_dt := SYSDATE;
460: IF l_n_request_id = -1 THEN
461: l_n_request_id := NULL;
454: /* Setting concurrent program values */
455:
456: l_n_request_id := fnd_global.conc_request_id;
457: l_n_prog_appl_id := fnd_global.prog_appl_id;
458: l_n_prog_id := fnd_global.conc_program_id;
459: l_d_prog_upd_dt := SYSDATE;
460: IF l_n_request_id = -1 THEN
461: l_n_request_id := NULL;
462: l_n_prog_appl_id := NULL;
1022: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_UNIT_VERSION','LEGACY_PS_REC_TABLES'),
1023: l_unit_ver_rec.interface_id,
1024: l_n_msg_num,
1025: l_c_msg_txt,
1026: NVL(fnd_global.user_id,-1),
1027: SYSDATE,
1028: NVL(fnd_global.user_id,-1),
1029: SYSDATE,
1030: NVL(fnd_global.login_id,-1),
1024: l_n_msg_num,
1025: l_c_msg_txt,
1026: NVL(fnd_global.user_id,-1),
1027: SYSDATE,
1028: NVL(fnd_global.user_id,-1),
1029: SYSDATE,
1030: NVL(fnd_global.login_id,-1),
1031: l_n_request_id,
1032: l_n_prog_appl_id,
1026: NVL(fnd_global.user_id,-1),
1027: SYSDATE,
1028: NVL(fnd_global.user_id,-1),
1029: SYSDATE,
1030: NVL(fnd_global.login_id,-1),
1031: l_n_request_id,
1032: l_n_prog_appl_id,
1033: l_n_prog_id,
1034: l_d_prog_upd_dt
1123: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_TEACH_RESP','LEGACY_PS_REC_TABLES'),
1124: v_tab_unit_tr(i).interface_id,
1125: l_n_msg_num,
1126: l_c_msg_txt,
1127: NVL(fnd_global.user_id,-1),
1128: SYSDATE,
1129: NVL(fnd_global.user_id,-1),
1130: SYSDATE,
1131: NVL(fnd_global.login_id,-1),
1125: l_n_msg_num,
1126: l_c_msg_txt,
1127: NVL(fnd_global.user_id,-1),
1128: SYSDATE,
1129: NVL(fnd_global.user_id,-1),
1130: SYSDATE,
1131: NVL(fnd_global.login_id,-1),
1132: l_n_request_id,
1133: l_n_prog_appl_id,
1127: NVL(fnd_global.user_id,-1),
1128: SYSDATE,
1129: NVL(fnd_global.user_id,-1),
1130: SYSDATE,
1131: NVL(fnd_global.login_id,-1),
1132: l_n_request_id,
1133: l_n_prog_appl_id,
1134: l_n_prog_id,
1135: l_d_prog_upd_dt
1227: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_UNIT_DISCP','LEGACY_PS_REC_TABLES'),
1228: v_tab_unit_dscp(i).interface_id,
1229: l_n_msg_num,
1230: l_c_msg_txt,
1231: NVL(fnd_global.user_id,-1),
1232: SYSDATE,
1233: NVL(fnd_global.user_id,-1),
1234: SYSDATE,
1235: NVL(fnd_global.login_id,-1),
1229: l_n_msg_num,
1230: l_c_msg_txt,
1231: NVL(fnd_global.user_id,-1),
1232: SYSDATE,
1233: NVL(fnd_global.user_id,-1),
1234: SYSDATE,
1235: NVL(fnd_global.login_id,-1),
1236: l_n_request_id,
1237: l_n_prog_appl_id,
1231: NVL(fnd_global.user_id,-1),
1232: SYSDATE,
1233: NVL(fnd_global.user_id,-1),
1234: SYSDATE,
1235: NVL(fnd_global.login_id,-1),
1236: l_n_request_id,
1237: l_n_prog_appl_id,
1238: l_n_prog_id,
1239: l_d_prog_upd_dt
1330: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_GRD_SCH','LEGACY_PS_REC_TABLES'),
1331: v_tab_unit_gs(i).interface_id,
1332: l_n_msg_num,
1333: l_c_msg_txt,
1334: NVL(fnd_global.user_id,-1),
1335: SYSDATE,
1336: NVL(fnd_global.user_id,-1),
1337: SYSDATE,
1338: NVL(fnd_global.login_id,-1),
1332: l_n_msg_num,
1333: l_c_msg_txt,
1334: NVL(fnd_global.user_id,-1),
1335: SYSDATE,
1336: NVL(fnd_global.user_id,-1),
1337: SYSDATE,
1338: NVL(fnd_global.login_id,-1),
1339: l_n_request_id,
1340: l_n_prog_appl_id,
1334: NVL(fnd_global.user_id,-1),
1335: SYSDATE,
1336: NVL(fnd_global.user_id,-1),
1337: SYSDATE,
1338: NVL(fnd_global.login_id,-1),
1339: l_n_request_id,
1340: l_n_prog_appl_id,
1341: l_n_prog_id,
1342: l_d_prog_upd_dt
1433: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_UNIT_SEC','LEGACY_PS_REC_TABLES'),
1434: v_tab_usec(i).interface_id,
1435: l_n_msg_num,
1436: l_c_msg_txt,
1437: NVL(fnd_global.user_id,-1),
1438: SYSDATE,
1439: NVL(fnd_global.user_id,-1),
1440: SYSDATE,
1441: NVL(fnd_global.login_id,-1),
1435: l_n_msg_num,
1436: l_c_msg_txt,
1437: NVL(fnd_global.user_id,-1),
1438: SYSDATE,
1439: NVL(fnd_global.user_id,-1),
1440: SYSDATE,
1441: NVL(fnd_global.login_id,-1),
1442: l_n_request_id,
1443: l_n_prog_appl_id,
1437: NVL(fnd_global.user_id,-1),
1438: SYSDATE,
1439: NVL(fnd_global.user_id,-1),
1440: SYSDATE,
1441: NVL(fnd_global.login_id,-1),
1442: l_n_request_id,
1443: l_n_prog_appl_id,
1444: l_n_prog_id,
1445: l_d_prog_upd_dt
1538: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_UNIT_GRD_SCH','LEGACY_PS_REC_TABLES'),
1539: v_tab_usec_gs(i).interface_id,
1540: l_n_msg_num,
1541: l_c_msg_txt,
1542: NVL(fnd_global.user_id,-1),
1543: SYSDATE,
1544: NVL(fnd_global.user_id,-1),
1545: SYSDATE,
1546: NVL(fnd_global.login_id,-1),
1540: l_n_msg_num,
1541: l_c_msg_txt,
1542: NVL(fnd_global.user_id,-1),
1543: SYSDATE,
1544: NVL(fnd_global.user_id,-1),
1545: SYSDATE,
1546: NVL(fnd_global.login_id,-1),
1547: l_n_request_id,
1548: l_n_prog_appl_id,
1542: NVL(fnd_global.user_id,-1),
1543: SYSDATE,
1544: NVL(fnd_global.user_id,-1),
1545: SYSDATE,
1546: NVL(fnd_global.login_id,-1),
1547: l_n_request_id,
1548: l_n_prog_appl_id,
1549: l_n_prog_id,
1550: l_d_prog_upd_dt
1641: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_UNIT_SEC_OCCUR','LEGACY_PS_REC_TABLES'),
1642: v_tab_uso(i).interface_id,
1643: l_n_msg_num,
1644: l_c_msg_txt,
1645: NVL(fnd_global.user_id,-1),
1646: SYSDATE,
1647: NVL(fnd_global.user_id,-1),
1648: SYSDATE,
1649: NVL(fnd_global.login_id,-1),
1643: l_n_msg_num,
1644: l_c_msg_txt,
1645: NVL(fnd_global.user_id,-1),
1646: SYSDATE,
1647: NVL(fnd_global.user_id,-1),
1648: SYSDATE,
1649: NVL(fnd_global.login_id,-1),
1650: l_n_request_id,
1651: l_n_prog_appl_id,
1645: NVL(fnd_global.user_id,-1),
1646: SYSDATE,
1647: NVL(fnd_global.user_id,-1),
1648: SYSDATE,
1649: NVL(fnd_global.login_id,-1),
1650: l_n_request_id,
1651: l_n_prog_appl_id,
1652: l_n_prog_id,
1653: l_d_prog_upd_dt
1744: igs_ps_validate_lgcy_pkg.get_lkup_meaning('PS_UNIT_REF','LEGACY_PS_REC_TABLES'),
1745: v_tab_unit_ref(i).interface_id,
1746: l_n_msg_num,
1747: l_c_msg_txt,
1748: NVL(fnd_global.user_id,-1),
1749: SYSDATE,
1750: NVL(fnd_global.user_id,-1),
1751: SYSDATE,
1752: NVL(fnd_global.login_id,-1),
1746: l_n_msg_num,
1747: l_c_msg_txt,
1748: NVL(fnd_global.user_id,-1),
1749: SYSDATE,
1750: NVL(fnd_global.user_id,-1),
1751: SYSDATE,
1752: NVL(fnd_global.login_id,-1),
1753: l_n_request_id,
1754: l_n_prog_appl_id,
1748: NVL(fnd_global.user_id,-1),
1749: SYSDATE,
1750: NVL(fnd_global.user_id,-1),
1751: SYSDATE,
1752: NVL(fnd_global.login_id,-1),
1753: l_n_request_id,
1754: l_n_prog_appl_id,
1755: l_n_prog_id,
1756: l_d_prog_upd_dt
1873: fnd_message.get,
1874: v_tab_ins(i).interface_id,
1875: l_n_msg_num,
1876: l_c_msg_txt,
1877: NVL(fnd_global.user_id,-1),
1878: SYSDATE,
1879: NVL(fnd_global.user_id,-1),
1880: SYSDATE,
1881: NVL(fnd_global.login_id,-1),
1875: l_n_msg_num,
1876: l_c_msg_txt,
1877: NVL(fnd_global.user_id,-1),
1878: SYSDATE,
1879: NVL(fnd_global.user_id,-1),
1880: SYSDATE,
1881: NVL(fnd_global.login_id,-1),
1882: l_n_request_id,
1883: l_n_prog_appl_id,
1877: NVL(fnd_global.user_id,-1),
1878: SYSDATE,
1879: NVL(fnd_global.user_id,-1),
1880: SYSDATE,
1881: NVL(fnd_global.login_id,-1),
1882: l_n_request_id,
1883: l_n_prog_appl_id,
1884: l_n_prog_id,
1885: l_d_prog_upd_dt);