DBA Data[Home] [Help]

APPS.IGS_PS_LGCY_CONC_PKG dependencies on IGS_PS_LGCY_ERR_INT

Line 1003: INSERT INTO igs_ps_lgcy_err_int

999: l_c_msg_name := get_msg_from_stack(l_curr_num);
1000: get_message(l_c_msg_name,l_n_msg_num,l_c_msg_txt);
1001: l_c_msg_txt := fnd_msg_pub.get(l_curr_num,'F');
1002:
1003: INSERT INTO igs_ps_lgcy_err_int
1004: (
1005: err_message_id,
1006: int_table_code,
1007: int_table_id,

Line 1021: igs_ps_lgcy_err_int_s.nextval,

1017: program_id,
1018: program_update_date)
1019: VALUES
1020: (
1021: igs_ps_lgcy_err_int_s.nextval,
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,

Line 1104: INSERT INTO igs_ps_lgcy_err_int

1100: l_c_msg_name := get_msg_from_stack(l_curr_num);
1101: get_message(l_c_msg_name,l_n_msg_num,l_c_msg_txt);
1102: l_c_msg_txt := fnd_msg_pub.get(l_curr_num,'F');
1103:
1104: INSERT INTO igs_ps_lgcy_err_int
1105: (
1106: err_message_id,
1107: int_table_code,
1108: int_table_id,

Line 1122: igs_ps_lgcy_err_int_s.nextval,

1118: program_id,
1119: program_update_date)
1120: VALUES
1121: (
1122: igs_ps_lgcy_err_int_s.nextval,
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,

Line 1208: INSERT INTO igs_ps_lgcy_err_int

1204: l_c_msg_name := get_msg_from_stack(l_curr_num);
1205: get_message(l_c_msg_name,l_n_msg_num,l_c_msg_txt);
1206: l_c_msg_txt := fnd_msg_pub.get(l_curr_num,'F');
1207:
1208: INSERT INTO igs_ps_lgcy_err_int
1209: (
1210: err_message_id,
1211: int_table_code,
1212: int_table_id,

Line 1226: igs_ps_lgcy_err_int_s.nextval,

1222: program_id,
1223: program_update_date)
1224: VALUES
1225: (
1226: igs_ps_lgcy_err_int_s.nextval,
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,

Line 1311: INSERT INTO igs_ps_lgcy_err_int

1307: l_c_msg_name := get_msg_from_stack(l_curr_num);
1308: get_message(l_c_msg_name,l_n_msg_num,l_c_msg_txt);
1309: l_c_msg_txt := fnd_msg_pub.get(l_curr_num,'F');
1310:
1311: INSERT INTO igs_ps_lgcy_err_int
1312: (
1313: err_message_id,
1314: int_table_code,
1315: int_table_id,

Line 1329: igs_ps_lgcy_err_int_s.nextval,

1325: program_id,
1326: program_update_date)
1327: VALUES
1328: (
1329: igs_ps_lgcy_err_int_s.nextval,
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,

Line 1414: INSERT INTO igs_ps_lgcy_err_int

1410: l_c_msg_name := get_msg_from_stack(l_curr_num);
1411: get_message(l_c_msg_name,l_n_msg_num,l_c_msg_txt);
1412: l_c_msg_txt := fnd_msg_pub.get(l_curr_num,'F');
1413:
1414: INSERT INTO igs_ps_lgcy_err_int
1415: (
1416: err_message_id,
1417: int_table_code,
1418: int_table_id,

Line 1432: igs_ps_lgcy_err_int_s.nextval,

1428: program_id,
1429: program_update_date)
1430: VALUES
1431: (
1432: igs_ps_lgcy_err_int_s.nextval,
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,

Line 1518: INSERT INTO igs_ps_lgcy_err_int

1514: l_c_msg_name := get_msg_from_stack(l_curr_num);
1515: get_message(l_c_msg_name,l_n_msg_num,l_c_msg_txt);
1516: l_c_msg_txt := fnd_msg_pub.get(l_curr_num,'F');
1517:
1518: INSERT INTO igs_ps_lgcy_err_int
1519: (
1520: err_message_id,
1521: int_table_code,
1522: int_table_id,

Line 1537: igs_ps_lgcy_err_int_s.nextval,

1533: program_update_date
1534: )
1535: VALUES
1536: (
1537: igs_ps_lgcy_err_int_s.nextval,
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,

Line 1622: INSERT INTO igs_ps_lgcy_err_int

1618: l_c_msg_name := get_msg_from_stack(l_curr_num);
1619: get_message(l_c_msg_name,l_n_msg_num,l_c_msg_txt);
1620: l_c_msg_txt := fnd_msg_pub.get(l_curr_num,'F');
1621:
1622: INSERT INTO igs_ps_lgcy_err_int
1623: (
1624: err_message_id,
1625: int_table_code,
1626: int_table_id,

Line 1640: igs_ps_lgcy_err_int_s.nextval,

1636: program_id,
1637: program_update_date)
1638: VALUES
1639: (
1640: igs_ps_lgcy_err_int_s.nextval,
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,

Line 1725: INSERT INTO igs_ps_lgcy_err_int

1721: l_c_msg_name := get_msg_from_stack(l_curr_num);
1722: get_message(l_c_msg_name,l_n_msg_num,l_c_msg_txt);
1723: l_c_msg_txt := fnd_msg_pub.get(l_curr_num,'F');
1724:
1725: INSERT INTO igs_ps_lgcy_err_int
1726: (
1727: err_message_id,
1728: int_table_code,
1729: int_table_id,

Line 1743: igs_ps_lgcy_err_int_s.nextval,

1739: program_id,
1740: program_update_date)
1741: VALUES
1742: (
1743: igs_ps_lgcy_err_int_s.nextval,
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,

Line 1856: INSERT INTO igs_ps_lgcy_err_int(

1852: l_c_msg_txt := fnd_msg_pub.get(l_curr_num,'F');
1853:
1854: fnd_message.set_name('IGS','IGS_PS_USO_INS_TBL_NAME');
1855:
1856: INSERT INTO igs_ps_lgcy_err_int(
1857: err_message_id,
1858: int_table_code,
1859: int_table_id,
1860: message_num,

Line 1872: igs_ps_lgcy_err_int_s.nextval,

1868: program_application_id,
1869: program_id,
1870: program_update_date
1871: ) VALUES(
1872: igs_ps_lgcy_err_int_s.nextval,
1873: fnd_message.get,
1874: v_tab_ins(i).interface_id,
1875: l_n_msg_num,
1876: l_c_msg_txt,