eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_UNIT_LGCY_PKG dependencies on FND_LOG

Line 35: sommukhe 27-SEP-2005 BUG #4632652.FND logging included.

31:
32: Known limitations,enhancements,remarks:
33: Change History (in reverse chronological order)
34: Who When What
35: sommukhe 27-SEP-2005 BUG #4632652.FND logging included.
36: smvk 28-Jul-2004 Bug # 3793580. Allowing the user to import instructors for No Set Day USO.
37: Coded to call procedure get_uso_id to get USO ID. Removed cursors used to derive USO id.
38: smvk 07-Nov-2003 Bug # 3138353. Added new procedure validate_unit_dtls to do unit level cross subprocesses validation.
39: smvk 10-Oct-2003 Bug # 3052445. Modified the signature of igs_ps_validate_lgcy_pkg.validate_waitlist_allowed without org unit code.

Line 1211: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1207: END validate_db_cons;
1208:
1209: BEGIN
1210:
1211: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1212: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.start_logging_for','Unit Versions');
1213: END IF;
1214:
1215: p_rec_status :='S';

Line 1212: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.start_logging_for','Unit Versions');

1208:
1209: BEGIN
1210:
1211: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1212: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.start_logging_for','Unit Versions');
1213: END IF;
1214:
1215: p_rec_status :='S';
1216: p_unit_ver_rec.msg_from := FND_MSG_PUB.COUNT_MSG;

Line 1220: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1216: p_unit_ver_rec.msg_from := FND_MSG_PUB.COUNT_MSG;
1217: trim_values(p_unit_ver_rec);
1218: validate_parameters(p_unit_ver_rec);
1219:
1220: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1221: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.status_after_validate_parameters',
1222: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1223: 'Status:'||p_unit_ver_rec.status);
1224: END IF;

Line 1221: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.status_after_validate_parameters',

1217: trim_values(p_unit_ver_rec);
1218: validate_parameters(p_unit_ver_rec);
1219:
1220: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1221: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.status_after_validate_parameters',
1222: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1223: 'Status:'||p_unit_ver_rec.status);
1224: END IF;
1225:

Line 1229: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1225:
1226: IF p_unit_ver_rec.status = 'S' THEN
1227: validate_derivations(p_unit_ver_rec);
1228:
1229: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1230: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.status_after_validate_derivations',
1231: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1232: 'Status:'||p_unit_ver_rec.status);
1233: END IF;

Line 1230: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.status_after_validate_derivations',

1226: IF p_unit_ver_rec.status = 'S' THEN
1227: validate_derivations(p_unit_ver_rec);
1228:
1229: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1230: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.status_after_validate_derivations',
1231: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1232: 'Status:'||p_unit_ver_rec.status);
1233: END IF;
1234:

Line 1240: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1236:
1237: IF p_unit_ver_rec.status = 'S' THEN
1238: validate_db_cons(p_unit_ver_rec);
1239:
1240: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1241: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.status_after_validate_db_cons',
1242: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1243: 'Status:'||p_unit_ver_rec.status);
1244: END IF;

Line 1241: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.status_after_validate_db_cons',

1237: IF p_unit_ver_rec.status = 'S' THEN
1238: validate_db_cons(p_unit_ver_rec);
1239:
1240: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1241: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.status_after_validate_db_cons',
1242: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1243: 'Status:'||p_unit_ver_rec.status);
1244: END IF;
1245:

Line 1251: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1247:
1248: IF p_unit_ver_rec.status = 'S' THEN
1249: igs_ps_validate_lgcy_pkg.unit_version(p_unit_ver_rec,l_n_coord_person_id);
1250:
1251: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1252: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.status_after_Business_validation',
1253: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1254: 'Status:'||p_unit_ver_rec.status);
1255: END IF;

Line 1252: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.status_after_Business_validation',

1248: IF p_unit_ver_rec.status = 'S' THEN
1249: igs_ps_validate_lgcy_pkg.unit_version(p_unit_ver_rec,l_n_coord_person_id);
1250:
1251: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1252: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.status_after_Business_validation',
1253: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1254: 'Status:'||p_unit_ver_rec.status);
1255: END IF;
1256:

Line 1284: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1280: g_n_user_id,
1281: g_n_login_id
1282: );
1283:
1284: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1285: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.Record_created_igs_ps_unit',
1286: 'Unit code:'||p_unit_ver_rec.unit_cd);
1287: END IF;
1288: END IF;

Line 1285: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.Record_created_igs_ps_unit',

1281: g_n_login_id
1282: );
1283:
1284: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1285: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.Record_created_igs_ps_unit',
1286: 'Unit code:'||p_unit_ver_rec.unit_cd);
1287: END IF;
1288: END IF;
1289:

Line 1323: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1319: g_n_user_id,
1320: g_n_login_id
1321: ) RETURNING subtitle_id INTO l_n_subtitle_id;
1322:
1323: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1324: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.rec_inserted_igs_ps_unit_subtitle',
1325: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1326: 'Subtitle_id:'||l_n_subtitle_id||' '||'Status:'||p_unit_ver_rec.status);
1327: END IF;

Line 1324: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.rec_inserted_igs_ps_unit_subtitle',

1320: g_n_login_id
1321: ) RETURNING subtitle_id INTO l_n_subtitle_id;
1322:
1323: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1324: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.rec_inserted_igs_ps_unit_subtitle',
1325: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1326: 'Subtitle_id:'||l_n_subtitle_id||' '||'Status:'||p_unit_ver_rec.status);
1327: END IF;
1328:

Line 1359: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1355: g_n_user_id,
1356: g_n_login_id
1357: );
1358:
1359: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1360: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.rec_inserted_igs_ps_unt_crclm_all',
1361: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1362: 'curriculum_id:'||p_unit_ver_rec.curriculum_id||' '||'Status:'||p_unit_ver_rec.status);
1363: END IF;

Line 1360: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.rec_inserted_igs_ps_unt_crclm_all',

1356: g_n_login_id
1357: );
1358:
1359: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1360: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.rec_inserted_igs_ps_unt_crclm_all',
1361: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number||' '||
1362: 'curriculum_id:'||p_unit_ver_rec.curriculum_id||' '||'Status:'||p_unit_ver_rec.status);
1363: END IF;
1364: END IF;

Line 1594: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1590: g_n_user_id,
1591: g_n_login_id
1592: );
1593:
1594: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1595: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.Record_Inserted',
1596: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number);
1597: END IF;
1598:

Line 1595: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.Record_Inserted',

1591: g_n_login_id
1592: );
1593:
1594: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1595: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.Record_Inserted',
1596: 'Unit code:'||p_unit_ver_rec.unit_cd||' '||'Version number:'||p_unit_ver_rec.version_number);
1597: END IF;
1598:
1599: p_unit_ver_rec.msg_from := NULL;

Line 1607: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1603: p_unit_ver_rec.msg_to := FND_MSG_PUB.COUNT_MSG;
1604: END IF;
1605: p_rec_status:= p_unit_ver_rec.status;
1606:
1607: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1608: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.after_import_status',p_rec_status);
1609: END IF;
1610:
1611: END create_unit_version;

Line 1608: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.after_import_status',p_rec_status);

1604: END IF;
1605: p_rec_status:= p_unit_ver_rec.status;
1606:
1607: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1608: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_version.after_import_status',p_rec_status);
1609: END IF;
1610:
1611: END create_unit_version;
1612:

Line 1730: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1726: END validate_db_cons;
1727:
1728: /* Main Teaching Responsibility Sub Process */
1729: BEGIN
1730: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1731: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.start_logging_for','Teaching Responsibility');
1732: END IF;
1733: p_c_rec_status := 'S';
1734:

Line 1731: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.start_logging_for','Teaching Responsibility');

1727:
1728: /* Main Teaching Responsibility Sub Process */
1729: BEGIN
1730: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1731: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.start_logging_for','Teaching Responsibility');
1732: END IF;
1733: p_c_rec_status := 'S';
1734:
1735: FOR I in 1..p_tab_teach_resp.LAST LOOP

Line 1742: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1738: p_tab_teach_resp(I).msg_from := fnd_msg_pub.count_msg;
1739: trim_values(p_tab_teach_resp(I) );
1740: validate_parameters ( p_tab_teach_resp(I) );
1741:
1742: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1743: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_validate_parameters',
1744: 'Unit code:'||p_tab_teach_resp(I).unit_cd||' '||'Version number:'||p_tab_teach_resp(I).version_number||' '||
1745: 'org_unit_cd:'||p_tab_teach_resp(I).org_unit_cd||' '||'Status:'||p_tab_teach_resp(I).status);
1746: END IF;

Line 1743: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_validate_parameters',

1739: trim_values(p_tab_teach_resp(I) );
1740: validate_parameters ( p_tab_teach_resp(I) );
1741:
1742: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1743: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_validate_parameters',
1744: 'Unit code:'||p_tab_teach_resp(I).unit_cd||' '||'Version number:'||p_tab_teach_resp(I).version_number||' '||
1745: 'org_unit_cd:'||p_tab_teach_resp(I).org_unit_cd||' '||'Status:'||p_tab_teach_resp(I).status);
1746: END IF;
1747:

Line 1751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1747:
1748: IF p_tab_teach_resp(I).status = 'S' THEN
1749: validate_derivations ( p_tab_teach_resp(I) );
1750:
1751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1752: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_validate_derivations',
1753: 'Unit code:'||p_tab_teach_resp(I).unit_cd||' '||'Version number:'||p_tab_teach_resp(I).version_number||' '||
1754: 'org_unit_cd:'||p_tab_teach_resp(I).org_unit_cd||' '||'ou_start_dt:'||l_d_ou_start_dt||' '||
1755: 'Status:'||p_tab_teach_resp(I).status);

Line 1752: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_validate_derivations',

1748: IF p_tab_teach_resp(I).status = 'S' THEN
1749: validate_derivations ( p_tab_teach_resp(I) );
1750:
1751: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1752: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_validate_derivations',
1753: 'Unit code:'||p_tab_teach_resp(I).unit_cd||' '||'Version number:'||p_tab_teach_resp(I).version_number||' '||
1754: 'org_unit_cd:'||p_tab_teach_resp(I).org_unit_cd||' '||'ou_start_dt:'||l_d_ou_start_dt||' '||
1755: 'Status:'||p_tab_teach_resp(I).status);
1756: END IF;

Line 1763: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1759:
1760: IF p_tab_teach_resp(I).status = 'S' THEN
1761: validate_db_cons ( p_tab_teach_resp(I) );
1762:
1763: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1764: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_validate_db_cons',
1765: 'Unit code:'||p_tab_teach_resp(I).unit_cd||' '||'Version number:'||p_tab_teach_resp(I).version_number||' '||
1766: 'org_unit_cd:'||p_tab_teach_resp(I).org_unit_cd||' '||'ou_start_dt:'||l_d_ou_start_dt||' '||
1767: 'Status:'||p_tab_teach_resp(I).status);

Line 1764: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_validate_db_cons',

1760: IF p_tab_teach_resp(I).status = 'S' THEN
1761: validate_db_cons ( p_tab_teach_resp(I) );
1762:
1763: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1764: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_validate_db_cons',
1765: 'Unit code:'||p_tab_teach_resp(I).unit_cd||' '||'Version number:'||p_tab_teach_resp(I).version_number||' '||
1766: 'org_unit_cd:'||p_tab_teach_resp(I).org_unit_cd||' '||'ou_start_dt:'||l_d_ou_start_dt||' '||
1767: 'Status:'||p_tab_teach_resp(I).status);
1768: END IF;

Line 1796: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1792: fnd_msg_pub.add;
1793: p_tab_teach_resp(I).status := 'W' ;
1794: END IF;
1795:
1796: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1797: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_Business_validation',
1798: 'Unit code:'||p_tab_teach_resp(I).unit_cd||' '||'Version number:'||p_tab_teach_resp(I).version_number||' '||
1799: 'org_unit_cd:'||p_tab_teach_resp(I).org_unit_cd||' '||'ou_start_dt:'||l_d_ou_start_dt||' '||
1800: 'Status:'||p_tab_teach_resp(I).status);

Line 1797: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_Business_validation',

1793: p_tab_teach_resp(I).status := 'W' ;
1794: END IF;
1795:
1796: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1797: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_Business_validation',
1798: 'Unit code:'||p_tab_teach_resp(I).unit_cd||' '||'Version number:'||p_tab_teach_resp(I).version_number||' '||
1799: 'org_unit_cd:'||p_tab_teach_resp(I).org_unit_cd||' '||'ou_start_dt:'||l_d_ou_start_dt||' '||
1800: 'Status:'||p_tab_teach_resp(I).status);
1801: END IF;

Line 1832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1828: SYSDATE,
1829: g_n_login_id
1830: );
1831:
1832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1833: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.Record_Inserted',
1834: 'Unit code:'||p_tab_teach_resp(I).unit_cd||' '||'Version number:'||p_tab_teach_resp(I).version_number||' '||
1835: 'org_unit_cd:'||p_tab_teach_resp(I).org_unit_cd||' '||'ou_start_dt:'||l_d_ou_start_dt);
1836: END IF;

Line 1833: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.Record_Inserted',

1829: g_n_login_id
1830: );
1831:
1832: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1833: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.Record_Inserted',
1834: 'Unit code:'||p_tab_teach_resp(I).unit_cd||' '||'Version number:'||p_tab_teach_resp(I).version_number||' '||
1835: 'org_unit_cd:'||p_tab_teach_resp(I).org_unit_cd||' '||'ou_start_dt:'||l_d_ou_start_dt);
1836: END IF;
1837:

Line 1857: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1853: IF NOT igs_ps_validate_lgcy_pkg.post_teach_resp(p_tab_teach_resp) THEN
1854: p_c_rec_status := 'E';
1855: END IF;
1856:
1857: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1858: fnd_log.string( fnd_log.level_statement,
1859: 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_Post_insert_validation','Status:'||p_c_rec_status);
1860: END IF;
1861:

Line 1858: fnd_log.string( fnd_log.level_statement,

1854: p_c_rec_status := 'E';
1855: END IF;
1856:
1857: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1858: fnd_log.string( fnd_log.level_statement,
1859: 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_Post_insert_validation','Status:'||p_c_rec_status);
1860: END IF;
1861:
1862: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 1862: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1858: fnd_log.string( fnd_log.level_statement,
1859: 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_Post_insert_validation','Status:'||p_c_rec_status);
1860: END IF;
1861:
1862: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1863: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.after_import_status',p_c_rec_status);
1864: END IF;
1865:
1866: END create_teach_resp;

Line 1863: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.after_import_status',p_c_rec_status);

1859: 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.status_after_Post_insert_validation','Status:'||p_c_rec_status);
1860: END IF;
1861:
1862: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1863: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_teach_resp.after_import_status',p_c_rec_status);
1864: END IF;
1865:
1866: END create_teach_resp;
1867:

Line 1972: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1968:
1969: /* Main Unit Discipline Sub Process */
1970: BEGIN
1971:
1972: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1973: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.start_logging_for','Unit Discipline');
1974: END IF;
1975:
1976: p_c_rec_status := 'S';

Line 1973: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.start_logging_for','Unit Discipline');

1969: /* Main Unit Discipline Sub Process */
1970: BEGIN
1971:
1972: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1973: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.start_logging_for','Unit Discipline');
1974: END IF;
1975:
1976: p_c_rec_status := 'S';
1977: FOR I in 1..p_tab_unit_dscp.LAST LOOP

Line 1984: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1980: p_tab_unit_dscp(I).msg_from := fnd_msg_pub.count_msg;
1981: trim_values(p_tab_unit_dscp(I) );
1982: validate_parameters ( p_tab_unit_dscp(I) );
1983:
1984: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1985: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.status_after_validate_parameters',
1986: 'Unit code:'||p_tab_unit_dscp(I).unit_cd||' '||'Version number:'||p_tab_unit_dscp(I).version_number||' '||
1987: 'discipline_group_cd:'||p_tab_unit_dscp(I).discipline_group_cd||' '||'Status:'||p_tab_unit_dscp(I).status);
1988: END IF;

Line 1985: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.status_after_validate_parameters',

1981: trim_values(p_tab_unit_dscp(I) );
1982: validate_parameters ( p_tab_unit_dscp(I) );
1983:
1984: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1985: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.status_after_validate_parameters',
1986: 'Unit code:'||p_tab_unit_dscp(I).unit_cd||' '||'Version number:'||p_tab_unit_dscp(I).version_number||' '||
1987: 'discipline_group_cd:'||p_tab_unit_dscp(I).discipline_group_cd||' '||'Status:'||p_tab_unit_dscp(I).status);
1988: END IF;
1989:

Line 1993: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1989:
1990: IF p_tab_unit_dscp(I).status = 'S' THEN
1991: validate_db_cons ( p_tab_unit_dscp(I) );
1992:
1993: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1994: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.status_after_validate_db_cons',
1995: 'Unit code:'||p_tab_unit_dscp(I).unit_cd||' '||'Version number:'||p_tab_unit_dscp(I).version_number||' '||
1996: 'discipline_group_cd:'||p_tab_unit_dscp(I).discipline_group_cd||' '||'Status:'||p_tab_unit_dscp(I).status);
1997: END IF;

Line 1994: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.status_after_validate_db_cons',

1990: IF p_tab_unit_dscp(I).status = 'S' THEN
1991: validate_db_cons ( p_tab_unit_dscp(I) );
1992:
1993: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1994: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.status_after_validate_db_cons',
1995: 'Unit code:'||p_tab_unit_dscp(I).unit_cd||' '||'Version number:'||p_tab_unit_dscp(I).version_number||' '||
1996: 'discipline_group_cd:'||p_tab_unit_dscp(I).discipline_group_cd||' '||'Status:'||p_tab_unit_dscp(I).status);
1997: END IF;
1998:

Line 2011: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2007: fnd_msg_pub.add;
2008: p_tab_unit_dscp(I).status := 'W';
2009: END IF;
2010:
2011: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2012: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.status_after_Business_validation',
2013: 'Unit code:'||p_tab_unit_dscp(I).unit_cd||' '||'Version number:'||p_tab_unit_dscp(I).version_number||' '||
2014: 'discipline_group_cd:'||p_tab_unit_dscp(I).discipline_group_cd||' '||'Status:'||p_tab_unit_dscp(I).status);
2015: END IF;

Line 2012: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.status_after_Business_validation',

2008: p_tab_unit_dscp(I).status := 'W';
2009: END IF;
2010:
2011: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2012: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.status_after_Business_validation',
2013: 'Unit code:'||p_tab_unit_dscp(I).unit_cd||' '||'Version number:'||p_tab_unit_dscp(I).version_number||' '||
2014: 'discipline_group_cd:'||p_tab_unit_dscp(I).discipline_group_cd||' '||'Status:'||p_tab_unit_dscp(I).status);
2015: END IF;
2016:

Line 2043: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2039: g_n_user_id,
2040: SYSDATE,
2041: g_n_login_id
2042: );
2043: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2044: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.Record_Inserted',
2045: 'Unit code:'||p_tab_unit_dscp(I).unit_cd||' '||'Version number:'||p_tab_unit_dscp(I).version_number||' '||
2046: 'discipline_group_cd:'||p_tab_unit_dscp(I).discipline_group_cd);
2047: END IF;

Line 2044: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.Record_Inserted',

2040: SYSDATE,
2041: g_n_login_id
2042: );
2043: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2044: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.Record_Inserted',
2045: 'Unit code:'||p_tab_unit_dscp(I).unit_cd||' '||'Version number:'||p_tab_unit_dscp(I).version_number||' '||
2046: 'discipline_group_cd:'||p_tab_unit_dscp(I).discipline_group_cd);
2047: END IF;
2048:

Line 2067: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2063: IF NOT igs_ps_validate_lgcy_pkg.post_unit_discip(p_tab_unit_dscp) THEN
2064: p_c_rec_status := 'E';
2065: END IF;
2066:
2067: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2068: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.Status_after_Post_insert_check',
2069: 'Status:'||p_c_rec_status);
2070: END IF;
2071:

Line 2068: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.Status_after_Post_insert_check',

2064: p_c_rec_status := 'E';
2065: END IF;
2066:
2067: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2068: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.Status_after_Post_insert_check',
2069: 'Status:'||p_c_rec_status);
2070: END IF;
2071:
2072: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 2072: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2068: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.Status_after_Post_insert_check',
2069: 'Status:'||p_c_rec_status);
2070: END IF;
2071:
2072: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2073: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.after_import_status',p_c_rec_status);
2074: END IF;
2075:
2076: END create_unit_discip;

Line 2073: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.after_import_status',p_c_rec_status);

2069: 'Status:'||p_c_rec_status);
2070: END IF;
2071:
2072: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2073: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_discip.after_import_status',p_c_rec_status);
2074: END IF;
2075:
2076: END create_unit_discip;
2077:

Line 2168: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2164:
2165: /* Main Grading Schema Sub Process */
2166: BEGIN
2167:
2168: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2169: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.start_logging_for','Unit Grading Schema');
2170: END IF;
2171:
2172: p_c_rec_status := 'S';

Line 2169: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.start_logging_for','Unit Grading Schema');

2165: /* Main Grading Schema Sub Process */
2166: BEGIN
2167:
2168: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2169: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.start_logging_for','Unit Grading Schema');
2170: END IF;
2171:
2172: p_c_rec_status := 'S';
2173: FOR I in 1..p_tab_grd_sch.LAST LOOP

Line 2180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2176: p_tab_grd_sch(I).msg_from := fnd_msg_pub.count_msg;
2177: trim_values(p_tab_grd_sch(I));
2178: validate_parameters ( p_tab_grd_sch(I) );
2179:
2180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2181: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.status_after_validate_parameters',
2182: 'Unit code:'||p_tab_grd_sch(I).unit_cd||' '||'Version number:'||p_tab_grd_sch(I).version_number||' '||
2183: 'grading_schema_code:'||p_tab_grd_sch(I).grading_schema_code||' '||'grd_schm_version_number:'||
2184: p_tab_grd_sch(I).grd_schm_version_number||' '||'Status:'||p_tab_grd_sch(I).status);

Line 2181: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.status_after_validate_parameters',

2177: trim_values(p_tab_grd_sch(I));
2178: validate_parameters ( p_tab_grd_sch(I) );
2179:
2180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2181: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.status_after_validate_parameters',
2182: 'Unit code:'||p_tab_grd_sch(I).unit_cd||' '||'Version number:'||p_tab_grd_sch(I).version_number||' '||
2183: 'grading_schema_code:'||p_tab_grd_sch(I).grading_schema_code||' '||'grd_schm_version_number:'||
2184: p_tab_grd_sch(I).grd_schm_version_number||' '||'Status:'||p_tab_grd_sch(I).status);
2185: END IF;

Line 2190: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2186:
2187: IF p_tab_grd_sch(I).status = 'S' THEN
2188: validate_db_cons ( p_tab_grd_sch(I) );
2189:
2190: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2191: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.status_after_validate_db_cons',
2192: 'Unit code:'||p_tab_grd_sch(I).unit_cd||' '||'Version number:'||p_tab_grd_sch(I).version_number||' '||
2193: 'grading_schema_code:'||p_tab_grd_sch(I).grading_schema_code||' '||'grd_schm_version_number:'||
2194: p_tab_grd_sch(I).grd_schm_version_number||' '||'Status:'||p_tab_grd_sch(I).status);

Line 2191: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.status_after_validate_db_cons',

2187: IF p_tab_grd_sch(I).status = 'S' THEN
2188: validate_db_cons ( p_tab_grd_sch(I) );
2189:
2190: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2191: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.status_after_validate_db_cons',
2192: 'Unit code:'||p_tab_grd_sch(I).unit_cd||' '||'Version number:'||p_tab_grd_sch(I).version_number||' '||
2193: 'grading_schema_code:'||p_tab_grd_sch(I).grading_schema_code||' '||'grd_schm_version_number:'||
2194: p_tab_grd_sch(I).grd_schm_version_number||' '||'Status:'||p_tab_grd_sch(I).status);
2195: END IF;

Line 2204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2200: /* Proceed with business validations only if the status is Success, 'S' */
2201: IF p_tab_grd_sch(I).status = 'S' THEN
2202: igs_ps_validate_lgcy_pkg.validate_unit_grd_sch ( p_tab_grd_sch(I) );
2203:
2204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2205: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.status_after_Business_Validation',
2206: 'Unit code:'||p_tab_grd_sch(I).unit_cd||' '||'Version number:'||p_tab_grd_sch(I).version_number||' '||
2207: 'grading_schema_code:'||p_tab_grd_sch(I).grading_schema_code||' '||'grd_schm_version_number:'||
2208: p_tab_grd_sch(I).grd_schm_version_number||' '||'Status:'||p_tab_grd_sch(I).status);

Line 2205: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.status_after_Business_Validation',

2201: IF p_tab_grd_sch(I).status = 'S' THEN
2202: igs_ps_validate_lgcy_pkg.validate_unit_grd_sch ( p_tab_grd_sch(I) );
2203:
2204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2205: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.status_after_Business_Validation',
2206: 'Unit code:'||p_tab_grd_sch(I).unit_cd||' '||'Version number:'||p_tab_grd_sch(I).version_number||' '||
2207: 'grading_schema_code:'||p_tab_grd_sch(I).grading_schema_code||' '||'grd_schm_version_number:'||
2208: p_tab_grd_sch(I).grd_schm_version_number||' '||'Status:'||p_tab_grd_sch(I).status);
2209: END IF;

Line 2242: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2238: SYSDATE,
2239: g_n_login_id
2240: );
2241:
2242: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2243: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.record_inserted',
2244: 'Unit code:'||p_tab_grd_sch(I).unit_cd||' '||'Version number:'||p_tab_grd_sch(I).version_number||' '||
2245: 'grading_schema_code:'||p_tab_grd_sch(I).grading_schema_code||' '||'grd_schm_version_number:'||
2246: p_tab_grd_sch(I).grd_schm_version_number);

Line 2243: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.record_inserted',

2239: g_n_login_id
2240: );
2241:
2242: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2243: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.record_inserted',
2244: 'Unit code:'||p_tab_grd_sch(I).unit_cd||' '||'Version number:'||p_tab_grd_sch(I).version_number||' '||
2245: 'grading_schema_code:'||p_tab_grd_sch(I).grading_schema_code||' '||'grd_schm_version_number:'||
2246: p_tab_grd_sch(I).grd_schm_version_number);
2247: END IF;

Line 2267: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2263: IF NOT igs_ps_validate_lgcy_pkg.post_unit_grd_sch (p_tab_grd_sch) THEN
2264: p_c_rec_status := 'E';
2265: END IF;
2266:
2267: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2268: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.after_import_status',p_c_rec_status);
2269: END IF;
2270:
2271:

Line 2268: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.after_import_status',p_c_rec_status);

2264: p_c_rec_status := 'E';
2265: END IF;
2266:
2267: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2268: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_grd_sch.after_import_status',p_c_rec_status);
2269: END IF;
2270:
2271:
2272: END create_unit_grd_sch;

Line 2301: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2297: l_c_message VARCHAR2(30);
2298:
2299: BEGIN
2300:
2301: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2302: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.validate_unit_dtls.start_logging_for','Unit Details Validations');
2303: END IF;
2304:
2305: OPEN c_unit_status (p_unit_ver_rec.unit_status);

Line 2302: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.validate_unit_dtls.start_logging_for','Unit Details Validations');

2298:
2299: BEGIN
2300:
2301: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2302: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.validate_unit_dtls.start_logging_for','Unit Details Validations');
2303: END IF;
2304:
2305: OPEN c_unit_status (p_unit_ver_rec.unit_status);
2306: FETCH c_unit_status INTO rec_unit_status;

Line 2337: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2333: p_rec_status := p_unit_ver_rec.status;
2334: END IF;
2335: END IF;
2336:
2337: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2338: fnd_log.string( fnd_log.level_procedure,
2339: 'igs.plsql.igs_ps_unit_lgcy_pkg.validate_unit_dtls.record_status_after_validation_of_unit_details',
2340: p_unit_ver_rec.status);
2341: END IF;

Line 2338: fnd_log.string( fnd_log.level_procedure,

2334: END IF;
2335: END IF;
2336:
2337: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2338: fnd_log.string( fnd_log.level_procedure,
2339: 'igs.plsql.igs_ps_unit_lgcy_pkg.validate_unit_dtls.record_status_after_validation_of_unit_details',
2340: p_unit_ver_rec.status);
2341: END IF;
2342:

Line 2588: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2584: ********************************************************************************************* */
2585: BEGIN
2586:
2587: validate_uo_parameters ( p_usec_rec );
2588: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2589: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_validate_uo_parameters',
2590: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2591: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2592: END IF;

Line 2589: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_validate_uo_parameters',

2585: BEGIN
2586:
2587: validate_uo_parameters ( p_usec_rec );
2588: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2589: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_validate_uo_parameters',
2590: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2591: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2592: END IF;
2593:

Line 2596: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2592: END IF;
2593:
2594: IF ( p_usec_rec.status = 'S' ) THEN
2595: validate_uo_derivations ( p_usec_rec );
2596: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2597: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_validate_uo_derivations',
2598: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2599: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2600: END IF;

Line 2597: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_validate_uo_derivations',

2593:
2594: IF ( p_usec_rec.status = 'S' ) THEN
2595: validate_uo_derivations ( p_usec_rec );
2596: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2597: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_validate_uo_derivations',
2598: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2599: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2600: END IF;
2601: END IF;

Line 2605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2601: END IF;
2602:
2603: IF ( p_usec_rec.status = 'S' ) THEN
2604: validate_uo_db_cons ( p_usec_rec );
2605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2606: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_validate_uo_db_cons',
2607: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2608: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2609: END IF;

Line 2606: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_validate_uo_db_cons',

2602:
2603: IF ( p_usec_rec.status = 'S' ) THEN
2604: validate_uo_db_cons ( p_usec_rec );
2605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2606: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_validate_uo_db_cons',
2607: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2608: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2609: END IF;
2610: END IF;

Line 2614: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2610: END IF;
2611:
2612: IF ( p_usec_rec.status = 'K' ) THEN
2613: -- If the record is already existing update status as 'Success' and return
2614: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2615: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.record is already existing update status as Success and return',
2616: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2617: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2618: END IF;

Line 2615: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.record is already existing update status as Success and return',

2611:
2612: IF ( p_usec_rec.status = 'K' ) THEN
2613: -- If the record is already existing update status as 'Success' and return
2614: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2615: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.record is already existing update status as Success and return',
2616: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2617: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2618: END IF;
2619: p_usec_rec.status := 'S';

Line 2623: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2619: p_usec_rec.status := 'S';
2620: RETURN;
2621: END IF;
2622: IF p_calling_context IN ('G','S') THEN
2623: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2624: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.calling_context_G_or_S_return',
2625: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2626: ||p_usec_rec.teach_cal_alternate_code);
2627: END IF;

Line 2624: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.calling_context_G_or_S_return',

2620: RETURN;
2621: END IF;
2622: IF p_calling_context IN ('G','S') THEN
2623: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2624: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.calling_context_G_or_S_return',
2625: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2626: ||p_usec_rec.teach_cal_alternate_code);
2627: END IF;
2628: RETURN ;

Line 2638: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2634: fnd_message.set_name ( 'IGS', 'IGS_PS_CALTYPE_TEACHING_CAL' );
2635: fnd_msg_pub.add;
2636: p_usec_rec.status := 'E';
2637: END IF;
2638: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2639: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_Business_validation',
2640: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2641: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2642: END IF;

Line 2639: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_Business_validation',

2635: fnd_msg_pub.add;
2636: p_usec_rec.status := 'E';
2637: END IF;
2638: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2639: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_Business_validation',
2640: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2641: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2642: END IF;
2643: END IF;

Line 2667: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2663: SYSDATE,
2664: g_n_login_id
2665: );
2666: p_usec_rec.status := 'S';
2667: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2668: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.Record_Inserted',
2669: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2670: ||p_usec_rec.teach_cal_alternate_code);
2671: END IF;

Line 2668: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.Record_Inserted',

2664: g_n_login_id
2665: );
2666: p_usec_rec.status := 'S';
2667: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2668: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.Record_Inserted',
2669: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2670: ||p_usec_rec.teach_cal_alternate_code);
2671: END IF;
2672: END IF;

Line 2775: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2771: AS
2772: BEGIN
2773:
2774: validate_uop_derivations ( p_usec_rec );
2775: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2776: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.status_after_validate_uop_parameters',
2777: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2778: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2779: END IF;

Line 2776: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.status_after_validate_uop_parameters',

2772: BEGIN
2773:
2774: validate_uop_derivations ( p_usec_rec );
2775: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2776: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.status_after_validate_uop_parameters',
2777: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2778: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2779: END IF;
2780:

Line 2783: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2779: END IF;
2780:
2781: IF ( p_usec_rec.status = 'S' ) THEN
2782: validate_uop_db_cons ( p_usec_rec );
2783: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2784: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.status_after_validate_uop_db_cons',
2785: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2786: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2787: END IF;

Line 2784: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.status_after_validate_uop_db_cons',

2780:
2781: IF ( p_usec_rec.status = 'S' ) THEN
2782: validate_uop_db_cons ( p_usec_rec );
2783: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2784: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.status_after_validate_uop_db_cons',
2785: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2786: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2787: END IF;
2788: END IF;

Line 2793: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2789:
2790:
2791: IF ( p_usec_rec.status = 'K' ) THEN
2792: -- If the record is already existing update status as 'Success' and return
2793: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2794: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.record is already existing update status as Success and return',
2795: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2796: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2797: END IF;

Line 2794: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.record is already existing update status as Success and return',

2790:
2791: IF ( p_usec_rec.status = 'K' ) THEN
2792: -- If the record is already existing update status as 'Success' and return
2793: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2794: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.record is already existing update status as Success and return',
2795: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2796: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2797: END IF;
2798: p_usec_rec.status := 'S';

Line 2802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2798: p_usec_rec.status := 'S';
2799: RETURN;
2800: END IF;
2801: IF p_calling_context IN ('G','S') THEN
2802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2803: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.calling_context_G_or_S_return',
2804: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2805: ||p_usec_rec.teach_cal_alternate_code);
2806: END IF;

Line 2803: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.calling_context_G_or_S_return',

2799: RETURN;
2800: END IF;
2801: IF p_calling_context IN ('G','S') THEN
2802: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2803: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.calling_context_G_or_S_return',
2804: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2805: ||p_usec_rec.teach_cal_alternate_code);
2806: END IF;
2807: RETURN ;

Line 2831: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2827: fnd_msg_pub.add;
2828: p_usec_rec.status := 'W';
2829: END IF;
2830:
2831: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2832: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.status_after_Business_validation',
2833: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2834: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2835: END IF;

Line 2832: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.status_after_Business_validation',

2828: p_usec_rec.status := 'W';
2829: END IF;
2830:
2831: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2832: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.status_after_Business_validation',
2833: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2834: ||p_usec_rec.teach_cal_alternate_code||' '||'Status:'||p_usec_rec.status);
2835: END IF;
2836:

Line 2855: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2851: WHERE unit_cd = p_usec_rec.unit_cd
2852: AND version_number = p_usec_rec.version_number
2853: AND cal_type = l_c_cal_type
2854: AND ci_sequence_number = l_n_seq_num;
2855: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2856: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.Record_updated_when_uop_deleted',
2857: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2858: ||p_usec_rec.teach_cal_alternate_code);
2859: END IF;

Line 2856: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.Record_updated_when_uop_deleted',

2852: AND version_number = p_usec_rec.version_number
2853: AND cal_type = l_c_cal_type
2854: AND ci_sequence_number = l_n_seq_num;
2855: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2856: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.Record_updated_when_uop_deleted',
2857: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2858: ||p_usec_rec.teach_cal_alternate_code);
2859: END IF;
2860: ELSE

Line 2896: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

2892: SYSDATE,
2893: g_n_login_id
2894: );
2895:
2896: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2897: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.Record_Inserted',
2898: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2899: ||p_usec_rec.teach_cal_alternate_code);
2900: END IF;

Line 2897: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.Record_Inserted',

2893: g_n_login_id
2894: );
2895:
2896: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2897: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.Record_Inserted',
2898: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
2899: ||p_usec_rec.teach_cal_alternate_code);
2900: END IF;
2901: END IF;

Line 3675: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3671: BEGIN
3672:
3673: validate_uoo_parameters ( p_usec_rec );
3674:
3675: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3676: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_validate_uoo_parameters',
3677: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3678: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3679: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 3676: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_validate_uoo_parameters',

3672:
3673: validate_uoo_parameters ( p_usec_rec );
3674:
3675: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3676: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_validate_uoo_parameters',
3677: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3678: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3679: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
3680: END IF;

Line 3686: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3682: IF ( p_usec_rec.status = 'S' ) THEN
3683: validate_uoo_derivations ( p_usec_rec );
3684:
3685:
3686: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3687: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_validate_uoo_derivations',
3688: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3689: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3690: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 3687: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_validate_uoo_derivations',

3683: validate_uoo_derivations ( p_usec_rec );
3684:
3685:
3686: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3687: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_validate_uoo_derivations',
3688: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3689: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3690: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
3691: END IF;

Line 3700: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3696: l_insert_update:='I';
3697: IF p_usec_rec.status = 'S' AND p_calling_context IN ('G', 'S') THEN
3698: l_insert_update:= check_insert_update(p_usec_rec);
3699:
3700: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3701: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_check_insert_update',
3702: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3703: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3704: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 3701: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_check_insert_update',

3697: IF p_usec_rec.status = 'S' AND p_calling_context IN ('G', 'S') THEN
3698: l_insert_update:= check_insert_update(p_usec_rec);
3699:
3700: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3701: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_check_insert_update',
3702: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3703: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3704: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
3705: END IF;

Line 3721: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3717: fnd_msg_pub.add;
3718: p_usec_rec.status := 'A';
3719: END IF;
3720:
3721: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3722: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_check_import_allowed',
3723: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3724: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3725: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 3722: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_check_import_allowed',

3718: p_usec_rec.status := 'A';
3719: END IF;
3720:
3721: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3722: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_check_import_allowed',
3723: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3724: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3725: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
3726: END IF;

Line 3733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3729:
3730: IF p_usec_rec.status = 'S' THEN
3731: Assign_default(p_usec_rec,l_insert_update);
3732:
3733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3734: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_Assign_default',
3735: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3736: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3737: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 3734: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_Assign_default',

3730: IF p_usec_rec.status = 'S' THEN
3731: Assign_default(p_usec_rec,l_insert_update);
3732:
3733: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3734: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_Assign_default',
3735: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3736: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3737: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
3738: END IF;

Line 3745: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3741:
3742: IF ( p_usec_rec.status = 'S' ) THEN
3743: validate_uoo_db_cons ( p_usec_rec,l_insert_update );
3744:
3745: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3746: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_validate_uoo_db_cons',
3747: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3748: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3749: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 3746: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_validate_uoo_db_cons',

3742: IF ( p_usec_rec.status = 'S' ) THEN
3743: validate_uoo_db_cons ( p_usec_rec,l_insert_update );
3744:
3745: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3746: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_validate_uoo_db_cons',
3747: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3748: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3749: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
3750: END IF;

Line 3761: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3757: IF ( p_usec_rec.status = 'S' ) THEN
3758: -- Check for validation by calling validate_uoo
3759: igs_ps_validate_lgcy_pkg.validate_uoo ( p_usec_rec, l_c_cal_type, l_n_seq_num,l_n_sup_uoo_id,l_insert_update,l_conc_flag ) ;
3760:
3761: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3762: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_Business validations',
3763: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3764: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3765: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 3762: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_Business validations',

3758: -- Check for validation by calling validate_uoo
3759: igs_ps_validate_lgcy_pkg.validate_uoo ( p_usec_rec, l_c_cal_type, l_n_seq_num,l_n_sup_uoo_id,l_insert_update,l_conc_flag ) ;
3760:
3761: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3762: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_Business validations',
3763: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3764: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3765: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
3766: END IF;

Line 3950: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3946: p_usec_rec.default_enroll_flag,
3947: 'N'
3948: );
3949:
3950: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3951: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.record_inserted',
3952: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3953: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3954: p_usec_rec.unit_class);

Line 3951: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.record_inserted',

3947: 'N'
3948: );
3949:
3950: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3951: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.record_inserted',
3952: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3953: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3954: p_usec_rec.unit_class);
3955: END IF;

Line 3966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

3962: UPDATE igs_ps_sch_pat_int set import_done_flag='Y' WHERE int_pat_id = l_cur_int_pat.int_pat_id;
3963: END IF;
3964: CLOSE cur_int_pat;
3965:
3966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3967: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.interface_table_updated',
3968: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3969: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3970: p_usec_rec.unit_class||' '||'int_pat_id:'||l_cur_int_pat.int_pat_id);

Line 3967: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.interface_table_updated',

3963: END IF;
3964: CLOSE cur_int_pat;
3965:
3966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3967: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.interface_table_updated',
3968: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
3969: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
3970: p_usec_rec.unit_class||' '||'int_pat_id:'||l_cur_int_pat.int_pat_id);
3971: END IF;

Line 4018: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4014: AND unit_class = p_usec_rec.unit_class
4015: AND location_cd = p_usec_rec.location_cd
4016: AND cal_type = l_c_cal_type ;
4017:
4018: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4019: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.record_updated',
4020: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4021: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4022: p_usec_rec.unit_class);

Line 4019: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.record_updated',

4015: AND location_cd = p_usec_rec.location_cd
4016: AND cal_type = l_c_cal_type ;
4017:
4018: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4019: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.record_updated',
4020: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4021: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4022: p_usec_rec.unit_class);
4023: END IF;

Line 4034: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4030: UPDATE igs_ps_sch_usec_int_all set import_done_flag='Y' WHERE int_usec_id = l_cur_int_usec.int_usec_id;
4031: UPDATE igs_ps_sch_pat_int set import_done_flag='Y' WHERE int_pat_id = l_cur_int_usec.int_pat_id;
4032: END IF;
4033:
4034: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4035: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.interface_table_updated',
4036: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4037: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4038: p_usec_rec.unit_class||' '||'int_pat_id:'||l_cur_int_pat.int_pat_id);

Line 4035: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.interface_table_updated',

4031: UPDATE igs_ps_sch_pat_int set import_done_flag='Y' WHERE int_pat_id = l_cur_int_usec.int_pat_id;
4032: END IF;
4033:
4034: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4035: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.interface_table_updated',
4036: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4037: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4038: p_usec_rec.unit_class||' '||'int_pat_id:'||l_cur_int_pat.int_pat_id);
4039: END IF;

Line 4485: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4481:
4482: IF p_usec_rec.status = 'S' THEN
4483: get_uoo_id ( p_usec_rec);
4484:
4485: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4486: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_get_uoo_id',
4487: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4488: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4489: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 4486: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_get_uoo_id',

4482: IF p_usec_rec.status = 'S' THEN
4483: get_uoo_id ( p_usec_rec);
4484:
4485: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4486: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_get_uoo_id',
4487: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4488: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4489: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
4490: END IF;

Line 4499: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4495: l_insert_update:='I';
4496: IF p_usec_rec.status = 'S' AND p_calling_context IN ('G', 'S') THEN
4497: l_insert_update:= check_insert_update(p_usec_rec);
4498:
4499: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4500: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_check_insert_update',
4501: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4502: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4503: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 4500: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_check_insert_update',

4496: IF p_usec_rec.status = 'S' AND p_calling_context IN ('G', 'S') THEN
4497: l_insert_update:= check_insert_update(p_usec_rec);
4498:
4499: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4500: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_check_insert_update',
4501: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4502: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4503: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
4504: END IF;

Line 4511: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4507:
4508: IF p_usec_rec.status = 'S' THEN
4509: Assign_default(p_usec_rec,l_insert_update);
4510:
4511: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4512: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_Assign_default',
4513: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4514: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4515: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 4512: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_Assign_default',

4508: IF p_usec_rec.status = 'S' THEN
4509: Assign_default(p_usec_rec,l_insert_update);
4510:
4511: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4512: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_Assign_default',
4513: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4514: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4515: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
4516: END IF;

Line 4523: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4519:
4520: IF ( p_usec_rec.status = 'S' ) THEN
4521: validate_cp_db_cons ( p_usec_rec,l_insert_update );
4522:
4523: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4524: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_validate_cp_db_cons',
4525: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4526: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4527: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 4524: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_validate_cp_db_cons',

4520: IF ( p_usec_rec.status = 'S' ) THEN
4521: validate_cp_db_cons ( p_usec_rec,l_insert_update );
4522:
4523: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4524: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_validate_cp_db_cons',
4525: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4526: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4527: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
4528: END IF;

Line 4537: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4533: IF ( p_usec_rec.status = 'S' ) THEN
4534: -- Check for validation by calling validate_cps
4535: igs_ps_validate_lgcy_pkg.validate_cps ( p_usec_rec,l_n_uoo_id,l_insert_update ) ;
4536:
4537: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4538: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_Business_validation',
4539: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4540: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4541: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 4538: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_Business_validation',

4534: -- Check for validation by calling validate_cps
4535: igs_ps_validate_lgcy_pkg.validate_cps ( p_usec_rec,l_n_uoo_id,l_insert_update ) ;
4536:
4537: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4538: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_Business_validation',
4539: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4540: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4541: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
4542: END IF;

Line 4610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4606: p_usec_rec.exclude_from_max_cp_limit,
4607: p_usec_rec.claimable_hours
4608: );
4609:
4610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4611: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.record_inserted',
4612: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4613: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4614: p_usec_rec.unit_class);

Line 4611: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.record_inserted',

4607: p_usec_rec.claimable_hours
4608: );
4609:
4610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4611: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.record_inserted',
4612: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4613: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4614: p_usec_rec.unit_class);
4615: END IF;

Line 4645: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4641: exclude_from_max_cp_limit = p_usec_rec.exclude_from_max_cp_limit,
4642: claimable_hours =p_usec_rec.claimable_hours
4643: WHERE uoo_id = l_n_uoo_id;
4644:
4645: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4646: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.record_updated',
4647: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4648: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4649: p_usec_rec.unit_class);

Line 4646: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.record_updated',

4642: claimable_hours =p_usec_rec.claimable_hours
4643: WHERE uoo_id = l_n_uoo_id;
4644:
4645: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4646: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.record_updated',
4647: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4648: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4649: p_usec_rec.unit_class);
4650: END IF;

Line 4909: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4905:
4906: IF p_usec_rec.status = 'S' THEN
4907: get_uoo_id ( p_usec_rec);
4908:
4909: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4910: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_get_uoo_id',
4911: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4912: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4913: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 4910: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_get_uoo_id',

4906: IF p_usec_rec.status = 'S' THEN
4907: get_uoo_id ( p_usec_rec);
4908:
4909: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4910: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_get_uoo_id',
4911: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4912: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4913: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
4914: END IF;

Line 4923: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4919: l_insert_update:='I';
4920: IF p_usec_rec.status = 'S' AND p_calling_context IN ('G', 'S') THEN
4921: l_insert_update:= check_insert_update(p_usec_rec);
4922:
4923: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4924: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_check_insert_update',
4925: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4926: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4927: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 4924: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_check_insert_update',

4920: IF p_usec_rec.status = 'S' AND p_calling_context IN ('G', 'S') THEN
4921: l_insert_update:= check_insert_update(p_usec_rec);
4922:
4923: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4924: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_check_insert_update',
4925: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4926: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4927: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
4928: END IF;

Line 4935: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4931:
4932: IF p_usec_rec.status = 'S' THEN
4933: Assign_default(p_usec_rec,l_insert_update);
4934:
4935: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4936: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_Assign_default',
4937: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4938: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4939: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 4936: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_Assign_default',

4932: IF p_usec_rec.status = 'S' THEN
4933: Assign_default(p_usec_rec,l_insert_update);
4934:
4935: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4936: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_Assign_default',
4937: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4938: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4939: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
4940: END IF;

Line 4947: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4943:
4944: IF ( p_usec_rec.status = 'S' ) THEN
4945: validate_ref_db_cons ( p_usec_rec,l_insert_update );
4946:
4947: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4948: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_validate_ref_db_cons',
4949: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4950: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4951: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 4948: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_validate_ref_db_cons',

4944: IF ( p_usec_rec.status = 'S' ) THEN
4945: validate_ref_db_cons ( p_usec_rec,l_insert_update );
4946:
4947: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4948: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_validate_ref_db_cons',
4949: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4950: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4951: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
4952: END IF;

Line 4961: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

4957: -- Check for validation by calling validate_ref
4958: l_n_subtitle_id := NULL;
4959: igs_ps_validate_lgcy_pkg.validate_ref ( p_usec_rec, l_n_subtitle_id ,l_n_uoo_id,l_insert_update);
4960:
4961: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4962: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_Business_validation',
4963: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4964: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4965: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 4962: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_Business_validation',

4958: l_n_subtitle_id := NULL;
4959: igs_ps_validate_lgcy_pkg.validate_ref ( p_usec_rec, l_n_subtitle_id ,l_n_uoo_id,l_insert_update);
4960:
4961: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
4962: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_Business_validation',
4963: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
4964: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
4965: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
4966: END IF;

Line 5050: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5046: p_usec_rec.reference_title,
5047: l_n_subtitle_id
5048: );
5049:
5050: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5051: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.record_inserted',
5052: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5053: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5054: p_usec_rec.unit_class);

Line 5051: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.record_inserted',

5047: l_n_subtitle_id
5048: );
5049:
5050: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5051: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.record_inserted',
5052: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5053: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5054: p_usec_rec.unit_class);
5055: END IF;

Line 5092: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5088: record_exclusion_flag =p_usec_rec.reference_rec_exclusion_flag,
5089: subtitle_id=l_n_subtitle_id
5090: WHERE uoo_id = l_n_uoo_id;
5091:
5092: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5093: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.record_updated',
5094: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5095: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5096: p_usec_rec.unit_class);

Line 5093: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.record_updated',

5089: subtitle_id=l_n_subtitle_id
5090: WHERE uoo_id = l_n_uoo_id;
5091:
5092: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5093: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.record_updated',
5094: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5095: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5096: p_usec_rec.unit_class);
5097: END IF;

Line 5346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5342:
5343: IF p_usec_rec.status = 'S' THEN
5344: get_uoo_id ( p_usec_rec);
5345:
5346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5347: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_get_uoo_id',
5348: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5349: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5350: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 5347: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_get_uoo_id',

5343: IF p_usec_rec.status = 'S' THEN
5344: get_uoo_id ( p_usec_rec);
5345:
5346: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5347: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_get_uoo_id',
5348: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5349: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5350: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
5351: END IF;

Line 5360: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5356: l_insert_update:='I';
5357: IF p_usec_rec.status = 'S' AND p_calling_context IN ('G', 'S') THEN
5358: l_insert_update:= check_insert_update(p_usec_rec);
5359:
5360: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5361: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_check_insert_update',
5362: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5363: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5364: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 5361: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_check_insert_update',

5357: IF p_usec_rec.status = 'S' AND p_calling_context IN ('G', 'S') THEN
5358: l_insert_update:= check_insert_update(p_usec_rec);
5359:
5360: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5361: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_check_insert_update',
5362: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5363: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5364: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
5365: END IF;

Line 5372: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5368:
5369: IF p_usec_rec.status = 'S' THEN
5370: Assign_default(p_usec_rec,l_insert_update);
5371:
5372: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5373: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_Assign_default',
5374: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5375: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5376: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 5373: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_Assign_default',

5369: IF p_usec_rec.status = 'S' THEN
5370: Assign_default(p_usec_rec,l_insert_update);
5371:
5372: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5373: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_Assign_default',
5374: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5375: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5376: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
5377: END IF;

Line 5384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5380:
5381: IF p_usec_rec.status = 'S' THEN
5382: validate_db_cons(p_usec_rec,l_insert_update);
5383:
5384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5385: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_validate_db_cons',
5386: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5387: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5388: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 5385: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_validate_db_cons',

5381: IF p_usec_rec.status = 'S' THEN
5382: validate_db_cons(p_usec_rec,l_insert_update);
5383:
5384: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5385: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_validate_db_cons',
5386: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5387: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5388: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
5389: END IF;

Line 5396: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5392:
5393: IF p_usec_rec.status = 'S' THEN
5394: igs_ps_validate_lgcy_pkg.validate_usec_el (p_usec_rec,l_n_uoo_id,l_insert_update);
5395:
5396: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5397: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_business_validations',
5398: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5399: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5400: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 5397: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_business_validations',

5393: IF p_usec_rec.status = 'S' THEN
5394: igs_ps_validate_lgcy_pkg.validate_usec_el (p_usec_rec,l_n_uoo_id,l_insert_update);
5395:
5396: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5397: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_business_validations',
5398: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5399: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5400: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
5401: END IF;

Line 5444: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5440: sysdate,
5441: g_n_login_id
5442: );
5443:
5444: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5445: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.record_inserted',
5446: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5447: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5448: p_usec_rec.unit_class);

Line 5445: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.record_inserted',

5441: g_n_login_id
5442: );
5443:
5444: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5445: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.record_inserted',
5446: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5447: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5448: p_usec_rec.unit_class);
5449: END IF;

Line 5466: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5462: last_update_date= SYSDATE ,
5463: last_update_login= g_n_login_id
5464: WHERE uoo_id =l_n_uoo_id;
5465:
5466: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5467: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.record_updated',
5468: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5469: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5470: p_usec_rec.unit_class);

Line 5467: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.record_updated',

5463: last_update_login= g_n_login_id
5464: WHERE uoo_id =l_n_uoo_id;
5465:
5466: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5467: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.record_updated',
5468: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5469: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5470: p_usec_rec.unit_class);
5471: END IF;

Line 5477: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5473: END IF;
5474:
5475: igs_ps_validate_lgcy_pkg.post_usec_limits(p_usec_rec,p_calling_context,l_n_uoo_id,l_insert_update);
5476:
5477: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5478: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_post_usec_limits',
5479: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5480: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5481: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);

Line 5478: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_post_usec_limits',

5474:
5475: igs_ps_validate_lgcy_pkg.post_usec_limits(p_usec_rec,p_calling_context,l_n_uoo_id,l_insert_update);
5476:
5477: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5478: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_post_usec_limits',
5479: 'Unit code:'||p_usec_rec.unit_cd||' '||'Version number:'||p_usec_rec.version_number||' '||'teach_cal_alternate_code:'
5480: ||p_usec_rec.teach_cal_alternate_code||' '||'Location_cd:'||p_usec_rec.location_cd||' '||'Unit Class:'||
5481: p_usec_rec.unit_class||' '||'Status:'||p_usec_rec.status);
5482: END IF;

Line 5493: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

5489:
5490:
5491: BEGIN
5492:
5493: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
5494: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.start_logging_for','Unit Sections');
5495: END IF;
5496:
5497: p_c_rec_status := 'S';

Line 5494: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.start_logging_for','Unit Sections');

5490:
5491: BEGIN
5492:
5493: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
5494: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.start_logging_for','Unit Sections');
5495: END IF;
5496:
5497: p_c_rec_status := 'S';
5498: FOR I in 1..p_usec_tbl.LAST LOOP

Line 5507: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5503:
5504: trim_values(p_usec_tbl(I));
5505: -- Create Unit Offering
5506:
5507: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5508: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.call',
5509: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5510: ||p_usec_tbl(I).teach_cal_alternate_code);
5511: END IF;

Line 5508: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.call',

5504: trim_values(p_usec_tbl(I));
5505: -- Create Unit Offering
5506:
5507: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5508: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.call',
5509: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5510: ||p_usec_tbl(I).teach_cal_alternate_code);
5511: END IF;
5512:

Line 5515: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5511: END IF;
5512:
5513: create_uo ( p_usec_rec => p_usec_tbl(I) );
5514:
5515: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5516: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_record_creation',
5517: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5518: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Status:'||p_usec_tbl(I).status);
5519: END IF;

Line 5516: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_record_creation',

5512:
5513: create_uo ( p_usec_rec => p_usec_tbl(I) );
5514:
5515: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5516: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uo.status_after_record_creation',
5517: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5518: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Status:'||p_usec_tbl(I).status);
5519: END IF;
5520:

Line 5525: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5521:
5522: IF p_usec_tbl(I).status = 'S' THEN
5523: -- Create Unit Offering Pattern
5524:
5525: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5526: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.call',
5527: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5528: ||p_usec_tbl(I).teach_cal_alternate_code);
5529: END IF;

Line 5526: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.call',

5522: IF p_usec_tbl(I).status = 'S' THEN
5523: -- Create Unit Offering Pattern
5524:
5525: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5526: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.call',
5527: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5528: ||p_usec_tbl(I).teach_cal_alternate_code);
5529: END IF;
5530:

Line 5533: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5529: END IF;
5530:
5531: create_uop ( p_usec_tbl(I) );
5532:
5533: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5534: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.status_after_record_creation',
5535: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5536: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Status:'||p_usec_tbl(I).status);
5537: END IF;

Line 5534: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.status_after_record_creation',

5530:
5531: create_uop ( p_usec_tbl(I) );
5532:
5533: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5534: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uop.status_after_record_creation',
5535: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5536: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Status:'||p_usec_tbl(I).status);
5537: END IF;
5538:

Line 5543: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5539: END IF;
5540:
5541: IF p_usec_tbl(I).status = 'S' THEN
5542: -- Create Unit Offering Option
5543: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5544: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.call',
5545: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5546: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5547: p_usec_tbl(I).unit_class);

Line 5544: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.call',

5540:
5541: IF p_usec_tbl(I).status = 'S' THEN
5542: -- Create Unit Offering Option
5543: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5544: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.call',
5545: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5546: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5547: p_usec_tbl(I).unit_class);
5548: END IF;

Line 5552: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5548: END IF;
5549:
5550: create_uoo ( p_usec_tbl(I) );
5551:
5552: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5553: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_record_creation',
5554: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5555: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5556: p_usec_tbl(I).unit_class||' '||'Status:'||p_usec_tbl(I).status);

Line 5553: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_record_creation',

5549:
5550: create_uoo ( p_usec_tbl(I) );
5551:
5552: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5553: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_uoo.status_after_record_creation',
5554: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5555: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5556: p_usec_tbl(I).unit_class||' '||'Status:'||p_usec_tbl(I).status);
5557: END IF;

Line 5561: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5557: END IF;
5558: END IF;
5559: IF p_usec_tbl(I).status = 'S' THEN
5560: -- Create Unit Section Credit Points
5561: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5562: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.call',
5563: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5564: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5565: p_usec_tbl(I).unit_class);

Line 5562: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.call',

5558: END IF;
5559: IF p_usec_tbl(I).status = 'S' THEN
5560: -- Create Unit Section Credit Points
5561: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5562: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.call',
5563: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5564: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5565: p_usec_tbl(I).unit_class);
5566: END IF;

Line 5570: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5566: END IF;
5567:
5568: create_cp ( p_usec_tbl(I) );
5569:
5570: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5571: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_record_creation',
5572: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5573: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5574: p_usec_tbl(I).unit_class||' '||'Status:'||p_usec_tbl(I).status);

Line 5571: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_record_creation',

5567:
5568: create_cp ( p_usec_tbl(I) );
5569:
5570: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5571: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_cp.status_after_record_creation',
5572: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5573: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5574: p_usec_tbl(I).unit_class||' '||'Status:'||p_usec_tbl(I).status);
5575: END IF;

Line 5580: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5576:
5577: END IF;
5578: IF p_usec_tbl(I).status = 'S' THEN
5579: -- Create Unit Section Reference
5580: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5581: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.call',
5582: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5583: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5584: p_usec_tbl(I).unit_class);

Line 5581: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.call',

5577: END IF;
5578: IF p_usec_tbl(I).status = 'S' THEN
5579: -- Create Unit Section Reference
5580: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5581: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.call',
5582: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5583: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5584: p_usec_tbl(I).unit_class);
5585: END IF;

Line 5589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5585: END IF;
5586:
5587: create_ref ( p_usec_tbl(I) );
5588:
5589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5590: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_record_creation',
5591: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5592: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5593: p_usec_tbl(I).unit_class||' '||'Status:'||p_usec_tbl(I).status);

Line 5590: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_record_creation',

5586:
5587: create_ref ( p_usec_tbl(I) );
5588:
5589: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5590: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_ref.status_after_record_creation',
5591: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5592: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5593: p_usec_tbl(I).unit_class||' '||'Status:'||p_usec_tbl(I).status);
5594: END IF;

Line 5599: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5595:
5596: END IF;
5597: IF p_usec_tbl(I).status = 'S' THEN
5598: -- Create Unit Section Enrollment Limits
5599: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5600: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.call',
5601: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5602: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5603: p_usec_tbl(I).unit_class);

Line 5600: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.call',

5596: END IF;
5597: IF p_usec_tbl(I).status = 'S' THEN
5598: -- Create Unit Section Enrollment Limits
5599: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5600: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.call',
5601: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5602: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5603: p_usec_tbl(I).unit_class);
5604: END IF;

Line 5608: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5604: END IF;
5605:
5606: create_usec_el ( p_usec_tbl(I) );
5607:
5608: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5609: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_record_creation',
5610: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5611: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5612: p_usec_tbl(I).unit_class||' '||'Status:'||p_usec_tbl(I).status);

Line 5609: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_record_creation',

5605:
5606: create_usec_el ( p_usec_tbl(I) );
5607:
5608: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5609: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.create_usec_el.status_after_record_creation',
5610: 'Unit code:'||p_usec_tbl(I).unit_cd||' '||'Version number:'||p_usec_tbl(I).version_number||' '||'teach_cal_alternate_code:'
5611: ||p_usec_tbl(I).teach_cal_alternate_code||' '||'Location_cd:'||p_usec_tbl(I).location_cd||' '||'Unit Class:'||
5612: p_usec_tbl(I).unit_class||' '||'Status:'||p_usec_tbl(I).status);
5613: END IF;

Line 5649: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

5645: END IF;
5646: END IF;--exists
5647: END LOOP;
5648:
5649: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
5650: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.after_import_status',p_c_rec_status);
5651: END IF;
5652:
5653: END create_unit_section;

Line 5650: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.after_import_status',p_c_rec_status);

5646: END IF;--exists
5647: END LOOP;
5648:
5649: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
5650: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_section.after_import_status',p_c_rec_status);
5651: END IF;
5652:
5653: END create_unit_section;
5654:

Line 5829: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

5825:
5826: /* Main Unit Section Grading Schema Sub Process */
5827: BEGIN
5828:
5829: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
5830: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.start_logging_for','Unit Section Grading Schema');
5831: END IF;
5832:
5833: p_c_rec_status := 'S';

Line 5830: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.start_logging_for','Unit Section Grading Schema');

5826: /* Main Unit Section Grading Schema Sub Process */
5827: BEGIN
5828:
5829: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
5830: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.start_logging_for','Unit Section Grading Schema');
5831: END IF;
5832:
5833: p_c_rec_status := 'S';
5834: FOR I in 1..p_tab_usec_gs.LAST LOOP

Line 5843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5839: p_tab_usec_gs(I).msg_from := fnd_msg_pub.count_msg;
5840: trim_values(p_tab_usec_gs(I) );
5841: validate_parameters ( p_tab_usec_gs(I) );
5842:
5843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5844: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_validate_parameters',
5845: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5846: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5847: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'

Line 5844: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_validate_parameters',

5840: trim_values(p_tab_usec_gs(I) );
5841: validate_parameters ( p_tab_usec_gs(I) );
5842:
5843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5844: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_validate_parameters',
5845: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5846: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5847: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'
5848: ||p_tab_usec_gs(I).grd_schm_version_number||' '||'Status:'||p_tab_usec_gs(I).status);

Line 5854: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5850:
5851: IF p_tab_usec_gs(I).status = 'S' THEN
5852: validate_derivations ( p_tab_usec_gs(I));
5853:
5854: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5855: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_validate_derivations',
5856: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5857: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5858: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'

Line 5855: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_validate_derivations',

5851: IF p_tab_usec_gs(I).status = 'S' THEN
5852: validate_derivations ( p_tab_usec_gs(I));
5853:
5854: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5855: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_validate_derivations',
5856: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5857: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5858: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'
5859: ||p_tab_usec_gs(I).grd_schm_version_number||' '||'Status:'||p_tab_usec_gs(I).status);

Line 5869: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5865: l_insert_update:='I';
5866: IF p_tab_usec_gs(I).status = 'S' AND p_calling_context IN ('G','S') THEN
5867: l_insert_update:= check_insert_update(p_tab_usec_gs(I));
5868:
5869: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5870: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_check_insert_update',
5871: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5872: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5873: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'

Line 5870: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_check_insert_update',

5866: IF p_tab_usec_gs(I).status = 'S' AND p_calling_context IN ('G','S') THEN
5867: l_insert_update:= check_insert_update(p_tab_usec_gs(I));
5868:
5869: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5870: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_check_insert_update',
5871: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5872: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5873: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'
5874: ||p_tab_usec_gs(I).grd_schm_version_number||' '||'Status:'||p_tab_usec_gs(I).status);

Line 5888: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5884: fnd_msg_pub.add;
5885: p_tab_usec_gs(I).status := 'A';
5886: END IF;
5887:
5888: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5889: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_check_import_allowed',
5890: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5891: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5892: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'

Line 5889: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_check_import_allowed',

5885: p_tab_usec_gs(I).status := 'A';
5886: END IF;
5887:
5888: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5889: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_check_import_allowed',
5890: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5891: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5892: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'
5893: ||p_tab_usec_gs(I).grd_schm_version_number||' '||'Status:'||p_tab_usec_gs(I).status);

Line 5906: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5902: l_tbl_uoo(l_tbl_uoo.count+1) :=l_n_uoo_id;
5903: END IF;
5904: END IF;
5905:
5906: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5907: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.count_unique_uoo_ids',
5908: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5909: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5910: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'

Line 5907: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.count_unique_uoo_ids',

5903: END IF;
5904: END IF;
5905:
5906: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5907: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.count_unique_uoo_ids',
5908: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5909: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5910: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'
5911: ||p_tab_usec_gs(I).grd_schm_version_number||' '||'Count:'||l_tbl_uoo.count);

Line 5917: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5913:
5914: IF p_tab_usec_gs(I).status = 'S' THEN
5915: validate_db_cons ( p_tab_usec_gs(I),l_insert_update );
5916:
5917: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5918: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_validate_db_cons',
5919: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5920: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5921: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'

Line 5918: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_validate_db_cons',

5914: IF p_tab_usec_gs(I).status = 'S' THEN
5915: validate_db_cons ( p_tab_usec_gs(I),l_insert_update );
5916:
5917: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5918: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_validate_db_cons',
5919: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5920: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5921: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'
5922: ||p_tab_usec_gs(I).grd_schm_version_number||' '||'Status:'||p_tab_usec_gs(I).status);

Line 5934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5930: /* Proceed with business validations only if the status is Success, 'S' */
5931: IF p_tab_usec_gs(I).status = 'S' THEN
5932: igs_ps_validate_lgcy_pkg.validate_usec_grd_sch ( p_tab_usec_gs(I),l_n_uoo_id );
5933:
5934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5935: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_Business_validation',
5936: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5937: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5938: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'

Line 5935: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_Business_validation',

5931: IF p_tab_usec_gs(I).status = 'S' THEN
5932: igs_ps_validate_lgcy_pkg.validate_usec_grd_sch ( p_tab_usec_gs(I),l_n_uoo_id );
5933:
5934: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5935: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.status_after_Business_validation',
5936: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5937: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5938: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'
5939: ||p_tab_usec_gs(I).grd_schm_version_number||' '||'Status:'||p_tab_usec_gs(I).status);

Line 5972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5968: SYSDATE,
5969: g_n_login_id
5970: );
5971:
5972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5973: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.record_inserted',
5974: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5975: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5976: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'

Line 5973: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.record_inserted',

5969: g_n_login_id
5970: );
5971:
5972: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5973: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.record_inserted',
5974: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5975: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5976: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'
5977: ||p_tab_usec_gs(I).grd_schm_version_number);

Line 5992: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

5988: WHERE grading_schema_code = p_tab_usec_gs(I).grading_schema_code
5989: AND grd_schm_version_number = p_tab_usec_gs(I).grd_schm_version_number
5990: AND uoo_id = l_n_uoo_id;
5991:
5992: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5993: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.record_updated',
5994: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5995: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5996: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'

Line 5993: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.record_updated',

5989: AND grd_schm_version_number = p_tab_usec_gs(I).grd_schm_version_number
5990: AND uoo_id = l_n_uoo_id;
5991:
5992: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
5993: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.record_updated',
5994: 'Unit code:'||p_tab_usec_gs(I).unit_cd||' '||'Version number:'||p_tab_usec_gs(I).version_number||' '||'teach_cal_alternate_code:'
5995: ||p_tab_usec_gs(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_gs(I).location_cd||' '||'Unit Class:'||
5996: p_tab_usec_gs(I).unit_class||' '||'Grading Schema Code:'||p_tab_usec_gs(I).grading_schema_code||' '||'Grading Schema Version Number:'
5997: ||p_tab_usec_gs(I).grd_schm_version_number);

Line 6027: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6023: p_c_rec_status := 'E';
6024: END IF;
6025: l_tbl_uoo.DELETE;
6026:
6027: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6028: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.after_import_status',p_c_rec_status);
6029: END IF;
6030:
6031:

Line 6028: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.after_import_status',p_c_rec_status);

6024: END IF;
6025: l_tbl_uoo.DELETE;
6026:
6027: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6028: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_grd_sch.after_import_status',p_c_rec_status);
6029: END IF;
6030:
6031:
6032: END create_usec_grd_sch;

Line 6865: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

6861:
6862: /* Main Unit Section Occurrence Sub Process */
6863: BEGIN
6864:
6865: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6866: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.start_logging_for','Unit Section Occurrence');
6867: END IF;
6868:
6869: p_c_rec_status := 'S';

Line 6866: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.start_logging_for','Unit Section Occurrence');

6862: /* Main Unit Section Occurrence Sub Process */
6863: BEGIN
6864:
6865: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
6866: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.start_logging_for','Unit Section Occurrence');
6867: END IF;
6868:
6869: p_c_rec_status := 'S';
6870: FOR I in 1..p_tab_usec_occur.LAST LOOP

Line 6894: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

6890: p_tab_usec_occur(I).msg_from := fnd_msg_pub.count_msg;
6891: trim_values(p_tab_usec_occur(I) );
6892: validate_parameters ( p_tab_usec_occur(I) );
6893:
6894: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6895: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_validate_parameters',
6896: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6897: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6898: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||

Line 6895: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_validate_parameters',

6891: trim_values(p_tab_usec_occur(I) );
6892: validate_parameters ( p_tab_usec_occur(I) );
6893:
6894: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6895: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_validate_parameters',
6896: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6897: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6898: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||
6899: 'Status:'||p_tab_usec_occur(I).status);

Line 6906: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

6902: --Only derivation no defaulting
6903: IF p_tab_usec_occur(I).status = 'S' THEN
6904: validate_derivations ( p_tab_usec_occur(I));
6905:
6906: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6907: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_validate_derivations',
6908: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6909: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6910: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||

Line 6907: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_validate_derivations',

6903: IF p_tab_usec_occur(I).status = 'S' THEN
6904: validate_derivations ( p_tab_usec_occur(I));
6905:
6906: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6907: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_validate_derivations',
6908: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6909: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6910: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||
6911: 'Status:'||p_tab_usec_occur(I).status);

Line 6921: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

6917: l_insert_update:='I';
6918: IF p_tab_usec_occur(I).status = 'S' AND p_calling_context IN ('G','S') THEN
6919: l_insert_update:= check_insert_update(p_tab_usec_occur(I));
6920:
6921: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6922: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_check_insert_update',
6923: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6924: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6925: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||

Line 6922: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_check_insert_update',

6918: IF p_tab_usec_occur(I).status = 'S' AND p_calling_context IN ('G','S') THEN
6919: l_insert_update:= check_insert_update(p_tab_usec_occur(I));
6920:
6921: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6922: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_check_insert_update',
6923: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6924: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6925: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||
6926: 'Status:'||p_tab_usec_occur(I).status);

Line 6939: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

6935: fnd_msg_pub.add;
6936: p_tab_usec_occur(I).status := 'A';
6937: END IF;
6938:
6939: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6940: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_check_import_allowed',
6941: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6942: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6943: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||

Line 6940: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_check_import_allowed',

6936: p_tab_usec_occur(I).status := 'A';
6937: END IF;
6938:
6939: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6940: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_check_import_allowed',
6941: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6942: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6943: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||
6944: 'Status:'||p_tab_usec_occur(I).status);

Line 6953: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

6949: --Defaulting depending upon insert or update
6950: IF p_tab_usec_occur(I).status = 'S' THEN
6951: assign_defaults(p_tab_usec_occur(I),l_insert_update);
6952:
6953: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6954: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_assign_defaults',
6955: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6956: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6957: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||

Line 6954: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_assign_defaults',

6950: IF p_tab_usec_occur(I).status = 'S' THEN
6951: assign_defaults(p_tab_usec_occur(I),l_insert_update);
6952:
6953: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6954: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_assign_defaults',
6955: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6956: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6957: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||
6958: 'Status:'||p_tab_usec_occur(I).status);

Line 6966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

6962:
6963: IF p_tab_usec_occur(I).status = 'S' THEN
6964: validate_db_cons ( p_tab_usec_occur(I),l_insert_update);
6965:
6966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6967: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_validate_db_cons',
6968: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6969: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6970: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||

Line 6967: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_validate_db_cons',

6963: IF p_tab_usec_occur(I).status = 'S' THEN
6964: validate_db_cons ( p_tab_usec_occur(I),l_insert_update);
6965:
6966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6967: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_validate_db_cons',
6968: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6969: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6970: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||
6971: 'Status:'||p_tab_usec_occur(I).status);

Line 6986: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

6982: l_n_preferred_building_code,l_n_preferred_room_code,l_n_uso_id,
6983: l_insert_update,p_calling_context,l_notify_status,l_c_schedule_status
6984: );
6985:
6986: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6987: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_Business_validation',
6988: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6989: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6990: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||

Line 6987: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_Business_validation',

6983: l_insert_update,p_calling_context,l_notify_status,l_c_schedule_status
6984: );
6985:
6986: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
6987: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.status_after_Business_validation',
6988: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
6989: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
6990: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier||' '||
6991: 'Status:'||p_tab_usec_occur(I).status);

Line 7114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7110: l_n_tbl_cnt :=l_tbl_uso.count+1;
7111: l_tbl_uso(l_n_tbl_cnt):=l_n_usec_occurs_id ;
7112:
7113:
7114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7115: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.record_inserted',
7116: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
7117: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
7118: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier);

Line 7115: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.record_inserted',

7111: l_tbl_uso(l_n_tbl_cnt):=l_n_usec_occurs_id ;
7112:
7113:
7114: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7115: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.record_inserted',
7116: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
7117: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
7118: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier);
7119: END IF;

Line 7281: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7277: preferred_region_code=p_tab_usec_occur(I).preferred_region_code,
7278: no_set_day_ind=p_tab_usec_occur(I).no_set_day_ind
7279: WHERE unit_section_occurrence_id = l_n_uso_id ;
7280:
7281: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7282: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.record_updated',
7283: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
7284: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
7285: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier);

Line 7282: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.record_updated',

7278: no_set_day_ind=p_tab_usec_occur(I).no_set_day_ind
7279: WHERE unit_section_occurrence_id = l_n_uso_id ;
7280:
7281: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7282: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.record_updated',
7283: 'Unit code:'||p_tab_usec_occur(I).unit_cd||' '||'Version number:'||p_tab_usec_occur(I).version_number||' '||'teach_cal_alternate_code:'
7284: ||p_tab_usec_occur(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_usec_occur(I).location_cd||' '||'Unit Class:'||
7285: p_tab_usec_occur(I).unit_class||'Occurrence Identifier:'|| p_tab_usec_occur(I).occurrence_identifier);
7286: END IF;

Line 7306: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

7302: END IF;
7303: END IF;
7304: END LOOP;
7305:
7306: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
7307: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.after_import_status',p_c_rec_status);
7308: END IF;
7309:
7310: END create_usec_occur;

Line 7307: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.after_import_status',p_c_rec_status);

7303: END IF;
7304: END LOOP;
7305:
7306: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
7307: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_usec_occur.after_import_status',p_c_rec_status);
7308: END IF;
7309:
7310: END create_usec_occur;
7311:

Line 7890: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

7886: ----
7887:
7888: BEGIN
7889:
7890: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
7891: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.start_logging_for','Reference: Unit,Unit Sections,Unit section Occurrence');
7892: END IF;
7893:
7894: p_c_rec_status := 'S';

Line 7891: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.start_logging_for','Reference: Unit,Unit Sections,Unit section Occurrence');

7887:
7888: BEGIN
7889:
7890: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
7891: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.start_logging_for','Reference: Unit,Unit Sections,Unit section Occurrence');
7892: END IF;
7893:
7894: p_c_rec_status := 'S';
7895:

Line 7913: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7909: -- Validate the parameters values
7910:
7911: validate_parameters(p_tab_ref_cd(i));
7912:
7913: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7914: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_validate_parameters',
7915: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
7916: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
7917: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||

Line 7914: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_validate_parameters',

7910:
7911: validate_parameters(p_tab_ref_cd(i));
7912:
7913: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7914: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_validate_parameters',
7915: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
7916: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
7917: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
7918: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 7927: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7923: -- Derive the required values
7924: IF p_tab_ref_cd(i).status = 'S' THEN
7925: validate_derivation(p_tab_ref_cd(i));
7926:
7927: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7928: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_validate_derivation',
7929: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
7930: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
7931: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||

Line 7928: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_validate_derivation',

7924: IF p_tab_ref_cd(i).status = 'S' THEN
7925: validate_derivation(p_tab_ref_cd(i));
7926:
7927: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7928: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_validate_derivation',
7929: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
7930: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
7931: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
7932: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 7944: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7940: l_insert_update:='I';
7941: IF p_tab_ref_cd(i).status = 'S' AND p_calling_context IN ('G','S') THEN
7942: l_insert_update:= check_insert_update(p_tab_ref_cd(I));
7943:
7944: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7945: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_check_insert_update',
7946: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
7947: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
7948: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||

Line 7945: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_check_insert_update',

7941: IF p_tab_ref_cd(i).status = 'S' AND p_calling_context IN ('G','S') THEN
7942: l_insert_update:= check_insert_update(p_tab_ref_cd(I));
7943:
7944: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7945: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_check_insert_update',
7946: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
7947: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
7948: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
7949: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 7964: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7960: fnd_msg_pub.add;
7961: p_tab_ref_cd(i).status := 'A';
7962: END IF;
7963:
7964: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7965: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_check_import_allowed',
7966: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
7967: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
7968: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||

Line 7965: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_check_import_allowed',

7961: p_tab_ref_cd(i).status := 'A';
7962: END IF;
7963:
7964: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7965: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_check_import_allowed',
7966: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
7967: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
7968: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
7969: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 7980: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7976: -- Check for database constraints
7977: IF p_tab_ref_cd(i).status = 'S' THEN
7978: validate_db_cons(p_tab_ref_cd(i),l_insert_update);
7979:
7980: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7981: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_validate_db_cons',
7982: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
7983: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
7984: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||

Line 7981: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_validate_db_cons',

7977: IF p_tab_ref_cd(i).status = 'S' THEN
7978: validate_db_cons(p_tab_ref_cd(i),l_insert_update);
7979:
7980: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7981: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_validate_db_cons',
7982: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
7983: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
7984: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
7985: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 7995: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

7991:
7992: IF p_tab_ref_cd(i).status = 'S' THEN
7993: igs_ps_validate_lgcy_pkg.validate_unit_reference(p_tab_ref_cd(i),l_n_uoo_id,l_n_uso_id,p_calling_context);
7994:
7995: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7996: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_Business_Validation',
7997: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
7998: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
7999: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||

Line 7996: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_Business_Validation',

7992: IF p_tab_ref_cd(i).status = 'S' THEN
7993: igs_ps_validate_lgcy_pkg.validate_unit_reference(p_tab_ref_cd(i),l_n_uoo_id,l_n_uso_id,p_calling_context);
7994:
7995: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7996: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.status_after_Business_Validation',
7997: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
7998: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
7999: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
8000: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 8035: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8031: sysdate,
8032: g_n_user_id,
8033: g_n_login_id
8034: );
8035: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8036: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_unit_ref_cd',
8037: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8038: ||p_tab_ref_cd(i).version_number||' '||'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||
8039: 'reference_cd:'||p_tab_ref_cd(i).reference_cd||' '||'gen_ref_flag:'||p_tab_ref_cd(i).gen_ref_flag);

Line 8036: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_unit_ref_cd',

8032: g_n_user_id,
8033: g_n_login_id
8034: );
8035: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8036: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_unit_ref_cd',
8037: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8038: ||p_tab_ref_cd(i).version_number||' '||'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||
8039: 'reference_cd:'||p_tab_ref_cd(i).reference_cd||' '||'gen_ref_flag:'||p_tab_ref_cd(i).gen_ref_flag);
8040: END IF;

Line 8067: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8063: g_n_login_id,
8064: p_tab_ref_cd(i).reference_cd,
8065: p_tab_ref_cd(i).description
8066: );
8067: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8068: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_unitreqref_cd',
8069: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8070: ||p_tab_ref_cd(i).version_number||' '||'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||
8071: 'reference_cd:'||p_tab_ref_cd(i).reference_cd||' '||'gen_ref_flag:'||p_tab_ref_cd(i).gen_ref_flag);

Line 8068: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_unitreqref_cd',

8064: p_tab_ref_cd(i).reference_cd,
8065: p_tab_ref_cd(i).description
8066: );
8067: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8068: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_unitreqref_cd',
8069: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8070: ||p_tab_ref_cd(i).version_number||' '||'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||
8071: 'reference_cd:'||p_tab_ref_cd(i).reference_cd||' '||'gen_ref_flag:'||p_tab_ref_cd(i).gen_ref_flag);
8072: END IF;

Line 8111: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8107: p_tab_ref_cd(i).reference_cd_type,
8108: p_tab_ref_cd(i).reference_cd,
8109: p_tab_ref_cd(i).description
8110: );
8111: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8112: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_usec_ref_cd',
8113: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8114: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8115: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||

Line 8112: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_usec_ref_cd',

8108: p_tab_ref_cd(i).reference_cd,
8109: p_tab_ref_cd(i).description
8110: );
8111: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8112: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_usec_ref_cd',
8113: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8114: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8115: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
8116: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 8125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8121: UPDATE igs_ps_usec_ref_cd SET reference_code_desc=p_tab_ref_cd(i).description,last_updated_by=g_n_user_id,
8122: last_update_date=SYSDATE WHERE unit_section_reference_id=l_n_usec_ref_id AND
8123: reference_code_type=p_tab_ref_cd(i).reference_cd_type AND reference_code=p_tab_ref_cd(i).reference_cd;
8124:
8125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8126: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Updated_igs_ps_usec_ref_cd',
8127: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8128: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8129: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||

Line 8126: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Updated_igs_ps_usec_ref_cd',

8122: last_update_date=SYSDATE WHERE unit_section_reference_id=l_n_usec_ref_id AND
8123: reference_code_type=p_tab_ref_cd(i).reference_cd_type AND reference_code=p_tab_ref_cd(i).reference_cd;
8124:
8125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8126: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Updated_igs_ps_usec_ref_cd',
8127: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8128: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8129: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
8130: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 8161: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8157: g_n_login_id,
8158: p_tab_ref_cd(i).reference_cd,
8159: p_tab_ref_cd(i).description
8160: );
8161: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8162: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_us_req_ref_cd',
8163: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8164: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8165: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||

Line 8162: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_us_req_ref_cd',

8158: p_tab_ref_cd(i).reference_cd,
8159: p_tab_ref_cd(i).description
8160: );
8161: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8162: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_Inserted_igs_ps_us_req_ref_cd',
8163: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8164: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8165: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
8166: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 8175: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8171: UPDATE igs_ps_us_req_ref_cd SET reference_code_desc=p_tab_ref_cd(i).description,last_updated_by=g_n_user_id,
8172: last_update_date=SYSDATE WHERE unit_section_reference_id=l_n_usec_ref_id AND
8173: reference_cd_type=p_tab_ref_cd(i).reference_cd_type AND reference_code=p_tab_ref_cd(i).reference_cd;
8174:
8175: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8176: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_updated_igs_ps_us_req_ref_cd',
8177: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8178: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8179: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||

Line 8176: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_updated_igs_ps_us_req_ref_cd',

8172: last_update_date=SYSDATE WHERE unit_section_reference_id=l_n_usec_ref_id AND
8173: reference_cd_type=p_tab_ref_cd(i).reference_cd_type AND reference_code=p_tab_ref_cd(i).reference_cd;
8174:
8175: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8176: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_updated_igs_ps_us_req_ref_cd',
8177: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8178: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8179: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
8180: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 8219: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8215: g_n_user_id,
8216: g_n_login_id,
8217: p_tab_ref_cd(i).description
8218: );
8219: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8220: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_inserted_igs_ps_usec_ocur_ref',
8221: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8222: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8223: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||

Line 8220: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_inserted_igs_ps_usec_ocur_ref',

8216: g_n_login_id,
8217: p_tab_ref_cd(i).description
8218: );
8219: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8220: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_inserted_igs_ps_usec_ocur_ref',
8221: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8222: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8223: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
8224: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 8234: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8230: UPDATE igs_ps_usec_ocur_ref SET reference_code_desc=p_tab_ref_cd(i).description,last_updated_by=g_n_user_id,
8231: last_update_date=SYSDATE WHERE unit_section_occurrence_id=l_n_uso_id AND
8232: reference_code_type=p_tab_ref_cd(i).reference_cd_type AND reference_code=p_tab_ref_cd(i).reference_cd;
8233:
8234: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8235: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_updated_igs_ps_usec_ocur_ref',
8236: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8237: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8238: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||

Line 8235: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_updated_igs_ps_usec_ocur_ref',

8231: last_update_date=SYSDATE WHERE unit_section_occurrence_id=l_n_uso_id AND
8232: reference_code_type=p_tab_ref_cd(i).reference_cd_type AND reference_code=p_tab_ref_cd(i).reference_cd;
8233:
8234: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8235: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.Record_updated_igs_ps_usec_ocur_ref',
8236: 'Data Type:'||p_tab_ref_cd(i).data_type||' '||'Unit code:'||p_tab_ref_cd(i).unit_cd||' '||'Version number:'
8237: ||p_tab_ref_cd(i).version_number||' '||'teach_cal_alternate_code:'||p_tab_ref_cd(i).teach_cal_alternate_code
8238: ||' '||'Location_cd:'||p_tab_ref_cd(i).location_cd||' '||'Unit Class:'||p_tab_ref_cd(i).unit_class||' '||
8239: 'reference_cd_type:'||p_tab_ref_cd(i).reference_cd_type||' '||'reference_cd:'||p_tab_ref_cd(i).reference_cd||

Line 8262: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

8258: END IF; -- status is E
8259: END IF; -- end of exist(i) if
8260: END LOOP;
8261:
8262: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
8263: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.after_import_status',p_c_rec_status);
8264: END IF;
8265:
8266:

Line 8263: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.after_import_status',p_c_rec_status);

8259: END IF; -- end of exist(i) if
8260: END LOOP;
8261:
8262: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
8263: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_unit_ref_code.after_import_status',p_c_rec_status);
8264: END IF;
8265:
8266:
8267: END create_unit_ref_code;

Line 8594: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

8590: END validate_db_cons;
8591:
8592: BEGIN
8593:
8594: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
8595: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.start_logging_for','Unit Section Occurrence Instructors');
8596: END IF;
8597:
8598: p_c_rec_status := 'S';

Line 8595: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.start_logging_for','Unit Section Occurrence Instructors');

8591:
8592: BEGIN
8593:
8594: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
8595: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.start_logging_for','Unit Section Occurrence Instructors');
8596: END IF;
8597:
8598: p_c_rec_status := 'S';
8599: FOR I in 1..p_tab_uso_ins.LAST LOOP

Line 8606: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8602: p_tab_uso_ins(I).msg_from := fnd_msg_pub.count_msg;
8603: trim_values(p_tab_uso_ins(I));
8604: validate_parameters(p_tab_uso_ins(I));
8605:
8606: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8607: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.status_after_validate_parameters',
8608: 'Unit code:'||p_tab_uso_ins(I).unit_cd||' '||'Version number:'||p_tab_uso_ins(I).version_number||' '||
8609: 'teach_cal_alternate_code:'||p_tab_uso_ins(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_uso_ins(I).location_cd
8610: ||' '||'Unit Class:'||p_tab_uso_ins(I).unit_class||' '||'instructor_person_number:'||p_tab_uso_ins(I).instructor_person_number

Line 8607: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.status_after_validate_parameters',

8603: trim_values(p_tab_uso_ins(I));
8604: validate_parameters(p_tab_uso_ins(I));
8605:
8606: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8607: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.status_after_validate_parameters',
8608: 'Unit code:'||p_tab_uso_ins(I).unit_cd||' '||'Version number:'||p_tab_uso_ins(I).version_number||' '||
8609: 'teach_cal_alternate_code:'||p_tab_uso_ins(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_uso_ins(I).location_cd
8610: ||' '||'Unit Class:'||p_tab_uso_ins(I).unit_class||' '||'instructor_person_number:'||p_tab_uso_ins(I).instructor_person_number
8611: ||' '||'occurrence_identifier'||p_tab_uso_ins(I).occurrence_identifier

Line 8618: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8614:
8615: IF p_tab_uso_ins(I).status = 'S' THEN
8616: validate_derivation(p_tab_uso_ins(I));
8617:
8618: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8619: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.status_after_validate_derivation',
8620: 'Unit code:'||p_tab_uso_ins(I).unit_cd||' '||'Version number:'||p_tab_uso_ins(I).version_number||' '||
8621: 'teach_cal_alternate_code:'||p_tab_uso_ins(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_uso_ins(I).location_cd
8622: ||' '||'Unit Class:'||p_tab_uso_ins(I).unit_class||' '||'instructor_person_number:'||p_tab_uso_ins(I).instructor_person_number

Line 8619: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.status_after_validate_derivation',

8615: IF p_tab_uso_ins(I).status = 'S' THEN
8616: validate_derivation(p_tab_uso_ins(I));
8617:
8618: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8619: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.status_after_validate_derivation',
8620: 'Unit code:'||p_tab_uso_ins(I).unit_cd||' '||'Version number:'||p_tab_uso_ins(I).version_number||' '||
8621: 'teach_cal_alternate_code:'||p_tab_uso_ins(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_uso_ins(I).location_cd
8622: ||' '||'Unit Class:'||p_tab_uso_ins(I).unit_class||' '||'instructor_person_number:'||p_tab_uso_ins(I).instructor_person_number
8623: ||' '||'occurrence_identifier'||p_tab_uso_ins(I).occurrence_identifier

Line 8631: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8627: END IF;
8628:
8629: IF p_tab_uso_ins(I).status = 'S' THEN
8630: validate_db_cons ( p_tab_uso_ins(I) );
8631: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8632: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.status_after_validate_db_cons',
8633: 'Unit code:'||p_tab_uso_ins(I).unit_cd||' '||'Version number:'||p_tab_uso_ins(I).version_number||' '||
8634: 'teach_cal_alternate_code:'||p_tab_uso_ins(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_uso_ins(I).location_cd
8635: ||' '||'Unit Class:'||p_tab_uso_ins(I).unit_class||' '||'instructor_person_number:'||p_tab_uso_ins(I).instructor_person_number

Line 8632: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.status_after_validate_db_cons',

8628:
8629: IF p_tab_uso_ins(I).status = 'S' THEN
8630: validate_db_cons ( p_tab_uso_ins(I) );
8631: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8632: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.status_after_validate_db_cons',
8633: 'Unit code:'||p_tab_uso_ins(I).unit_cd||' '||'Version number:'||p_tab_uso_ins(I).version_number||' '||
8634: 'teach_cal_alternate_code:'||p_tab_uso_ins(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_uso_ins(I).location_cd
8635: ||' '||'Unit Class:'||p_tab_uso_ins(I).unit_class||' '||'instructor_person_number:'||p_tab_uso_ins(I).instructor_person_number
8636: ||' '||'occurrence_identifier'||p_tab_uso_ins(I).occurrence_identifier

Line 8660: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8656: g_n_user_id,
8657: sysdate,
8658: g_n_login_id
8659: );
8660: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8661: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.record_inserted',
8662: 'Unit code:'||p_tab_uso_ins(I).unit_cd||' '||'Version number:'||p_tab_uso_ins(I).version_number||' '||
8663: 'teach_cal_alternate_code:'||p_tab_uso_ins(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_uso_ins(I).location_cd
8664: ||' '||'Unit Class:'||p_tab_uso_ins(I).unit_class||' '||'instructor_person_number:'||p_tab_uso_ins(I).instructor_person_number

Line 8661: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.record_inserted',

8657: sysdate,
8658: g_n_login_id
8659: );
8660: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8661: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.record_inserted',
8662: 'Unit code:'||p_tab_uso_ins(I).unit_cd||' '||'Version number:'||p_tab_uso_ins(I).version_number||' '||
8663: 'teach_cal_alternate_code:'||p_tab_uso_ins(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_uso_ins(I).location_cd
8664: ||' '||'Unit Class:'||p_tab_uso_ins(I).unit_class||' '||'instructor_person_number:'||p_tab_uso_ins(I).instructor_person_number
8665: ||' '||'occurrence_identifier'||p_tab_uso_ins(I).occurrence_identifier

Line 8672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

8668: END IF;
8669:
8670: IF p_tab_uso_ins(I).status = 'S' THEN
8671: igs_ps_validate_lgcy_pkg.post_uso_ins(l_n_ins_id, l_n_uoo_id, p_tab_uso_ins(I),I);
8672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8673: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.status_after_post_uso_ins',
8674: 'Unit code:'||p_tab_uso_ins(I).unit_cd||' '||'Version number:'||p_tab_uso_ins(I).version_number||' '||
8675: 'teach_cal_alternate_code:'||p_tab_uso_ins(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_uso_ins(I).location_cd
8676: ||' '||'Unit Class:'||p_tab_uso_ins(I).unit_class||' '||'instructor_person_number:'||p_tab_uso_ins(I).instructor_person_number

Line 8673: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.status_after_post_uso_ins',

8669:
8670: IF p_tab_uso_ins(I).status = 'S' THEN
8671: igs_ps_validate_lgcy_pkg.post_uso_ins(l_n_ins_id, l_n_uoo_id, p_tab_uso_ins(I),I);
8672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
8673: fnd_log.string( fnd_log.level_statement, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.status_after_post_uso_ins',
8674: 'Unit code:'||p_tab_uso_ins(I).unit_cd||' '||'Version number:'||p_tab_uso_ins(I).version_number||' '||
8675: 'teach_cal_alternate_code:'||p_tab_uso_ins(I).teach_cal_alternate_code||' '||'Location_cd:'||p_tab_uso_ins(I).location_cd
8676: ||' '||'Unit Class:'||p_tab_uso_ins(I).unit_class||' '||'instructor_person_number:'||p_tab_uso_ins(I).instructor_person_number
8677: ||' '||'occurrence_identifier'||p_tab_uso_ins(I).occurrence_identifier

Line 8710: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

8706: IF NOT igs_ps_validate_lgcy_pkg.post_uso_ins_busi(p_tab_uso_ins) THEN
8707: p_c_rec_status := 'E';
8708: END IF;
8709:
8710: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
8711: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.after_import_status',p_c_rec_status);
8712: END IF;
8713:
8714: l_tbl_uso.DELETE;

Line 8711: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.after_import_status',p_c_rec_status);

8707: p_c_rec_status := 'E';
8708: END IF;
8709:
8710: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
8711: fnd_log.string( fnd_log.level_procedure, 'igs.plsql.igs_ps_unit_lgcy_pkg.create_uso_ins.after_import_status',p_c_rec_status);
8712: END IF;
8713:
8714: l_tbl_uso.DELETE;
8715: