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

APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on FND_FILE

Line 12970: fnd_file.put_line (FND_FILE.LOG,p_message);

12966:
12967: -- This procedure outputs messages into the log file Level 0 - System messages. 1 - user messages
12968: IF p_level >= g_debug_level THEN
12969:
12970: fnd_file.put_line (FND_FILE.LOG,p_message);
12971:
12972: END IF;
12973:
12974: END Put_Log_Msg;

Line 13560: fnd_file.put_line(FND_FILE.LOG,' ');

13556:
13557: FOR c_new_pers_rec IN c_new_pers(p_batch_id) LOOP
13558: l_per_count := l_per_count + 1;
13559: IF l_per_count = 1 THEN
13560: fnd_file.put_line(FND_FILE.LOG,' ');
13561: fnd_message.set_name('IGS','IGS_SV_PERS_ON_HOLD');
13562: fnd_file.put_line(fnd_file.log,fnd_message.get());
13563: fnd_file.put_line(FND_FILE.LOG,' ');
13564: fnd_message.set_name('IGS','IGS_SV_PER_NUM');

Line 13562: fnd_file.put_line(fnd_file.log,fnd_message.get());

13558: l_per_count := l_per_count + 1;
13559: IF l_per_count = 1 THEN
13560: fnd_file.put_line(FND_FILE.LOG,' ');
13561: fnd_message.set_name('IGS','IGS_SV_PERS_ON_HOLD');
13562: fnd_file.put_line(fnd_file.log,fnd_message.get());
13563: fnd_file.put_line(FND_FILE.LOG,' ');
13564: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13565: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13566: Put_Log_Msg(' --------------',1);

Line 13563: fnd_file.put_line(FND_FILE.LOG,' ');

13559: IF l_per_count = 1 THEN
13560: fnd_file.put_line(FND_FILE.LOG,' ');
13561: fnd_message.set_name('IGS','IGS_SV_PERS_ON_HOLD');
13562: fnd_file.put_line(fnd_file.log,fnd_message.get());
13563: fnd_file.put_line(FND_FILE.LOG,' ');
13564: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13565: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13566: Put_Log_Msg(' --------------',1);
13567: END IF;

Line 13565: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

13561: fnd_message.set_name('IGS','IGS_SV_PERS_ON_HOLD');
13562: fnd_file.put_line(fnd_file.log,fnd_message.get());
13563: fnd_file.put_line(FND_FILE.LOG,' ');
13564: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13565: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13566: Put_Log_Msg(' --------------',1);
13567: END IF;
13568: Put_Log_Msg(' ' || c_new_pers_rec.person_number,1);
13569: END LOOP;

Line 13576: fnd_file.put_line(FND_FILE.LOG,' ');

13572:
13573: FOR c_updated_pers_rec IN c_updated_pers(p_batch_id) LOOP
13574: l_per_count := l_per_count + 1;
13575: IF l_per_count = 1 THEN
13576: fnd_file.put_line(FND_FILE.LOG,' ');
13577: fnd_message.set_name('IGS','IGS_SV_INFO_ON_HOLD');
13578: fnd_file.put_line(fnd_file.log,fnd_message.get());
13579: fnd_file.put_line(FND_FILE.LOG,' ');
13580: fnd_message.set_name('IGS','IGS_SV_PER_NUM');

Line 13578: fnd_file.put_line(fnd_file.log,fnd_message.get());

13574: l_per_count := l_per_count + 1;
13575: IF l_per_count = 1 THEN
13576: fnd_file.put_line(FND_FILE.LOG,' ');
13577: fnd_message.set_name('IGS','IGS_SV_INFO_ON_HOLD');
13578: fnd_file.put_line(fnd_file.log,fnd_message.get());
13579: fnd_file.put_line(FND_FILE.LOG,' ');
13580: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13581: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));
13582: fnd_message.set_name('IGS','IGS_SV_INFMN');

Line 13579: fnd_file.put_line(FND_FILE.LOG,' ');

13575: IF l_per_count = 1 THEN
13576: fnd_file.put_line(FND_FILE.LOG,' ');
13577: fnd_message.set_name('IGS','IGS_SV_INFO_ON_HOLD');
13578: fnd_file.put_line(fnd_file.log,fnd_message.get());
13579: fnd_file.put_line(FND_FILE.LOG,' ');
13580: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13581: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));
13582: fnd_message.set_name('IGS','IGS_SV_INFMN');
13583: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

Line 13581: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));

13577: fnd_message.set_name('IGS','IGS_SV_INFO_ON_HOLD');
13578: fnd_file.put_line(fnd_file.log,fnd_message.get());
13579: fnd_file.put_line(FND_FILE.LOG,' ');
13580: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13581: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));
13582: fnd_message.set_name('IGS','IGS_SV_INFMN');
13583: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13584: Put_Log_Msg(' -------------- ------------ ',1);
13585:

Line 13583: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

13579: fnd_file.put_line(FND_FILE.LOG,' ');
13580: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13581: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));
13582: fnd_message.set_name('IGS','IGS_SV_INFMN');
13583: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13584: Put_Log_Msg(' -------------- ------------ ',1);
13585:
13586: END IF;
13587: OPEN c_get_prsn_num(c_updated_pers_rec.person_id);

Line 13670: fnd_file.put_line(fnd_file.log,fnd_message.get());

13666: AND pers.record_status = 'C';
13667:
13668: BEGIN
13669: fnd_message.set_name('IGS','IGS_SV_BTCH');
13670: fnd_file.put_line(fnd_file.log,fnd_message.get());
13671: fnd_file.put_line(FND_FILE.LOG,' ');
13672: --Put_Log_Msg(' Following Batch IDs are generated: ',0);
13673: fnd_message.set_name('IGS','IGS_SV_BTCH_ID');
13674: fnd_file.put(fnd_file.log,' ' || fnd_message.get());

Line 13671: fnd_file.put_line(FND_FILE.LOG,' ');

13667:
13668: BEGIN
13669: fnd_message.set_name('IGS','IGS_SV_BTCH');
13670: fnd_file.put_line(fnd_file.log,fnd_message.get());
13671: fnd_file.put_line(FND_FILE.LOG,' ');
13672: --Put_Log_Msg(' Following Batch IDs are generated: ',0);
13673: fnd_message.set_name('IGS','IGS_SV_BTCH_ID');
13674: fnd_file.put(fnd_file.log,' ' || fnd_message.get());
13675: fnd_message.set_name('IGS','IGS_SV_PERS_COUNT');

Line 13674: fnd_file.put(fnd_file.log,' ' || fnd_message.get());

13670: fnd_file.put_line(fnd_file.log,fnd_message.get());
13671: fnd_file.put_line(FND_FILE.LOG,' ');
13672: --Put_Log_Msg(' Following Batch IDs are generated: ',0);
13673: fnd_message.set_name('IGS','IGS_SV_BTCH_ID');
13674: fnd_file.put(fnd_file.log,' ' || fnd_message.get());
13675: fnd_message.set_name('IGS','IGS_SV_PERS_COUNT');
13676: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13677: --Put_Log_Msg(' Batch ID No. of Persons',0);
13678: --Put_Log_Msg(' -------- --------------',0);

Line 13676: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

13672: --Put_Log_Msg(' Following Batch IDs are generated: ',0);
13673: fnd_message.set_name('IGS','IGS_SV_BTCH_ID');
13674: fnd_file.put(fnd_file.log,' ' || fnd_message.get());
13675: fnd_message.set_name('IGS','IGS_SV_PERS_COUNT');
13676: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13677: --Put_Log_Msg(' Batch ID No. of Persons',0);
13678: --Put_Log_Msg(' -------- --------------',0);
13679: -- g_running_batches(1) := 2020205;
13680:

Line 13699: fnd_file.put_line(FND_FILE.LOG,' ');

13695: Put_Log_Msg(' ' || g_running_batches(i) || ' : ' || l_per_count,1);
13696: l_batch_count := l_batch_count+1;
13697: END LOOP;
13698:
13699: fnd_file.put_line(FND_FILE.LOG,' ');
13700: fnd_message.set_name('IGS','IGS_SV_BTCH_PERS');
13701: fnd_file.put_line(fnd_file.log,fnd_message.get());
13702: fnd_file.put_line(FND_FILE.LOG,' ');
13703: -- Put_Log_Msg(' ',0);

Line 13701: fnd_file.put_line(fnd_file.log,fnd_message.get());

13697: END LOOP;
13698:
13699: fnd_file.put_line(FND_FILE.LOG,' ');
13700: fnd_message.set_name('IGS','IGS_SV_BTCH_PERS');
13701: fnd_file.put_line(fnd_file.log,fnd_message.get());
13702: fnd_file.put_line(FND_FILE.LOG,' ');
13703: -- Put_Log_Msg(' ',0);
13704: -- Put_Log_Msg(' Following are the person records included in each batch: ',0);
13705: -- Put_Log_Msg(' ',0);

Line 13702: fnd_file.put_line(FND_FILE.LOG,' ');

13698:
13699: fnd_file.put_line(FND_FILE.LOG,' ');
13700: fnd_message.set_name('IGS','IGS_SV_BTCH_PERS');
13701: fnd_file.put_line(fnd_file.log,fnd_message.get());
13702: fnd_file.put_line(FND_FILE.LOG,' ');
13703: -- Put_Log_Msg(' ',0);
13704: -- Put_Log_Msg(' Following are the person records included in each batch: ',0);
13705: -- Put_Log_Msg(' ',0);
13706:

Line 13709: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get() || ': ' || g_parallel_batches(i));

13705: -- Put_Log_Msg(' ',0);
13706:
13707: FOR i IN 1..g_parallel_batches.COUNT LOOP
13708: fnd_message.set_name('IGS','IGS_SV_BTCH_ID');
13709: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get() || ': ' || g_parallel_batches(i));
13710: -- Put_Log_Msg(' Batch ID: '||g_parallel_batches(i),0);
13711: -- Put_Log_Msg(' ------------------------',0);
13712: fnd_message.set_name('IGS','IGS_SV_NEW_PERS');
13713: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

Line 13713: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

13709: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get() || ': ' || g_parallel_batches(i));
13710: -- Put_Log_Msg(' Batch ID: '||g_parallel_batches(i),0);
13711: -- Put_Log_Msg(' ------------------------',0);
13712: fnd_message.set_name('IGS','IGS_SV_NEW_PERS');
13713: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13714: --- Put_Log_Msg(' New Persons: ',0);
13715: -- Put_Log_Msg(' ------------',0);
13716: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13717: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));

Line 13717: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));

13713: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13714: --- Put_Log_Msg(' New Persons: ',0);
13715: -- Put_Log_Msg(' ------------',0);
13716: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13717: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));
13718: fnd_message.set_name('IGS','IGS_SV_INFMN');
13719: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13720: -- Put_Log_Msg(' Person Number Information ',0);
13721: Put_Log_Msg(' -------------- ------------ ',1);

Line 13719: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

13715: -- Put_Log_Msg(' ------------',0);
13716: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13717: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));
13718: fnd_message.set_name('IGS','IGS_SV_INFMN');
13719: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13720: -- Put_Log_Msg(' Person Number Information ',0);
13721: Put_Log_Msg(' -------------- ------------ ',1);
13722:
13723: FOR new_persons IN c_get_new_persons(g_parallel_batches(i)) LOOP

Line 13728: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

13724: Put_Log_Msg(' ' || rpad(new_persons.prsn_num,30,' ') || ' ' || new_persons.info,1);
13725: END LOOP;
13726:
13727: fnd_message.set_name('IGS','IGS_SV_UPD_PERS');
13728: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13729: --Put_Log_Msg(' Updated Persons: ',0);
13730: Put_Log_Msg(' ----------------',1);
13731: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13732: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));

Line 13732: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));

13728: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13729: --Put_Log_Msg(' Updated Persons: ',0);
13730: Put_Log_Msg(' ----------------',1);
13731: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13732: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));
13733: fnd_message.set_name('IGS','IGS_SV_INFMN');
13734: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13735: --Put_Log_Msg(' Person Number Information ',0);
13736: Put_Log_Msg(' -------------- ------------ ',1);

Line 13734: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

13730: Put_Log_Msg(' ----------------',1);
13731: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13732: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));
13733: fnd_message.set_name('IGS','IGS_SV_INFMN');
13734: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13735: --Put_Log_Msg(' Person Number Information ',0);
13736: Put_Log_Msg(' -------------- ------------ ',1);
13737:
13738: FOR updated_persons IN c_get_updated_persons(g_parallel_batches(i)) LOOP

Line 13748: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

13744: FOR i IN 1..g_running_batches.COUNT LOOP
13745: Put_Log_Msg(' Batch ID: ' || g_running_batches(i),1);
13746: Put_Log_Msg(' ------------------------',1);
13747: fnd_message.set_name('IGS','IGS_SV_NEW_PERS');
13748: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13749: -- Put_Log_Msg(' New Persons: ',0);
13750: Put_Log_Msg(' ------------',1);
13751: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13752: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));

Line 13752: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));

13748: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13749: -- Put_Log_Msg(' New Persons: ',0);
13750: Put_Log_Msg(' ------------',1);
13751: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13752: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));
13753: fnd_message.set_name('IGS','IGS_SV_INFMN');
13754: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13755: -- Put_Log_Msg(' Person Number Information ',0);
13756: Put_Log_Msg(' -------------- ------------ ',1);

Line 13754: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

13750: Put_Log_Msg(' ------------',1);
13751: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13752: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));
13753: fnd_message.set_name('IGS','IGS_SV_INFMN');
13754: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13755: -- Put_Log_Msg(' Person Number Information ',0);
13756: Put_Log_Msg(' -------------- ------------ ',1);
13757:
13758: FOR new_persons IN c_get_new_persons(g_running_batches(i)) LOOP

Line 13763: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

13759: Put_Log_Msg(' ' || rpad(new_persons.prsn_num,30,' ') || ' ' || new_persons.info,1);
13760: END LOOP;
13761:
13762: fnd_message.set_name('IGS','IGS_SV_UPD_PERS');
13763: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13764: -- Put_Log_Msg(' Updated Persons: ',0);
13765: Put_Log_Msg(' ----------------',1);
13766: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13767: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));

Line 13767: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));

13763: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13764: -- Put_Log_Msg(' Updated Persons: ',0);
13765: Put_Log_Msg(' ----------------',1);
13766: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13767: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));
13768: fnd_message.set_name('IGS','IGS_SV_INFMN');
13769: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13770: --Put_Log_Msg(' Person Number Information ',0);
13771: Put_Log_Msg(' -------------- ------------ ',1);

Line 13769: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

13765: Put_Log_Msg(' ----------------',1);
13766: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
13767: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),30,' '));
13768: fnd_message.set_name('IGS','IGS_SV_INFMN');
13769: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
13770: --Put_Log_Msg(' Person Number Information ',0);
13771: Put_Log_Msg(' -------------- ------------ ',1);
13772:
13773: FOR updated_persons IN c_get_updated_persons(g_running_batches(i)) LOOP

Line 13924: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

13920:
13921: IF p_group_id IS NULL THEN
13922: -- Put_Log_Msg('Group ID cannot be left blank when new DSO is being assigned for a group', 0);
13923: FND_MESSAGE.SET_NAME('IGS','IGS_SV_INV_GRP_ID');
13924: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
13925: FND_MSG_PUB.Add;
13926: RAISE FND_API.G_EXC_ERROR;
13927: END IF;
13928:

Line 13932: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

13928:
13929: l_str := igs_pe_dynamic_persid_group.igs_get_dynamic_sql(p_group_id ,lv_status);
13930: IF lv_status <> 'S' THEN
13931: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');
13932: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
13933: RETURN;
13934: END IF;
13935:
13936: /* Debug */

Line 14009: fnd_file.put_line(fnd_file.log,fnd_message.get());

14005:
14006: IF l_counter = 1 THEN
14007: fnd_message.set_name('IGS','IGS_SV_NEW_REL');
14008: fnd_message.set_token('PRSN_NAME', l_first_name||' '|| l_last_name);
14009: fnd_file.put_line(fnd_file.log,fnd_message.get());
14010: -- Put_Log_Msg('New DSO_OF relationship created for following persons with '||l_first_name||' '|| l_last_name, 0);
14011: Put_Log_Msg(' ', 1);
14012: fnd_message.set_name('IGS','IGS_SV_PRSN_NAME');
14013: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));

Line 14013: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));

14009: fnd_file.put_line(fnd_file.log,fnd_message.get());
14010: -- Put_Log_Msg('New DSO_OF relationship created for following persons with '||l_first_name||' '|| l_last_name, 0);
14011: Put_Log_Msg(' ', 1);
14012: fnd_message.set_name('IGS','IGS_SV_PRSN_NAME');
14013: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14014: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
14015: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14016: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));
14017: fnd_file.put_line(fnd_file.log,' -------------');

Line 14015: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

14011: Put_Log_Msg(' ', 1);
14012: fnd_message.set_name('IGS','IGS_SV_PRSN_NAME');
14013: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14014: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
14015: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14016: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));
14017: fnd_file.put_line(fnd_file.log,' -------------');
14018: -- Put_Log_Msg('Person Name Person Number', 0);
14019: -- Put_Log_Msg('----------- -------------', 0);

Line 14016: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));

14012: fnd_message.set_name('IGS','IGS_SV_PRSN_NAME');
14013: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14014: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
14015: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14016: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));
14017: fnd_file.put_line(fnd_file.log,' -------------');
14018: -- Put_Log_Msg('Person Name Person Number', 0);
14019: -- Put_Log_Msg('----------- -------------', 0);
14020: END IF;

Line 14017: fnd_file.put_line(fnd_file.log,' -------------');

14013: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14014: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
14015: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14016: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));
14017: fnd_file.put_line(fnd_file.log,' -------------');
14018: -- Put_Log_Msg('Person Name Person Number', 0);
14019: -- Put_Log_Msg('----------- -------------', 0);
14020: END IF;
14021: OPEN c_get_person_num(l_person_id);

Line 14024: fnd_file.put(fnd_file.log,' ' || rpad(l_first_name||' '|| l_last_name,60,' '));

14020: END IF;
14021: OPEN c_get_person_num(l_person_id);
14022: FETCH c_get_person_num INTO l_person_num, l_first_name, l_last_name;
14023: CLOSE c_get_person_num;
14024: fnd_file.put(fnd_file.log,' ' || rpad(l_first_name||' '|| l_last_name,60,' '));
14025: fnd_file.put_line(fnd_file.log,' ' || l_person_num);
14026: --Put_Log_Msg(l_first_name||' '|| l_last_name||' '|| l_person_num, 0);
14027: ELSE
14028: l_temp_count := l_temp_count + 1;

Line 14025: fnd_file.put_line(fnd_file.log,' ' || l_person_num);

14021: OPEN c_get_person_num(l_person_id);
14022: FETCH c_get_person_num INTO l_person_num, l_first_name, l_last_name;
14023: CLOSE c_get_person_num;
14024: fnd_file.put(fnd_file.log,' ' || rpad(l_first_name||' '|| l_last_name,60,' '));
14025: fnd_file.put_line(fnd_file.log,' ' || l_person_num);
14026: --Put_Log_Msg(l_first_name||' '|| l_last_name||' '|| l_person_num, 0);
14027: ELSE
14028: l_temp_count := l_temp_count + 1;
14029: OPEN c_get_person_num(l_person_id);

Line 14047: fnd_file.put_line(fnd_file.log,fnd_message.get());

14043: FOR i IN 1..g_existing_rel.COUNT LOOP
14044: IF i = 1 THEN
14045: Put_Log_Msg(' ', 1);
14046: fnd_message.set_name('IGS','IGS_SV_REL_EXISTS');
14047: fnd_file.put_line(fnd_file.log,fnd_message.get());
14048: Put_Log_Msg(' ', 1);
14049: fnd_message.set_name('IGS','IGS_SV_PRSN_NAME');
14050: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14051: fnd_message.set_name('IGS','IGS_SV_PER_NUM');

Line 14050: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));

14046: fnd_message.set_name('IGS','IGS_SV_REL_EXISTS');
14047: fnd_file.put_line(fnd_file.log,fnd_message.get());
14048: Put_Log_Msg(' ', 1);
14049: fnd_message.set_name('IGS','IGS_SV_PRSN_NAME');
14050: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14051: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
14052: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),20,' '));
14053: fnd_message.set_name('IGS','IGS_SV_DSO');
14054: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

Line 14052: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),20,' '));

14048: Put_Log_Msg(' ', 1);
14049: fnd_message.set_name('IGS','IGS_SV_PRSN_NAME');
14050: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14051: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
14052: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),20,' '));
14053: fnd_message.set_name('IGS','IGS_SV_DSO');
14054: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14055:
14056: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));

Line 14054: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

14050: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14051: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
14052: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),20,' '));
14053: fnd_message.set_name('IGS','IGS_SV_DSO');
14054: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14055:
14056: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));
14057: fnd_file.put(fnd_file.log, rpad(' -----------',20,' '));
14058: fnd_file.put_line(fnd_file.log,' -------------');

Line 14056: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));

14052: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),20,' '));
14053: fnd_message.set_name('IGS','IGS_SV_DSO');
14054: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14055:
14056: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));
14057: fnd_file.put(fnd_file.log, rpad(' -----------',20,' '));
14058: fnd_file.put_line(fnd_file.log,' -------------');
14059:
14060: -- Put_Log_Msg('Relationship not created for following persons:',0);

Line 14057: fnd_file.put(fnd_file.log, rpad(' -----------',20,' '));

14053: fnd_message.set_name('IGS','IGS_SV_DSO');
14054: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14055:
14056: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));
14057: fnd_file.put(fnd_file.log, rpad(' -----------',20,' '));
14058: fnd_file.put_line(fnd_file.log,' -------------');
14059:
14060: -- Put_Log_Msg('Relationship not created for following persons:',0);
14061: -- Put_Log_Msg('Person Name Person Number Existing DSO',0);

Line 14058: fnd_file.put_line(fnd_file.log,' -------------');

14054: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14055:
14056: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));
14057: fnd_file.put(fnd_file.log, rpad(' -----------',20,' '));
14058: fnd_file.put_line(fnd_file.log,' -------------');
14059:
14060: -- Put_Log_Msg('Relationship not created for following persons:',0);
14061: -- Put_Log_Msg('Person Name Person Number Existing DSO',0);
14062: -- Put_Log_Msg('----------- ------------- ------------',0);

Line 14064: fnd_file.put(fnd_file.log,' ' || rpad(g_existing_rel(i).person_name,60,' '));

14060: -- Put_Log_Msg('Relationship not created for following persons:',0);
14061: -- Put_Log_Msg('Person Name Person Number Existing DSO',0);
14062: -- Put_Log_Msg('----------- ------------- ------------',0);
14063: END IF;
14064: fnd_file.put(fnd_file.log,' ' || rpad(g_existing_rel(i).person_name,60,' '));
14065: fnd_file.put(fnd_file.log,' ' || rpad(g_existing_rel(i).person_num,20,' '));
14066: fnd_file.put_line(fnd_file.log,' ' || g_existing_rel(i).dso_person_num);
14067: -- Put_Log_Msg(g_existing_rel(i).person_name || ' '||rpad(g_existing_rel(i).person_num,20,' ')||' ' || g_existing_rel(i).dso_person_num,0);
14068: END LOOP;

Line 14065: fnd_file.put(fnd_file.log,' ' || rpad(g_existing_rel(i).person_num,20,' '));

14061: -- Put_Log_Msg('Person Name Person Number Existing DSO',0);
14062: -- Put_Log_Msg('----------- ------------- ------------',0);
14063: END IF;
14064: fnd_file.put(fnd_file.log,' ' || rpad(g_existing_rel(i).person_name,60,' '));
14065: fnd_file.put(fnd_file.log,' ' || rpad(g_existing_rel(i).person_num,20,' '));
14066: fnd_file.put_line(fnd_file.log,' ' || g_existing_rel(i).dso_person_num);
14067: -- Put_Log_Msg(g_existing_rel(i).person_name || ' '||rpad(g_existing_rel(i).person_num,20,' ')||' ' || g_existing_rel(i).dso_person_num,0);
14068: END LOOP;
14069: Put_Log_Msg(' ', 1);

Line 14066: fnd_file.put_line(fnd_file.log,' ' || g_existing_rel(i).dso_person_num);

14062: -- Put_Log_Msg('----------- ------------- ------------',0);
14063: END IF;
14064: fnd_file.put(fnd_file.log,' ' || rpad(g_existing_rel(i).person_name,60,' '));
14065: fnd_file.put(fnd_file.log,' ' || rpad(g_existing_rel(i).person_num,20,' '));
14066: fnd_file.put_line(fnd_file.log,' ' || g_existing_rel(i).dso_person_num);
14067: -- Put_Log_Msg(g_existing_rel(i).person_name || ' '||rpad(g_existing_rel(i).person_num,20,' ')||' ' || g_existing_rel(i).dso_person_num,0);
14068: END LOOP;
14069: Put_Log_Msg(' ', 1);
14070: fnd_message.set_name('IGS','IGS_SV_REL_CREATED');

Line 14072: fnd_file.put_line(fnd_file.log,fnd_message.get());

14068: END LOOP;
14069: Put_Log_Msg(' ', 1);
14070: fnd_message.set_name('IGS','IGS_SV_REL_CREATED');
14071: fnd_message.set_token('COUNT', l_counter);
14072: fnd_file.put_line(fnd_file.log,fnd_message.get());
14073: Put_Log_Msg(' ', 1);
14074: fnd_message.set_name('IGS','IGS_SV_REL_NOT_CRTED');
14075: fnd_message.set_token('COUNT', g_existing_rel.COUNT);
14076: fnd_file.put_line(fnd_file.log,fnd_message.get());

Line 14076: fnd_file.put_line(fnd_file.log,fnd_message.get());

14072: fnd_file.put_line(fnd_file.log,fnd_message.get());
14073: Put_Log_Msg(' ', 1);
14074: fnd_message.set_name('IGS','IGS_SV_REL_NOT_CRTED');
14075: fnd_message.set_token('COUNT', g_existing_rel.COUNT);
14076: fnd_file.put_line(fnd_file.log,fnd_message.get());
14077: ELSE
14078: IF p_old_dso_id IS NULL THEN
14079: --Put_Log_Msg('Enter the old DSO ID for which new relationships have to be created.', 0);
14080: FND_MESSAGE.SET_NAME('IGS','IGS_SV_INV_DSO_ID');

Line 14081: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

14077: ELSE
14078: IF p_old_dso_id IS NULL THEN
14079: --Put_Log_Msg('Enter the old DSO ID for which new relationships have to be created.', 0);
14080: FND_MESSAGE.SET_NAME('IGS','IGS_SV_INV_DSO_ID');
14081: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
14082: FND_MSG_PUB.Add;
14083: RAISE FND_API.G_EXC_ERROR;
14084: END IF;
14085: IF p_old_dso_id = p_new_dso_id THEN

Line 14088: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

14084: END IF;
14085: IF p_old_dso_id = p_new_dso_id THEN
14086: --Put_Log_Msg('Old DSO ID and new DSO ID cannot be same. Request Terminated', 0);
14087: FND_MESSAGE.SET_NAME('IGS','IGS_SV_INV_PARAMS');
14088: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
14089: FND_MSG_PUB.Add;
14090: RAISE FND_API.G_EXC_ERROR;
14091: END IF;
14092: FOR r_old_dso_rel_rec IN c_old_dso_rel(l_old_dso_partyid) LOOP

Line 14171: fnd_file.put_line(fnd_file.log,fnd_message.get());

14167: CLOSE c_get_person_num;
14168: fnd_message.set_name('IGS','IGS_SV_REL_UPD');
14169: fnd_message.set_token('OLD_DSO_NAME', l_first_name||' '|| l_last_name);
14170: fnd_message.set_token('NEW_DSO_NAME', l_new_first_name||' '|| l_new_last_name);
14171: fnd_file.put_line(fnd_file.log,fnd_message.get());
14172: Put_Log_Msg(' ', 1);
14173: fnd_message.set_name('IGS','IGS_SV_PRSN_NAME');
14174: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14175: fnd_message.set_name('IGS','IGS_SV_PER_NUM');

Line 14174: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));

14170: fnd_message.set_token('NEW_DSO_NAME', l_new_first_name||' '|| l_new_last_name);
14171: fnd_file.put_line(fnd_file.log,fnd_message.get());
14172: Put_Log_Msg(' ', 1);
14173: fnd_message.set_name('IGS','IGS_SV_PRSN_NAME');
14174: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14175: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
14176: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14177: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));
14178: fnd_file.put_line(fnd_file.log,' -------------');

Line 14176: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());

14172: Put_Log_Msg(' ', 1);
14173: fnd_message.set_name('IGS','IGS_SV_PRSN_NAME');
14174: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14175: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
14176: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14177: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));
14178: fnd_file.put_line(fnd_file.log,' -------------');
14179:
14180: --Put_Log_Msg('and new relationship created with '||l_new_first_name||' '|| l_new_last_name||':', 0);

Line 14177: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));

14173: fnd_message.set_name('IGS','IGS_SV_PRSN_NAME');
14174: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14175: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
14176: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14177: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));
14178: fnd_file.put_line(fnd_file.log,' -------------');
14179:
14180: --Put_Log_Msg('and new relationship created with '||l_new_first_name||' '|| l_new_last_name||':', 0);
14181: --Put_Log_Msg('Person Name Person Number', 0);

Line 14178: fnd_file.put_line(fnd_file.log,' -------------');

14174: fnd_file.put(fnd_file.log,' ' || rpad(fnd_message.get(),60,' '));
14175: fnd_message.set_name('IGS','IGS_SV_PER_NUM');
14176: fnd_file.put_line(fnd_file.log,' ' || fnd_message.get());
14177: fnd_file.put(fnd_file.log, rpad(' -----------',60,' '));
14178: fnd_file.put_line(fnd_file.log,' -------------');
14179:
14180: --Put_Log_Msg('and new relationship created with '||l_new_first_name||' '|| l_new_last_name||':', 0);
14181: --Put_Log_Msg('Person Name Person Number', 0);
14182: --Put_Log_Msg('----------- -------------', 0);

Line 14188: fnd_file.put(fnd_file.log,' ' || rpad(l_first_name||' '|| l_last_name,60,' '));

14184: OPEN c_get_person_num(l_obj_id);
14185: FETCH c_get_person_num INTO l_person_num, l_first_name, l_last_name;
14186: CLOSE c_get_person_num;
14187: -- Put_Log_Msg(l_first_name||' '||l_last_name ||' '||l_person_num, 0);
14188: fnd_file.put(fnd_file.log,' ' || rpad(l_first_name||' '|| l_last_name,60,' '));
14189: fnd_file.put_line(fnd_file.log,' ' || l_person_num);
14190:
14191:
14192: END LOOP;

Line 14189: fnd_file.put_line(fnd_file.log,' ' || l_person_num);

14185: FETCH c_get_person_num INTO l_person_num, l_first_name, l_last_name;
14186: CLOSE c_get_person_num;
14187: -- Put_Log_Msg(l_first_name||' '||l_last_name ||' '||l_person_num, 0);
14188: fnd_file.put(fnd_file.log,' ' || rpad(l_first_name||' '|| l_last_name,60,' '));
14189: fnd_file.put_line(fnd_file.log,' ' || l_person_num);
14190:
14191:
14192: END LOOP;
14193: Put_Log_Msg(' ', 1);

Line 14196: fnd_file.put_line(fnd_file.log,fnd_message.get());

14192: END LOOP;
14193: Put_Log_Msg(' ', 1);
14194: fnd_message.set_name('IGS','IGS_SV_REL_UPDATED');
14195: fnd_message.set_token('COUNT', l_count);
14196: fnd_file.put_line(fnd_file.log,fnd_message.get());
14197: END IF;
14198:
14199: EXCEPTION
14200: WHEN FND_API.G_EXC_ERROR THEN