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_SV_BATCH_PROCESS_PKG dependencies on IGS_SV_BATCH_PROCESS_PKG

Line 1: PACKAGE BODY IGS_SV_BATCH_PROCESS_PKG AS

1: PACKAGE BODY IGS_SV_BATCH_PROCESS_PKG AS
2: /* $Header: IGSSV01B.pls 120.25 2006/07/28 14:31:42 prbhardw noship $ */
3:
4: /******************************************************************
5:

Line 41: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGS_SV_BATCH_PROCESS_PKG';

37: SEVIS_PRIMARY_FOREIGN - SEVIS Primary Foreign Address/SEVIS Primary Address outside of United States
38: SEVIS_SITE_OF_ACTIVITY - SEVIS Site of Activity/SEVIS Site of Activity
39: ***********************************************************************************/
40:
41: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGS_SV_BATCH_PROCESS_PKG';
42: g_us_addr_usage CONSTANT VARCHAR2(30) := 'SEVIS_PRIMARY_US';
43: g_f_addr_usage CONSTANT VARCHAR2(30) := 'SEVIS_PRIMARY_FOREIGN';
44: g_site_addr_usage CONSTANT VARCHAR2(30) := 'SEVIS_SITE_OF_ACTIVITY';
45: g_school_sevis_id CONSTANT VARCHAR2(30) := 'SV_SCH_CD';

Line 58: l_prog_label CONSTANT VARCHAR2(500) :='igs.plsql.igs_sv_batch_process_pkg';

54: g_create_count NUMBER(15) := 0; -- prbhardw CP enhancement
55: g_update_count NUMBER(15) := 0; -- prbhardw CP enhancement
56: g_running_create_batch NUMBER(15); -- prbhardw CP enhancement
57: g_running_update_batch NUMBER(15); -- prbhardw CP enhancement
58: l_prog_label CONSTANT VARCHAR2(500) :='igs.plsql.igs_sv_batch_process_pkg';
59: l_label VARCHAR2(4000);
60: l_debug_str VARCHAR2(32000);
61: g_person_status VARCHAR2(6) := 'NEW';
62: g_legal_status VARCHAR2(6) := 'NEW';

Line 200: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Submit_Event';

196: l_con_req_id NUMBER;
197: BEGIN
198: /* Debug */
199: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
200: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Submit_Event';
201: l_debug_str := 'Entering Submit_Event. p_batch_type is ' || p_batch_type || 'and p_batch_id is ' || p_batch_id;
202: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
203: END IF;
204:

Line 227: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Submit_Event';

223:
224: IF l_party_id IS NULL THEN
225: /* Debug */
226: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
227: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Submit_Event';
228: l_debug_str := 'IGS_SV_PRTNR_STP_ERR error in Submit_Event.';
229: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
230: END IF;
231:

Line 245: l_label := 'igs.plsql.igs_sv_batch_process_pkg.event_parameters';

241:
242: l_event_key := p_batch_id || l_con_req_id;
243:
244: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
245: l_label := 'igs.plsql.igs_sv_batch_process_pkg.event_parameters';
246: l_debug_str := 'batch_id= '|| p_batch_id || 'l_party_id= '|| l_party_id || ' l_party_site_id='||l_party_site_id || 'l_trans_type= ' || l_trans_type || ' l_trans_subtype= ' || l_trans_subtype || ' l_debug_level = ' || l_debug_level ;
247: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
248: END IF;
249: /* Manoj

Line 281: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Submit_Event';

277: l_parameter_list.DELETE;
278:
279: /* Debug */
280: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
281: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Submit_Event';
282: l_debug_str := 'Exiting Submit_Event. l_event_key: '||l_event_key;
283: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
284: END IF;
285:

Line 309: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Dump_Current_Person';

305:
306: BEGIN
307: /* Debug */
308: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
309: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Dump_Current_Person';
310: l_debug_str := 'Entering Dump_Current_Person. p_student_rec.person_id is '|| p_student_rec.person_id;
311: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
312: END IF;
313:

Line 340: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Dump_Current_Person';

336:
337: Put_Log_Msg('********************************************************',1);
338: /* Debug */
339: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
340: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Dump_Current_Person';
341: l_debug_str := 'Exiting Dump_Current_Person.';
342: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
343: END IF;
344: END Dump_Current_Person;

Line 395: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_School_Sevis_Id';

391:
392: BEGIN
393: /* Debug
394: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
395: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_School_Sevis_Id';
396: l_debug_str := 'Entering Get_School_Sevis_Id. p_batch_type is '|| p_batch_type;
397: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
398: END IF;
399:

Line 408: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_School_Sevis_Id';

404: CLOSE c_alt_id;
405:
406: /* Debug
407: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
408: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_School_Sevis_Id';
409: l_debug_str := 'Exiting Get_School_Sevis_Id with return value '|| l_alt_id;
410: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
411: END IF;
412:

Line 494: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Is_Number';

490:
491: BEGIN
492: /* Debug */
493: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
494: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Is_Number';
495: l_debug_str := 'Entering Is_Number. p_num is '|| p_num;
496: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
497: END IF;
498: Put_Log_Msg('Is_Number begins',0);

Line 507: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Is_Number';

503:
504: WHEN VALUE_ERROR THEN
505: /* Debug */
506: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
507: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Is_Number';
508: l_debug_str := 'Exception in Is_Number'||SQLERRM;
509: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
510: END IF;
511:

Line 549: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Lookup_Name';

545:
546: BEGIN
547: /* Debug */
548: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
549: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Lookup_Name';
550: l_debug_str := 'Entering Get_Lookup_Name. p_type is '||p_type ||' and p_code is '|| p_code;
551: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
552: END IF;
553:

Line 560: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Lookup_Name';

556: CLOSE c_blk_name;
557:
558: /* Debug */
559: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
560: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Lookup_Name';
561: l_debug_str := 'Returning from Get_Lookup_Name with value '||l_block_name;
562: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
563: END IF;
564:

Line 608: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Convert_Country_Code';

604:
605: BEGIN
606: /* Debug */
607: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
608: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Convert_Country_Code';
609: l_debug_str := 'Entering Convert_Country_Code. p_code is '||p_code;
610: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
611: END IF;
612: --Code for non-ISO countries

Line 652: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Convert_Country_Code';

648: END IF;
649:
650: /* Debug */
651: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
652: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Convert_Country_Code';
653: l_debug_str := 'Returning from Convert_Country_Code with value '|| l_block_name;
654: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
655: END IF;
656:

Line 700: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Convert_Visa_Type';

696:
697: BEGIN
698: /* Debug */
699: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
700: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Convert_Visa_Type';
701: l_debug_str := 'Entering Convert_Visa_Type. p_visa_meaning is '||p_visa_meaning;
702: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
703: END IF;
704:

Line 713: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Convert_Visa_Type';

709:
710: CLOSE c_visa_type;
711: /* Debug */
712: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
713: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Convert_Visa_Type';
714: l_debug_str := 'Returning from Convert_Visa_Type with value '|| l_sv_visa_code;
715: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
716: END IF;
717:

Line 757: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Convert_Suffix';

753:
754: BEGIN
755: /* Debug */
756: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
757: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Convert_Suffix';
758: l_debug_str := 'Entering Convert_Suffix. p_person_num is '||p_person_num || ', p_code is '||p_code||' and p_type is '||p_type;
759: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
760: END IF;
761:

Line 780: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Convert_Suffix';

776: CLOSE c_name_suffix;
777:
778: /* Debug */
779: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
780: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Convert_Suffix';
781: l_debug_str := 'Returning from Convert_Suffix with value '|| l_name_suffix;
782: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
783: END IF;
784:

Line 810: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Block_Name';

806:
807: BEGIN
808: /* Debug */
809: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
810: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Block_Name';
811: l_debug_str := 'Inside Get_Block_Name. p_block is '||p_block;
812: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
813: END IF;
814:

Line 853: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Person_Sevis_Id';

849:
850: BEGIN
851: /* Debug */
852: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
853: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Person_Sevis_Id';
854: l_debug_str := 'Entering Get_Person_Sevis_Id. p_person_id is '||p_person_id;
855: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
856: END IF;
857:

Line 867: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Person_Sevis_Id';

863: IF l_alt_id IS NOT NULL AND LENGTH(l_alt_id)<=11 THEN
864:
865: /* Debug */
866: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
867: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Person_Sevis_Id';
868: l_debug_str := 'Returning from Get_Person_Sevis_Id with value '||l_alt_id;
869: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
870: END IF;
871:

Line 877: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Person_Sevis_Id';

873:
874: END IF;
875: /* Debug */
876: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
877: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Person_Sevis_Id';
878: l_debug_str := 'Returning from Get_Person_Sevis_Id ';
879: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
880: END IF;
881:

Line 908: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Check_US_Terr';

904:
905: BEGIN
906: /* Debug */
907: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
908: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Check_US_Terr';
909: l_debug_str := 'Entering Check_US_Terr. p_person_num is '||p_person_num ||' and p_code is '||p_code;
910: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
911: END IF;
912:

Line 927: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Check_US_Terr';

923:
924: CLOSE c_name;
925: /* Debug */
926: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
927: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Check_US_Terr';
928: l_debug_str := 'Returning E from Check_US_Terr ';
929: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
930: END IF;
931:

Line 940: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Check_US_Terr';

936: CLOSE c_name;
937:
938: /* Debug */
939: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
940: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Check_US_Terr';
941: l_debug_str := 'Returning S from Check_US_Terr ';
942: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
943: END IF;
944:

Line 980: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Prev_Dep';

976: l_count NUMBER := 0;
977: BEGIN
978: /* Debug */
979: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
980: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Prev_Dep';
981: l_debug_str := 'Entering Get_Prev_Dep. p_person_id is '||p_person_id||' dependent id is'||p_depdnt_id;
982: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
983: END IF;
984:

Line 1071: l_label := 'igs.plsql.igs_sv_batch_process_pkg.is_valid_addr';

1067:
1068: BEGIN
1069: /* Debug */
1070: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1071: l_label := 'igs.plsql.igs_sv_batch_process_pkg.is_valid_addr';
1072: l_debug_str := 'Entering is_valid_addr. person id: '||p_person_id ||'site id: '|| p_site_id;
1073: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1074: END IF;
1075: Put_Log_Msg('is_valid_addr begins',0);

Line 1119: l_label := 'igs.plsql.igs_sv_batch_process_pkg.is_valid_addr';

1115:
1116: WHEN OTHERS THEN
1117: /* Debug */
1118: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1119: l_label := 'igs.plsql.igs_sv_batch_process_pkg.is_valid_addr';
1120: l_debug_str := 'Exception in is_valid_addr'||SQLERRM;
1121: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1122: END IF;
1123:

Line 1201: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';

1197: BEGIN
1198:
1199: /* Debug */
1200: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1201: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';
1202: l_debug_str := 'Entering Validate_Issue_Info. p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
1203: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1204: END IF;
1205:

Line 1240: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';

1236: p_data_rec.adjudicated_flag := c_data_rec.adjudicated_flag;
1237:
1238: /* Debug */
1239: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1240: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';
1241: l_debug_str := 'Exiting from for loop of Validate_Issue_Info';
1242: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1243: END IF;
1244:

Line 1280: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';

1276: p_data_rec.no_show_flag := c_data_rec.no_show_flag;
1277:
1278: /* Debug */
1279: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1280: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';
1281: l_debug_str := 'Exiting from for loop of Validate_Issue_Info';
1282: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1283: END IF;
1284: EXIT; -- one record is enough

Line 1297: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';

1293:
1294: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
1295: /* Debug */
1296: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1297: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';
1298: l_debug_str := 'Returning N from Validate_Issue_Info';
1299: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1300: END IF;
1301:

Line 1392: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';

1388:
1389: Put_Log_Msg(l_api_name||' Validation error, return E ',1);
1390: /* Debug */
1391: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1392: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';
1393: l_debug_str := 'Returning E from Validate_Issue_Info';
1394: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1395: END IF;
1396:

Line 1406: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';

1402:
1403: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
1404: /* Debug */
1405: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1406: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';
1407: l_debug_str := 'Returning S from Validate_Issue_Info';
1408: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1409: END IF;
1410:

Line 1418: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';

1414:
1415: WHEN OTHERS THEN
1416: /* Debug */
1417: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1418: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Issue_Info';
1419: l_debug_str := 'Exception in Validate_Issue_Info'||SQLERRM;
1420: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1421: END IF;
1422:

Line 1463: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Name';

1459: returnVal boolean := false;
1460: BEGIN
1461: /* Debug */
1462: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1463: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Name';
1464: l_debug_str := 'Inside Validate_Name. p_Name is '|| p_Name;
1465: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1466: END IF;
1467:

Line 1476: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Name';

1472: END IF;
1473: END LOOP;
1474: /* Debug */
1475: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1476: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Name';
1477: l_debug_str := 'Returning from Validate_Name';
1478: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1479: END IF;
1480:

Line 1570: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Bio_Info';

1566: -- 05 M-2
1567: -- 06 J-2
1568: /* Debug */
1569: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1570: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Bio_Info';
1571: l_debug_str := 'Inside Validate_Bio_Info. p_person_rec.batch_type is '|| p_person_rec.batch_type ||' and person_id is '|| p_person_rec.person_id;
1572: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1573: END IF;
1574:

Line 1694: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Bio_Info';

1690:
1691: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
1692: /* Debug */
1693: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1694: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Bio_Info';
1695: l_debug_str := 'Returning N from Validate_Bio_Info.';
1696: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1697: END IF;
1698:

Line 1787: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Bio_Info';

1783:
1784: Put_Log_Msg(l_api_name||' Validation error, return E ',1);
1785: /* Debug */
1786: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1787: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Bio_Info';
1788: l_debug_str := 'Returning E from Validate_Bio_Info.';
1789: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1790: END IF;
1791: RETURN 'E';

Line 1800: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Bio_Info';

1796:
1797: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
1798: /* Debug */
1799: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1800: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Bio_Info';
1801: l_debug_str := 'Returning S from Validate_Bio_Info.';
1802: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1803: END IF;
1804:

Line 1812: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Bio_Info';

1808:
1809: WHEN OTHERS THEN
1810: /* Debug */
1811: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1812: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Bio_Info';
1813: l_debug_str := 'Exception in Validate_Bio_Info.'||SQLERRM;
1814: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1815: END IF;
1816:

Line 1883: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Other_Info';

1879:
1880: BEGIN
1881: /* Debug */
1882: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1883: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Other_Info';
1884: l_debug_str := 'Entering Validate_Other_Info. Batch_id is '||p_person_rec.batch_id||' and person_id is '||p_person_rec.person_id;
1885: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1886: END IF;
1887: Put_Log_Msg(l_api_name||' starts ',0);

Line 1998: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Other_Info';

1994:
1995: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
1996: /* Debug */
1997: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1998: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Other_Info';
1999: l_debug_str := 'Returning N from Validate_Other_Info.';
2000: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2001: END IF;
2002: RETURN 'N';

Line 2011: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Other_Info';

2007:
2008: Put_Log_Msg(l_api_name||' Validation error, return E ',1);
2009: /* Debug */
2010: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2011: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Other_Info';
2012: l_debug_str := 'Returning E from Validate_Other_Info.';
2013: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2014: END IF;
2015:

Line 2025: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Other_Info';

2021:
2022: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
2023: /* Debug */
2024: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2025: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Other_Info';
2026: l_debug_str := 'Returning S from Validate_Other_Info.';
2027: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2028: END IF;
2029:

Line 2037: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Other_Info';

2033:
2034: WHEN OTHERS THEN
2035: /* Debug */
2036: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2037: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Other_Info';
2038: l_debug_str := 'Exception in Validate_Other_Info.'||SQLERRM;
2039: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2040: END IF;
2041:

Line 2111: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_F_Addr_Info';

2107:
2108: Put_Log_Msg(l_api_name||' Starts ',0);
2109: /* Debug */
2110: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2111: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_F_Addr_Info';
2112: l_debug_str := 'Entering Validate_F_Addr_Info. batch_id is '|| p_person_rec.batch_id||' and person_id is '|| p_person_rec.person_id;
2113: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2114: END IF;
2115:

Line 2144: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_F_Addr_Info';

2140: p_data_rec(l_counter).address_line2 := SUBSTR(c_addr_rec.addr_line_1||c_addr_rec.addr_line_2||c_addr_rec.addr_line_3||c_addr_rec.addr_line_4,61,120);
2141:
2142: /* Debug */
2143: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2144: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_F_Addr_Info';
2145: l_debug_str := 'Exiting from for loop in Validate_F_Addr_Info.';
2146: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2147: END IF;
2148:

Line 2160: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_F_Addr_Info';

2156:
2157: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
2158: /* Debug */
2159: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2160: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_F_Addr_Info';
2161: l_debug_str := 'Returning N from Validate_F_Addr_Info.';
2162: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2163: END IF;
2164: RETURN 'N';

Line 2197: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_F_Addr_Info';

2193:
2194: Put_Log_Msg(l_api_name||' Validation error, return E ',1);
2195: /* Debug */
2196: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2197: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_F_Addr_Info';
2198: l_debug_str := 'Returning E from Validate_F_Addr_Info.';
2199: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2200: END IF;
2201:

Line 2209: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_F_Addr_Info';

2205:
2206: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
2207: /* Debug */
2208: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2209: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_F_Addr_Info';
2210: l_debug_str := 'Returning S from Validate_F_Addr_Info.';
2211: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2212: END IF;
2213:

Line 2221: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_F_Addr_Info';

2217:
2218: WHEN OTHERS THEN
2219: /* Debug */
2220: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2221: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_F_Addr_Info';
2222: l_debug_str := 'Exception in Validate_F_Addr_Info.'||SQLERRM;
2223: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2224: END IF;
2225:

Line 2293: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_US_Addr_Info';

2289:
2290: BEGIN
2291: /* Debug */
2292: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2293: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_US_Addr_Info';
2294: l_debug_str := 'Entering Validate_US_Addr_Info. p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
2295: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2296: END IF;
2297: Put_Log_Msg(l_api_name||' Starts ',0);

Line 2326: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_US_Addr_Info';

2322: p_data_rec(l_counter).last_update_login := g_update_login;
2323:
2324: /* Debug */
2325: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2326: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_US_Addr_Info';
2327: l_debug_str := 'exiting from for loop in Validate_US_Addr_Info.';
2328: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2329: END IF;
2330:

Line 2340: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_US_Addr_Info';

2336:
2337: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
2338: /* Debug */
2339: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2340: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_US_Addr_Info';
2341: l_debug_str := 'Returning N from Validate_US_Addr_Info. ';
2342: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2343: END IF;
2344:

Line 2373: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_US_Addr_Info';

2369:
2370: Put_Log_Msg(l_api_name||' Validation error, return E ',1);
2371: /* Debug */
2372: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2373: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_US_Addr_Info';
2374: l_debug_str := 'Returning E from Validate_US_Addr_Info. ';
2375: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2376: END IF;
2377:

Line 2388: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_US_Addr_Info';

2384:
2385: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
2386: /* Debug */
2387: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2388: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_US_Addr_Info';
2389: l_debug_str := 'Returning S from Validate_US_Addr_Info. ';
2390: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2391: END IF;
2392:

Line 2400: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_US_Addr_Info';

2396:
2397: WHEN OTHERS THEN
2398: /* Debug */
2399: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2400: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_US_Addr_Info';
2401: l_debug_str := 'Exception in Validate_US_Addr_Info. '||SQLERRM;
2402: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2403: END IF;
2404:

Line 2615: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Site_Info';

2611:
2612: BEGIN
2613: /* Debug */
2614: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2615: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Site_Info';
2616: l_debug_str := 'Entering Validate_Site_Info. p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
2617: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2618: END IF;
2619:

Line 2769: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Site_Info';

2765:
2766: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
2767: /* Debug */
2768: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2769: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Site_Info';
2770: l_debug_str := 'Returning N from Validate_Site_Info.';
2771: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2772: END IF;
2773:

Line 2780: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Site_Info';

2776:
2777: Put_Log_Msg(l_api_name||' Validation error, return E ',1);
2778: /* Debug */
2779: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2780: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Site_Info';
2781: l_debug_str := 'Returning E from Validate_Site_Info.';
2782: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2783: END IF;
2784: RETURN 'E';

Line 2793: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Site_Info';

2789:
2790: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
2791: /* Debug */
2792: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2793: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Site_Info';
2794: l_debug_str := 'Returning S from Validate_Site_Info. No of SOA rec: '||l_counter;
2795: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2796: END IF;
2797:

Line 2805: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Site_Info';

2801:
2802: WHEN OTHERS THEN
2803: /* Debug */
2804: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2805: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Site_Info';
2806: l_debug_str := 'Exception in Validate_Site_Info.'||SQLERRM;
2807: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2808: END IF;
2809:

Line 2899: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Edu_Info

2895:
2896: BEGIN
2897: /* Debug */
2898: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2899: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Edu_Info
2900: ';
2901: l_debug_str := 'Entering Validate_Edu_Info. p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
2902: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2903: END IF;

Line 2995: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Edu_Info';

2991:
2992: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
2993: /* Debug */
2994: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2995: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Edu_Info';
2996: l_debug_str := 'Returning N from Validate_Edu_Info.';
2997: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2998: END IF;
2999:

Line 3072: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Edu_Info';

3068:
3069: Put_Log_Msg(l_api_name||' Validation error, return E ',1);
3070: /* Debug */
3071: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3072: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Edu_Info';
3073: l_debug_str := 'Returning E from Validate_Edu_Info.';
3074: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3075: END IF;
3076: RETURN 'E';

Line 3085: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Edu_Info';

3081:
3082: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
3083: /* Debug */
3084: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3085: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Edu_Info';
3086: l_debug_str := 'Returning S from Validate_Edu_Info.';
3087: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3088: END IF;
3089:

Line 3097: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Edu_Info';

3093:
3094: WHEN OTHERS THEN
3095: /* Debug */
3096: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3097: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Edu_Info';
3098: l_debug_str := 'Exception in Validate_Edu_Info.'||SQLERRM;
3099: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3100: END IF;
3101:

Line 3187: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Othr_Prgm_Info';

3183: BEGIN
3184:
3185: /* Debug */
3186: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3187: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Othr_Prgm_Info';
3188: l_debug_str := 'Entering Get_Othr_Prgm_Info. form_id is '||g_nonimg_form_id ||' and person_id is '||p_data_rec.person_id;
3189: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3190: END IF;
3191:

Line 3254: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Othr_Prgm_Info';

3250:
3251: WHEN OTHERS THEN
3252: /* Debug */
3253: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3254: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Othr_Prgm_Info';
3255: l_debug_str := 'Exception in Get_Othr_Prgm_Info.'||SQLERRM;
3256: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3257: END IF;
3258:

Line 3320: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Auth_Code';

3316:
3317: BEGIN
3318: /* Debug */
3319: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3320: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Auth_Code';
3321: l_debug_str := 'Entering Insert_Edu_Info. person_id is '||p_auth_drp_data_rec.person_id|| ' and batch_id is '||p_auth_drp_data_rec.batch_id;
3322: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3323: END IF;
3324:

Line 3332: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Auth_Code';

3328:
3329:
3330: /* Debug */
3331: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3332: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Auth_Code';
3333: l_debug_str := 'After assigning values to local variables';
3334: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3335: END IF;
3336:

Line 3378: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Auth_Code';

3374: l_not_reqd_reason := l_cur_rec.not_reqd_reason;
3375:
3376: /* Debug */
3377: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3378: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Auth_Code';
3379: l_debug_str := 'After assigning values received from get_othr_prgm_info to local variables';
3380: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3381: END IF;
3382: END IF;

Line 3442: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Auth_Code';

3438: '0'
3439: );
3440: /* Debug */
3441: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3442: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Auth_Code';
3443: l_debug_str := 'Record inserted';
3444: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3445: END IF;
3446:

Line 3456: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Auth_Code';

3452: END IF;
3453:
3454: /* Debug */
3455: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3456: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Auth_Code';
3457: l_debug_str := 'EXCEPTION in Insert_Auth_Code. '||SQLERRM;
3458: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3459: END IF;
3460: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 3627: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

3623: BEGIN
3624:
3625: /* Debug */
3626: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3627: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
3628: l_debug_str := 'Entering Validate_Prgm_Info. p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
3629: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3630: END IF;
3631:

Line 3669: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

3665:
3666: Put_Log_Msg('validating Authorization. Values srt. SEVIS auth ID: '||l_sevis_auth_id,0);
3667: /* Debug */
3668: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3669: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
3670: l_debug_str := 'Comparing values for authorization code. p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
3671: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3672: END IF;
3673:

Line 3706: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

3702: CLOSE c_drp;
3703:
3704: /* Debug */
3705: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3706: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
3707: l_debug_str := 'Authorization values set. action type is '||p_auth_drp_data_rec(l_auth_rec_count).prgm_action_type ||' and action code is '||p_auth_drp_data_rec(l_auth_rec_count).auth_action_code;
3708: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3709: END IF;
3710:

Line 3731: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

3727: Put_Log_Msg(FND_MESSAGE.Get,1);
3728: l_not_valid := TRUE;
3729: /* Debug */
3730: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3731: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
3732: l_debug_str := 'Validation failure for Authorization. Error: Invalid authorization drop below for F-1 visa';
3733: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3734: END IF;
3735: ELSIF ADD_MONTHS(l_auth_end_dt,-5) > l_auth_start_dt AND l_visa_type = 'M-1' THEN

Line 3744: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

3740: Put_Log_Msg(FND_MESSAGE.Get,1);
3741: l_not_valid := TRUE;
3742: /* Debug */
3743: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3744: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
3745: l_debug_str := 'Validation failure for Authorization. Error: Invalid authorization drop below for M-1 visa';
3746: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3747: END IF;
3748: END IF;

Line 3760: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

3756: Put_Log_Msg(FND_MESSAGE.Get,1);
3757: l_not_valid := TRUE;
3758: /* Debug */
3759: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3760: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
3761: l_debug_str := 'Validation failure for Authorization. Error: Invalid authorization start date';
3762: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3763: END IF;
3764: END IF;

Line 3772: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

3768: Put_Log_Msg(FND_MESSAGE.Get,1);
3769: l_not_valid := TRUE;
3770: /* Debug */
3771: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3772: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
3773: l_debug_str := 'Validation failure for Authorization. Error: Invalid authorization end date';
3774: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3775: END IF;
3776: END IF;

Line 3785: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

3781: Put_Log_Msg('validating Authorization. l_not_valid is true',0);
3782: Put_Log_Msg(l_api_name||' Validation error, return E ',1);
3783: /* Debug */
3784: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3785: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
3786: l_debug_str := 'Returning E from Validate_Prgm_Info. Authorization code failed to validate.';
3787: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3788: END IF;
3789:

Line 3865: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

3861:
3862:
3863: /* Debug */
3864: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3865: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
3866: l_debug_str := 'Exiting from for loop in Validate_Prgm_Info.';
3867: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3868: END IF;
3869:

Line 3953: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

3949: IF l_not_valid THEN
3950: Put_Log_Msg(l_api_name||' Validation error, return E ',1);
3951: /* Debug */
3952: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3953: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
3954: l_debug_str := 'Returning E from Validate_Prgm_Info.';
3955: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3956: END IF;
3957:

Line 3988: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

3984: p_data_rec(l_counter).end_prgm_reason := c_data_rec.end_program_reason ;
3985: p_data_rec(l_counter).remarks := c_data_rec.remarks ;
3986: /* Debug */
3987: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3988: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
3989: l_debug_str := 'Exiting from for loop in Validate_Prgm_Info.';
3990: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3991: END IF;
3992:

Line 4094: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

4090: IF l_not_valid THEN
4091: Put_Log_Msg(l_api_name||' Validation error, return E ',1);
4092: /* Debug */
4093: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4094: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
4095: l_debug_str := 'Returning E from Validate_Prgm_Info.';
4096: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4097: END IF;
4098:

Line 4111: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

4107: IF l_counter = 0 AND l_auth_rec_count = 0 THEN
4108: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
4109: /* Debug */
4110: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4111: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
4112: l_debug_str := 'Returning N from validate_empl_Info.';
4113: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4114: END IF;
4115: RETURN 'N';

Line 4122: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

4118:
4119: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
4120: /* Debug */
4121: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4122: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
4123: l_debug_str := 'Returning S from Validate_Prgm_Info.';
4124: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4125: END IF;
4126:

Line 4134: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';

4130:
4131: WHEN OTHERS THEN
4132: /* Debug */
4133: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4134: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Prgm_Info';
4135: l_debug_str := 'Exception in Validate_Prgm_Info.'||SQLERRM;
4136: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4137: END IF;
4138:

Line 4259: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Finance_Info';

4255:
4256: Put_Log_Msg(l_api_name||' starts ',0);
4257: /* Debug */
4258: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4259: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Finance_Info';
4260: l_debug_str := 'Entering Validate_Finance_Info. p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
4261: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4262: END IF;
4263:

Line 4389: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Finance_Info';

4385:
4386: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
4387: /* Debug */
4388: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4389: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Finance_Info';
4390: l_debug_str := 'Returning N from Validate_Finance_Info.';
4391: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4392: END IF;
4393:

Line 4476: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Finance_Info';

4472:
4473: Put_Log_Msg(l_api_name||' Validation error, return E ',1);
4474: /* Debug */
4475: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4476: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Finance_Info';
4477: l_debug_str := 'Returning E from Validate_Finance_Info.';
4478: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4479: END IF;
4480:

Line 4491: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Finance_Info';

4487:
4488: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
4489: /* Debug */
4490: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4491: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Finance_Info';
4492: l_debug_str := 'Returning S from Validate_Finance_Info.';
4493: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4494: END IF;
4495:

Line 4504: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Finance_Info';

4500:
4501: WHEN OTHERS THEN
4502: /* Debug */
4503: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4504: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Finance_Info';
4505: l_debug_str := 'Exception in Validate_Finance_Info. '||SQLERRM;
4506: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4507: END IF;
4508:

Line 4619: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';

4615:
4616: Put_Log_Msg(l_api_name||' starts ',0);
4617: /* Debug */
4618: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4619: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';
4620: l_debug_str := 'Entering Validate_Dependent_Info. p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
4621: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4622: END IF;
4623:

Line 4693: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';

4689:
4690: Put_Log_Msg('Validation error occurs ',1);
4691: /* Debug */
4692: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4693: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';
4694: l_debug_str := 'Returning E from Validate_Dependent_Info.';
4695: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4696: END IF;
4697:

Line 4705: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';

4701:
4702: Put_Log_Msg('Dependent not found by Validate procedure ',0);
4703: /* Debug */
4704: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4705: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';
4706: l_debug_str := 'IGS_SV_UNEXP_EXCPT_ERR Error in Validate_Dependent_Info.';
4707: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4708: END IF;
4709:

Line 4740: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';

4736: IF p_person_rec.record_status = 'C' THEN
4737:
4738: /* Debug */
4739: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4740: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';
4741: l_debug_str := 'Exiting from for loop in Validate_Dependent_Info.';
4742: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4743: END IF;
4744:

Line 4757: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';

4753:
4754: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
4755: /* Debug */
4756: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4757: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';
4758: l_debug_str := 'Returning N from Validate_Dependent_Info.';
4759: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4760: END IF;
4761:

Line 4771: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';

4767:
4768: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
4769: /* Debug */
4770: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4771: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';
4772: l_debug_str := 'Returning S from Validate_Dependent_Info.';
4773: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4774: END IF;
4775:

Line 4783: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';

4779:
4780: WHEN OTHERS THEN
4781: /* Debug */
4782: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4783: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Dependent_Info';
4784: l_debug_str := 'Exception in Validate_Dependent_Info. '||SQLERRM;
4785: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4786: END IF;
4787:

Line 4851: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Convictions_Info';

4847: l_not_valid BOOLEAN := FALSE;
4848: BEGIN
4849: /* Debug */
4850: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4851: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Convictions_Info';
4852: l_debug_str := 'Entering Validate_Convictions_Info. p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
4853: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4854: END IF;
4855:

Line 4887: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Convictions_Info';

4883:
4884: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
4885: /* Debug */
4886: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4887: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Convictions_Info';
4888: l_debug_str := 'Returning N from Validate_Convictions_Info';
4889: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4890: END IF;
4891:

Line 4904: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Convictions_Info';

4900:
4901: Put_Log_Msg(l_api_name||' Validation error, return E ',0);
4902: /* Debug */
4903: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4904: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Convictions_Info';
4905: l_debug_str := 'Returning E from Validate_Convictions_Info';
4906: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4907: END IF;
4908:

Line 4916: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Convictions_Info';

4912:
4913: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
4914: /* Debug */
4915: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4916: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Convictions_Info';
4917: l_debug_str := 'Returning S from Validate_Convictions_Info';
4918: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4919: END IF;
4920:

Line 4928: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Convictions_Info';

4924:
4925: WHEN OTHERS THEN
4926: /* Debug */
4927: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4928: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Convictions_Info';
4929: l_debug_str := 'Exception in Validate_Convictions_Info '||SQLERRM;
4930: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4931: END IF;
4932:

Line 5011: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Legal_Info';

5007:
5008: BEGIN
5009: /* Debug */
5010: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5011: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Legal_Info';
5012: l_debug_str := 'Entering Validate_Legal_Info. p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
5013: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5014: END IF;
5015:

Line 5076: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Legal_Info';

5072:
5073: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
5074: /* Debug */
5075: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5076: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Legal_Info';
5077: l_debug_str := 'Returning N from Validate_Legal_Info.';
5078: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5079: END IF;
5080: RETURN 'N';

Line 5087: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Legal_Info';

5083:
5084: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
5085: /* Debug */
5086: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5087: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Legal_Info';
5088: l_debug_str := 'Returning S from Validate_Legal_Info.';
5089: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5090: END IF;
5091: RETURN 'S'; -- Successfull validation

Line 5098: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Legal_Info';

5094:
5095: WHEN OTHERS THEN
5096: /* Debug */
5097: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5098: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Legal_Info';
5099: l_debug_str := 'Exception in Validate_Legal_Info. '||SQLERRM;
5100: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5101: END IF;
5102:

Line 5161: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_ev_Legal_Info';

5157:
5158: BEGIN
5159: /* Debug */
5160: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5161: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_ev_Legal_Info';
5162: l_debug_str := 'Entering Validate_ev_Legal_Info. p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
5163: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5164: END IF;
5165:

Line 5222: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_ev_Legal_Info';

5218:
5219: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
5220: /* Debug */
5221: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5222: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_ev_Legal_Info';
5223: l_debug_str := 'Returning N from Validate_ev_Legal_Info.';
5224: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5225: END IF;
5226: RETURN 'N';

Line 5233: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_ev_Legal_Info';

5229:
5230: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
5231: /* Debug */
5232: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5233: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_ev_Legal_Info';
5234: l_debug_str := 'Returning S from Validate_ev_Legal_Info.';
5235: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5236: END IF;
5237: RETURN 'S'; -- Successfull validation

Line 5244: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_ev_Legal_Info';

5240:
5241: WHEN OTHERS THEN
5242: /* Debug */
5243: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5244: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_ev_Legal_Info';
5245: l_debug_str := 'Exception in Validate_ev_Legal_Info. '||SQLERRM;
5246: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5247: END IF;
5248:

Line 5298: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Empl_Info';

5294:
5295: BEGIN
5296: /* Debug */
5297: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5298: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Empl_Info';
5299: l_debug_str := 'Entering Get_Empl_Info. p_data_rec.person_id is '||p_data_rec.person_id;
5300: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5301: END IF;
5302:

Line 5326: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Empl_Info';

5322: Put_Log_Msg('Record not found ',0);
5323: CLOSE c_data_rec;
5324: /* Debug */
5325: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5326: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Empl_Info';
5327: l_debug_str := 'Returning N from Get_Empl_Info';
5328: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5329: END IF;
5330: RETURN 'N';

Line 5339: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Empl_Info';

5335:
5336: Put_Log_Msg(l_api_name||' ends S ',0);
5337: /* Debug */
5338: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5339: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Empl_Info';
5340: l_debug_str := 'Returning S from Get_Empl_Info';
5341: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5342: END IF;
5343: RETURN 'S';

Line 5350: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Empl_Info';

5346:
5347: WHEN FND_API.G_EXC_ERROR THEN
5348: /* Debug */
5349: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5350: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Empl_Info';
5351: l_debug_str := 'Exception in Get_Empl_Info '||SQLERRM;
5352: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5353: END IF;
5354:

Line 5361: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Empl_Info';

5357:
5358: WHEN OTHERS THEN
5359: /* Debug */
5360: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5361: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Empl_Info';
5362: l_debug_str := 'Exception in Get_Empl_Info '||SQLERRM;
5363: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5364: END IF;
5365: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

Line 5413: l_label := 'igs.plsql.igs_sv_batch_process_pkg.validate_employment_Info';

5409:
5410: BEGIN
5411: /* Debug */
5412: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5413: l_label := 'igs.plsql.igs_sv_batch_process_pkg.validate_employment_Info';
5414: l_debug_str := 'Entering validate_employment_Info. p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
5415: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5416: END IF;
5417:

Line 5494: l_label := 'igs.plsql.igs_sv_batch_process_pkg.validate_employment_Info';

5490:
5491: END IF;
5492: /* Debug */
5493: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5494: l_label := 'igs.plsql.igs_sv_batch_process_pkg.validate_employment_Info';
5495: l_debug_str := 'Returning from validate_employment_Info';
5496: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5497: END IF;
5498:

Line 5566: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Empl_Info';

5562: BEGIN
5563:
5564: /* Debug */
5565: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5566: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Empl_Info';
5567: l_debug_str := 'Entering validate_empl_Info p_person_rec.batch_id is '||p_person_rec.batch_id ||' and person_id is '||p_person_rec.person_id;
5568: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5569: END IF;
5570:

Line 5600: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Empl_Info';

5596: p_data_rec(l_counter).action_code := c_data_rec.action_code;
5597:
5598: /* Debug */
5599: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5600: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Empl_Info';
5601: l_debug_str := 'Remarks: '||p_data_rec(l_counter).remarks||' Empl Type: '||p_data_rec(l_counter).empl_rec_type;
5602: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5603: END IF;
5604:

Line 5631: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Empl_Info';

5627: IF l_not_valid THEN
5628: Put_Log_Msg(l_api_name||' Validation error, return E ',1);
5629: /* Debug */
5630: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5631: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Empl_Info';
5632: l_debug_str := 'Returning E from validate_empl_Info.';
5633: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5634: END IF;
5635: RETURN 'E';

Line 5644: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Empl_Info';

5640: IF l_counter = 0 THEN
5641: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
5642: /* Debug */
5643: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5644: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Empl_Info';
5645: l_debug_str := 'Returning N from validate_empl_Info.';
5646: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5647: END IF;
5648: RETURN 'N';

Line 5656: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Empl_Info';

5652:
5653: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
5654: /* Debug */
5655: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5656: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Empl_Info';
5657: l_debug_str := 'Returning S from validate_empl_Info.';
5658: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5659: END IF;
5660: RETURN 'S'; -- Successfull validation

Line 5666: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Empl_Info';

5662:
5663: WHEN OTHERS THEN
5664: /* Debug */
5665: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5666: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Validate_Empl_Info';
5667: l_debug_str := 'Exception in validate_empl_Info. '||SQLERRM;
5668: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5669: END IF;
5670:

Line 5731: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Issue_Info';

5727:
5728: BEGIN
5729: /* Debug */
5730: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5731: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Issue_Info';
5732: l_debug_str := 'Entering Get_Issue_Info. p_data_rec.person_id is '||p_data_rec.person_id;
5733: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5734: END IF;
5735:

Line 5764: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Issue_Info';

5760: Put_Log_Msg('Record not found ',0);
5761: CLOSE c_data_rec;
5762: /* Debug */
5763: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5764: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Issue_Info';
5765: l_debug_str := 'Returning N from Get_Issue_Info.';
5766: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5767: END IF;
5768: RETURN 'N';

Line 5777: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Issue_Info';

5773:
5774: Put_Log_Msg(l_api_name||' ends S ',0);
5775: /* Debug */
5776: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5777: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Issue_Info';
5778: l_debug_str := 'Returning S from Get_Issue_Info.';
5779: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5780: END IF;
5781: RETURN 'S';

Line 5790: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Issue_Info';

5786:
5787: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
5788: /* Debug */
5789: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5790: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Issue_Info';
5791: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Issue_Info. '||SQLERRM;
5792: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5793: END IF;
5794:

Line 5804: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Issue_Info';

5800: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5801: END IF;
5802: /* Debug */
5803: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5804: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Issue_Info';
5805: l_debug_str := 'Exception in Get_Issue_Info. '||SQLERRM;
5806: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5807: END IF;
5808:

Line 5869: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';

5865:
5866: BEGIN
5867: /* Debug */
5868: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5869: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';
5870: l_debug_str := 'Entering Get_Bio_Info. p_data_rec.person_id is '||p_data_rec.person_id;
5871: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5872: END IF;
5873:

Line 5899: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';

5895: Put_Log_Msg('Record not found ',0);
5896: CLOSE c_data_rec;
5897: /* Debug */
5898: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5899: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';
5900: l_debug_str := 'Returning N from Get_Bio_Info.';
5901: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5902: END IF;
5903: RETURN 'N';

Line 5912: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';

5908:
5909: Put_Log_Msg(l_api_name||' ends S ',0);
5910: /* Debug */
5911: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5912: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';
5913: l_debug_str := 'Returning S from Get_Bio_Info.';
5914: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5915: END IF;
5916:

Line 5924: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';

5920:
5921: WHEN FND_API.G_EXC_ERROR THEN
5922: /* Debug */
5923: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5924: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';
5925: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Bio_Info. '||SQLERRM;
5926: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5927: END IF;
5928:

Line 5940: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';

5936: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5937: END IF;
5938: /* Debug */
5939: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5940: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Bio_Info';
5941: l_debug_str := 'Exception in Get_Bio_Info. '||SQLERRM;
5942: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5943: END IF;
5944: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 5993: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Other_Info';

5989:
5990: BEGIN
5991: /* Debug */
5992: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5993: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Other_Info';
5994: l_debug_str := 'Entering Get_Other_Info. p_data_rec.person_id is '||p_data_rec.person_id;
5995: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5996: END IF;
5997:

Line 6013: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Other_Info';

6009: Put_Log_Msg('Record not found ',0);
6010: CLOSE c_data_rec;
6011: /* Debug */
6012: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6013: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Other_Info';
6014: l_debug_str := 'Returning N from Get_Other_Info.';
6015: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6016: END IF;
6017:

Line 6027: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Other_Info';

6023:
6024: Put_Log_Msg(l_api_name||' ends S ',0);
6025: /* Debug */
6026: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6027: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Other_Info';
6028: l_debug_str := 'Returning S from Get_Other_Info.';
6029: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6030: END IF;
6031: RETURN 'S';

Line 6040: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Other_Info';

6036:
6037: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6038: /* Debug */
6039: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6040: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Other_Info';
6041: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Other_Info-- Returning U. '||SQLERRM;
6042: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6043: END IF;
6044: RETURN 'U';

Line 6055: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Other_Info';

6051:
6052: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
6053: /* Debug */
6054: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6055: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Other_Info';
6056: l_debug_str := 'Exception in Get_Other_Info-- Returning U. '||SQLERRM;
6057: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6058: END IF;
6059: RETURN 'U';

Line 6122: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Address_Info';

6118:
6119: Put_Log_Msg(l_api_name||' begins ',0);
6120: /* Debug */
6121: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6122: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Address_Info';
6123: l_debug_str := 'Entering Get_Address_Info. p_data_rec.party_site_id is '||p_data_rec.party_site_id;
6124: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6125: END IF;
6126:

Line 6150: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Address_Info';

6146: Put_Log_Msg('Record not found ',0);
6147: CLOSE c_data_rec;
6148: /* Debug */
6149: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6150: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Address_Info';
6151: l_debug_str := 'Returning N from Get_Address_Info.';
6152: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6153: END IF;
6154:

Line 6164: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Address_Info';

6160:
6161: Put_Log_Msg(l_api_name||' ends S ',0);
6162: /* Debug */
6163: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6164: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Address_Info';
6165: l_debug_str := 'Returning S from Get_Address_Info.';
6166: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6167: END IF;
6168: RETURN 'S';

Line 6177: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Address_Info';

6173:
6174: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6175: /* Debug */
6176: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6177: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Address_Info';
6178: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Address_Info. Returning U... '||SQLERRM;
6179: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6180: END IF;
6181:

Line 6193: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Address_Info';

6189:
6190: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
6191: /* Debug */
6192: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6193: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Address_Info';
6194: l_debug_str := 'EXCEPTION in Get_Address_Info. Returning U... '||SQLERRM;
6195: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6196: END IF;
6197:

Line 6260: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Edu_Info';

6256:
6257: Put_Log_Msg(l_api_name||' begins ',0);
6258: /* Debug */
6259: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6260: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Edu_Info';
6261: l_debug_str := 'Entering Get_Edu_Info. p_data_rec.person_id is '||p_data_rec.person_id;
6262: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6263: END IF;
6264:

Line 6288: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Edu_Info';

6284: Put_Log_Msg('Record not found ',0);
6285: CLOSE c_data_rec;
6286: /* Debug */
6287: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6288: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Edu_Info';
6289: l_debug_str := 'Returning N from Get_Edu_Info.';
6290: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6291: END IF;
6292: RETURN 'N';

Line 6301: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Edu_Info';

6297:
6298: Put_Log_Msg(l_api_name||' ends S ',0);
6299: /* Debug */
6300: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6301: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Edu_Info';
6302: l_debug_str := 'Returning S from Get_Edu_Info.';
6303: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6304: END IF;
6305: RETURN 'S';

Line 6314: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Edu_Info';

6310:
6311: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6312: /* Debug */
6313: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6314: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Edu_Info';
6315: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Edu_Info. '||SQLERRM;
6316: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6317: END IF;
6318:

Line 6330: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Edu_Info';

6326:
6327: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
6328: /* Debug */
6329: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6330: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Edu_Info';
6331: l_debug_str := 'EXCEPTION: Returning U from Get_Edu_Info. '||SQLERRM;
6332: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6333: END IF;
6334: RETURN 'U';

Line 6410: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Finance_Info';

6406:
6407: Put_Log_Msg(l_api_name||' begins ',0);
6408: /* Debug */
6409: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6410: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Finance_Info';
6411: l_debug_str := 'Entering Get_Finance_Info. p_data_rec.person_id is '||p_data_rec.person_id;
6412: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6413: END IF;
6414:

Line 6454: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Finance_Info';

6450: Put_Log_Msg('Record not found ',0);
6451: CLOSE c_data_rec;
6452: /* Debug */
6453: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6454: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Finance_Info';
6455: l_debug_str := 'Returning N from Get_Finance_Info.';
6456: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6457: END IF;
6458: RETURN 'N';

Line 6467: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Finance_Info';

6463:
6464: Put_Log_Msg(l_api_name||' ends S ',0);
6465: /* Debug */
6466: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6467: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Finance_Info';
6468: l_debug_str := 'Returning S from Get_Finance_Info.';
6469: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6470: END IF;
6471: RETURN 'S';

Line 6480: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Finance_Info';

6476:
6477: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6478: /* Debug */
6479: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6480: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Finance_Info';
6481: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Finance_Info. '||SQLERRM;
6482: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6483: END IF;
6484: RETURN 'U';

Line 6495: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Finance_Info';

6491:
6492: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
6493: /* Debug */
6494: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6495: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Finance_Info';
6496: l_debug_str := 'EXCEPTION: Returning U from Get_Finance_Info. '||SQLERRM;
6497: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6498: END IF;
6499: RETURN 'U';

Line 6563: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Dependent_Info';

6559:
6560: BEGIN
6561: /* Debug */
6562: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6563: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Dependent_Info';
6564: l_debug_str := 'Entering Get_Dependent_Info. p_data_rec.person_id is '||p_data_rec.person_id||' and p_data_rec.depdnt_id is '||p_data_rec.depdnt_id;
6565: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6566: END IF;
6567: Put_Log_Msg(l_api_name||' begins ',0);

Line 6596: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Dependent_Info';

6592: Put_Log_Msg('Record not found ',0);
6593: CLOSE c_data_rec;
6594: /* Debug */
6595: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6596: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Dependent_Info';
6597: l_debug_str := 'Returning N from Get_Dependent_Info.';
6598: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6599: END IF;
6600: RETURN 'N';

Line 6609: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Dependent_Info';

6605:
6606: Put_Log_Msg(l_api_name||' ends S ',0);
6607: /* Debug */
6608: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6609: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Dependent_Info';
6610: l_debug_str := 'Returning S from Get_Dependent_Info.';
6611: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6612: END IF;
6613: RETURN 'S';

Line 6621: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Dependent_Info';

6617: WHEN FND_API.G_EXC_ERROR THEN
6618: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6619: /* Debug */
6620: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6621: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Dependent_Info';
6622: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Dependent_Info. '||SQLERRM;
6623: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6624: END IF;
6625: RETURN 'U';

Line 6635: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Dependent_Info';

6631:
6632: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
6633: /* Debug */
6634: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6635: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Dependent_Info';
6636: l_debug_str := 'EXCEPTION: Returning U from Get_Dependent_Info. '||SQLERRM;
6637: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6638: END IF;
6639: RETURN 'U';

Line 6696: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Legal_Info';

6692:
6693: Put_Log_Msg(l_api_name||' begins ',0);
6694: /* Debug */
6695: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6696: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Legal_Info';
6697: l_debug_str := 'Entering Get_Legal_Info. p_data_rec.person_id is '||p_data_rec.person_id;
6698: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6699: END IF;
6700:

Line 6722: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Legal_Info';

6718: Put_Log_Msg('Record not found ',0);
6719: CLOSE c_data_rec;
6720: /* Debug */
6721: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6722: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Legal_Info';
6723: l_debug_str := 'Returning N from Get_Legal_Info.';
6724: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6725: END IF;
6726: g_legal_status := 'NEW';

Line 6736: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Legal_Info';

6732: g_legal_status := 'EDIT';
6733: Put_Log_Msg(l_api_name||' ends S ',0);
6734: /* Debug */
6735: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6736: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Legal_Info';
6737: l_debug_str := 'Returning S from Get_Legal_Info.';
6738: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6739: END IF;
6740:

Line 6750: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Legal_Info';

6746:
6747: Put_Log_Msg(l_api_name||' EXEC ERROR ',1);
6748: /* Debug */
6749: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6750: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Legal_Info';
6751: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Legal_Info. '||SQLERRM;
6752: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6753: END IF;
6754: RETURN 'U';

Line 6765: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Legal_Info';

6761:
6762: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);
6763: /* Debug */
6764: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6765: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_Legal_Info';
6766: l_debug_str := 'EXCEPTION: Returning U from Get_Legal_Info. '||SQLERRM;
6767: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6768: END IF;
6769: RETURN 'U';

Line 6799: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Issue_Info';

6795:
6796: BEGIN
6797: /* Debug */
6798: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6799: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Issue_Info';
6800: l_debug_str := 'Entering Update_Issue_Info. p_data_rec.person_id is '||p_data_rec.person_id|| ' and p_data_rec.batch_id is '||p_data_rec.batch_id;
6801: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6802: END IF;
6803:

Line 6829: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Issue_Info';

6825: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6826: END IF;
6827: /* Debug */
6828: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6829: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Issue_Info';
6830: l_debug_str := 'EXCEPTION in Update_Issue_Info. '||SQLERRM;
6831: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6832: END IF;
6833: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 6865: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Bio_Info';

6861:
6862: BEGIN
6863: /* Debug */
6864: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6865: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Bio_Info';
6866: l_debug_str := 'Entering Insert_Bio_Info. p_data_rec.person_id is '||p_data_rec.person_id|| ' and p_data_rec.batch_id is '||p_data_rec.batch_id;
6867: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6868: END IF;
6869: Insert_Summary_Info(p_data_rec.batch_id,

Line 6937: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Bio_Info';

6933: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6934: END IF;
6935: /* Debug */
6936: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6937: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Bio_Info';
6938: l_debug_str := 'EXCEPTION in Insert_Bio_Info. '||SQLERRM;
6939: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6940: END IF;
6941: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 6973: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Other_Info';

6969:
6970: BEGIN
6971: /* Debug */
6972: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6973: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Other_Info';
6974: l_debug_str := 'Entering Insert_Other_Info. p_data_rec.person_id is '||p_data_rec.person_id|| ' and p_data_rec.batch_id is '||p_data_rec.batch_id;
6975: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6976: END IF;
6977: Insert_Summary_Info(p_data_rec.batch_id,

Line 7022: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Other_Info';

7018: END IF;
7019:
7020: /* Debug */
7021: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7022: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Other_Info';
7023: l_debug_str := 'EXCEPTION in Insert_Other_Info. '||SQLERRM;
7024: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7025: END IF;
7026: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 7063: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Address_Info';

7059: l_remarks VARCHAR2(500);
7060: BEGIN
7061: /* Debug */
7062: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7063: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Address_Info';
7064: l_debug_str := 'Entering Insert_Address_Info. Number of records: '||p_records;
7065: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7066: END IF;
7067:

Line 7178: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Address_Info';

7174: END IF;
7175:
7176: /* Debug */
7177: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7178: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Address_Info';
7179: l_debug_str := 'EXCEPTION in Insert_Address_Info. '||SQLERRM;
7180: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7181: END IF;
7182: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 7237: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Edu_Info';

7233:
7234: BEGIN
7235: /* Debug */
7236: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7237: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Edu_Info';
7238: l_debug_str := 'Entering Insert_Edu_Info. p_data_rec.person_id is '||p_data_rec.person_id|| ' and p_data_rec.batch_id is '||p_data_rec.batch_id;
7239: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7240: END IF;
7241: l_position_code := p_data_rec.position_code;

Line 7258: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Edu_Info';

7254: l_prgm_end_date := p_data_rec.prgm_end_date;
7255:
7256: /* Debug */
7257: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7258: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Edu_Info';
7259: l_debug_str := 'After assigning values to local variables';
7260: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7261: END IF;
7262: -- Nonimg action types:

Line 7368: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Edu_Info';

7364: l_prgm_end_date := l_cur_rec.prgm_end_date;
7365: END IF;
7366: /* Debug */
7367: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7368: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Edu_Info';
7369: l_debug_str := 'After assigning values received from get_othr_prgm_info to local variables';
7370: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7371: END IF;
7372: END IF;

Line 7461: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Edu_Info';

7457: );
7458:
7459: /* Debug */
7460: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7461: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Edu_Info';
7462: l_debug_str := 'Record inserted';
7463: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7464: END IF;
7465:

Line 7475: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Edu_Info';

7471: END IF;
7472:
7473: /* Debug */
7474: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7475: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Edu_Info';
7476: l_debug_str := 'EXCEPTION in Insert_Edu_Info. '||SQLERRM;
7477: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7478: END IF;
7479: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 7511: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Finance_Info';

7507:
7508: BEGIN
7509: /* Debug */
7510: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7511: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Finance_Info';
7512: l_debug_str := 'Entering Insert_Finance_Info. p_data_rec.person_id is '||p_data_rec.person_id|| ' and p_data_rec.batch_id is '||p_data_rec.batch_id;
7513: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7514: END IF;
7515: Insert_Summary_Info(p_data_rec.batch_id,

Line 7613: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Finance_Info';

7609: END IF;
7610:
7611: /* Debug */
7612: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7613: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Finance_Info';
7614: l_debug_str := 'EXCEPTION in Insert_Finance_Info. '||SQLERRM;
7615: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7616: END IF;
7617: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 7654: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Dependent_Info';

7650:
7651: BEGIN
7652: /* Debug */
7653: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7654: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Dependent_Info';
7655: l_debug_str := 'Entering Insert_Dependent_Info.Number of records being inserted: '||p_records;
7656: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7657: END IF;
7658:

Line 7763: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Dependent_Info';

7759: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7760: END IF;
7761: /* Debug */
7762: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7763: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Dependent_Info';
7764: l_debug_str := 'EXCEPTION in Insert_Dependent_Info. '||SQLERRM;
7765: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7766: END IF;
7767: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 7788: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Dependent_Info';

7784:
7785: BEGIN
7786: /* Debug */
7787: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7788: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Dependent_Info';
7789: l_debug_str := 'Entering Insert_Dependent_Info.';
7790: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7791: END IF;
7792:

Line 7895: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Dependent_Info';

7891: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7892: END IF;
7893: /* Debug */
7894: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7895: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Dependent_Info';
7896: l_debug_str := 'EXCEPTION in Insert_Dependent_Info. '||SQLERRM;
7897: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7898: END IF;
7899: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 7930: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Convictions_Info';

7926:
7927: BEGIN
7928: /* Debug */
7929: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7930: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Convictions_Info';
7931: l_debug_str := 'Entering Insert_Convictions_Info. p_data_rec.person_id is '||p_data_rec.person_id|| ' and p_data_rec.batch_id is '||p_data_rec.batch_id;
7932: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7933: END IF;
7934: Insert_Summary_Info(p_data_rec.batch_id,

Line 7976: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Convictions_Info';

7972: END IF;
7973:
7974: /* Debug */
7975: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7976: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Convictions_Info';
7977: l_debug_str := 'EXCEPTION in Insert_Convictions_Info. '||SQLERRM;
7978: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7979: END IF;
7980: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 8010: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Legal_Info';

8006:
8007: BEGIN
8008: /* Debug */
8009: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8010: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Legal_Info';
8011: l_debug_str := 'Entering Insert_Legal_Info. p_data_rec.person_id is '||p_data_rec.person_id|| ' and p_data_rec.batch_id is '||p_data_rec.batch_id;
8012: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8013: END IF;
8014: Insert_Summary_Info(p_data_rec.batch_id,

Line 8074: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Legal_Info';

8070: END IF;
8071:
8072: /* Debug */
8073: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8074: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Legal_Info';
8075: l_debug_str := 'EXCEPTION in Insert_Legal_Info. '||SQLERRM;
8076: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8077: END IF;
8078: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 8110: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Empl_Info';

8106: l_btch_id NUMBER(14);
8107: BEGIN
8108: /* Debug */
8109: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8110: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Empl_Info';
8111: l_debug_str := 'Entering Insert_Empl_Info. p_data_rec.person_id is '||p_data_rec.person_id|| ' and p_data_rec.batch_id is '||p_data_rec.batch_id;
8112: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8113: END IF;
8114: IF g_person_status = 'NEW' THEN

Line 8144: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

8140: 'IGS_SV_EMPL_INFO',
8141: p_data_rec.nonimg_empl_id);
8142: /* Debug */
8143: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8144: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
8145: l_debug_str := 'mut_exclusive chk returns '||l_btch_id||' for batch: '||p_data_rec.batch_id||'person: '||p_data_rec.person_id||' action: '||l_action||' tag: '||l_tag_code;
8146: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8147: END IF;
8148:

Line 8211: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Empl_Info';

8207: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
8208: END IF;
8209: /* Debug */
8210: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8211: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Empl_Info';
8212: l_debug_str := 'EXCEPTION in Insert_Empl_Info. '||SQLERRM;
8213: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8214: END IF;
8215: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 8293: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';

8289:
8290: BEGIN
8291: /* Debug */
8292: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8293: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';
8294: l_debug_str := 'Entering Update_Registration_Info. p_person_rec.person_id is '||p_person_rec.person_id|| ' and p_person_rec.batch_type is '||p_person_rec.batch_type;
8295: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8296: END IF;
8297:

Line 8331: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';

8327:
8328: Put_Log_Msg('Validation error occurs ',1);
8329: /* Debug */
8330: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8331: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';
8332: l_debug_str := 'Returning S from Update_Registration_Info.';
8333: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8334: END IF;
8335:

Line 8343: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';

8339:
8340: Put_Log_Msg('Unexpected error returned by validation ',1);
8341: /* Debug */
8342: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8343: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';
8344: l_debug_str := 'Unexpected error in Update_Registration_Info.';
8345: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8346: END IF;
8347:

Line 8361: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';

8357:
8358: IF l_status = 'U' THEN
8359: /* Debug */
8360: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8361: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';
8362: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Registration_Info.';
8363: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8364: END IF;
8365:

Line 8431: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';

8427:
8428: p_person_rec.person_status := 'I';
8429: /* Debug
8430: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8431: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';
8432: l_debug_str := 'Returning S from Update_Registration_Info.';
8433: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8434: END IF;
8435:

Line 8468: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';

8464:
8465: Put_Log_Msg('Validation error occurs - return S ',1);
8466: /* Debug */
8467: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8468: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';
8469: l_debug_str := 'Returning S from Update_Registration_Info.';
8470: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8471: END IF;
8472:

Line 8492: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';

8488:
8489: p_person_rec.person_status := 'I';
8490: /* Debug */
8491: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8492: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';
8493: l_debug_str := 'Returning S from Update_Registration_Info.';
8494: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8495: END IF;
8496:

Line 8514: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';

8510:
8511: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
8512: /* Debug */
8513: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8514: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';
8515: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Registration_Info. '||SQLERRM;
8516: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8517: END IF;
8518: RETURN 'U';

Line 8529: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';

8525:
8526: Put_Log_Msg(l_api_name||' OTHERS return U',1);
8527: /* Debug */
8528: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8529: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Registration_Info';
8530: l_debug_str := 'EXCEPTION: Returning U from Update_Registration_Info. '||SQLERRM;
8531: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8532: END IF;
8533: RETURN 'U';

Line 8557: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';

8553:
8554: BEGIN
8555: /* Debug */
8556: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8557: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';
8558: l_debug_str := 'Entering Update_ev_Legal_Info. p_person_rec.person_id is '||p_person_rec.person_id|| ' and p_person_rec.batch_type is '||p_person_rec.batch_type;
8559: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8560: END IF;
8561:

Line 8576: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';

8572:
8573: Put_Log_Msg('Validation error occurs ',1);
8574: /* Debug */
8575: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8576: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';
8577: l_debug_str := 'Returning S from Update_ev_Legal_Info.';
8578: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8579: END IF;
8580:

Line 8588: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';

8584:
8585: Put_Log_Msg('Unexpected error returned by validation ',1);
8586: /* Debug */
8587: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8588: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';
8589: l_debug_str := 'Unexpected error in Update_ev_Legal_Info.';
8590: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8591: END IF;
8592:

Line 8605: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';

8601: l_status := Get_Legal_Info ( p_data_rec => l_prev_rec);
8602: IF l_status = 'U' THEN
8603: /* Debug */
8604: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8605: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';
8606: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_ev_Legal_Info.';
8607: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8608: END IF;
8609:

Line 8615: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Previous_Legal_Info';

8611:
8612: END IF;
8613:
8614: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8615: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Previous_Legal_Info';
8616: l_debug_str := 'psprt_issuing_cntry_code=' || l_prev_rec.psprt_issuing_cntry_code;
8617: l_debug_str := l_debug_str || 'psprt_exp_date=' || l_prev_rec.psprt_exp_date;
8618: l_debug_str := l_debug_str || 'visa_number=' || l_prev_rec.visa_number ;
8619: l_debug_str := l_debug_str || 'visa_issuing_post=' || l_prev_rec.visa_issuing_post;

Line 8631: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Current_Legal_Info';

8627: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8628: END IF;
8629:
8630: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8631: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Current_Legal_Info';
8632: l_debug_str := 'psprt_issuing_cntry_code=' || l_cur_rec.psprt_issuing_cntry_code;
8633: l_debug_str := l_debug_str || 'psprt_exp_date=' || l_cur_rec.psprt_exp_date;
8634: l_debug_str := l_debug_str || 'visa_number=' || l_cur_rec.visa_number ;
8635: l_debug_str := l_debug_str || 'visa_issuing_post=' || l_cur_rec.visa_issuing_post;

Line 8699: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';

8695:
8696: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
8697: /* Debug */
8698: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8699: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';
8700: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_ev_Legal_Info. '||SQLERRM;
8701: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8702: END IF;
8703: RETURN 'U';

Line 8714: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';

8710:
8711: Put_Log_Msg(l_api_name||' OTHERS return U',1);
8712: /* Debug */
8713: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8714: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_ev_Legal_Info';
8715: l_debug_str := 'EXCEPTION: Returning U from Update_ev_Legal_Info. '||SQLERRM;
8716: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8717: END IF;
8718: RETURN 'U';

Line 8773: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

8769:
8770: Put_Log_Msg(l_api_name||' begins ',0);
8771: /* Debug */
8772: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8773: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
8774: l_debug_str := 'Entering Update_EV_Address_Info. p_person_rec.form_id is '||p_person_rec.form_id;
8775: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8776: END IF;
8777:

Line 8799: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

8795:
8796: Put_Log_Msg('Validation error occurs - return S ',1);
8797: /* Debug */
8798: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8799: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
8800: l_debug_str := 'Returning S from Update_EV_Address_Info.';
8801: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8802: END IF;
8803:

Line 8811: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

8807:
8808: Put_Log_Msg('Unexpected error returned by validation ',1);
8809: /* Debug */
8810: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8811: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
8812: l_debug_str := 'Unexpected error in Update_EV_Address_Info.';
8813: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8814: END IF;
8815:

Line 8828: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

8824:
8825: p_person_rec.person_status := 'I';
8826: /* Debug */
8827: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8828: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
8829: l_debug_str := 'Returning S from Update_EV_Address_Info.';
8830: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8831: END IF;
8832:

Line 8887: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

8883: ELSE
8884: --Error found l_status = 'U'
8885: /* Debug */
8886: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8887: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
8888: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';
8889: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8890: END IF;
8891: RAISE FND_API.G_EXC_ERROR;

Line 8912: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

8908:
8909: Put_Log_Msg('Validation error occurs - return S ',1);
8910: /* Debug */
8911: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8912: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
8913: l_debug_str := 'Returning S from Update_EV_Address_Info. us_addr_status is E';
8914: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8915: END IF;
8916:

Line 8924: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

8920:
8921: Put_Log_Msg('Unexpected error returned by validation ',1);
8922: /* Debug */
8923: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8924: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
8925: l_debug_str := 'ERROR in Update_EV_Address_Info. us_addr_status is U';
8926: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8927: END IF;
8928:

Line 8936: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

8932:
8933: Put_Log_Msg('Site of activity Address block is not found return S',0);
8934: /* Debug */
8935: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8936: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
8937: l_debug_str := 'Returning S from Update_EV_Address_Info. us_addr_status is N';
8938: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8939: END IF;
8940:

Line 8959: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Previous_Site_Info';

8955:
8956:
8957: --manoj starts
8958: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8959: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Previous_Site_Info';
8960: l_debug_str := 'address_line1=' || l_prev_site_addr_rec.address_line1;
8961: l_debug_str := l_debug_str || 'address_line2=' || l_prev_site_addr_rec.address_line2;
8962: l_debug_str := l_debug_str || 'city=' || l_prev_site_addr_rec.city ;
8963: l_debug_str := l_debug_str || 'state=' || l_prev_site_addr_rec.state;

Line 8975: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Current_Site_Info';

8971: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8972: END IF;
8973:
8974: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8975: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Current_Site_Info';
8976: l_debug_str := 'address_line1=' || l_site_addr_rec(l_cur).address_line1;
8977: l_debug_str := l_debug_str || 'address_line2=' || l_site_addr_rec(l_cur).address_line2;
8978: l_debug_str := l_debug_str || 'city=' || l_site_addr_rec(l_cur).city ;
8979: l_debug_str := l_debug_str || 'state=' || l_site_addr_rec(l_cur).state;

Line 9054: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

9050: ELSE
9051: --Error found l_statsite = 'U'
9052: /* Debug */
9053: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9054: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
9055: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';
9056: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9057: END IF;
9058:

Line 9067: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

9063: /* IF p_person_rec.changes_found = 'Y' THEN
9064: -- one address only
9065: /* Debug
9066: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9067: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
9068: l_debug_str := 'changes_found is Y. Exiting Update_EV_Address_Info.';
9069: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9070: END IF;
9071: EXIT;

Line 9088: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

9084:
9085: Put_Log_Msg(l_api_name||' ends ',0);
9086: /* Debug */
9087: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9088: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
9089: l_debug_str := 'Returning S from Update_EV_Address_Info.';
9090: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9091: END IF;
9092:

Line 9102: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

9098:
9099: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
9100: /* Debug */
9101: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9102: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
9103: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_EV_Address_Info. '||SQLERRM;
9104: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9105: END IF;
9106: RETURN 'U';

Line 9117: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';

9113:
9114: Put_Log_Msg(l_api_name||' OTHERS return U',1);
9115: /* Debug */
9116: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9117: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Address_Info';
9118: l_debug_str := 'EXCEPTION: Returning U from Update_EV_Address_Info. '||SQLERRM;
9119: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9120: END IF;
9121:

Line 9166: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';

9162:
9163: BEGIN
9164: /* Debug */
9165: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9166: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9167: l_debug_str := 'Entering Update_Personal_Info. p_person_rec.person_id is '||p_person_rec.person_id;
9168: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9169: END IF;
9170:

Line 9216: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';

9212:
9213: Put_Log_Msg('UPI - Validation error occurs ',1);
9214: /* Debug */
9215: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9216: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9217: l_debug_str := 'Returning S from Update_Personal_Info.';
9218: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9219: END IF;
9220:

Line 9233: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';

9229:
9230: Put_Log_Msg('UPI - unexpected error returned by validation ',1);
9231: /* Debug */
9232: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9233: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9234: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Personal_Info.';
9235: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9236: END IF;
9237:

Line 9247: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';

9243:
9244: Put_Log_Msg('UPI BIO block is not found ',1);
9245: /* Debug */
9246: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9247: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9248: l_debug_str := 'IGS_SV_UNEXP_EXCPT_ERR in Update_Personal_Info. bio_status is N';
9249: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9250: END IF;
9251:

Line 9270: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';

9266:
9267: IF l_status = 'U' THEN
9268: /* Debug */
9269: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9270: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9271: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. l_status is U';
9272: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9273: END IF;
9274: RAISE FND_API.G_EXC_ERROR;

Line 9312: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';

9308: p_person_rec.changes_found := 'Y';
9309: Put_Log_Msg('Bio info is changed ',0);
9310: /* Debug */
9311: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9312: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9313: l_debug_str := 'Bio Info changed. l_prev_bio_rec.citizen_cntry_code '||l_prev_bio_rec.citizen_cntry_code||' and l_bio_rec.citizen_cntry_code:'||l_bio_rec.citizen_cntry_code;
9314: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9315: END IF;
9316:

Line 9356: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';

9352:
9353: --Error found l_status = 'U'
9354: /* Debug */
9355: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9356: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9357: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info.';
9358: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9359: END IF;
9360:

Line 9419: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';

9415:
9416: --Error found l_status = 'U'
9417: /* Debug */
9418: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9419: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9420: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. f_addr_status is S';
9421: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9422: END IF;
9423:

Line 9480: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';

9476: ELSE
9477: --Error found l_status = 'U'
9478: /* Debug */
9479: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9480: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9481: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. us_addr_status is S';
9482: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9483: END IF;
9484:

Line 9529: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';

9525:
9526: Put_Log_Msg(l_api_name||' ends ',0);
9527: /* Debug */
9528: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9529: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9530: l_debug_str := 'Returning S from Update_Personal_Info.';
9531: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9532: END IF;
9533:

Line 9543: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';

9539:
9540: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
9541: /* Debug */
9542: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9543: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9544: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Personal_Info. '||SQLERRM;
9545: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9546: END IF;
9547: RETURN 'U';

Line 9558: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';

9554:
9555: Put_Log_Msg(l_api_name||' OTHERS return U',1);
9556: /* Debug */
9557: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9558: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Personal_Info';
9559: l_debug_str := 'EXCEPTION: Returning U from Update_Personal_Info. '||SQLERRM;
9560: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9561: END IF;
9562: RETURN 'U';

Line 9596: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_EV_Prgm_Info';

9592: ORDER BY effective_date;
9593: BEGIN
9594: /* Debug */
9595: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9596: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_EV_Prgm_Info';
9597: l_debug_str := 'Entering Get_EV_Prgm_Info. p_data_rec.person_id is '||p_data_rec.person_id;
9598: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9599: END IF;
9600:

Line 9619: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_EV_Prgm_Info';

9615: Put_Log_Msg('Record not found ',0);
9616: CLOSE c_data_rec;
9617: /* Debug */
9618: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9619: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_EV_Prgm_Info';
9620: l_debug_str := 'Returning N from Get_EV_Prgm_Info';
9621: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9622: END IF;
9623: RETURN 'N';

Line 9632: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_EV_Prgm_Info';

9628:
9629: Put_Log_Msg(l_api_name||' ends S ',0);
9630: /* Debug */
9631: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9632: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_EV_Prgm_Info';
9633: l_debug_str := 'Returning S from Get_EV_Prgm_Info';
9634: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9635: END IF;
9636: RETURN 'S';

Line 9643: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_EV_Prgm_Info';

9639:
9640: WHEN FND_API.G_EXC_ERROR THEN
9641: /* Debug */
9642: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9643: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_EV_Prgm_Info';
9644: l_debug_str := 'Exception in Get_EV_Prgm_Info '||SQLERRM;
9645: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9646: END IF;
9647:

Line 9654: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_EV_Prgm_Info';

9650:
9651: WHEN OTHERS THEN
9652: /* Debug */
9653: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9654: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_EV_Prgm_Info';
9655: l_debug_str := 'Exception in Get_EV_Prgm_Info '||SQLERRM;
9656: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9657: END IF;
9658: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

Line 9697: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_nonimg_Prgm_Info';

9693: ORDER BY effective_date;
9694: BEGIN
9695: /* Debug */
9696: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9697: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_nonimg_Prgm_Info';
9698: l_debug_str := 'Entering Get_nonimg_Prgm_Info. p_data_rec.person_id is '||p_data_rec.person_id;
9699: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9700: END IF;
9701:

Line 9719: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_nonimg_Prgm_Info';

9715: Put_Log_Msg('Record not found ',0);
9716: CLOSE c_data_rec;
9717: /* Debug */
9718: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9719: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_nonimg_Prgm_Info';
9720: l_debug_str := 'Returning N from Get_nonimg_Prgm_Info';
9721: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9722: END IF;
9723: RETURN 'N';

Line 9732: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_nonimg_Prgm_Info';

9728:
9729: Put_Log_Msg(l_api_name||' ends S ',0);
9730: /* Debug */
9731: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9732: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_nonimg_Prgm_Info';
9733: l_debug_str := 'Returning S from Get_nonimg_Prgm_Info';
9734: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9735: END IF;
9736: RETURN 'S';

Line 9743: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_nonimg_Prgm_Info';

9739:
9740: WHEN FND_API.G_EXC_ERROR THEN
9741: /* Debug */
9742: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9743: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_nonimg_Prgm_Info';
9744: l_debug_str := 'Exception in Get_nonimg_Prgm_Info '||SQLERRM;
9745: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9746: END IF;
9747:

Line 9754: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_nonimg_Prgm_Info';

9750:
9751: WHEN OTHERS THEN
9752: /* Debug */
9753: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9754: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Get_nonimg_Prgm_Info';
9755: l_debug_str := 'Exception in Get_nonimg_Prgm_Info '||SQLERRM;
9756: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9757: END IF;
9758: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

Line 9799: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

9795:
9796: Put_Log_Msg(l_api_name||' begins ',0);
9797: /* Debug */
9798: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9799: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
9800: l_debug_str := 'Entering Update_Program_Info. p_person_rec.person_id is '||p_person_rec.person_id;
9801: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9802: END IF;
9803:

Line 9816: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

9812:
9813: Put_Log_Msg('Validation error occurs ',1);
9814: /* Debug */
9815: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9816: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
9817: l_debug_str := 'Returning S from Update_Program_Info. p_person_rec.edu_status is E';
9818: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9819: END IF;
9820:

Line 9830: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

9826:
9827: Put_Log_Msg('Unexpected error returned by validation ',1);
9828: /* Debug */
9829: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9830: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
9831: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';
9832: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9833: END IF;
9834:

Line 9844: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

9840:
9841: Put_Log_Msg('EDU block is not found ',0);
9842: /* Debug */
9843: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9844: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
9845: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is N.';
9846: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9847: END IF;
9848:

Line 9866: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

9862:
9863: IF l_status = 'U' OR l_status = 'N' THEN
9864: /* Debug */
9865: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9866: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
9867: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';
9868: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9869: END IF;
9870: RAISE FND_API.G_EXC_ERROR;

Line 9927: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

9923:
9924: Put_Log_Msg('Validation error occurs ',1);
9925: /* Debug */
9926: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9927: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
9928: l_debug_str := 'Returning S from Update_Program_Info.';
9929: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9930: END IF;
9931:

Line 9939: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

9935:
9936: Put_Log_Msg('Unexpected error returned by validation ',1);
9937: /* Debug */
9938: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9939: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
9940: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info.';
9941: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9942: END IF;
9943:

Line 9960: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

9956:
9957: IF l_status = 'U' THEN
9958: /* Debug */
9959: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9960: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
9961: l_debug_str := 'Unexpected error in Update_Employment_Info. l_status is U.';
9962: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9963: END IF;
9964: RAISE FND_API.G_EXC_ERROR;

Line 10015: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

10011:
10012: Put_Log_Msg(l_api_name||' ends ',0);
10013: /* Debug */
10014: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10015: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
10016: l_debug_str := 'Final Return S from Update_Program_Info.';
10017: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10018: END IF;
10019:

Line 10029: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

10025:
10026: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
10027: /* Debug */
10028: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10029: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
10030: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Program_Info. '||SQLERRM;
10031: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10032: END IF;
10033: RETURN 'U';

Line 10044: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

10040:
10041: Put_Log_Msg(l_api_name||' OTHERS return U',1);
10042: /* Debug */
10043: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10044: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
10045: l_debug_str := 'EXCEPTION: Returning U from Update_Program_Info. '||SQLERRM;
10046: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10047: END IF;
10048:

Line 10087: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';

10083:
10084: Put_Log_Msg(l_api_name||' begins ',0);
10085: /* Debug */
10086: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10087: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';
10088: l_debug_str := 'Entering Update_EV_Program_Info. p_person_rec.person_id is '||p_person_rec.person_id;
10089: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10090: END IF;
10091:

Line 10103: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

10099:
10100: Put_Log_Msg('Validation error occurs ',1);
10101: /* Debug */
10102: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10103: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
10104: l_debug_str := 'Returning S from Update_Program_Info. p_person_rec.edu_status is E';
10105: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10106: END IF;
10107:

Line 10117: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

10113:
10114: Put_Log_Msg('Unexpected error returned by validation ',1);
10115: /* Debug */
10116: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10117: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
10118: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';
10119: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10120: END IF;
10121:

Line 10131: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

10127:
10128: Put_Log_Msg('EDU block is not found ',0);
10129: /* Debug */
10130: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10131: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
10132: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is N.';
10133: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10134: END IF;
10135:

Line 10153: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';

10149:
10150: IF l_status = 'U' OR l_status = 'N' THEN
10151: /* Debug */
10152: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10153: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Program_Info';
10154: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';
10155: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10156: END IF;
10157: RAISE FND_API.G_EXC_ERROR;

Line 10212: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';

10208:
10209: Put_Log_Msg('Validation error occurs ',1);
10210: /* Debug */
10211: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10212: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';
10213: l_debug_str := 'Returning S from Update_EV_Program_Info. p_person_rec.edu_status is E.';
10214: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10215: END IF;
10216:

Line 10224: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';

10220:
10221: Put_Log_Msg('Unexpected error returned by validation ',1);
10222: /* Debug */
10223: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10224: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';
10225: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Program_Info. p_person_rec.edu_status is U.';
10226: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10227: END IF;
10228:

Line 10246: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

10242:
10243: IF l_status = 'U' THEN
10244: /* Debug */
10245: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10246: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
10247: l_debug_str := 'Unexpected error in Update_Employment_Info. l_status is U.';
10248: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10249: END IF;
10250: RAISE FND_API.G_EXC_ERROR;

Line 10284: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';

10280:
10281: IF p_person_rec.edu_status = 'C' AND p_person_rec.person_status <> 'I' THEN
10282: /* Debug */
10283: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10284: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';
10285: l_debug_str := 'inserting prgm info.';
10286: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10287: END IF;
10288: Insert_Edu_Info ('PRGM', p_data_rec => l_cur_prgm_rec(l_current), p_auth_drp_data_rec => NULL);

Line 10295: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';

10291:
10292: Put_Log_Msg(l_api_name||' ends ',0);
10293: /* Debug */
10294: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10295: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';
10296: l_debug_str := 'Returning S from Update_EV_Program_Info.';
10297: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10298: END IF;
10299:

Line 10309: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';

10305:
10306: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
10307: /* Debug */
10308: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10309: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';
10310: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_EV_Program_Info. '||SQLERRM;
10311: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10312: END IF;
10313:

Line 10325: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';

10321:
10322: Put_Log_Msg(l_api_name||' OTHERS return U',1);
10323: /* Debug */
10324: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10325: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_EV_Program_Info';
10326: l_debug_str := 'EXCEPTION: Returning U from Update_EV_Program_Info. '||SQLERRM;
10327: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10328: END IF;
10329:

Line 10366: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';

10362:
10363: Put_Log_Msg(l_api_name||' begins ',0);
10364: /* Debug */
10365: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10366: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';
10367: l_debug_str := 'Entering Update_Finance_Info. p_person_rec.person_id is '||p_person_rec.person_id;
10368: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10369: END IF;
10370:

Line 10381: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';

10377:
10378: Put_Log_Msg('Validation error occurs ',1);
10379: /* Debug */
10380: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10381: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';
10382: l_debug_str := 'Returning S from Update_Finance_Info. p_person_rec.fin_status is E';
10383: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10384: END IF;
10385:

Line 10393: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';

10389:
10390: Put_Log_Msg('Unexpected error returned by validation ',1);
10391: /* Debug */
10392: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10393: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';
10394: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. fin_status is U';
10395: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10396: END IF;
10397:

Line 10407: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';

10403:
10404: Put_Log_Msg('Finance block is not found ',0);
10405: /* Debug */
10406: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10407: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';
10408: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. fin_status is N';
10409: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10410: END IF;
10411:

Line 10430: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';

10426:
10427: IF l_status = 'U' OR l_status = 'N' THEN
10428: /* Debug */
10429: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10430: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';
10431: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. l_status is U or N';
10432: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10433: END IF;
10434:

Line 10516: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';

10512: END IF;
10513: Put_Log_Msg(l_api_name||' ends ',0);
10514: /* Debug */
10515: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10516: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';
10517: l_debug_str := 'Returning S from Update_Finance_Info.';
10518: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10519: END IF;
10520:

Line 10530: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';

10526:
10527: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
10528: /* Debug */
10529: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10530: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';
10531: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Finance_Info. '||SQLERRM;
10532: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10533: END IF;
10534: RETURN 'U';

Line 10545: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';

10541:
10542: Put_Log_Msg(l_api_name||' OTHERS return U',1);
10543: /* Debug */
10544: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10545: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Finance_Info';
10546: l_debug_str := 'EXCEPTION: Returning U from Update_Finance_Info. '||SQLERRM;
10547: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10548: END IF;
10549:

Line 10601: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';

10597:
10598: Put_Log_Msg(l_api_name||' begins ',0);
10599: /* Debug */
10600: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10601: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10602: l_debug_str := 'Entering Update_Dependent_Info. p_person_rec.person_id is '||p_person_rec.person_id;
10603: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10604: END IF;
10605:

Line 10619: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';

10615:
10616: Put_Log_Msg('Validation error occurs ',1);
10617: /* Debug */
10618: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10619: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10620: l_debug_str := 'Returning S from Update_Dependent_Info. dep_status is E.';
10621: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10622: END IF;
10623: RETURN 'S';

Line 10630: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';

10626:
10627: Put_Log_Msg('Unexpected error returned by validation ',1);
10628: /* Debug */
10629: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10630: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10631: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. dep_status is U.';
10632: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10633: END IF;
10634:

Line 10642: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';

10638:
10639: Put_Log_Msg('Dependent block is not found ',0);
10640: /* Debug */
10641: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10642: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10643: l_debug_str := 'Returning S from Update_Dependent_Info. dep_status is N.';
10644: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10645: END IF;
10646: RETURN 'S';

Line 10665: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Previous_Dependent_Info';

10661: --manoj stars
10662:
10663:
10664: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10665: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Previous_Dependent_Info';
10666: l_debug_str := 'l_prev_rec action_type='||l_prev_rec.depdnt_action_type;
10667: l_debug_str := l_debug_str || 'visa_type=' || l_prev_rec.visa_type;
10668: l_debug_str := l_debug_str || 'last_name=' || l_prev_rec.last_name;
10669: l_debug_str := l_debug_str || 'first_name=' || l_prev_rec.first_name ;

Line 10688: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Current_Dependent_Info';

10684: END IF;
10685:
10686:
10687: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10688: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Current_Dependent_Info';
10689: l_debug_str := 'cur dep action type: '||l_cur_rec(l_current).depdnt_action_type;
10690: l_debug_str := l_debug_str || 'visa_type=' || l_cur_rec(l_current).visa_type;
10691: l_debug_str := l_debug_str || 'last_name=' || l_cur_rec(l_current).last_name;
10692: l_debug_str := l_debug_str || 'first_name=' || l_cur_rec(l_current).first_name;

Line 10713: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';

10709:
10710: IF l_status = 'U' THEN
10711: /* Debug */
10712: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10713: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10714: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. l_status is U.';
10715: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10716: END IF;
10717: RAISE FND_API.G_EXC_ERROR;

Line 10734: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';

10730:
10731: Put_Log_Msg('Validation error occurs ',0);
10732: /* Debug */
10733: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10734: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10735: l_debug_str := 'Returning S from Update_Dependent_Info. l_status is S.';
10736: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10737: END IF;
10738: RETURN 'S';

Line 10812: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';

10808:
10809: Put_Log_Msg('Info is changed for '||l_cur_rec(l_current).depdnt_id,0);
10810: /* Debug */
10811: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10812: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10813: l_debug_str := 'Update_Dependent_Info. l_prev_rec.depdnt_action_type: '||l_prev_rec.depdnt_action_type||'cur dep action type: '||l_cur_rec(l_current).depdnt_action_type;
10814: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10815: END IF;
10816: --IF l_prev_rec.depdnt_action_type = l_cur_rec(l_current).depdnt_action_type THEN

Line 10831: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';

10827: /* IF p_person_rec.dep_status = 'C' AND p_person_rec.record_status ='C' THEN prbhardw CP enhancement
10828: -- Only one dependent in the update section.
10829: /* Debug
10830: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10831: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10832: l_debug_str := 'Exiting Update_Dependent_Info. dep_status and record_status is C.';
10833: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10834: END IF;
10835:

Line 10849: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';

10845: END IF; */
10846: Put_Log_Msg(l_api_name||' ends ',0);
10847: /* Debug */
10848: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10849: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10850: l_debug_str := 'Returning S from Update_Dependent_Info.';
10851: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10852: END IF;
10853:

Line 10862: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';

10858: WHEN FND_API.G_EXC_ERROR THEN
10859: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
10860: /* Debug */
10861: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10862: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10863: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Dependent_Info. '||SQLERRM;
10864: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10865: END IF;
10866: RETURN 'U';

Line 10876: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';

10872: END IF;
10873: Put_Log_Msg(l_api_name||' OTHERS return U',1);
10874: /* Debug */
10875: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10876: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Dependent_Info';
10877: l_debug_str := 'EXCEPTION: Returning U from Update_Dependent_Info. '||SQLERRM;
10878: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10879: END IF;
10880:

Line 10919: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

10915:
10916: Put_Log_Msg(l_api_name||' begins ',0);
10917: /* Debug */
10918: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10919: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
10920: l_debug_str := 'Entering Update_Employment_Info. p_person_rec.person_id is '||p_person_rec.person_id;
10921: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10922: END IF;
10923:

Line 10935: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

10931: p_person_rec.person_status := 'I';
10932: Put_Log_Msg('Validation error occurs ',1);
10933: /* Debug */
10934: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10935: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
10936: l_debug_str := 'Returning S from Update_Employment_Info. empl_status is E.';
10937: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10938: END IF;
10939: RETURN 'S';

Line 10944: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

10940: ELSIF p_person_rec.empl_status = 'U' THEN --Unexpected error - terminate execution
10941: Put_Log_Msg('Unexpected error returned by validation ',1);
10942: /* Debug */
10943: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10944: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
10945: l_debug_str := 'Unexpected error in Update_Employment_Info. empl_status is U.';
10946: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10947: END IF;
10948: RAISE FND_API.G_EXC_ERROR;

Line 10953: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

10949: ELSIF p_person_rec.empl_status = 'N' THEN -- Not found
10950: Put_Log_Msg('Employment block is not found ',0);
10951: /* Debug */
10952: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10953: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
10954: l_debug_str := 'Returning S from Update_Employment_Info. empl_status is N.';
10955: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10956: END IF;
10957: RETURN 'S';

Line 10973: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Previous_empl_Info';

10969:
10970:
10971: --manoj starts
10972: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10973: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Previous_empl_Info';
10974: l_debug_str := 'empl_rec_type=' || l_prev_rec.empl_rec_type;
10975: l_debug_str := l_debug_str || 'empl_type=' || l_prev_rec.empl_type;
10976: l_debug_str := l_debug_str || 'recommend_empl=' || l_prev_rec.recommend_empl ;
10977: l_debug_str := l_debug_str || 'rescind_empl=' || l_prev_rec.rescind_empl;

Line 10988: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Current_empl_Info';

10984: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10985: END IF;
10986:
10987: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10988: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Current_empl_Info';
10989: l_debug_str := 'empl_rec_type=' || l_cur_rec(l_current).empl_rec_type;
10990: l_debug_str := l_debug_str || 'empl_type=' || l_cur_rec(l_current).empl_type;
10991: l_debug_str := l_debug_str || 'recommend_empl=' || l_cur_rec(l_current).recommend_empl ;
10992: l_debug_str := l_debug_str || 'rescind_empl=' || l_cur_rec(l_current).rescind_empl;

Line 11007: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

11003: --manoj ends
11004:
11005: /* Debug */
11006: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11007: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
11008: l_debug_str := 'l_status from Get_Empl_Info: '||l_status;
11009: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11010: END IF;
11011: IF l_status = 'U' THEN

Line 11014: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

11010: END IF;
11011: IF l_status = 'U' THEN
11012: /* Debug */
11013: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11014: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
11015: l_debug_str := 'Unexpected error in Update_Employment_Info. l_status is U.';
11016: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11017: END IF;
11018: RAISE FND_API.G_EXC_ERROR;

Line 11083: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

11079:
11080: Put_Log_Msg(l_api_name||' ends ',0);
11081: /* Debug */
11082: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11083: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
11084: l_debug_str := 'Returning S from Update_Employment_Info.';
11085: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11086: END IF;
11087: RETURN 'S';

Line 11096: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

11092:
11093: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
11094: /* Debug */
11095: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11096: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
11097: l_debug_str := 'ND_API.G_EXC_ERROR: Returning U from Update_Employment_Info. '||SQLERRM;
11098: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11099: END IF;
11100: RETURN 'U';

Line 11111: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';

11107:
11108: Put_Log_Msg(l_api_name||' OTHERS return U',1);
11109: /* Debug */
11110: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11111: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Employment_Info';
11112: l_debug_str := 'EXCEPTION: Returning U from Update_Employment_Info. '||SQLERRM;
11113: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11114: END IF;
11115:

Line 11151: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';

11147:
11148: Put_Log_Msg(l_api_name||' begins ',0);
11149: /* Debug */
11150: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11151: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';
11152: l_debug_str := 'Entering Update_Conviction_Info. p_person_rec.person_id is '||p_person_rec.person_id;
11153: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11154: END IF;
11155:

Line 11169: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';

11165:
11166: Put_Log_Msg('Validation error occurs ',1);
11167: /* Debug */
11168: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11169: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';
11170: l_debug_str := 'Returning S from Update_Conviction_Info. conv_status is E.';
11171: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11172: END IF;
11173:

Line 11181: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';

11177:
11178: Put_Log_Msg('Unexpected error returned by validation ',1);
11179: /* Debug */
11180: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11181: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';
11182: l_debug_str := 'Unexpected error in Update_Conviction_Info. conv_status is U.';
11183: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11184: END IF;
11185:

Line 11193: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';

11189:
11190: Put_Log_Msg('Convictions block is not found ',0);
11191: /* Debug */
11192: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11193: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';
11194: l_debug_str := 'Returning S from Update_Conviction_Info. conv_status is N.';
11195: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11196: END IF;
11197:

Line 11217: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';

11213:
11214: Put_Log_Msg(l_api_name||' ends ',0);
11215: /* Debug */
11216: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11217: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';
11218: l_debug_str := 'Returning S from Update_Conviction_Info.';
11219: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11220: END IF;
11221:

Line 11231: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';

11227:
11228: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',1);
11229: /* Debug */
11230: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11231: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';
11232: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Conviction_Info. '||SQLERRM;
11233: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11234: END IF;
11235: RETURN 'U';

Line 11246: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';

11242:
11243: Put_Log_Msg(l_api_name||' OTHERS return U',1);
11244: /* Debug */
11245: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11246: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Update_Conviction_Info';
11247: l_debug_str := 'EXCEPTION: Returning U from Update_Conviction_Info. '||SQLERRM;
11248: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11249: END IF;
11250:

Line 11280: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Remove_Person_Data';

11276:
11277: BEGIN
11278: /* Debug */
11279: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11280: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Remove_Person_Data';
11281: l_debug_str := 'Entering Remove_Person_Data. p_person_id is '||p_person_id||' and p_batch_id is '||p_batch_id;
11282: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11283: END IF;
11284: -- Delete from all related tables

Line 11310: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Remove_Person_Data';

11306: DELETE FROM igs_sv_btch_summary WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ); -- prbhardw
11307:
11308: /* Debug */
11309: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11310: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Remove_Person_Data';
11311: l_debug_str := 'Exiting Remove_Person_Data.';
11312: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11313: END IF;
11314:

Line 11356: l_label := 'igs.plsql.igs_sv_batch_process_pkg.EV_Batch_Process';

11352: BEGIN
11353: -- Just call the procedure
11354: /* Debug */
11355: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11356: l_label := 'igs.plsql.igs_sv_batch_process_pkg.EV_Batch_Process';
11357: l_debug_str := 'Entering EV_Batch_Process. p_validate_only is '||p_validate_only;
11358: l_debug_str := l_debug_str || 'l_org_id=' || l_org_id;
11359: l_debug_str := l_debug_str || 'l_dso_id=' || l_dso_id;
11360: l_debug_str := l_debug_str || 'l_dso_party_id=' || l_dso_party_id;

Line 11383: l_label := 'igs.plsql.igs_sv_batch_process_pkg.EV_Batch_Process';

11379:
11380: WHEN OTHERS THEN
11381: /* Debug */
11382: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11383: l_label := 'igs.plsql.igs_sv_batch_process_pkg.EV_Batch_Process';
11384: l_debug_str := 'Exception in EV_Batch_Process. '||SQLERRM;
11385: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11386: END IF;
11387:

Line 11673: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

11669:
11670: BEGIN
11671: /* Debug */
11672: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11673: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
11674: l_debug_str := 'Entering Create_Batch. p_batch_type is '||p_batch_type;
11675: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11676: END IF;
11677:

Line 11684: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

11680: SAVEPOINT Create_Batch;
11681: IF fnd_profile.value('IGS_SV_ENABLED') <> 'Y' THEN
11682: /* Debug */
11683: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11684: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
11685: l_debug_str := 'Raise ERROR: Sevis Disabled';
11686: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11687: END IF;
11688:

Line 11723: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

11719: CLOSE submiter_number_cur;
11720:
11721: /* Debug */
11722: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11723: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
11724: l_debug_str := 'Raise FND_API.G_EXC_ERROR: l_person_sevis_id is null';
11725: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11726: END IF;
11727:

Line 11748: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

11744:
11745: IF l_batch_id IS NOT NULL AND p_validate_only = 'N' THEN
11746: /*Debug*/
11747: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11748: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
11749: l_debug_str := 'Raise ERROR: message name IGS_SV_BATCH_FOUND';
11750: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11751: END IF;
11752:

Line 11842: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

11838:
11839: Put_Log_Msg('Initializing student record',0);
11840: /* Debug */
11841: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11842: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
11843: l_debug_str := 'Setting person values in Create_Batch Person ID '||c_student_list_rec.person_id||' Person No: '||c_student_list_rec.person_number;
11844: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11845: END IF;
11846: -- Initialize record group for the student

Line 11917: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

11913: CLOSE c_get_dso_id;
11914: END IF;
11915: /* Debug */
11916: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11917: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
11918: l_debug_str := 'Inserting in igs_sv_persons batch id: '||l_batch_id;
11919: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11920: END IF;
11921: INSERT INTO igs_sv_persons (

Line 12014: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12010: l_soa_count := l_count;
12011: IF l_student_rec.site_addr_status = 'U' THEN --Unexpected error - terminate execution
12012: /* Debug */
12013: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12014: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12015: l_debug_str := 'Returning U from Create_Batch. site_addr_status is U.';
12016: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12017: END IF;
12018:

Line 12071: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12067: FND_MESSAGE.SET_TOKEN('BLOCK_ID',5);
12068: FND_MSG_PUB.Add;
12069: /* Debug */
12070: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12071: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12072: l_debug_str := 'IGS_SV_UNEXP_EXCPT_ERR in Create_Batch.';
12073: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12074: END IF;
12075:

Line 12169: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12165:
12166: IF l_status <> 'S' THEN
12167: /* Debug */
12168: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12169: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12170: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Employment_Info is not S';
12171: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12172: END IF;
12173: RAISE FND_API.G_EXC_ERROR;

Line 12183: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12179: l_status := Update_Registration_Info ( p_person_rec => l_student_rec );
12180: IF l_status <> 'S' THEN
12181: /* Debug */
12182: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12183: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12184: l_debug_str := 'ERROR in Create_Batch. l_status is not S';
12185: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12186: END IF;
12187:

Line 12198: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12194:
12195: IF l_status <> 'S' THEN
12196: /* Debug */
12197: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12198: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12199: l_debug_str := 'ERROR in Create_Batch. changes_found <> Y and l_status is not S';
12200: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12201: END IF;
12202: RAISE FND_API.G_EXC_ERROR;

Line 12213: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12209:
12210: IF l_status <> 'S' THEN
12211: /* Debug */
12212: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12213: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12214: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Program_Info is not S';
12215: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12216: END IF;
12217:

Line 12230: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12226:
12227: IF l_status <> 'S' THEN
12228: /* Debug */
12229: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12230: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12231: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Finance_Info is not S';
12232: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12233: END IF;
12234: RAISE FND_API.G_EXC_ERROR;

Line 12246: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12242:
12243: IF l_status <> 'S' THEN
12244: /* Debug */
12245: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12246: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12247: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Dependent_Info is not S';
12248: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12249: END IF;
12250: RAISE FND_API.G_EXC_ERROR;

Line 12263: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12259:
12260: IF l_status <> 'S' THEN
12261: /* Debug */
12262: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12263: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12264: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Conviction_Info is not S';
12265: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12266: END IF;
12267: RAISE FND_API.G_EXC_ERROR;

Line 12302: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12298:
12299: IF l_status <> 'S' THEN
12300: /* Debug */
12301: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12302: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12303: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Personal_Info is not S';
12304: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12305: END IF;
12306:

Line 12313: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12309: l_status := Update_ev_legal_Info ( p_person_rec => l_student_rec );
12310: IF l_status <> 'S' THEN
12311: /* Debug */
12312: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12313: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12314: l_debug_str := 'ERROR in Create_Batch. Update_ev_legal_Info status is not S';
12315: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12316: END IF;
12317:

Line 12329: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12325:
12326: IF l_status <> 'S' THEN
12327: /* Debug */
12328: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12329: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12330: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Finance_Info is not S';
12331: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12332: END IF;
12333: RAISE FND_API.G_EXC_ERROR;

Line 12346: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12342:
12343: IF l_status <> 'S' THEN
12344: /* Debug */
12345: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12346: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12347: l_debug_str := 'ERROR in Create_Batch. l_status from Update_EV_Program_Info is not S';
12348: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12349: END IF;
12350: RAISE FND_API.G_EXC_ERROR;

Line 12363: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12359:
12360: IF l_status <> 'S' THEN
12361: /* Debug */
12362: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12363: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12364: l_debug_str := 'ERROR in Create_Batch. l_status from Update_EV_Address_Info is not S';
12365: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12366: END IF;
12367: RAISE FND_API.G_EXC_ERROR;

Line 12380: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12376:
12377: IF l_status <> 'S' THEN
12378: /* Debug */
12379: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12380: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12381: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Dependent_Info is not S';
12382: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12383: END IF;
12384: RAISE FND_API.G_EXC_ERROR;

Line 12497: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12493:
12494: END IF;
12495: /* Debug */
12496: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12497: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12498: l_debug_str := 'Commiting in Create_Batch. l_batch_status: '||l_batch_status;
12499: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12500: END IF;
12501: compose_log_file;

Line 12512: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12508:
12509: WHEN FND_API.G_EXC_ERROR THEN
12510: /* Debug */
12511: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12512: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12513: l_debug_str := 'FND_API.G_EXC_ERROR exception in Create_Batch. '||SQLERRM;
12514: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12515: END IF;
12516: ROLLBACK TO Create_Batch;

Line 12530: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';

12526: WHEN OTHERS THEN
12527:
12528: /* Debug */
12529: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12530: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Create_Batch';
12531: l_debug_str := 'Other exception in Create_Batch. '||SQLERRM;
12532: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12533: END IF;
12534: ROLLBACK TO Create_Batch;

Line 12588: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Batch_Process';

12584:
12585: BEGIN
12586: /* Debug */
12587: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12588: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Batch_Process';
12589: l_debug_str := 'Entering NIMG_Batch_Process.';
12590: l_debug_str := l_debug_str || 'l_org_id=' || l_org_id;
12591: l_debug_str := l_debug_str || 'l_dso_id=' || l_dso_id;
12592: l_debug_str := l_debug_str || 'l_dso_party_id=' || l_dso_party_id;

Line 12620: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Batch_Process';

12616: WHEN OTHERS THEN
12617:
12618: /* Debug */
12619: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12620: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Batch_Process';
12621: l_debug_str := 'Exception in NIMG_Batch_Process. '||SQLERRM;
12622: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12623: END IF;
12624:

Line 12676: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Purge_Batch';

12672: BEGIN
12673:
12674: /* Debug */
12675: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12676: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Purge_Batch';
12677: l_debug_str := 'Entering Purge_Batch. p_batch_type is '||p_batch_type;
12678: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12679: END IF;
12680: FND_MSG_PUB.initialize;

Line 12720: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Batch_Process';

12716:
12717: retcode := 0;
12718: /* Debug */
12719: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12720: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Batch_Process';
12721: l_debug_str := 'retcode in NIMG_Batch_Process: '||retcode;
12722: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12723: END IF;
12724: EXCEPTION

Line 12730: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Batch_Process';

12726: WHEN FND_API.G_EXC_ERROR THEN
12727:
12728: /* Debug */
12729: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12730: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Batch_Process';
12731: l_debug_str := 'FND_API.G_EXC_ERROR Exception in NIMG_Batch_Process. '||SQLERRM;
12732: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12733: END IF;
12734: ROLLBACK TO Purge_Batch;

Line 12744: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Batch_Process';

12740: WHEN OTHERS THEN
12741:
12742: /* Debug */
12743: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12744: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Batch_Process';
12745: l_debug_str := 'Exception in NIMG_Batch_Process. '||SQLERRM;
12746: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12747: END IF;
12748: ROLLBACK TO Purge_Batch;

Line 12790: l_label := 'igs.plsql.igs_sv_batch_process_pkg.EV_Purge_Batch';

12786:
12787: BEGIN
12788: /* Debug */
12789: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12790: l_label := 'igs.plsql.igs_sv_batch_process_pkg.EV_Purge_Batch';
12791: l_debug_str := 'Entering EV_Purge_Batch.';
12792: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12793: END IF;
12794: -- Just call the procedure

Line 12806: l_label := 'igs.plsql.igs_sv_batch_process_pkg.EV_Purge_Batch';

12802:
12803: WHEN OTHERS THEN
12804: /* Debug */
12805: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12806: l_label := 'igs.plsql.igs_sv_batch_process_pkg.EV_Purge_Batch';
12807: l_debug_str := 'EXCEPTION in EV_Purge_Batch. '||SQLERRM;
12808: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12809: END IF;
12810: retcode := 2;

Line 12851: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Purge_Batch';

12847: BEGIN
12848:
12849: /* Debug */
12850: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12851: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Purge_Batch';
12852: l_debug_str := 'Entering NIMG_Purge_Batch.';
12853: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12854: END IF;
12855: -- Just call the procedure

Line 12869: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Purge_Batch';

12865:
12866: WHEN OTHERS THEN
12867: /* Debug */
12868: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12869: l_label := 'igs.plsql.igs_sv_batch_process_pkg.NIMG_Purge_Batch';
12870: l_debug_str := 'EXCEPTION in NIMG_Purge_Batch. '||SQLERRM;
12871: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12872: END IF;
12873: ROLLBACK TO NIMG_Purge_Batch;

Line 12910: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Generate_Message';

12906:
12907: BEGIN
12908: /* Debug */
12909: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12910: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Generate_Message';
12911: l_debug_str := 'Entering Generate_Message.';
12912: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12913: END IF;
12914: FND_MSg_PUB.Count_And_Get ( p_count => l_msg_count,

Line 12935: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Generate_Message';

12931:
12932: END IF;
12933: /* Debug */
12934: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12935: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Generate_Message';
12936: l_debug_str := 'Exiting Generate_Message. l_msg_data is: '||l_msg_data;
12937: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12938: END IF;
12939: END Generate_Message;

Line 13000: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_person_record';

12996:
12997: BEGIN
12998: /* Debug */
12999: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13000: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_person_record';
13001: l_debug_str := 'Entering process_person_record. p_sevisID is: '||p_sevisID||' and p_person_id is: '||p_person_id;
13002: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13003: END IF;
13004:

Line 13074: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_person_record';

13070:
13071: END IF;
13072: /* Debug */
13073: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13074: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_person_record';
13075: l_debug_str := 'Exiting process_person_record';
13076: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13077: END IF;
13078:

Line 13111: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_trans_header';

13107:
13108: BEGIN
13109:
13110: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13111: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_trans_header';
13112: l_debug_str := 'Came in with p_BatchID = '||p_BatchID||' p_FileErrorCode = '||p_FileErrorCode ||' p_FileValidation = '||p_FileValidation||' '||SQLERRM;
13113: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13114: END IF;
13115:

Line 13164: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_trans_header';

13160: EXCEPTION
13161: WHEN FND_API.G_EXC_ERROR THEN
13162: /* Debug */
13163: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13164: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_trans_header';
13165: l_debug_str := 'FND_API.G_EXC_ERROR in process_trans_header '||SQLERRM;
13166: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13167: END IF;
13168: ROLLBACK TO process_trans_header;

Line 13172: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_trans_header';

13168: ROLLBACK TO process_trans_header;
13169: WHEN OTHERS THEN
13170: /* Debug */
13171: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13172: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_trans_header';
13173: l_debug_str := 'Exiting process_trans_header '||SQLERRM;
13174: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13175: END IF;
13176: ROLLBACK TO process_trans_header;

Line 13222: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_student_record';

13218:
13219: BEGIN
13220:
13221: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13222: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_student_record';
13223: l_debug_str := 'Came in with p_BatchID = '||p_BatchID||' p_sevisID = '||p_sevisID
13224: ||' p_PersonID = '||p_PersonID|| ' p_Status = '||p_Status
13225: ||' p_SEVIS_ErrorCode = '||p_SEVIS_ErrorCode||' p_SEVIS_ErrorElement = '||p_SEVIS_ErrorElement||' '||SQLERRM;
13226: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 13303: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_dep_record';

13299:
13300:
13301: BEGIN
13302: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13303: l_label := 'igs.plsql.igs_sv_batch_process_pkg.process_dep_record';
13304: l_debug_str := 'Came in with p_BatchID = '||p_BatchID||' p_DepPersonID = '||p_DepPersonID
13305: ||' p_DepSevisID = '||p_DepSevisID||' p_PersonID = '||p_PersonID
13306: || ' p_Status = '||p_Status||' p_SEVIS_ErrorCode = '
13307: ||p_SEVIS_ErrorCode||' p_SEVIS_ErrorElement = '||p_SEVIS_ErrorElement||' '||SQLERRM;

Line 13381: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Summary_Info';

13377: l_batch NUMBER(20) := 0;
13378: BEGIN
13379: /* Debug */
13380: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13381: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Summary_Info';
13382: l_debug_str := 'Entering Insert_Summary_Info. p_data_rec.person_id is '||p_person_id|| ' and batch_id is '||p_batch_id;
13383: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13384: END IF;
13385:

Line 13422: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Summary_Info';

13418: FETCH c_test INTO l_batch;
13419: CLOSE c_test;
13420: /* Debug */
13421: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13422: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Summary_Info';
13423: l_debug_str := 'record in Insert_Summary_Info max batch_id: '||l_batch;
13424: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13425: END IF;
13426: EXCEPTION

Line 13434: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Summary_Info';

13430: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13431: END IF;
13432: /* Debug */
13433: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13434: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Insert_Summary_Info';
13435: l_debug_str := 'EXCEPTION in Insert_Summary_Info. '||SQLERRM;
13436: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13437: END IF;
13438: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 13474: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Generate_Batch_XML';

13470: BEGIN
13471: retcode := 0;
13472: /* Debug */
13473: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13474: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Generate_Batch_XML';
13475: l_debug_str := 'Batch_id for Generate_Batch_XML: '||batch_id;
13476: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13477: END IF;
13478: Put_Log_Msg('Batch id for Generate Batch XML: '||batch_id, 0);

Line 13496: fnd_message.set_token ('NAME', 'igs_sv_batch_process_pkg.Generate_Batch_XML'|| '-' || SQLERRM);

13492: WHEN OTHERS THEN
13493: ROLLBACK;
13494: retcode := 2;
13495: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
13496: fnd_message.set_token ('NAME', 'igs_sv_batch_process_pkg.Generate_Batch_XML'|| '-' || SQLERRM);
13497: igs_ge_msg_stack.conc_exception_hndl;
13498: END Generate_Batch_XML;
13499:
13500:

Line 13606: l_label := 'igs.plsql.igs_sv_batch_process_pkg.xml_log_file';

13602: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13603: END IF;
13604: /* Debug */
13605: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13606: l_label := 'igs.plsql.igs_sv_batch_process_pkg.xml_log_file';
13607: l_debug_str := 'EXCEPTION in xml_log_file.'||SQLERRM;
13608: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13609: END IF;
13610: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 13787: l_label := 'igs.plsql.igs_sv_batch_process_pkg.compose_log_file';

13783: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
13784: END IF;
13785: /* Debug */
13786: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13787: l_label := 'igs.plsql.igs_sv_batch_process_pkg.compose_log_file';
13788: l_debug_str := 'EXCEPTION in compose_log_file.'||SQLERRM;
13789: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13790: END IF;
13791: Put_Log_Msg(l_api_name||' OTHERS ERROR ',1);

Line 13913: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Assign_DSO';

13909: lv_last_update_date := SYSDATE;
13910: lv_object_version_number := 1;
13911: /* Debug */
13912: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13913: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Assign_DSO';
13914: l_debug_str := 'p_group_type: '||p_group_type||' p_old_dso_id: '||p_old_dso_id||' p_new_dso_id: '||p_new_dso_id||' p_group_id: '||p_group_id;
13915: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13916: END IF;
13917: Put_Log_Msg('group type: '||p_group_type||'; old dso id: '||p_old_dso_id||'; new dso id: '||p_new_dso_id||'; group id: '||p_group_id, 0);

Line 13938: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Assign_DSO';

13934: END IF;
13935:
13936: /* Debug */
13937: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
13938: l_label := 'igs.plsql.igs_sv_batch_process_pkg.Assign_DSO';
13939: l_debug_str := 'Query: '||l_str;
13940: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
13941: END IF;
13942:

Line 14204: fnd_message.set_token ('NAME', 'igs_sv_batch_process_pkg.Assign_DSO'|| '-' || SQLERRM);

14200: WHEN FND_API.G_EXC_ERROR THEN
14201: ROLLBACK;
14202: retcode := 2;
14203: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
14204: fnd_message.set_token ('NAME', 'igs_sv_batch_process_pkg.Assign_DSO'|| '-' || SQLERRM);
14205: igs_ge_msg_stack.conc_exception_hndl;
14206: WHEN OTHERS THEN
14207: ROLLBACK;
14208: retcode := 2;

Line 14210: fnd_message.set_token ('NAME', 'igs_sv_batch_process_pkg.Assign_DSO'|| '-' || SQLERRM);

14206: WHEN OTHERS THEN
14207: ROLLBACK;
14208: retcode := 2;
14209: fnd_message.set_name ('IGS', 'IGS_GE_UNHANDLED_EXP');
14210: fnd_message.set_token ('NAME', 'igs_sv_batch_process_pkg.Assign_DSO'|| '-' || SQLERRM);
14211: igs_ge_msg_stack.conc_exception_hndl;
14212: END Assign_DSO;
14213:
14214: END igs_sv_batch_process_pkg;

Line 14214: END igs_sv_batch_process_pkg;

14210: fnd_message.set_token ('NAME', 'igs_sv_batch_process_pkg.Assign_DSO'|| '-' || SQLERRM);
14211: igs_ge_msg_stack.conc_exception_hndl;
14212: END Assign_DSO;
14213:
14214: END igs_sv_batch_process_pkg;