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_AD_IMP_001 dependencies on FND_FILE

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

51: FND_MESSAGE.SET_NAME('IGS', 'IGS_PE_IMP_DET_ERROR');
52: FND_MESSAGE.SET_TOKEN('CONTEXT', l_context_token_str);
53: FND_MESSAGE.SET_TOKEN('ERROR_CD', p_error);
54:
55: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
56: END logerrormessage;
57:
58: PROCEDURE print_stats(p_interface_run_id IN igs_ad_interface_all.interface_run_id%TYPE) AS
59: /*****************************************************************

Line 77: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');

73: AND lk.lookup_type = cp_lookup_type
74: AND imp.interface_run_id = cp_interface_run_id
75: ORDER BY meaning, entity_name;
76: BEGIN
77: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
78: FND_MESSAGE.SET_NAME('IGS','IGS_PE_IMP_HEADER1');
79: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
80: FND_MESSAGE.SET_NAME('IGS','IGS_PE_IMP_HEADER2');
81: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

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

75: ORDER BY meaning, entity_name;
76: BEGIN
77: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
78: FND_MESSAGE.SET_NAME('IGS','IGS_PE_IMP_HEADER1');
79: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
80: FND_MESSAGE.SET_NAME('IGS','IGS_PE_IMP_HEADER2');
81: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
82: /*
83: FND_FILE.PUT_LINE(FND_FILE.LOG,

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

77: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
78: FND_MESSAGE.SET_NAME('IGS','IGS_PE_IMP_HEADER1');
79: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
80: FND_MESSAGE.SET_NAME('IGS','IGS_PE_IMP_HEADER2');
81: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
82: /*
83: FND_FILE.PUT_LINE(FND_FILE.LOG,
84: 'Category Entity Total No of Total No of Total No of Total No of');
85: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 83: FND_FILE.PUT_LINE(FND_FILE.LOG,

79: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
80: FND_MESSAGE.SET_NAME('IGS','IGS_PE_IMP_HEADER2');
81: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
82: /*
83: FND_FILE.PUT_LINE(FND_FILE.LOG,
84: 'Category Entity Total No of Total No of Total No of Total No of');
85: FND_FILE.PUT_LINE(FND_FILE.LOG,
86: ' Records Processed Records Successful Records with Error Records with Warning');
87: */

Line 85: FND_FILE.PUT_LINE(FND_FILE.LOG,

81: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
82: /*
83: FND_FILE.PUT_LINE(FND_FILE.LOG,
84: 'Category Entity Total No of Total No of Total No of Total No of');
85: FND_FILE.PUT_LINE(FND_FILE.LOG,
86: ' Records Processed Records Successful Records with Error Records with Warning');
87: */
88:
89: FND_FILE.PUT_LINE(FND_FILE.LOG,

Line 89: FND_FILE.PUT_LINE(FND_FILE.LOG,

85: FND_FILE.PUT_LINE(FND_FILE.LOG,
86: ' Records Processed Records Successful Records with Error Records with Warning');
87: */
88:
89: FND_FILE.PUT_LINE(FND_FILE.LOG,
90: '---------------------------------------------------------------------------------------------------------------------------------------------------');
91: FOR get_statistics_rec IN c_get_statistics('IMP_CATEGORIES',p_interface_run_id)
92: LOOP
93: FND_FILE.PUT_LINE (FND_FILE.LOG, RPAD(get_statistics_rec.meaning,39,' ') ||

Line 93: FND_FILE.PUT_LINE (FND_FILE.LOG, RPAD(get_statistics_rec.meaning,39,' ') ||

89: FND_FILE.PUT_LINE(FND_FILE.LOG,
90: '---------------------------------------------------------------------------------------------------------------------------------------------------');
91: FOR get_statistics_rec IN c_get_statistics('IMP_CATEGORIES',p_interface_run_id)
92: LOOP
93: FND_FILE.PUT_LINE (FND_FILE.LOG, RPAD(get_statistics_rec.meaning,39,' ') ||
94: RPAD(get_statistics_rec.entity_name,29,' ') ||
95: RPAD(get_statistics_rec.total_rec_num,20,' ') ||
96: RPAD(get_statistics_rec.total_success_num,20,' ') ||
97: RPAD(get_statistics_rec.total_error_num,20,' ') ||

Line 125: Fnd_File.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);

121: IF p_token_name IS NOT NULL AND
122: p_token_value IS NOT NULL THEN
123: FND_MESSAGE.SET_TOKEN(p_token_name, p_token_value);
124: END IF;
125: Fnd_File.PUT_LINE(Fnd_File.LOG,FND_MESSAGE.GET);
126: END set_message;
127:
128: PROCEDURE logHeader(p_proc_name VARCHAR2) AS
129: BEGIN

Line 130: FND_FILE.PUT_LINE(FND_FILE.LOG,p_proc_name);

126: END set_message;
127:
128: PROCEDURE logHeader(p_proc_name VARCHAR2) AS
129: BEGIN
130: FND_FILE.PUT_LINE(FND_FILE.LOG,p_proc_name);
131: END;
132: PROCEDURE logdetail(p_debug_msg VARCHAR2) AS
133: BEGIN
134: FND_FILE.PUT_LINE(FND_FILE.LOG,p_debug_msg);

Line 134: FND_FILE.PUT_LINE(FND_FILE.LOG,p_debug_msg);

130: FND_FILE.PUT_LINE(FND_FILE.LOG,p_proc_name);
131: END;
132: PROCEDURE logdetail(p_debug_msg VARCHAR2) AS
133: BEGIN
134: FND_FILE.PUT_LINE(FND_FILE.LOG,p_debug_msg);
135: END;
136:
137: PROCEDURE update_parent_record_status (p_source_type_id IN NUMBER,
138: p_batch_id IN NUMBER,

Line 285: fnd_file.put_line(fnd_file.log,'Error occurred while calling IGR_IMP_002.UPDATE_PARENT_RECORD_STATUS() : '||SQLERRM);

281: END; ';
282: EXECUTE IMMEDIATE l_stmt USING p_interface_run_id;
283: EXCEPTION
284: WHEN OTHERS THEN
285: fnd_file.put_line(fnd_file.log,'Error occurred while calling IGR_IMP_002.UPDATE_PARENT_RECORD_STATUS() : '||SQLERRM);
286: END;
287: END IF;
288:
289: -- Based upon person child

Line 531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot import Qualification Details in non-legacy mode of import');

527: WHERE interface_run_id = p_interface_run_id;
528: COMMIT;
529:
530: IF l_count1 = 1 THEN
531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot import Qualification Details in non-legacy mode of import');
532: ELSE
533: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot import Application History Details in non-legacy mode of import');
534: END IF;
535:

Line 533: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot import Application History Details in non-legacy mode of import');

529:
530: IF l_count1 = 1 THEN
531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot import Qualification Details in non-legacy mode of import');
532: ELSE
533: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Cannot import Application History Details in non-legacy mode of import');
534: END IF;
535:
536: RETURN TRUE;
537: END IF;

Line 665: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

661:
662: IF l_batch_desc IS NULL OR
663: l_source_type IS NULL OR
664: l_match_set_name IS NULL THEN
665: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
666: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id );
667: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id );
668: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id );
669: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invalid Batch OR Source Type OR Match Set');

Line 666: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id );

662: IF l_batch_desc IS NULL OR
663: l_source_type IS NULL OR
664: l_match_set_name IS NULL THEN
665: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
666: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id );
667: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id );
668: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id );
669: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invalid Batch OR Source Type OR Match Set');
670: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

Line 667: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id );

663: l_source_type IS NULL OR
664: l_match_set_name IS NULL THEN
665: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
666: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id );
667: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id );
668: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id );
669: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invalid Batch OR Source Type OR Match Set');
670: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
671: --Enable Business Event before quiting Bulk Process

Line 668: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id );

664: l_match_set_name IS NULL THEN
665: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
666: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id );
667: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id );
668: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id );
669: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invalid Batch OR Source Type OR Match Set');
670: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
671: --Enable Business Event before quiting Bulk Process
672: IGS_PE_GEN_003.TURNOFF_TCA_BE (

Line 669: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invalid Batch OR Source Type OR Match Set');

665: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
666: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id );
667: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id );
668: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id );
669: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invalid Batch OR Source Type OR Match Set');
670: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
671: --Enable Business Event before quiting Bulk Process
672: IGS_PE_GEN_003.TURNOFF_TCA_BE (
673: P_TURNOFF => 'N'

Line 670: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

666: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id );
667: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id );
668: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id );
669: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invalid Batch OR Source Type OR Match Set');
670: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
671: --Enable Business Event before quiting Bulk Process
672: IGS_PE_GEN_003.TURNOFF_TCA_BE (
673: P_TURNOFF => 'N'
674: );

Line 677: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

673: P_TURNOFF => 'N'
674: );
675: RETURN;
676: ELSE
677: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
678: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id ||' '|| 'Batch Description :' || l_batch_desc );
679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id ||' '|| 'Source Type :' || l_source_type );
680: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id ||' '|| 'Match Set Name :' || l_match_set_name );
681: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

Line 678: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id ||' '|| 'Batch Description :' || l_batch_desc );

674: );
675: RETURN;
676: ELSE
677: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
678: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id ||' '|| 'Batch Description :' || l_batch_desc );
679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id ||' '|| 'Source Type :' || l_source_type );
680: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id ||' '|| 'Match Set Name :' || l_match_set_name );
681: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
682: END IF;

Line 679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id ||' '|| 'Source Type :' || l_source_type );

675: RETURN;
676: ELSE
677: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
678: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id ||' '|| 'Batch Description :' || l_batch_desc );
679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id ||' '|| 'Source Type :' || l_source_type );
680: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id ||' '|| 'Match Set Name :' || l_match_set_name );
681: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
682: END IF;
683: igs_ad_interface_ctl_pkg.insert_row (

Line 680: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id ||' '|| 'Match Set Name :' || l_match_set_name );

676: ELSE
677: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
678: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id ||' '|| 'Batch Description :' || l_batch_desc );
679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id ||' '|| 'Source Type :' || l_source_type );
680: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id ||' '|| 'Match Set Name :' || l_match_set_name );
681: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
682: END IF;
683: igs_ad_interface_ctl_pkg.insert_row (
684: x_rowid => l_rowid,

Line 681: FND_FILE.PUT_LINE(FND_FILE.LOG, '');

677: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
678: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Batch ID :' || p_batch_id ||' '|| 'Batch Description :' || l_batch_desc );
679: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Source Type ID :' || p_source_type_id ||' '|| 'Source Type :' || l_source_type );
680: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Match Set ID :' || p_match_set_id ||' '|| 'Match Set Name :' || l_match_set_name );
681: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
682: END IF;
683: igs_ad_interface_ctl_pkg.insert_row (
684: x_rowid => l_rowid,
685: x_interface_run_id => l_interface_run_id ,

Line 698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Another import process with same batch and source type is currently under execution hence aborting.');

694: WHERE batch_id = p_batch_id
695: AND source_type_id = p_source_type_id
696: AND status = '2';
697: IF l_cnt_dup_process_run > 1 THEN
698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Another import process with same batch and source type is currently under execution hence aborting.');
699: APP_EXCEPTION.RAISE_EXCEPTION;
700: ELSE
701: igs_ad_imp_001.g_interface_run_id := l_interface_run_id;
702: igs_ad_imp_001.g_enable_log := p_enable_log;