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_NI_BATCH_PROCESS_PKG dependencies on IGS_SV_NI_BATCH_PROCESS_PKG

Line 1: PACKAGE BODY igs_sv_ni_batch_process_pkg AS

1: PACKAGE BODY igs_sv_ni_batch_process_pkg AS
2: /* $Header: IGSSV03B.pls 120.1 2006/05/31 10:01:26 vskumar noship $ */
3:
4: /******************************************************************
5:

Line 41: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGS_SV_NI_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_NI_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_ni_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_ni_batch_process_pkg';
59: l_label VARCHAR2(4000);
60: l_debug_str VARCHAR2(32000);
61: g_person_status VARCHAR2(6) := 'NEW';
62: g_nonimg_form_id NUMBER(15);

Line 198: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Submit_Event';

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

Line 223: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Submit_Event';

219:
220: IF l_party_id IS NULL THEN
221: /* Debug */
222: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
223: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Submit_Event';
224: l_debug_str := 'IGS_SV_PRTNR_STP_ERR error in Submit_Event.';
225: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
226: END IF;
227:

Line 241: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.event_parameters';

237:
238: l_event_key := p_batch_id || l_con_req_id;
239:
240: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
241: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.event_parameters';
242: 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 ;
243: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
244: END IF;
245: /* Manoj

Line 277: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Submit_Event';

273: l_parameter_list.DELETE;
274:
275: /* Debug */
276: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
277: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Submit_Event';
278: l_debug_str := 'Exiting Submit_Event. l_event_key: '||l_event_key;
279: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
280: END IF;
281:

Line 305: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Dump_Current_Person';

301:
302: BEGIN
303: /* Debug */
304: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
305: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Dump_Current_Person';
306: l_debug_str := 'Entering Dump_Current_Person. p_student_rec.person_id is '|| p_student_rec.person_id;
307: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
308: END IF;
309:

Line 336: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Dump_Current_Person';

332:
333: Put_Log_Msg('********************************************************',0);
334: /* Debug */
335: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
336: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Dump_Current_Person';
337: l_debug_str := 'Exiting Dump_Current_Person.';
338: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
339: END IF;
340: END Dump_Current_Person;

Line 391: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_School_Sevis_Id';

387:
388: BEGIN
389: /* Debug
390: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
391: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_School_Sevis_Id';
392: l_debug_str := 'Entering Get_School_Sevis_Id. p_batch_type is '|| p_batch_type;
393: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
394: END IF;
395:

Line 404: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_School_Sevis_Id';

400: CLOSE c_alt_id;
401:
402: /* Debug
403: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
404: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_School_Sevis_Id';
405: l_debug_str := 'Exiting Get_School_Sevis_Id with return value '|| l_alt_id;
406: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
407: END IF;
408:

Line 490: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Is_Number';

486:
487: BEGIN
488: /* Debug */
489: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
490: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Is_Number';
491: l_debug_str := 'Entering Is_Number. p_num is '|| p_num;
492: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
493: END IF;
494:

Line 502: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Is_Number';

498:
499: WHEN VALUE_ERROR THEN
500: /* Debug */
501: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
502: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Is_Number';
503: l_debug_str := 'Exception in Is_Number'||SQLERRM;
504: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
505: END IF;
506:

Line 544: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Lookup_Name';

540:
541: BEGIN
542: /* Debug */
543: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
544: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Lookup_Name';
545: l_debug_str := 'Entering Get_Lookup_Name. p_type is '||p_type ||' and p_code is '|| p_code;
546: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
547: END IF;
548:

Line 555: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Lookup_Name';

551: CLOSE c_blk_name;
552:
553: /* Debug */
554: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
555: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Lookup_Name';
556: l_debug_str := 'Returning from Get_Lookup_Name with value '||l_block_name;
557: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
558: END IF;
559:

Line 597: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Convert_Country_Code';

593:
594: BEGIN
595: /* Debug */
596: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
597: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Convert_Country_Code';
598: l_debug_str := 'Entering Convert_Country_Code. p_code is '||p_code;
599: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
600: END IF;
601:

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

604: CLOSE c_blk_name;
605:
606: /* Debug */
607: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
608: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Convert_Country_Code';
609: l_debug_str := 'Returning from Convert_Country_Code with value '|| l_block_name;
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:

Line 656: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Convert_Visa_Type';

652:
653: BEGIN
654: /* Debug */
655: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
656: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Convert_Visa_Type';
657: l_debug_str := 'Entering Convert_Visa_Type. p_visa_meaning is '||p_visa_meaning;
658: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
659: END IF;
660:

Line 669: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Convert_Visa_Type';

665:
666: CLOSE c_visa_type;
667: /* Debug */
668: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
669: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Convert_Visa_Type';
670: l_debug_str := 'Returning from Convert_Visa_Type with value '|| l_sv_visa_code;
671: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
672: END IF;
673:

Line 713: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Convert_Suffix';

709:
710: BEGIN
711: /* Debug */
712: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
713: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Convert_Suffix';
714: l_debug_str := 'Entering Convert_Suffix. p_person_num is '||p_person_num || ', p_code is '||p_code||' and p_type is '||p_type;
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 736: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Convert_Suffix';

732: CLOSE c_name_suffix;
733:
734: /* Debug */
735: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
736: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Convert_Suffix';
737: l_debug_str := 'Returning from Convert_Suffix with value '|| l_name_suffix;
738: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
739: END IF;
740:

Line 766: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Block_Name';

762:
763: BEGIN
764: /* Debug */
765: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
766: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Block_Name';
767: l_debug_str := 'Inside Get_Block_Name. p_block is '||p_block;
768: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
769: END IF;
770:

Line 809: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Person_Sevis_Id';

805:
806: BEGIN
807: /* Debug */
808: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
809: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Person_Sevis_Id';
810: l_debug_str := 'Entering Get_Person_Sevis_Id. p_person_id is '||p_person_id;
811: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
812: END IF;
813:

Line 823: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Person_Sevis_Id';

819: IF l_alt_id IS NOT NULL AND LENGTH(l_alt_id)<=11 THEN
820:
821: /* Debug */
822: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
823: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Person_Sevis_Id';
824: l_debug_str := 'Returning from Get_Person_Sevis_Id with value '||l_alt_id;
825: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
826: END IF;
827:

Line 833: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Person_Sevis_Id';

829:
830: END IF;
831: /* Debug */
832: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
833: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Person_Sevis_Id';
834: l_debug_str := 'Returning from Get_Person_Sevis_Id ';
835: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
836: END IF;
837:

Line 864: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Check_US_Terr';

860:
861: BEGIN
862: /* Debug */
863: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
864: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Check_US_Terr';
865: l_debug_str := 'Entering Check_US_Terr. p_person_num is '||p_person_num ||' and p_code is '||p_code;
866: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
867: END IF;
868:

Line 883: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Check_US_Terr';

879:
880: CLOSE c_name;
881: /* Debug */
882: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
883: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Check_US_Terr';
884: l_debug_str := 'Returning E from Check_US_Terr ';
885: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
886: END IF;
887:

Line 896: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Check_US_Terr';

892: CLOSE c_name;
893:
894: /* Debug */
895: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
896: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Check_US_Terr';
897: l_debug_str := 'Returning S from Check_US_Terr ';
898: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
899: END IF;
900:

Line 979: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';

975: BEGIN
976:
977: /* Debug */
978: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
979: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';
980: 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;
981: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
982: END IF;
983:

Line 1018: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';

1014: p_data_rec.adjudicated_flag := c_data_rec.adjudicated_flag;
1015:
1016: /* Debug */
1017: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1018: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';
1019: l_debug_str := 'Exiting from for loop of Validate_Issue_Info';
1020: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1021: END IF;
1022:

Line 1058: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';

1054: p_data_rec.no_show_flag := c_data_rec.no_show_flag;
1055:
1056: /* Debug */
1057: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1058: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';
1059: l_debug_str := 'Exiting from for loop of Validate_Issue_Info';
1060: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1061: END IF;
1062: EXIT; -- one record is enough

Line 1075: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';

1071:
1072: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
1073: /* Debug */
1074: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1075: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';
1076: l_debug_str := 'Returning N from Validate_Issue_Info';
1077: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1078: END IF;
1079:

Line 1170: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';

1166:
1167: Put_Log_Msg(l_api_name||' Validation error, return E ',0);
1168: /* Debug */
1169: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1170: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';
1171: l_debug_str := 'Returning E from Validate_Issue_Info';
1172: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1173: END IF;
1174:

Line 1184: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';

1180:
1181: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
1182: /* Debug */
1183: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1184: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';
1185: l_debug_str := 'Returning S from Validate_Issue_Info';
1186: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1187: END IF;
1188:

Line 1196: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';

1192:
1193: WHEN OTHERS THEN
1194: /* Debug */
1195: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1196: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Issue_Info';
1197: l_debug_str := 'Exception in Validate_Issue_Info'||SQLERRM;
1198: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1199: END IF;
1200:

Line 1241: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Name';

1237: returnVal boolean := false;
1238: BEGIN
1239: /* Debug */
1240: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1241: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Name';
1242: l_debug_str := 'Inside Validate_Name. p_Name is '|| p_Name;
1243: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1244: END IF;
1245:

Line 1254: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Name';

1250: END IF;
1251: END LOOP;
1252: /* Debug */
1253: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1254: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Name';
1255: l_debug_str := 'Returning from Validate_Name';
1256: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1257: END IF;
1258:

Line 1348: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Bio_Info';

1344: -- 05 M-2
1345: -- 06 J-2
1346: /* Debug */
1347: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1348: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Bio_Info';
1349: 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;
1350: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1351: END IF;
1352:

Line 1469: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Bio_Info';

1465:
1466: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
1467: /* Debug */
1468: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1469: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Bio_Info';
1470: l_debug_str := 'Returning N from Validate_Bio_Info.';
1471: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1472: END IF;
1473:

Line 1562: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Bio_Info';

1558:
1559: Put_Log_Msg(l_api_name||' Validation error, return E ',0);
1560: /* Debug */
1561: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1562: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Bio_Info';
1563: l_debug_str := 'Returning E from Validate_Bio_Info.';
1564: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1565: END IF;
1566: RETURN 'E';

Line 1575: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Bio_Info';

1571:
1572: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
1573: /* Debug */
1574: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1575: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Bio_Info';
1576: l_debug_str := 'Returning S from Validate_Bio_Info.';
1577: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1578: END IF;
1579:

Line 1587: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Bio_Info';

1583:
1584: WHEN OTHERS THEN
1585: /* Debug */
1586: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1587: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Bio_Info';
1588: l_debug_str := 'Exception in Validate_Bio_Info.'||SQLERRM;
1589: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1590: END IF;
1591:

Line 1658: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Other_Info';

1654:
1655: BEGIN
1656: /* Debug */
1657: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1658: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Other_Info';
1659: l_debug_str := 'Entering Validate_Other_Info. Batch_id is '||p_person_rec.batch_id||' and person_id is '||p_person_rec.person_id;
1660: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1661: END IF;
1662: Put_Log_Msg(l_api_name||' starts ',0);

Line 1773: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Other_Info';

1769:
1770: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
1771: /* Debug */
1772: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1773: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Other_Info';
1774: l_debug_str := 'Returning N from Validate_Other_Info.';
1775: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1776: END IF;
1777: RETURN 'N';

Line 1786: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Other_Info';

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

Line 1800: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Other_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_ni_batch_process_pkg.Validate_Other_Info';
1801: l_debug_str := 'Returning S from Validate_Other_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_ni_batch_process_pkg.Validate_Other_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_ni_batch_process_pkg.Validate_Other_Info';
1813: l_debug_str := 'Exception in Validate_Other_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 1885: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_F_Addr_Info';

1881:
1882: Put_Log_Msg(l_api_name||' Starts ',0);
1883: /* Debug */
1884: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1885: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_F_Addr_Info';
1886: 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;
1887: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1888: END IF;
1889:

Line 1918: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_F_Addr_Info';

1914: 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);
1915:
1916: /* Debug */
1917: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1918: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_F_Addr_Info';
1919: l_debug_str := 'Exiting from for loop in Validate_F_Addr_Info.';
1920: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1921: END IF;
1922:

Line 1934: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_F_Addr_Info';

1930:
1931: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
1932: /* Debug */
1933: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1934: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_F_Addr_Info';
1935: l_debug_str := 'Returning N from Validate_F_Addr_Info.';
1936: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1937: END IF;
1938: RETURN 'N';

Line 1962: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_F_Addr_Info';

1958:
1959: Put_Log_Msg(l_api_name||' Validation error, return E ',0);
1960: /* Debug */
1961: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1962: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_F_Addr_Info';
1963: l_debug_str := 'Returning E from Validate_F_Addr_Info.';
1964: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1965: END IF;
1966:

Line 1974: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_F_Addr_Info';

1970:
1971: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
1972: /* Debug */
1973: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1974: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_F_Addr_Info';
1975: l_debug_str := 'Returning S from Validate_F_Addr_Info.';
1976: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1977: END IF;
1978:

Line 1986: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_F_Addr_Info';

1982:
1983: WHEN OTHERS THEN
1984: /* Debug */
1985: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
1986: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_F_Addr_Info';
1987: l_debug_str := 'Exception in Validate_F_Addr_Info.'||SQLERRM;
1988: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
1989: END IF;
1990:

Line 2058: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_US_Addr_Info';

2054:
2055: BEGIN
2056: /* Debug */
2057: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2058: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_US_Addr_Info';
2059: 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;
2060: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2061: END IF;
2062: Put_Log_Msg(l_api_name||' Starts ',0);

Line 2091: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_US_Addr_Info';

2087: p_data_rec(l_counter).last_update_login := g_update_login;
2088:
2089: /* Debug */
2090: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2091: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_US_Addr_Info';
2092: l_debug_str := 'exiting from for loop in Validate_US_Addr_Info.';
2093: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2094: END IF;
2095:

Line 2105: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_US_Addr_Info';

2101:
2102: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
2103: /* Debug */
2104: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2105: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_US_Addr_Info';
2106: l_debug_str := 'Returning N from Validate_US_Addr_Info. ';
2107: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2108: END IF;
2109:

Line 2131: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_US_Addr_Info';

2127:
2128: Put_Log_Msg(l_api_name||' Validation error, return E ',0);
2129: /* Debug */
2130: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2131: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_US_Addr_Info';
2132: l_debug_str := 'Returning E from Validate_US_Addr_Info. ';
2133: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2134: END IF;
2135:

Line 2146: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_US_Addr_Info';

2142:
2143: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
2144: /* Debug */
2145: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2146: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_US_Addr_Info';
2147: l_debug_str := 'Returning S from Validate_US_Addr_Info. ';
2148: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2149: END IF;
2150:

Line 2158: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_US_Addr_Info';

2154:
2155: WHEN OTHERS THEN
2156: /* Debug */
2157: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2158: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_US_Addr_Info';
2159: l_debug_str := 'Exception in Validate_US_Addr_Info. '||SQLERRM;
2160: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2161: END IF;
2162:

Line 2290: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Edu_Info

2286:
2287: BEGIN
2288: /* Debug */
2289: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2290: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Edu_Info
2291: ';
2292: 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;
2293: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2294: END IF;

Line 2386: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Edu_Info';

2382:
2383: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
2384: /* Debug */
2385: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2386: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Edu_Info';
2387: l_debug_str := 'Returning N from Validate_Edu_Info.';
2388: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2389: END IF;
2390:

Line 2463: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Edu_Info';

2459:
2460: Put_Log_Msg(l_api_name||' Validation error, return E ',0);
2461: /* Debug */
2462: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2463: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Edu_Info';
2464: l_debug_str := 'Returning E from Validate_Edu_Info.';
2465: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2466: END IF;
2467: RETURN 'E';

Line 2476: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Edu_Info';

2472:
2473: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
2474: /* Debug */
2475: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2476: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Edu_Info';
2477: l_debug_str := 'Returning S from Validate_Edu_Info.';
2478: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2479: END IF;
2480:

Line 2488: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Edu_Info';

2484:
2485: WHEN OTHERS THEN
2486: /* Debug */
2487: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2488: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Edu_Info';
2489: l_debug_str := 'Exception in Validate_Edu_Info.'||SQLERRM;
2490: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2491: END IF;
2492:

Line 2578: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Othr_Prgm_Info';

2574: BEGIN
2575:
2576: /* Debug */
2577: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2578: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Othr_Prgm_Info';
2579: l_debug_str := 'Entering Get_Othr_Prgm_Info. form_id is '||g_nonimg_form_id ||' and person_id is '||p_data_rec.person_id;
2580: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2581: END IF;
2582:

Line 2645: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Othr_Prgm_Info';

2641:
2642: WHEN OTHERS THEN
2643: /* Debug */
2644: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2645: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Othr_Prgm_Info';
2646: l_debug_str := 'Exception in Get_Othr_Prgm_Info.'||SQLERRM;
2647: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2648: END IF;
2649:

Line 2803: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';

2799: BEGIN
2800:
2801: /* Debug */
2802: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2803: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';
2804: 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;
2805: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2806: END IF;
2807:

Line 2941: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';

2937:
2938:
2939: /* Debug */
2940: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
2941: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';
2942: l_debug_str := 'Exiting from for loop in Validate_Prgm_Info.';
2943: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
2944: END IF;
2945:

Line 3029: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';

3025: IF l_not_valid THEN
3026: Put_Log_Msg(l_api_name||' Validation error, return E ',0);
3027: /* Debug */
3028: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3029: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';
3030: l_debug_str := 'Returning E from Validate_Prgm_Info.';
3031: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3032: END IF;
3033:

Line 3064: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';

3060: p_data_rec(l_counter).end_prgm_reason := c_data_rec.end_program_reason ;
3061: p_data_rec(l_counter).remarks := c_data_rec.remarks ;
3062: /* Debug */
3063: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3064: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';
3065: l_debug_str := 'Exiting from for loop in Validate_Prgm_Info.';
3066: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3067: END IF;
3068:

Line 3170: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';

3166: IF l_not_valid THEN
3167: Put_Log_Msg(l_api_name||' Validation error, return E ',0);
3168: /* Debug */
3169: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3170: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';
3171: l_debug_str := 'Returning E from Validate_Prgm_Info.';
3172: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3173: END IF;
3174:

Line 3187: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';

3183: IF l_counter = 0 THEN
3184: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
3185: /* Debug */
3186: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3187: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';
3188: l_debug_str := 'Returning N from validate_empl_Info.';
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: RETURN 'N';

Line 3198: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';

3194:
3195: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
3196: /* Debug */
3197: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3198: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';
3199: l_debug_str := 'Returning S from Validate_Prgm_Info.';
3200: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3201: END IF;
3202:

Line 3210: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';

3206:
3207: WHEN OTHERS THEN
3208: /* Debug */
3209: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3210: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Prgm_Info';
3211: l_debug_str := 'Exception in Validate_Prgm_Info.'||SQLERRM;
3212: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3213: END IF;
3214:

Line 3335: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Finance_Info';

3331:
3332: Put_Log_Msg(l_api_name||' starts ',0);
3333: /* Debug */
3334: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3335: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Finance_Info';
3336: 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;
3337: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3338: END IF;
3339:

Line 3465: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Finance_Info';

3461:
3462: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
3463: /* Debug */
3464: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3465: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Finance_Info';
3466: l_debug_str := 'Returning N from Validate_Finance_Info.';
3467: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3468: END IF;
3469:

Line 3552: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Finance_Info';

3548:
3549: Put_Log_Msg(l_api_name||' Validation error, return E ',0);
3550: /* Debug */
3551: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3552: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Finance_Info';
3553: l_debug_str := 'Returning E from Validate_Finance_Info.';
3554: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3555: END IF;
3556:

Line 3567: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Finance_Info';

3563:
3564: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
3565: /* Debug */
3566: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3567: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Finance_Info';
3568: l_debug_str := 'Returning S from Validate_Finance_Info.';
3569: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3570: END IF;
3571:

Line 3580: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Finance_Info';

3576:
3577: WHEN OTHERS THEN
3578: /* Debug */
3579: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3580: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Finance_Info';
3581: l_debug_str := 'Exception in Validate_Finance_Info. '||SQLERRM;
3582: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3583: END IF;
3584:

Line 3681: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';

3677:
3678: Put_Log_Msg(l_api_name||' starts ',0);
3679: /* Debug */
3680: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3681: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';
3682: 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;
3683: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3684: END IF;
3685:

Line 3741: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';

3737:
3738: Put_Log_Msg('Validation error occurs ',0);
3739: /* Debug */
3740: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3741: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';
3742: l_debug_str := 'Returning E from Validate_Dependent_Info.';
3743: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3744: END IF;
3745:

Line 3753: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';

3749:
3750: Put_Log_Msg('Dependent not found by Validate procedure ',0);
3751: /* Debug */
3752: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3753: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';
3754: l_debug_str := 'IGS_SV_UNEXP_EXCPT_ERR Error in Validate_Dependent_Info.';
3755: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3756: END IF;
3757:

Line 3788: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';

3784: IF p_person_rec.record_status = 'C' THEN
3785:
3786: /* Debug */
3787: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3788: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';
3789: l_debug_str := 'Exiting from for loop in Validate_Dependent_Info.';
3790: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3791: END IF;
3792:

Line 3805: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';

3801:
3802: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
3803: /* Debug */
3804: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3805: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';
3806: l_debug_str := 'Returning N from Validate_Dependent_Info.';
3807: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3808: END IF;
3809:

Line 3819: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';

3815:
3816: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
3817: /* Debug */
3818: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3819: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';
3820: l_debug_str := 'Returning S from Validate_Dependent_Info.';
3821: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3822: END IF;
3823:

Line 3831: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';

3827:
3828: WHEN OTHERS THEN
3829: /* Debug */
3830: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3831: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Dependent_Info';
3832: l_debug_str := 'Exception in Validate_Dependent_Info. '||SQLERRM;
3833: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3834: END IF;
3835:

Line 3899: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Convictions_Info';

3895: l_not_valid BOOLEAN := FALSE;
3896: BEGIN
3897: /* Debug */
3898: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3899: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Convictions_Info';
3900: 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;
3901: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3902: END IF;
3903:

Line 3935: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Convictions_Info';

3931:
3932: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
3933: /* Debug */
3934: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3935: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Convictions_Info';
3936: l_debug_str := 'Returning N from Validate_Convictions_Info';
3937: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3938: END IF;
3939:

Line 3952: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Convictions_Info';

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

Line 3964: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Convictions_Info';

3960:
3961: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
3962: /* Debug */
3963: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3964: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Convictions_Info';
3965: l_debug_str := 'Returning S from Validate_Convictions_Info';
3966: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3967: END IF;
3968:

Line 3976: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Convictions_Info';

3972:
3973: WHEN OTHERS THEN
3974: /* Debug */
3975: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
3976: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Convictions_Info';
3977: l_debug_str := 'Exception in Validate_Convictions_Info '||SQLERRM;
3978: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
3979: END IF;
3980:

Line 4059: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Legal_Info';

4055:
4056: BEGIN
4057: /* Debug */
4058: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4059: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Legal_Info';
4060: 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;
4061: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4062: END IF;
4063:

Line 4120: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Legal_Info';

4116:
4117: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
4118: /* Debug */
4119: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4120: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Legal_Info';
4121: l_debug_str := 'Returning N from Validate_Legal_Info.';
4122: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4123: END IF;
4124: RETURN 'N';

Line 4131: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Legal_Info';

4127:
4128: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
4129: /* Debug */
4130: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4131: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Legal_Info';
4132: l_debug_str := 'Returning S from Validate_Legal_Info.';
4133: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4134: END IF;
4135: RETURN 'S'; -- Successfull validation

Line 4142: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Legal_Info';

4138:
4139: WHEN OTHERS THEN
4140: /* Debug */
4141: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4142: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Legal_Info';
4143: l_debug_str := 'Exception in Validate_Legal_Info. '||SQLERRM;
4144: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4145: END IF;
4146:

Line 4205: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_ev_Legal_Info';

4201:
4202: BEGIN
4203: /* Debug */
4204: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4205: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_ev_Legal_Info';
4206: 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;
4207: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4208: END IF;
4209:

Line 4266: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_ev_Legal_Info';

4262:
4263: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
4264: /* Debug */
4265: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4266: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_ev_Legal_Info';
4267: l_debug_str := 'Returning N from Validate_ev_Legal_Info.';
4268: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4269: END IF;
4270: RETURN 'N';

Line 4277: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_ev_Legal_Info';

4273:
4274: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
4275: /* Debug */
4276: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4277: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_ev_Legal_Info';
4278: l_debug_str := 'Returning S from Validate_ev_Legal_Info.';
4279: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4280: END IF;
4281: RETURN 'S'; -- Successfull validation

Line 4288: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_ev_Legal_Info';

4284:
4285: WHEN OTHERS THEN
4286: /* Debug */
4287: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4288: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_ev_Legal_Info';
4289: l_debug_str := 'Exception in Validate_ev_Legal_Info. '||SQLERRM;
4290: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4291: END IF;
4292:

Line 4342: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Empl_Info';

4338:
4339: BEGIN
4340: /* Debug */
4341: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4342: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Empl_Info';
4343: l_debug_str := 'Entering Get_Empl_Info. p_data_rec.person_id is '||p_data_rec.person_id;
4344: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4345: END IF;
4346:

Line 4370: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Empl_Info';

4366: Put_Log_Msg('Record not found ',0);
4367: CLOSE c_data_rec;
4368: /* Debug */
4369: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4370: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Empl_Info';
4371: l_debug_str := 'Returning N from Get_Empl_Info';
4372: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4373: END IF;
4374: RETURN 'N';

Line 4383: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Empl_Info';

4379:
4380: Put_Log_Msg(l_api_name||' ends S ',0);
4381: /* Debug */
4382: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4383: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Empl_Info';
4384: l_debug_str := 'Returning S from Get_Empl_Info';
4385: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4386: END IF;
4387: RETURN 'S';

Line 4394: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Empl_Info';

4390:
4391: WHEN FND_API.G_EXC_ERROR THEN
4392: /* Debug */
4393: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4394: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Empl_Info';
4395: l_debug_str := 'Exception in Get_Empl_Info '||SQLERRM;
4396: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4397: END IF;
4398:

Line 4405: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Empl_Info';

4401:
4402: WHEN OTHERS THEN
4403: /* Debug */
4404: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4405: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Empl_Info';
4406: l_debug_str := 'Exception in Get_Empl_Info '||SQLERRM;
4407: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4408: END IF;
4409: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

Line 4457: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.validate_employment_Info';

4453:
4454: BEGIN
4455: /* Debug */
4456: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4457: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.validate_employment_Info';
4458: 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;
4459: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4460: END IF;
4461:

Line 4538: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.validate_employment_Info';

4534:
4535: END IF;
4536: /* Debug */
4537: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4538: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.validate_employment_Info';
4539: l_debug_str := 'Returning from validate_employment_Info';
4540: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4541: END IF;
4542:

Line 4610: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Empl_Info';

4606: BEGIN
4607:
4608: /* Debug */
4609: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4610: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Empl_Info';
4611: 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;
4612: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4613: END IF;
4614:

Line 4644: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Empl_Info';

4640: p_data_rec(l_counter).action_code := c_data_rec.action_code;
4641:
4642: /* Debug */
4643: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4644: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Empl_Info';
4645: l_debug_str := 'Remarks: '||p_data_rec(l_counter).remarks||' Empl Type: '||p_data_rec(l_counter).empl_rec_type;
4646: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4647: END IF;
4648:

Line 4675: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Empl_Info';

4671: IF l_not_valid THEN
4672: Put_Log_Msg(l_api_name||' Validation error, return E ',0);
4673: /* Debug */
4674: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4675: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Empl_Info';
4676: l_debug_str := 'Returning E from validate_empl_Info.';
4677: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4678: END IF;
4679: RETURN 'E';

Line 4688: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Empl_Info';

4684: IF l_counter = 0 THEN
4685: Put_Log_Msg(l_api_name||' Successfully completed, no rows found returns N ',0);
4686: /* Debug */
4687: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4688: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Empl_Info';
4689: l_debug_str := 'Returning N from validate_empl_Info.';
4690: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4691: END IF;
4692: RETURN 'N';

Line 4700: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Empl_Info';

4696:
4697: Put_Log_Msg(l_api_name||' Successfully completed, returns S',0);
4698: /* Debug */
4699: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4700: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Empl_Info';
4701: l_debug_str := 'Returning S from validate_empl_Info.';
4702: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4703: END IF;
4704: RETURN 'S'; -- Successfull validation

Line 4710: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Empl_Info';

4706:
4707: WHEN OTHERS THEN
4708: /* Debug */
4709: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4710: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Validate_Empl_Info';
4711: l_debug_str := 'Exception in validate_empl_Info. '||SQLERRM;
4712: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4713: END IF;
4714:

Line 4775: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Issue_Info';

4771:
4772: BEGIN
4773: /* Debug */
4774: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4775: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Issue_Info';
4776: l_debug_str := 'Entering Get_Issue_Info. p_data_rec.person_id is '||p_data_rec.person_id;
4777: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4778: END IF;
4779:

Line 4808: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Issue_Info';

4804: Put_Log_Msg('Record not found ',0);
4805: CLOSE c_data_rec;
4806: /* Debug */
4807: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4808: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Issue_Info';
4809: l_debug_str := 'Returning N from Get_Issue_Info.';
4810: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4811: END IF;
4812: RETURN 'N';

Line 4821: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Issue_Info';

4817:
4818: Put_Log_Msg(l_api_name||' ends S ',0);
4819: /* Debug */
4820: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4821: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Issue_Info';
4822: l_debug_str := 'Returning S from Get_Issue_Info.';
4823: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4824: END IF;
4825: RETURN 'S';

Line 4834: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Issue_Info';

4830:
4831: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
4832: /* Debug */
4833: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4834: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Issue_Info';
4835: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Issue_Info. '||SQLERRM;
4836: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4837: END IF;
4838:

Line 4848: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Issue_Info';

4844: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
4845: END IF;
4846: /* Debug */
4847: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4848: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Issue_Info';
4849: l_debug_str := 'Exception in Get_Issue_Info. '||SQLERRM;
4850: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4851: END IF;
4852:

Line 4913: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';

4909:
4910: BEGIN
4911: /* Debug */
4912: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4913: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';
4914: l_debug_str := 'Entering Get_Bio_Info. p_data_rec.person_id is '||p_data_rec.person_id;
4915: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4916: END IF;
4917:

Line 4943: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';

4939: Put_Log_Msg('Record not found ',0);
4940: CLOSE c_data_rec;
4941: /* Debug */
4942: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4943: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';
4944: l_debug_str := 'Returning N from Get_Bio_Info.';
4945: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4946: END IF;
4947: RETURN 'N';

Line 4956: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';

4952:
4953: Put_Log_Msg(l_api_name||' ends S ',0);
4954: /* Debug */
4955: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4956: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';
4957: l_debug_str := 'Returning S from Get_Bio_Info.';
4958: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4959: END IF;
4960:

Line 4968: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';

4964:
4965: WHEN FND_API.G_EXC_ERROR THEN
4966: /* Debug */
4967: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4968: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';
4969: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Bio_Info. '||SQLERRM;
4970: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4971: END IF;
4972:

Line 4984: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';

4980: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
4981: END IF;
4982: /* Debug */
4983: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
4984: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Bio_Info';
4985: l_debug_str := 'Exception in Get_Bio_Info. '||SQLERRM;
4986: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
4987: END IF;
4988: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 5037: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Other_Info';

5033:
5034: BEGIN
5035: /* Debug */
5036: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5037: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Other_Info';
5038: l_debug_str := 'Entering Get_Other_Info. p_data_rec.person_id is '||p_data_rec.person_id;
5039: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5040: END IF;
5041:

Line 5057: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Other_Info';

5053: Put_Log_Msg('Record not found ',0);
5054: CLOSE c_data_rec;
5055: /* Debug */
5056: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5057: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Other_Info';
5058: l_debug_str := 'Returning N from Get_Other_Info.';
5059: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5060: END IF;
5061:

Line 5071: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Other_Info';

5067:
5068: Put_Log_Msg(l_api_name||' ends S ',0);
5069: /* Debug */
5070: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5071: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Other_Info';
5072: l_debug_str := 'Returning S from Get_Other_Info.';
5073: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5074: END IF;
5075: RETURN 'S';

Line 5084: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Other_Info';

5080:
5081: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5082: /* Debug */
5083: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5084: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Other_Info';
5085: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Other_Info-- Returning U. '||SQLERRM;
5086: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5087: END IF;
5088: RETURN 'U';

Line 5099: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Other_Info';

5095:
5096: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
5097: /* Debug */
5098: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5099: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Other_Info';
5100: l_debug_str := 'Exception in Get_Other_Info-- Returning U. '||SQLERRM;
5101: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5102: END IF;
5103: RETURN 'U';

Line 5165: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Address_Info';

5161:
5162: Put_Log_Msg(l_api_name||' begins ',0);
5163: /* Debug */
5164: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5165: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Address_Info';
5166: l_debug_str := 'Entering Get_Address_Info. p_data_rec.party_site_id is '||p_data_rec.party_site_id;
5167: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5168: END IF;
5169:

Line 5192: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Address_Info';

5188: Put_Log_Msg('Record not found ',0);
5189: CLOSE c_data_rec;
5190: /* Debug */
5191: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5192: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Address_Info';
5193: l_debug_str := 'Returning N from Get_Address_Info.';
5194: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5195: END IF;
5196:

Line 5206: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Address_Info';

5202:
5203: Put_Log_Msg(l_api_name||' ends S ',0);
5204: /* Debug */
5205: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5206: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Address_Info';
5207: l_debug_str := 'Returning S from Get_Address_Info.';
5208: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5209: END IF;
5210: RETURN 'S';

Line 5219: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Address_Info';

5215:
5216: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5217: /* Debug */
5218: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5219: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Address_Info';
5220: l_debug_str := 'FND_API.G_EXC_ERROR in Get_Address_Info. Returning U... '||SQLERRM;
5221: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5222: END IF;
5223:

Line 5235: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Address_Info';

5231:
5232: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
5233: /* Debug */
5234: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5235: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Address_Info';
5236: l_debug_str := 'EXCEPTION in Get_Address_Info. Returning U... '||SQLERRM;
5237: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5238: END IF;
5239:

Line 5302: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Edu_Info';

5298:
5299: Put_Log_Msg(l_api_name||' begins ',0);
5300: /* Debug */
5301: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5302: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Edu_Info';
5303: l_debug_str := 'Entering Get_Edu_Info. p_data_rec.person_id is '||p_data_rec.person_id;
5304: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5305: END IF;
5306:

Line 5330: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Edu_Info';

5326: Put_Log_Msg('Record not found ',0);
5327: CLOSE c_data_rec;
5328: /* Debug */
5329: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5330: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Edu_Info';
5331: l_debug_str := 'Returning N from Get_Edu_Info.';
5332: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5333: END IF;
5334: RETURN 'N';

Line 5343: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Edu_Info';

5339:
5340: Put_Log_Msg(l_api_name||' ends S ',0);
5341: /* Debug */
5342: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5343: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Edu_Info';
5344: l_debug_str := 'Returning S from Get_Edu_Info.';
5345: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5346: END IF;
5347: RETURN 'S';

Line 5356: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Edu_Info';

5352:
5353: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5354: /* Debug */
5355: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5356: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Edu_Info';
5357: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Edu_Info. '||SQLERRM;
5358: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5359: END IF;
5360:

Line 5372: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Edu_Info';

5368:
5369: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
5370: /* Debug */
5371: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5372: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Edu_Info';
5373: l_debug_str := 'EXCEPTION: Returning U from Get_Edu_Info. '||SQLERRM;
5374: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5375: END IF;
5376: RETURN 'U';

Line 5452: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Finance_Info';

5448:
5449: Put_Log_Msg(l_api_name||' begins ',0);
5450: /* Debug */
5451: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5452: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Finance_Info';
5453: l_debug_str := 'Entering Get_Finance_Info. p_data_rec.person_id is '||p_data_rec.person_id;
5454: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5455: END IF;
5456:

Line 5496: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Finance_Info';

5492: Put_Log_Msg('Record not found ',0);
5493: CLOSE c_data_rec;
5494: /* Debug */
5495: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5496: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Finance_Info';
5497: l_debug_str := 'Returning N from Get_Finance_Info.';
5498: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5499: END IF;
5500: RETURN 'N';

Line 5509: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Finance_Info';

5505:
5506: Put_Log_Msg(l_api_name||' ends S ',0);
5507: /* Debug */
5508: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5509: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Finance_Info';
5510: l_debug_str := 'Returning S from Get_Finance_Info.';
5511: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5512: END IF;
5513: RETURN 'S';

Line 5522: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Finance_Info';

5518:
5519: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5520: /* Debug */
5521: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5522: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Finance_Info';
5523: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Finance_Info. '||SQLERRM;
5524: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5525: END IF;
5526: RETURN 'U';

Line 5537: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Finance_Info';

5533:
5534: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
5535: /* Debug */
5536: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5537: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Finance_Info';
5538: l_debug_str := 'EXCEPTION: Returning U from Get_Finance_Info. '||SQLERRM;
5539: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5540: END IF;
5541: RETURN 'U';

Line 5605: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Dependent_Info';

5601:
5602: BEGIN
5603: /* Debug */
5604: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5605: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Dependent_Info';
5606: 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;
5607: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5608: END IF;
5609: Put_Log_Msg(l_api_name||' begins ',0);

Line 5638: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Dependent_Info';

5634: Put_Log_Msg('Record not found ',0);
5635: CLOSE c_data_rec;
5636: /* Debug */
5637: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5638: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Dependent_Info';
5639: l_debug_str := 'Returning N from Get_Dependent_Info.';
5640: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5641: END IF;
5642: RETURN 'N';

Line 5651: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Dependent_Info';

5647:
5648: Put_Log_Msg(l_api_name||' ends S ',0);
5649: /* Debug */
5650: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5651: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Dependent_Info';
5652: l_debug_str := 'Returning S from Get_Dependent_Info.';
5653: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5654: END IF;
5655: RETURN 'S';

Line 5663: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Dependent_Info';

5659: WHEN FND_API.G_EXC_ERROR THEN
5660: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5661: /* Debug */
5662: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5663: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Dependent_Info';
5664: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Dependent_Info. '||SQLERRM;
5665: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5666: END IF;
5667: RETURN 'U';

Line 5677: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Dependent_Info';

5673:
5674: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
5675: /* Debug */
5676: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5677: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Dependent_Info';
5678: l_debug_str := 'EXCEPTION: Returning U from Get_Dependent_Info. '||SQLERRM;
5679: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5680: END IF;
5681: RETURN 'U';

Line 5738: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Legal_Info';

5734:
5735: Put_Log_Msg(l_api_name||' begins ',0);
5736: /* Debug */
5737: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5738: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Legal_Info';
5739: l_debug_str := 'Entering Get_Legal_Info. p_data_rec.person_id is '||p_data_rec.person_id;
5740: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5741: END IF;
5742:

Line 5764: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Legal_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_ni_batch_process_pkg.Get_Legal_Info';
5765: l_debug_str := 'Returning N from Get_Legal_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_ni_batch_process_pkg.Get_Legal_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_ni_batch_process_pkg.Get_Legal_Info';
5778: l_debug_str := 'Returning S from Get_Legal_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:

Line 5791: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Legal_Info';

5787:
5788: Put_Log_Msg(l_api_name||' EXEC ERROR ',0);
5789: /* Debug */
5790: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5791: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Legal_Info';
5792: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Get_Legal_Info. '||SQLERRM;
5793: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5794: END IF;
5795: RETURN 'U';

Line 5806: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Legal_Info';

5802:
5803: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);
5804: /* Debug */
5805: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5806: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_Legal_Info';
5807: l_debug_str := 'EXCEPTION: Returning U from Get_Legal_Info. '||SQLERRM;
5808: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5809: END IF;
5810: RETURN 'U';

Line 5840: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Issue_Info';

5836:
5837: BEGIN
5838: /* Debug */
5839: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5840: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Issue_Info';
5841: 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;
5842: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5843: END IF;
5844:

Line 5870: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Issue_Info';

5866: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5867: END IF;
5868: /* Debug */
5869: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5870: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Issue_Info';
5871: l_debug_str := 'EXCEPTION in Update_Issue_Info. '||SQLERRM;
5872: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5873: END IF;
5874: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 5906: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Bio_Info';

5902:
5903: BEGIN
5904: /* Debug */
5905: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5906: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Bio_Info';
5907: 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;
5908: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5909: END IF;
5910: Insert_Summary_Info(p_data_rec.batch_id,

Line 5978: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Bio_Info';

5974: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
5975: END IF;
5976: /* Debug */
5977: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
5978: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Bio_Info';
5979: l_debug_str := 'EXCEPTION in Insert_Bio_Info. '||SQLERRM;
5980: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5981: END IF;
5982: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 6014: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Other_Info';

6010:
6011: BEGIN
6012: /* Debug */
6013: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6014: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Other_Info';
6015: 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;
6016: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6017: END IF;
6018: Insert_Summary_Info(p_data_rec.batch_id,

Line 6063: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Other_Info';

6059: END IF;
6060:
6061: /* Debug */
6062: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6063: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Other_Info';
6064: l_debug_str := 'EXCEPTION in Insert_Other_Info. '||SQLERRM;
6065: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6066: END IF;
6067: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 6104: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Address_Info';

6100: l_remarks VARCHAR2(500);
6101: BEGIN
6102: /* Debug */
6103: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6104: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Address_Info';
6105: l_debug_str := 'Entering Insert_Address_Info. Number of records: '||p_records;
6106: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6107: END IF;
6108:

Line 6219: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Address_Info';

6215: END IF;
6216:
6217: /* Debug */
6218: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6219: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Address_Info';
6220: l_debug_str := 'EXCEPTION in Insert_Address_Info. '||SQLERRM;
6221: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6222: END IF;
6223: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 6278: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Edu_Info';

6274:
6275: BEGIN
6276: /* Debug */
6277: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6278: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Edu_Info';
6279: 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;
6280: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6281: END IF;
6282: l_position_code := p_data_rec.position_code;

Line 6299: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Edu_Info';

6295: l_prgm_end_date := p_data_rec.prgm_end_date;
6296:
6297: /* Debug */
6298: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6299: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Edu_Info';
6300: l_debug_str := 'After assigning values to local variables';
6301: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6302: END IF;
6303: -- Nonimg action types:

Line 6412: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Edu_Info';

6408: l_prgm_end_date := l_cur_rec.prgm_end_date;
6409: END IF;
6410: /* Debug */
6411: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6412: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Edu_Info';
6413: l_debug_str := 'After assigning values received from get_othr_prgm_info to local variables';
6414: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6415: END IF;
6416: END IF;

Line 6505: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Edu_Info';

6501: p_data_rec.auth_action_code
6502: );
6503: /* Debug */
6504: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6505: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Edu_Info';
6506: l_debug_str := 'Record inserted';
6507: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6508: END IF;
6509: IF p_edu_type = 'PRGM' THEN

Line 6532: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Edu_Info';

6528: END IF;
6529:
6530: /* Debug */
6531: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6532: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Edu_Info';
6533: l_debug_str := 'EXCEPTION in Insert_Edu_Info. '||SQLERRM;
6534: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6535: END IF;
6536: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 6569: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Finance_Info';

6565:
6566: BEGIN
6567: /* Debug */
6568: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6569: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Finance_Info';
6570: 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;
6571: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6572: END IF;
6573: Insert_Summary_Info(p_data_rec.batch_id,

Line 6671: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Finance_Info';

6667: END IF;
6668:
6669: /* Debug */
6670: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6671: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Finance_Info';
6672: l_debug_str := 'EXCEPTION in Insert_Finance_Info. '||SQLERRM;
6673: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6674: END IF;
6675: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 6711: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Dependent_Info';

6707: l_btch_id NUMBER(14);
6708: BEGIN
6709: /* Debug */
6710: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6711: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Dependent_Info';
6712: l_debug_str := 'Entering Insert_Dependent_Info.Number of records being inserted: '||p_records;
6713: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6714: END IF;
6715: FOR l_count IN 1..p_records LOOP

Line 6819: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Dependent_Info';

6815: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
6816: END IF;
6817: /* Debug */
6818: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6819: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Dependent_Info';
6820: l_debug_str := 'EXCEPTION in Insert_Dependent_Info. '||SQLERRM;
6821: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6822: END IF;
6823: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 6854: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Convictions_Info';

6850:
6851: BEGIN
6852: /* Debug */
6853: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6854: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Convictions_Info';
6855: 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;
6856: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6857: END IF;
6858: Insert_Summary_Info(p_data_rec.batch_id,

Line 6900: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Convictions_Info';

6896: END IF;
6897:
6898: /* Debug */
6899: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6900: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Convictions_Info';
6901: l_debug_str := 'EXCEPTION in Insert_Convictions_Info. '||SQLERRM;
6902: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6903: END IF;
6904: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 6934: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Legal_Info';

6930:
6931: BEGIN
6932: /* Debug */
6933: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6934: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Legal_Info';
6935: 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;
6936: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
6937: END IF;
6938: Insert_Summary_Info(p_data_rec.batch_id,

Line 6998: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Legal_Info';

6994: END IF;
6995:
6996: /* Debug */
6997: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
6998: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Legal_Info';
6999: l_debug_str := 'EXCEPTION in Insert_Legal_Info. '||SQLERRM;
7000: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7001: END IF;
7002: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 7034: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Empl_Info';

7030: l_btch_id NUMBER(14);
7031: BEGIN
7032: /* Debug */
7033: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7034: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Empl_Info';
7035: 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;
7036: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7037: END IF;
7038: IF g_person_status = 'NEW' THEN

Line 7068: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';

7064: 'IGS_SV_EMPL_INFO',
7065: p_data_rec.nonimg_empl_id);
7066: /* Debug */
7067: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7068: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
7069: 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;
7070: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7071: END IF;
7072:

Line 7135: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Empl_Info';

7131: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
7132: END IF;
7133: /* Debug */
7134: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7135: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Empl_Info';
7136: l_debug_str := 'EXCEPTION in Insert_Empl_Info. '||SQLERRM;
7137: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7138: END IF;
7139: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 7217: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';

7213:
7214: BEGIN
7215: /* Debug */
7216: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7217: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';
7218: 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;
7219: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7220: END IF;
7221:

Line 7255: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';

7251:
7252: Put_Log_Msg('Validation error occurs ',0);
7253: /* Debug */
7254: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7255: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';
7256: l_debug_str := 'Returning S from Update_Registration_Info.';
7257: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7258: END IF;
7259:

Line 7267: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';

7263:
7264: Put_Log_Msg('Unexpected error returned by validation ',0);
7265: /* Debug */
7266: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7267: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';
7268: l_debug_str := 'Unexpected error in Update_Registration_Info.';
7269: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7270: END IF;
7271:

Line 7285: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';

7281:
7282: IF l_status = 'U' THEN
7283: /* Debug */
7284: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7285: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';
7286: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Registration_Info.';
7287: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7288: END IF;
7289:

Line 7355: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';

7351:
7352: p_person_rec.person_status := 'I';
7353: /* Debug
7354: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7355: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';
7356: l_debug_str := 'Returning S from Update_Registration_Info.';
7357: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7358: END IF;
7359:

Line 7392: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';

7388:
7389: Put_Log_Msg('Validation error occurs - return S ',0);
7390: /* Debug */
7391: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7392: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';
7393: l_debug_str := 'Returning S from Update_Registration_Info.';
7394: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7395: END IF;
7396:

Line 7416: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';

7412:
7413: p_person_rec.person_status := 'I';
7414: /* Debug */
7415: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7416: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';
7417: l_debug_str := 'Returning S from Update_Registration_Info.';
7418: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7419: END IF;
7420:

Line 7438: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';

7434:
7435: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
7436: /* Debug */
7437: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7438: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';
7439: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Registration_Info. '||SQLERRM;
7440: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7441: END IF;
7442: RETURN 'U';

Line 7453: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';

7449:
7450: Put_Log_Msg(l_api_name||' OTHERS return U',0);
7451: /* Debug */
7452: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7453: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Registration_Info';
7454: l_debug_str := 'EXCEPTION: Returning U from Update_Registration_Info. '||SQLERRM;
7455: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7456: END IF;
7457: RETURN 'U';

Line 7481: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';

7477:
7478: BEGIN
7479: /* Debug */
7480: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7481: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';
7482: 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;
7483: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7484: END IF;
7485:

Line 7500: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';

7496:
7497: Put_Log_Msg('Validation error occurs ',0);
7498: /* Debug */
7499: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7500: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';
7501: l_debug_str := 'Returning S from Update_ev_Legal_Info.';
7502: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7503: END IF;
7504:

Line 7512: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';

7508:
7509: Put_Log_Msg('Unexpected error returned by validation ',0);
7510: /* Debug */
7511: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7512: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';
7513: l_debug_str := 'Unexpected error in Update_ev_Legal_Info.';
7514: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7515: END IF;
7516:

Line 7529: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';

7525: l_status := Get_Legal_Info ( p_data_rec => l_prev_rec);
7526: IF l_status = 'U' THEN
7527: /* Debug */
7528: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7529: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';
7530: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_ev_Legal_Info.';
7531: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7532: END IF;
7533:

Line 7539: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Previous_Legal_Info';

7535:
7536: END IF;
7537:
7538: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7539: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Previous_Legal_Info';
7540: l_debug_str := 'psprt_issuing_cntry_code=' || l_prev_rec.psprt_issuing_cntry_code;
7541: l_debug_str := l_debug_str || 'psprt_exp_date=' || l_prev_rec.psprt_exp_date;
7542: l_debug_str := l_debug_str || 'visa_number=' || l_prev_rec.visa_number ;
7543: l_debug_str := l_debug_str || 'visa_issuing_post=' || l_prev_rec.visa_issuing_post;

Line 7555: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Current_Legal_Info';

7551: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7552: END IF;
7553:
7554: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7555: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Current_Legal_Info';
7556: l_debug_str := 'psprt_issuing_cntry_code=' || l_cur_rec.psprt_issuing_cntry_code;
7557: l_debug_str := l_debug_str || 'psprt_exp_date=' || l_cur_rec.psprt_exp_date;
7558: l_debug_str := l_debug_str || 'visa_number=' || l_cur_rec.visa_number ;
7559: l_debug_str := l_debug_str || 'visa_issuing_post=' || l_cur_rec.visa_issuing_post;

Line 7623: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';

7619:
7620: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
7621: /* Debug */
7622: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7623: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';
7624: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_ev_Legal_Info. '||SQLERRM;
7625: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7626: END IF;
7627: RETURN 'U';

Line 7638: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';

7634:
7635: Put_Log_Msg(l_api_name||' OTHERS return U',0);
7636: /* Debug */
7637: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7638: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_ev_Legal_Info';
7639: l_debug_str := 'EXCEPTION: Returning U from Update_ev_Legal_Info. '||SQLERRM;
7640: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7641: END IF;
7642: RETURN 'U';

Line 7697: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

7693:
7694: Put_Log_Msg(l_api_name||' begins ',0);
7695: /* Debug */
7696: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7697: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7698: l_debug_str := 'Entering Update_EV_Address_Info. p_person_rec.form_id is '||p_person_rec.form_id;
7699: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7700: END IF;
7701:

Line 7723: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

7719:
7720: Put_Log_Msg('Validation error occurs - return S ',0);
7721: /* Debug */
7722: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7723: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7724: l_debug_str := 'Returning S from Update_EV_Address_Info.';
7725: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7726: END IF;
7727:

Line 7735: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

7731:
7732: Put_Log_Msg('Unexpected error returned by validation ',0);
7733: /* Debug */
7734: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7735: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7736: l_debug_str := 'Unexpected error in Update_EV_Address_Info.';
7737: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7738: END IF;
7739:

Line 7752: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

7748:
7749: p_person_rec.person_status := 'I';
7750: /* Debug */
7751: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7752: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7753: l_debug_str := 'Returning S from Update_EV_Address_Info.';
7754: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7755: END IF;
7756:

Line 7811: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

7807: ELSE
7808: --Error found l_status = 'U'
7809: /* Debug */
7810: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7811: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7812: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';
7813: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7814: END IF;
7815: RAISE FND_API.G_EXC_ERROR;

Line 7836: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

7832:
7833: Put_Log_Msg('Validation error occurs - return S ',0);
7834: /* Debug */
7835: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7836: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7837: l_debug_str := 'Returning S from Update_EV_Address_Info. us_addr_status is E';
7838: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7839: END IF;
7840:

Line 7848: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

7844:
7845: Put_Log_Msg('Unexpected error returned by validation ',0);
7846: /* Debug */
7847: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7848: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7849: l_debug_str := 'ERROR in Update_EV_Address_Info. us_addr_status is U';
7850: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7851: END IF;
7852:

Line 7860: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

7856:
7857: Put_Log_Msg('Site of activity Address block is not found return S',0);
7858: /* Debug */
7859: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7860: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7861: l_debug_str := 'Returning S from Update_EV_Address_Info. us_addr_status is N';
7862: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7863: END IF;
7864:

Line 7942: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

7938: ELSE
7939: --Error found l_statsite = 'U'
7940: /* Debug */
7941: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7942: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7943: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Address_Info.';
7944: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7945: END IF;
7946:

Line 7955: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

7951: /* IF p_person_rec.changes_found = 'Y' THEN
7952: -- one address only
7953: /* Debug
7954: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7955: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7956: l_debug_str := 'changes_found is Y. Exiting Update_EV_Address_Info.';
7957: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7958: END IF;
7959: EXIT;

Line 7976: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

7972:
7973: Put_Log_Msg(l_api_name||' ends ',0);
7974: /* Debug */
7975: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7976: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7977: l_debug_str := 'Returning S from Update_EV_Address_Info.';
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:

Line 7990: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

7986:
7987: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
7988: /* Debug */
7989: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
7990: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
7991: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_EV_Address_Info. '||SQLERRM;
7992: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
7993: END IF;
7994: RETURN 'U';

Line 8005: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';

8001:
8002: Put_Log_Msg(l_api_name||' OTHERS return U',0);
8003: /* Debug */
8004: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8005: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Address_Info';
8006: l_debug_str := 'EXCEPTION: Returning U from Update_EV_Address_Info. '||SQLERRM;
8007: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8008: END IF;
8009:

Line 8054: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';

8050:
8051: BEGIN
8052: /* Debug */
8053: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8054: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8055: l_debug_str := 'Entering Update_Personal_Info. p_person_rec.person_id is '||p_person_rec.person_id;
8056: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8057: END IF;
8058:

Line 8104: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';

8100:
8101: Put_Log_Msg('UPI - Validation error occurs ',0);
8102: /* Debug */
8103: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8104: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8105: l_debug_str := 'Returning S from Update_Personal_Info.';
8106: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8107: END IF;
8108:

Line 8121: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';

8117:
8118: Put_Log_Msg('UPI - unexpected error returned by validation ',0);
8119: /* Debug */
8120: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8121: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8122: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Personal_Info.';
8123: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8124: END IF;
8125:

Line 8135: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';

8131:
8132: Put_Log_Msg('UPI BIO block is not found ',0);
8133: /* Debug */
8134: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8135: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8136: l_debug_str := 'IGS_SV_UNEXP_EXCPT_ERR in Update_Personal_Info. bio_status is N';
8137: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8138: END IF;
8139:

Line 8158: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';

8154:
8155: IF l_status = 'U' THEN
8156: /* Debug */
8157: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8158: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8159: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. l_status is U';
8160: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8161: END IF;
8162: RAISE FND_API.G_EXC_ERROR;

Line 8200: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';

8196: p_person_rec.changes_found := 'Y';
8197: Put_Log_Msg('Bio info is changed ',0);
8198: /* Debug */
8199: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8200: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8201: 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;
8202: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8203: END IF;
8204:

Line 8244: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';

8240:
8241: --Error found l_status = 'U'
8242: /* Debug */
8243: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8244: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8245: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info.';
8246: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8247: END IF;
8248:

Line 8307: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';

8303:
8304: --Error found l_status = 'U'
8305: /* Debug */
8306: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8307: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8308: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. f_addr_status is S';
8309: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8310: END IF;
8311:

Line 8368: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';

8364: ELSE
8365: --Error found l_status = 'U'
8366: /* Debug */
8367: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8368: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8369: l_debug_str := 'FND_API.G_EXC_ERROR in Update_Personal_Info. us_addr_status is S';
8370: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8371: END IF;
8372:

Line 8417: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';

8413:
8414: Put_Log_Msg(l_api_name||' ends ',0);
8415: /* Debug */
8416: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8417: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8418: l_debug_str := 'Returning S from Update_Personal_Info.';
8419: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8420: END IF;
8421:

Line 8431: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';

8427:
8428: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
8429: /* Debug */
8430: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8431: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8432: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Personal_Info. '||SQLERRM;
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: RETURN 'U';

Line 8446: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';

8442:
8443: Put_Log_Msg(l_api_name||' OTHERS return U',0);
8444: /* Debug */
8445: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8446: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Personal_Info';
8447: l_debug_str := 'EXCEPTION: Returning U from Update_Personal_Info. '||SQLERRM;
8448: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8449: END IF;
8450: RETURN 'U';

Line 8484: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_EV_Prgm_Info';

8480: ORDER BY effective_date;
8481: BEGIN
8482: /* Debug */
8483: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8484: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_EV_Prgm_Info';
8485: l_debug_str := 'Entering Get_EV_Prgm_Info. p_data_rec.person_id is '||p_data_rec.person_id;
8486: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8487: END IF;
8488:

Line 8507: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_EV_Prgm_Info';

8503: Put_Log_Msg('Record not found ',0);
8504: CLOSE c_data_rec;
8505: /* Debug */
8506: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8507: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_EV_Prgm_Info';
8508: l_debug_str := 'Returning N from Get_EV_Prgm_Info';
8509: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8510: END IF;
8511: RETURN 'N';

Line 8520: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_EV_Prgm_Info';

8516:
8517: Put_Log_Msg(l_api_name||' ends S ',0);
8518: /* Debug */
8519: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8520: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_EV_Prgm_Info';
8521: l_debug_str := 'Returning S from Get_EV_Prgm_Info';
8522: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8523: END IF;
8524: RETURN 'S';

Line 8531: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_EV_Prgm_Info';

8527:
8528: WHEN FND_API.G_EXC_ERROR THEN
8529: /* Debug */
8530: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8531: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_EV_Prgm_Info';
8532: l_debug_str := 'Exception in Get_EV_Prgm_Info '||SQLERRM;
8533: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8534: END IF;
8535:

Line 8542: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_EV_Prgm_Info';

8538:
8539: WHEN OTHERS THEN
8540: /* Debug */
8541: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8542: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_EV_Prgm_Info';
8543: l_debug_str := 'Exception in Get_EV_Prgm_Info '||SQLERRM;
8544: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8545: END IF;
8546: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

Line 8585: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_nonimg_Prgm_Info';

8581: ORDER BY effective_date;
8582: BEGIN
8583: /* Debug */
8584: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8585: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_nonimg_Prgm_Info';
8586: l_debug_str := 'Entering Get_nonimg_Prgm_Info. p_data_rec.person_id is '||p_data_rec.person_id;
8587: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8588: END IF;
8589:

Line 8607: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_nonimg_Prgm_Info';

8603: Put_Log_Msg('Record not found ',0);
8604: CLOSE c_data_rec;
8605: /* Debug */
8606: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8607: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_nonimg_Prgm_Info';
8608: l_debug_str := 'Returning N from Get_nonimg_Prgm_Info';
8609: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8610: END IF;
8611: RETURN 'N';

Line 8620: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_nonimg_Prgm_Info';

8616:
8617: Put_Log_Msg(l_api_name||' ends S ',0);
8618: /* Debug */
8619: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8620: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_nonimg_Prgm_Info';
8621: l_debug_str := 'Returning S from Get_nonimg_Prgm_Info';
8622: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8623: END IF;
8624: RETURN 'S';

Line 8631: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_nonimg_Prgm_Info';

8627:
8628: WHEN FND_API.G_EXC_ERROR THEN
8629: /* Debug */
8630: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8631: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_nonimg_Prgm_Info';
8632: l_debug_str := 'Exception in Get_nonimg_Prgm_Info '||SQLERRM;
8633: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8634: END IF;
8635:

Line 8642: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_nonimg_Prgm_Info';

8638:
8639: WHEN OTHERS THEN
8640: /* Debug */
8641: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8642: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Get_nonimg_Prgm_Info';
8643: l_debug_str := 'Exception in Get_nonimg_Prgm_Info '||SQLERRM;
8644: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8645: END IF;
8646: IF (FND_MSg_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

Line 8686: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

8682:
8683: Put_Log_Msg(l_api_name||' begins ',0);
8684: /* Debug */
8685: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8686: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8687: l_debug_str := 'Entering Update_Program_Info. p_person_rec.person_id is '||p_person_rec.person_id;
8688: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8689: END IF;
8690:

Line 8703: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

8699:
8700: Put_Log_Msg('Validation error occurs ',0);
8701: /* Debug */
8702: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8703: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8704: l_debug_str := 'Returning S from Update_Program_Info. p_person_rec.edu_status is E';
8705: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8706: END IF;
8707:

Line 8717: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

8713:
8714: Put_Log_Msg('Unexpected error returned by validation ',0);
8715: /* Debug */
8716: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8717: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8718: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';
8719: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8720: END IF;
8721:

Line 8731: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

8727:
8728: Put_Log_Msg('EDU block is not found ',0);
8729: /* Debug */
8730: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8731: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8732: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is N.';
8733: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8734: END IF;
8735:

Line 8753: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

8749:
8750: IF l_status = 'U' OR l_status = 'N' THEN
8751: /* Debug */
8752: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8753: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8754: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';
8755: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8756: END IF;
8757: RAISE FND_API.G_EXC_ERROR;

Line 8814: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

8810:
8811: Put_Log_Msg('Validation error occurs ',0);
8812: /* Debug */
8813: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8814: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8815: l_debug_str := 'Returning S from Update_Program_Info.';
8816: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8817: END IF;
8818:

Line 8826: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

8822:
8823: Put_Log_Msg('Unexpected error returned by validation ',0);
8824: /* Debug */
8825: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8826: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8827: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info.';
8828: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8829: END IF;
8830:

Line 8847: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';

8843:
8844: IF l_status = 'U' THEN
8845: /* Debug */
8846: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8847: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
8848: l_debug_str := 'Unexpected error in Update_Employment_Info. l_status is U.';
8849: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8850: END IF;
8851: RAISE FND_API.G_EXC_ERROR;

Line 8890: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

8886:
8887: Put_Log_Msg(l_api_name||' ends ',0);
8888: /* Debug */
8889: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8890: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8891: l_debug_str := 'Final Return S from Update_Program_Info.';
8892: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8893: END IF;
8894:

Line 8904: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

8900:
8901: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
8902: /* Debug */
8903: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8904: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8905: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Program_Info. '||SQLERRM;
8906: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8907: END IF;
8908: RETURN 'U';

Line 8919: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

8915:
8916: Put_Log_Msg(l_api_name||' OTHERS return U',0);
8917: /* Debug */
8918: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8919: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8920: l_debug_str := 'EXCEPTION: Returning U from Update_Program_Info. '||SQLERRM;
8921: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8922: END IF;
8923:

Line 8962: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';

8958:
8959: Put_Log_Msg(l_api_name||' begins ',0);
8960: /* Debug */
8961: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8962: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';
8963: l_debug_str := 'Entering Update_EV_Program_Info. p_person_rec.person_id is '||p_person_rec.person_id;
8964: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8965: END IF;
8966:

Line 8978: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

8974:
8975: Put_Log_Msg('Validation error occurs ',0);
8976: /* Debug */
8977: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8978: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8979: l_debug_str := 'Returning S from Update_Program_Info. p_person_rec.edu_status is E';
8980: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8981: END IF;
8982:

Line 8992: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

8988:
8989: Put_Log_Msg('Unexpected error returned by validation ',0);
8990: /* Debug */
8991: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
8992: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
8993: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is U';
8994: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
8995: END IF;
8996:

Line 9006: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

9002:
9003: Put_Log_Msg('EDU block is not found ',0);
9004: /* Debug */
9005: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9006: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
9007: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. p_person_rec.edu_status is N.';
9008: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9009: END IF;
9010:

Line 9028: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';

9024:
9025: IF l_status = 'U' OR l_status = 'N' THEN
9026: /* Debug */
9027: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9028: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Program_Info';
9029: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_Program_Info. l_status is U or N.';
9030: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9031: END IF;
9032: RAISE FND_API.G_EXC_ERROR;

Line 9087: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';

9083:
9084: Put_Log_Msg('Validation error occurs ',0);
9085: /* Debug */
9086: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9087: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';
9088: l_debug_str := 'Returning S from Update_EV_Program_Info. p_person_rec.edu_status is E.';
9089: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9090: END IF;
9091:

Line 9099: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';

9095:
9096: Put_Log_Msg('Unexpected error returned by validation ',0);
9097: /* Debug */
9098: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9099: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';
9100: l_debug_str := 'RAISE FND_API.G_EXC_ERROR in Update_EV_Program_Info. p_person_rec.edu_status is U.';
9101: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9102: END IF;
9103:

Line 9121: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';

9117:
9118: IF l_status = 'U' THEN
9119: /* Debug */
9120: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9121: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9122: l_debug_str := 'Unexpected error in Update_Employment_Info. l_status is U.';
9123: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9124: END IF;
9125: RAISE FND_API.G_EXC_ERROR;

Line 9159: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';

9155:
9156: IF p_person_rec.edu_status = 'C' AND p_person_rec.person_status <> 'I' THEN
9157: /* Debug */
9158: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9159: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';
9160: l_debug_str := 'inserting prgm info.';
9161: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9162: END IF;
9163: Insert_Edu_Info ('PRGM', p_data_rec => l_cur_prgm_rec(l_current), p_auth_drp_data_rec => l_cur_authdrp_rec);

Line 9170: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';

9166:
9167: Put_Log_Msg(l_api_name||' ends ',0);
9168: /* Debug */
9169: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9170: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';
9171: l_debug_str := 'Returning S from Update_EV_Program_Info.';
9172: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9173: END IF;
9174:

Line 9184: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';

9180:
9181: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
9182: /* Debug */
9183: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9184: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';
9185: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_EV_Program_Info. '||SQLERRM;
9186: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9187: END IF;
9188:

Line 9200: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';

9196:
9197: Put_Log_Msg(l_api_name||' OTHERS return U',0);
9198: /* Debug */
9199: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9200: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_EV_Program_Info';
9201: l_debug_str := 'EXCEPTION: Returning U from Update_EV_Program_Info. '||SQLERRM;
9202: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9203: END IF;
9204:

Line 9241: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';

9237:
9238: Put_Log_Msg(l_api_name||' begins ',0);
9239: /* Debug */
9240: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9241: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';
9242: l_debug_str := 'Entering Update_Finance_Info. p_person_rec.person_id is '||p_person_rec.person_id;
9243: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9244: END IF;
9245:

Line 9256: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';

9252:
9253: Put_Log_Msg('Validation error occurs ',0);
9254: /* Debug */
9255: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9256: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';
9257: l_debug_str := 'Returning S from Update_Finance_Info. p_person_rec.fin_status is E';
9258: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9259: END IF;
9260:

Line 9268: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';

9264:
9265: Put_Log_Msg('Unexpected error returned by validation ',0);
9266: /* Debug */
9267: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9268: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';
9269: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. fin_status is U';
9270: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9271: END IF;
9272:

Line 9282: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';

9278:
9279: Put_Log_Msg('Finance block is not found ',0);
9280: /* Debug */
9281: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9282: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';
9283: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. fin_status is N';
9284: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9285: END IF;
9286:

Line 9305: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';

9301:
9302: IF l_status = 'U' OR l_status = 'N' THEN
9303: /* Debug */
9304: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9305: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';
9306: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Finance_Info. l_status is U or N';
9307: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9308: END IF;
9309:

Line 9391: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';

9387: END IF;
9388: Put_Log_Msg(l_api_name||' ends ',0);
9389: /* Debug */
9390: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9391: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';
9392: l_debug_str := 'Returning S from Update_Finance_Info.';
9393: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9394: END IF;
9395:

Line 9405: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';

9401:
9402: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
9403: /* Debug */
9404: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9405: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';
9406: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Finance_Info. '||SQLERRM;
9407: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9408: END IF;
9409: RETURN 'U';

Line 9420: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';

9416:
9417: Put_Log_Msg(l_api_name||' OTHERS return U',0);
9418: /* Debug */
9419: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9420: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Finance_Info';
9421: l_debug_str := 'EXCEPTION: Returning U from Update_Finance_Info. '||SQLERRM;
9422: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9423: END IF;
9424:

Line 9472: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';

9468:
9469: Put_Log_Msg(l_api_name||' begins ',0);
9470: /* Debug */
9471: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9472: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9473: l_debug_str := 'Entering Update_Dependent_Info. p_person_rec.person_id is '||p_person_rec.person_id;
9474: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9475: END IF;
9476:

Line 9490: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';

9486:
9487: Put_Log_Msg('Validation error occurs ',0);
9488: /* Debug */
9489: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9490: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9491: l_debug_str := 'Returning S from Update_Dependent_Info. dep_status is E.';
9492: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9493: END IF;
9494: RETURN 'S';

Line 9501: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';

9497:
9498: Put_Log_Msg('Unexpected error returned by validation ',0);
9499: /* Debug */
9500: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9501: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9502: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. dep_status is U.';
9503: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9504: END IF;
9505:

Line 9513: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';

9509:
9510: Put_Log_Msg('Dependent block is not found ',0);
9511: /* Debug */
9512: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9513: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9514: l_debug_str := 'Returning S from Update_Dependent_Info. dep_status is N.';
9515: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9516: END IF;
9517: RETURN 'S';

Line 9536: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Previous_Dependent_Info';

9532: --manoj stars
9533:
9534:
9535: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9536: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Previous_Dependent_Info';
9537: l_debug_str := 'l_prev_rec action_type='||l_prev_rec.depdnt_action_type;
9538: l_debug_str := l_debug_str || 'visa_type=' || l_prev_rec.visa_type;
9539: l_debug_str := l_debug_str || 'last_name=' || l_prev_rec.last_name;
9540: l_debug_str := l_debug_str || 'first_name=' || l_prev_rec.first_name ;

Line 9559: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Current_Dependent_Info';

9555: END IF;
9556:
9557:
9558: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9559: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Current_Dependent_Info';
9560: l_debug_str := 'cur dep action type: '||l_cur_rec(l_current).depdnt_action_type;
9561: l_debug_str := l_debug_str || 'visa_type=' || l_cur_rec(l_current).visa_type;
9562: l_debug_str := l_debug_str || 'last_name=' || l_cur_rec(l_current).last_name;
9563: l_debug_str := l_debug_str || 'first_name=' || l_cur_rec(l_current).first_name;

Line 9584: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';

9580:
9581: IF l_status = 'U' THEN
9582: /* Debug */
9583: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9584: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9585: l_debug_str := 'Raise FND_API.G_EXC_ERROR in Update_Dependent_Info. l_status is U.';
9586: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9587: END IF;
9588: RAISE FND_API.G_EXC_ERROR;

Line 9605: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';

9601:
9602: Put_Log_Msg('Validation error occurs ',0);
9603: /* Debug */
9604: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9605: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9606: l_debug_str := 'Returning S from Update_Dependent_Info. l_status is S.';
9607: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9608: END IF;
9609: RETURN 'S';

Line 9697: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';

9693:
9694: Put_Log_Msg('Info is changed for '||l_cur_rec(l_current).depdnt_id,0);
9695: /* Debug */
9696: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9697: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9698: 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;
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: --IF l_prev_rec.depdnt_action_type = l_cur_rec(l_current).depdnt_action_type THEN

Line 9716: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';

9712: /* IF p_person_rec.dep_status = 'C' AND p_person_rec.record_status ='C' THEN prbhardw CP enhancement
9713: -- Only one dependent in the update section.
9714: /* Debug
9715: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9716: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9717: l_debug_str := 'Exiting Update_Dependent_Info. dep_status and record_status is C.';
9718: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9719: END IF;
9720:

Line 9735: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';

9731:
9732: Put_Log_Msg(l_api_name||' ends ',0);
9733: /* Debug */
9734: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9735: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9736: l_debug_str := 'Returning S from Update_Dependent_Info.';
9737: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9738: END IF;
9739:

Line 9748: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';

9744: WHEN FND_API.G_EXC_ERROR THEN
9745: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
9746: /* Debug */
9747: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9748: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9749: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Dependent_Info. '||SQLERRM;
9750: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9751: END IF;
9752: RETURN 'U';

Line 9762: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';

9758: END IF;
9759: Put_Log_Msg(l_api_name||' OTHERS return U',0);
9760: /* Debug */
9761: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9762: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Dependent_Info';
9763: l_debug_str := 'EXCEPTION: Returning U from Update_Dependent_Info. '||SQLERRM;
9764: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9765: END IF;
9766:

Line 9805: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';

9801:
9802: Put_Log_Msg(l_api_name||' begins ',0);
9803: /* Debug */
9804: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9805: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9806: l_debug_str := 'Entering Update_Employment_Info. p_person_rec.person_id is '||p_person_rec.person_id;
9807: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9808: END IF;
9809:

Line 9821: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';

9817: p_person_rec.person_status := 'I';
9818: Put_Log_Msg('Validation error occurs ',0);
9819: /* Debug */
9820: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9821: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9822: l_debug_str := 'Returning S from Update_Employment_Info. empl_status is E.';
9823: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9824: END IF;
9825: RETURN 'S';

Line 9830: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';

9826: ELSIF p_person_rec.empl_status = 'U' THEN --Unexpected error - terminate execution
9827: Put_Log_Msg('Unexpected error returned by validation ',0);
9828: /* Debug */
9829: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9830: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9831: l_debug_str := 'Unexpected error in Update_Employment_Info. empl_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: RAISE FND_API.G_EXC_ERROR;

Line 9839: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';

9835: ELSIF p_person_rec.empl_status = 'N' THEN -- Not found
9836: Put_Log_Msg('Employment block is not found ',0);
9837: /* Debug */
9838: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9839: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9840: l_debug_str := 'Returning S from Update_Employment_Info. empl_status is N.';
9841: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9842: END IF;
9843: RETURN 'S';

Line 9857: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';

9853:
9854: l_status := Get_Empl_Info ( p_data_rec => l_prev_rec);
9855: /* Debug */
9856: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9857: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9858: l_debug_str := 'l_status from Get_Empl_Info: '||l_status;
9859: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9860: END IF;
9861: IF l_status = 'U' THEN

Line 9864: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';

9860: END IF;
9861: IF l_status = 'U' THEN
9862: /* Debug */
9863: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9864: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9865: l_debug_str := 'Unexpected error in Update_Employment_Info. l_status is U.';
9866: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9867: END IF;
9868: RAISE FND_API.G_EXC_ERROR;

Line 9934: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';

9930:
9931: Put_Log_Msg(l_api_name||' ends ',0);
9932: /* Debug */
9933: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9934: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9935: l_debug_str := 'Returning S from Update_Employment_Info.';
9936: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9937: END IF;
9938: RETURN 'S';

Line 9947: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';

9943:
9944: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
9945: /* Debug */
9946: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9947: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9948: l_debug_str := 'ND_API.G_EXC_ERROR: Returning U from Update_Employment_Info. '||SQLERRM;
9949: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9950: END IF;
9951: RETURN 'U';

Line 9962: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';

9958:
9959: Put_Log_Msg(l_api_name||' OTHERS return U',0);
9960: /* Debug */
9961: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
9962: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Employment_Info';
9963: l_debug_str := 'EXCEPTION: Returning U from Update_Employment_Info. '||SQLERRM;
9964: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
9965: END IF;
9966:

Line 10002: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';

9998:
9999: Put_Log_Msg(l_api_name||' begins ',0);
10000: /* Debug */
10001: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10002: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';
10003: l_debug_str := 'Entering Update_Conviction_Info. p_person_rec.person_id is '||p_person_rec.person_id;
10004: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10005: END IF;
10006:

Line 10020: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';

10016:
10017: Put_Log_Msg('Validation error occurs ',0);
10018: /* Debug */
10019: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10020: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';
10021: l_debug_str := 'Returning S from Update_Conviction_Info. conv_status is E.';
10022: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10023: END IF;
10024:

Line 10032: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';

10028:
10029: Put_Log_Msg('Unexpected error returned by validation ',0);
10030: /* Debug */
10031: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10032: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';
10033: l_debug_str := 'Unexpected error in Update_Conviction_Info. conv_status is U.';
10034: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10035: END IF;
10036:

Line 10044: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';

10040:
10041: Put_Log_Msg('Convictions block is not found ',0);
10042: /* Debug */
10043: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10044: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';
10045: l_debug_str := 'Returning S from Update_Conviction_Info. conv_status is N.';
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 10068: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';

10064:
10065: Put_Log_Msg(l_api_name||' ends ',0);
10066: /* Debug */
10067: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10068: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';
10069: l_debug_str := 'Returning S from Update_Conviction_Info.';
10070: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10071: END IF;
10072:

Line 10082: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';

10078:
10079: Put_Log_Msg(l_api_name||' EXEC_ERROR returns U',0);
10080: /* Debug */
10081: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10082: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';
10083: l_debug_str := 'FND_API.G_EXC_ERROR: Returning U from Update_Conviction_Info. '||SQLERRM;
10084: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10085: END IF;
10086: RETURN 'U';

Line 10097: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';

10093:
10094: Put_Log_Msg(l_api_name||' OTHERS return U',0);
10095: /* Debug */
10096: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10097: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Update_Conviction_Info';
10098: l_debug_str := 'EXCEPTION: Returning U from Update_Conviction_Info. '||SQLERRM;
10099: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10100: END IF;
10101:

Line 10131: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Remove_Person_Data';

10127:
10128: BEGIN
10129: /* Debug */
10130: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10131: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Remove_Person_Data';
10132: l_debug_str := 'Entering Remove_Person_Data. p_person_id is '||p_person_id||' and p_batch_id is '||p_batch_id;
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: -- Delete from all related tables

Line 10172: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Remove_Person_Data';

10168:
10169: 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
10170: /* Debug */
10171: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10172: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Remove_Person_Data';
10173: l_debug_str := 'Exiting Remove_Person_Data.';
10174: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10175: END IF;
10176:

Line 10218: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.EV_Batch_Process';

10214: BEGIN
10215: -- Just call the procedure
10216: /* Debug */
10217: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10218: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.EV_Batch_Process';
10219: l_debug_str := 'Entering EV_Batch_Process. p_validate_only is '||p_validate_only;
10220: l_debug_str := l_debug_str || 'l_org_id=' || l_org_id;
10221: l_debug_str := l_debug_str || 'l_dso_id=' || l_dso_id;
10222: l_debug_str := l_debug_str || 'l_dso_party_id=' || l_dso_party_id;

Line 10245: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.EV_Batch_Process';

10241:
10242: WHEN OTHERS THEN
10243: /* Debug */
10244: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10245: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.EV_Batch_Process';
10246: l_debug_str := 'Exception in EV_Batch_Process. '||SQLERRM;
10247: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10248: END IF;
10249:

Line 10523: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

10519:
10520: BEGIN
10521: /* Debug */
10522: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10523: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
10524: l_debug_str := 'Entering Create_Batch. p_batch_type is '||p_batch_type;
10525: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10526: END IF;
10527:

Line 10534: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

10530: SAVEPOINT Create_Batch;
10531: IF fnd_profile.value('IGS_SV_ENABLED') <> 'Y' THEN
10532: /* Debug */
10533: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10534: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
10535: l_debug_str := 'Raise ERROR: Sevis Disabled';
10536: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10537: END IF;
10538:

Line 10572: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

10568: CLOSE submiter_number_cur;
10569:
10570: /* Debug */
10571: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10572: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
10573: l_debug_str := 'Raise FND_API.G_EXC_ERROR: l_person_sevis_id is null';
10574: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10575: END IF;
10576:

Line 10596: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

10592:
10593: IF l_batch_id IS NOT NULL AND p_validate_only = 'N' THEN
10594: /*Debug*/
10595: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10596: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
10597: l_debug_str := 'Raise ERROR: message name IGS_SV_BATCH_FOUND';
10598: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10599: END IF;
10600:

Line 10687: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

10683:
10684: Put_Log_Msg('Initializing student record',0);
10685: /* Debug */
10686: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10687: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
10688: 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;
10689: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10690: END IF;
10691: -- Initialize record group for the student

Line 10762: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

10758: CLOSE c_get_dso_id;
10759: END IF;
10760: /* Debug */
10761: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10762: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
10763: l_debug_str := 'Inserting in igs_sv_persons batch id: '||l_batch_id;
10764: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10765: END IF;
10766: INSERT INTO igs_sv_persons (

Line 10859: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

10855: l_soa_count := l_count;
10856: IF l_student_rec.site_addr_status = 'U' THEN --Unexpected error - terminate execution
10857: /* Debug */
10858: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10859: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
10860: l_debug_str := 'Returning U from Create_Batch. site_addr_status is U.';
10861: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10862: END IF;
10863:

Line 10916: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

10912: FND_MESSAGE.SET_TOKEN('BLOCK_ID',5);
10913: FND_MSG_PUB.Add;
10914: /* Debug */
10915: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10916: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
10917: l_debug_str := 'IGS_SV_UNEXP_EXCPT_ERR in Create_Batch.';
10918: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10919: END IF;
10920:

Line 11014: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11010:
11011: IF l_status <> 'S' THEN
11012: /* Debug */
11013: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11014: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11015: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Employment_Info is not S';
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 11028: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11024: l_status := Update_Registration_Info ( p_person_rec => l_student_rec );
11025: IF l_status <> 'S' THEN
11026: /* Debug */
11027: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11028: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11029: l_debug_str := 'ERROR in Create_Batch. l_status is not S';
11030: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11031: END IF;
11032:

Line 11043: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11039:
11040: IF l_status <> 'S' THEN
11041: /* Debug */
11042: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11043: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11044: l_debug_str := 'ERROR in Create_Batch. changes_found <> Y and l_status is not S';
11045: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11046: END IF;
11047: RAISE FND_API.G_EXC_ERROR;

Line 11058: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11054:
11055: IF l_status <> 'S' THEN
11056: /* Debug */
11057: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11058: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11059: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Program_Info is not S';
11060: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11061: END IF;
11062:

Line 11075: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11071:
11072: IF l_status <> 'S' THEN
11073: /* Debug */
11074: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11075: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11076: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Finance_Info is not S';
11077: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11078: END IF;
11079: RAISE FND_API.G_EXC_ERROR;

Line 11091: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11087:
11088: IF l_status <> 'S' THEN
11089: /* Debug */
11090: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11091: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11092: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Dependent_Info is not S';
11093: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11094: END IF;
11095: RAISE FND_API.G_EXC_ERROR;

Line 11108: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11104:
11105: IF l_status <> 'S' THEN
11106: /* Debug */
11107: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11108: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11109: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Conviction_Info is not S';
11110: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11111: END IF;
11112: RAISE FND_API.G_EXC_ERROR;

Line 11147: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11143:
11144: IF l_status <> 'S' THEN
11145: /* Debug */
11146: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11147: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11148: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Personal_Info is not S';
11149: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11150: END IF;
11151:

Line 11158: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11154: l_status := Update_ev_legal_Info ( p_person_rec => l_student_rec );
11155: IF l_status <> 'S' THEN
11156: /* Debug */
11157: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11158: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11159: l_debug_str := 'ERROR in Create_Batch. Update_ev_legal_Info status is not S';
11160: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11161: END IF;
11162:

Line 11174: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11170:
11171: IF l_status <> 'S' THEN
11172: /* Debug */
11173: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11174: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11175: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Finance_Info is not S';
11176: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11177: END IF;
11178: RAISE FND_API.G_EXC_ERROR;

Line 11191: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11187:
11188: IF l_status <> 'S' THEN
11189: /* Debug */
11190: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11191: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11192: l_debug_str := 'ERROR in Create_Batch. l_status from Update_EV_Program_Info is not S';
11193: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11194: END IF;
11195: RAISE FND_API.G_EXC_ERROR;

Line 11208: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11204:
11205: IF l_status <> 'S' THEN
11206: /* Debug */
11207: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11208: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11209: l_debug_str := 'ERROR in Create_Batch. l_status from Update_EV_Address_Info is not S';
11210: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11211: END IF;
11212: RAISE FND_API.G_EXC_ERROR;

Line 11225: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11221:
11222: IF l_status <> 'S' THEN
11223: /* Debug */
11224: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11225: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11226: l_debug_str := 'ERROR in Create_Batch. l_status from Update_Dependent_Info is not S';
11227: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11228: END IF;
11229: RAISE FND_API.G_EXC_ERROR;

Line 11332: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11328: DELETE FROM igs_sv_batches WHERE batch_id > l_batch_id;
11329: END IF;
11330: /* Debug */
11331: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11332: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11333: l_debug_str := 'Commiting in Create_Batch. l_batch_status: '||l_batch_status;
11334: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11335: END IF;
11336: compose_log_file;

Line 11347: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11343:
11344: WHEN FND_API.G_EXC_ERROR THEN
11345: /* Debug */
11346: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11347: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11348: l_debug_str := 'FND_API.G_EXC_ERROR exception in Create_Batch. '||SQLERRM;
11349: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11350: END IF;
11351: ROLLBACK TO Create_Batch;

Line 11365: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';

11361: WHEN OTHERS THEN
11362:
11363: /* Debug */
11364: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11365: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
11366: l_debug_str := 'Other exception in Create_Batch. '||SQLERRM;
11367: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11368: END IF;
11369: ROLLBACK TO Create_Batch;

Line 11423: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Batch_Process';

11419:
11420: BEGIN
11421: /* Debug */
11422: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11423: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Batch_Process';
11424: l_debug_str := 'Entering NIMG_Batch_Process.';
11425: l_debug_str := l_debug_str || 'l_org_id=' || l_org_id;
11426: l_debug_str := l_debug_str || 'l_dso_id=' || l_dso_id;
11427: l_debug_str := l_debug_str || 'l_dso_party_id=' || l_dso_party_id;

Line 11455: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Batch_Process';

11451: WHEN OTHERS THEN
11452:
11453: /* Debug */
11454: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11455: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Batch_Process';
11456: l_debug_str := 'Exception in NIMG_Batch_Process. '||SQLERRM;
11457: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11458: END IF;
11459:

Line 11511: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Purge_Batch';

11507: BEGIN
11508:
11509: /* Debug */
11510: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11511: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Purge_Batch';
11512: l_debug_str := 'Entering Purge_Batch. p_batch_type is '||p_batch_type;
11513: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11514: END IF;
11515: FND_MSG_PUB.initialize;

Line 11543: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Batch_Process';

11539:
11540: retcode := 0;
11541: /* Debug */
11542: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11543: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Batch_Process';
11544: l_debug_str := 'retcode in NIMG_Batch_Process: '||retcode;
11545: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11546: END IF;
11547: EXCEPTION

Line 11553: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Batch_Process';

11549: WHEN FND_API.G_EXC_ERROR THEN
11550:
11551: /* Debug */
11552: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11553: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Batch_Process';
11554: l_debug_str := 'FND_API.G_EXC_ERROR Exception in NIMG_Batch_Process. '||SQLERRM;
11555: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11556: END IF;
11557: ROLLBACK TO Purge_Batch;

Line 11567: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Batch_Process';

11563: WHEN OTHERS THEN
11564:
11565: /* Debug */
11566: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11567: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Batch_Process';
11568: l_debug_str := 'Exception in NIMG_Batch_Process. '||SQLERRM;
11569: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11570: END IF;
11571: ROLLBACK TO Purge_Batch;

Line 11613: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.EV_Purge_Batch';

11609:
11610: BEGIN
11611: /* Debug */
11612: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11613: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.EV_Purge_Batch';
11614: l_debug_str := 'Entering EV_Purge_Batch.';
11615: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11616: END IF;
11617: -- Just call the procedure

Line 11629: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.EV_Purge_Batch';

11625:
11626: WHEN OTHERS THEN
11627: /* Debug */
11628: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11629: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.EV_Purge_Batch';
11630: l_debug_str := 'EXCEPTION in EV_Purge_Batch. '||SQLERRM;
11631: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11632: END IF;
11633: retcode := 2;

Line 11674: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Purge_Batch';

11670: BEGIN
11671:
11672: /* Debug */
11673: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11674: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Purge_Batch';
11675: l_debug_str := 'Entering NIMG_Purge_Batch.';
11676: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11677: END IF;
11678: -- Just call the procedure

Line 11692: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Purge_Batch';

11688:
11689: WHEN OTHERS THEN
11690: /* Debug */
11691: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11692: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.NIMG_Purge_Batch';
11693: l_debug_str := 'EXCEPTION in NIMG_Purge_Batch. '||SQLERRM;
11694: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11695: END IF;
11696: ROLLBACK TO NIMG_Purge_Batch;

Line 11733: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Generate_Message';

11729:
11730: BEGIN
11731: /* Debug */
11732: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11733: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Generate_Message';
11734: l_debug_str := 'Entering Generate_Message.';
11735: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11736: END IF;
11737: FND_MSg_PUB.Count_And_Get ( p_count => l_msg_count,

Line 11758: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Generate_Message';

11754:
11755: END IF;
11756: /* Debug */
11757: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11758: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Generate_Message';
11759: l_debug_str := 'Exiting Generate_Message. l_msg_data is: '||l_msg_data;
11760: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11761: END IF;
11762: END Generate_Message;

Line 11823: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_person_record';

11819:
11820: BEGIN
11821: /* Debug */
11822: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11823: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_person_record';
11824: l_debug_str := 'Entering process_person_record. p_sevisID is: '||p_sevisID||' and p_person_id is: '||p_person_id;
11825: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11826: END IF;
11827:

Line 11897: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_person_record';

11893:
11894: END IF;
11895: /* Debug */
11896: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11897: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_person_record';
11898: l_debug_str := 'Exiting process_person_record';
11899: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11900: END IF;
11901:

Line 11934: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_trans_header';

11930:
11931: BEGIN
11932:
11933: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11934: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_trans_header';
11935: l_debug_str := 'Came in with p_BatchID = '||p_BatchID||' p_FileErrorCode = '||p_FileErrorCode ||' p_FileValidation = '||p_FileValidation||' '||SQLERRM;
11936: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11937: END IF;
11938:

Line 11987: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_trans_header';

11983: EXCEPTION
11984: WHEN FND_API.G_EXC_ERROR THEN
11985: /* Debug */
11986: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11987: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_trans_header';
11988: l_debug_str := 'FND_API.G_EXC_ERROR in process_trans_header '||SQLERRM;
11989: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11990: END IF;
11991: ROLLBACK TO process_trans_header;

Line 11995: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_trans_header';

11991: ROLLBACK TO process_trans_header;
11992: WHEN OTHERS THEN
11993: /* Debug */
11994: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
11995: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_trans_header';
11996: l_debug_str := 'Exiting process_trans_header '||SQLERRM;
11997: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
11998: END IF;
11999: ROLLBACK TO process_trans_header;

Line 12045: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_student_record';

12041:
12042: BEGIN
12043:
12044: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12045: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_student_record';
12046: l_debug_str := 'Came in with p_BatchID = '||p_BatchID||' p_sevisID = '||p_sevisID
12047: ||' p_PersonID = '||p_PersonID|| ' p_Status = '||p_Status
12048: ||' p_SEVIS_ErrorCode = '||p_SEVIS_ErrorCode||' p_SEVIS_ErrorElement = '||p_SEVIS_ErrorElement||' '||SQLERRM;
12049: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);

Line 12126: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_dep_record';

12122:
12123:
12124: BEGIN
12125: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12126: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.process_dep_record';
12127: l_debug_str := 'Came in with p_BatchID = '||p_BatchID||' p_DepPersonID = '||p_DepPersonID
12128: ||' p_DepSevisID = '||p_DepSevisID||' p_PersonID = '||p_PersonID
12129: || ' p_Status = '||p_Status||' p_SEVIS_ErrorCode = '
12130: ||p_SEVIS_ErrorCode||' p_SEVIS_ErrorElement = '||p_SEVIS_ErrorElement||' '||SQLERRM;

Line 12204: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Summary_Info';

12200: l_batch NUMBER(20) := 0;
12201: BEGIN
12202: /* Debug */
12203: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12204: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Summary_Info';
12205: l_debug_str := 'Entering Insert_Summary_Info. p_data_rec.person_id is '||p_person_id|| ' and batch_id is '||p_batch_id;
12206: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12207: END IF;
12208:

Line 12245: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Summary_Info';

12241: FETCH c_test INTO l_batch;
12242: CLOSE c_test;
12243: /* Debug */
12244: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12245: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Summary_Info';
12246: l_debug_str := 'record in Insert_Summary_Info max batch_id: '||l_batch;
12247: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12248: END IF;
12249: EXCEPTION

Line 12257: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Summary_Info';

12253: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12254: END IF;
12255: /* Debug */
12256: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12257: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Insert_Summary_Info';
12258: l_debug_str := 'EXCEPTION in Insert_Summary_Info. '||SQLERRM;
12259: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12260: END IF;
12261: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 12295: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Generate_Batch_XML';

12291: l_batch_type VARCHAR2(1);
12292: BEGIN
12293: /* Debug */
12294: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12295: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Generate_Batch_XML';
12296: l_debug_str := 'Batch_id for Generate_Batch_XML: '||batch_id;
12297: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12298: END IF;
12299: Put_Log_Msg('Batch_id for Generate_Batch_XML: '||batch_id, 0);

Line 12473: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.compose_log_file';

12469: FND_MSg_PUB.Add_Exc_Msg (g_PKg_NAME, l_api_name);
12470: END IF;
12471: /* Debug */
12472: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
12473: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.compose_log_file';
12474: l_debug_str := 'EXCEPTION in compose_log_file.'||SQLERRM;
12475: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
12476: END IF;
12477: Put_Log_Msg(l_api_name||' OTHERS ERROR ',0);

Line 12483: END igs_sv_ni_batch_process_pkg;

12479: RAISE;
12480:
12481: END compose_log_file;
12482:
12483: END igs_sv_ni_batch_process_pkg;