47: l_context_token_str := l_context_token_str || ' - ' || p_match_ind;
48: END IF;
49:
50: -- Import Process Failed for Record: CONTEXT, Error: ERROR_CD
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);
48: END IF;
49:
50: -- Import Process Failed for Record: CONTEXT, Error: ERROR_CD
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;
49:
50: -- Import Process Failed for Record: CONTEXT, Error: ERROR_CD
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:
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: /*****************************************************************
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);
82: /*
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,
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,
84: 'Category Entity Total No of Total No of Total No of Total No of');
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,
116: Who When What
117: (reverse chronological order - newest change first)
118: ***************************************************************/
119: BEGIN
120: FND_MESSAGE.SET_NAME('IGS',p_name);
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;
119: BEGIN
120: FND_MESSAGE.SET_NAME('IGS',p_name);
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:
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
801: retcode:=2;
802: l_err_msg := SQLERRM;
803:
804: logdetail('EXCEPTION FROM Import Process' || l_err_msg);
805: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
806: igs_ge_msg_stack.conc_exception_hndl;
807:
808: -- Failure Condition
809: