31: x_err_code := 0; -- Initialize the value to 0 (Success)
32:
33: if x_err_name = 'GMS_UNEXPECTED_ERROR'
34: then
35: fnd_message.set_name('GMS', 'GMS_UNEXPECTED_ERROR');
36: fnd_message.set_token(x_token_name1, x_token_val1);
37: fnd_message.set_token(x_token_name2, x_token_val2);
38:
39: -- x_token_name5 is used for the Program Name.
32:
33: if x_err_name = 'GMS_UNEXPECTED_ERROR'
34: then
35: fnd_message.set_name('GMS', 'GMS_UNEXPECTED_ERROR');
36: fnd_message.set_token(x_token_name1, x_token_val1);
37: fnd_message.set_token(x_token_name2, x_token_val2);
38:
39: -- x_token_name5 is used for the Program Name.
40:
33: if x_err_name = 'GMS_UNEXPECTED_ERROR'
34: then
35: fnd_message.set_name('GMS', 'GMS_UNEXPECTED_ERROR');
36: fnd_message.set_token(x_token_name1, x_token_val1);
37: fnd_message.set_token(x_token_name2, x_token_val2);
38:
39: -- x_token_name5 is used for the Program Name.
40:
41: if x_token_name5 IS NOT NULL THEN
38:
39: -- x_token_name5 is used for the Program Name.
40:
41: if x_token_name5 IS NOT NULL THEN
42: fnd_message.set_token(x_token_name5, x_token_val5);
43: end if;
44:
45: x_err_code := 1; -- Unexpected Error
46: l_log_level := FND_LOG.LEVEL_EXCEPTION; --For bug 3269365
44:
45: x_err_code := 1; -- Unexpected Error
46: l_log_level := FND_LOG.LEVEL_EXCEPTION; --For bug 3269365
47: else
48: fnd_message.set_name('GMS', x_err_name);
49: IF x_token_name1 IS NOT NULL THEN
50: fnd_message.set_token(x_token_name1, x_token_val1);
51: END IF;
52: IF x_token_name2 IS NOT NULL THEN
46: l_log_level := FND_LOG.LEVEL_EXCEPTION; --For bug 3269365
47: else
48: fnd_message.set_name('GMS', x_err_name);
49: IF x_token_name1 IS NOT NULL THEN
50: fnd_message.set_token(x_token_name1, x_token_val1);
51: END IF;
52: IF x_token_name2 IS NOT NULL THEN
53: fnd_message.set_token(x_token_name2, x_token_val2);
54: END IF;
49: IF x_token_name1 IS NOT NULL THEN
50: fnd_message.set_token(x_token_name1, x_token_val1);
51: END IF;
52: IF x_token_name2 IS NOT NULL THEN
53: fnd_message.set_token(x_token_name2, x_token_val2);
54: END IF;
55: IF x_token_name3 IS NOT NULL THEN
56: fnd_message.set_token(x_token_name3, x_token_val3);
57: END IF;
52: IF x_token_name2 IS NOT NULL THEN
53: fnd_message.set_token(x_token_name2, x_token_val2);
54: END IF;
55: IF x_token_name3 IS NOT NULL THEN
56: fnd_message.set_token(x_token_name3, x_token_val3);
57: END IF;
58: IF x_token_name4 IS NOT NULL THEN
59: fnd_message.set_token(x_token_name4, x_token_val4);
60: END IF;
55: IF x_token_name3 IS NOT NULL THEN
56: fnd_message.set_token(x_token_name3, x_token_val3);
57: END IF;
58: IF x_token_name4 IS NOT NULL THEN
59: fnd_message.set_token(x_token_name4, x_token_val4);
60: END IF;
61: IF x_token_name5 IS NOT NULL THEN
62: fnd_message.set_token(x_token_name5, x_token_val5);
63: END IF;
58: IF x_token_name4 IS NOT NULL THEN
59: fnd_message.set_token(x_token_name4, x_token_val4);
60: END IF;
61: IF x_token_name5 IS NOT NULL THEN
62: fnd_message.set_token(x_token_name5, x_token_val5);
63: END IF;
64:
65: x_err_code := 2; -- Expected Error
66:
72: --End of bug 3269365
73:
74: if G_EXEC_TYPE = 'C'
75: then
76: x_err_buff_1 := fnd_message.get; -- Added for Bug: 1780253
77: fnd_file.put_line(FND_FILE.LOG, x_err_buff_1); -- Added for Bug: 1780253
78: If x_err_buff IS NOT NULL THEN -- Bug 2587078 : To prevent blank line getting printed in the log file.
79: fnd_file.put_line(FND_FILE.LOG, x_err_buff);
80: End If;
215:
216: IS
217: x_err_buff_1 VARCHAR2(2000) ;
218: Begin
219: fnd_message.set_name('GMS', x_exception_msg);
220:
221: IF x_exception_msg = 'GMS_UNEXPECTED_ERROR' THEN
222: fnd_message.set_token('SQLCODE',x_sql_code) ;
223: fnd_message.set_token('SQLERRM',x_sql_message) ;
218: Begin
219: fnd_message.set_name('GMS', x_exception_msg);
220:
221: IF x_exception_msg = 'GMS_UNEXPECTED_ERROR' THEN
222: fnd_message.set_token('SQLCODE',x_sql_code) ;
223: fnd_message.set_token('SQLERRM',x_sql_message) ;
224: fnd_message.set_token('PROGRAM_NAME',x_calling_place) ;
225: END IF;
226:
219: fnd_message.set_name('GMS', x_exception_msg);
220:
221: IF x_exception_msg = 'GMS_UNEXPECTED_ERROR' THEN
222: fnd_message.set_token('SQLCODE',x_sql_code) ;
223: fnd_message.set_token('SQLERRM',x_sql_message) ;
224: fnd_message.set_token('PROGRAM_NAME',x_calling_place) ;
225: END IF;
226:
227:
220:
221: IF x_exception_msg = 'GMS_UNEXPECTED_ERROR' THEN
222: fnd_message.set_token('SQLCODE',x_sql_code) ;
223: fnd_message.set_token('SQLERRM',x_sql_message) ;
224: fnd_message.set_token('PROGRAM_NAME',x_calling_place) ;
225: END IF;
226:
227:
228: if x_token_1 = 'PROJECT_ID' THEN
225: END IF;
226:
227:
228: if x_token_1 = 'PROJECT_ID' THEN
229: fnd_message.set_token('project_id',x_project_id) ;
230: ELSIF x_token_1 = 'PRJ' THEN
231: fnd_message.set_token('PRJ',x_project_id) ;
232: END IF;
233:
227:
228: if x_token_1 = 'PROJECT_ID' THEN
229: fnd_message.set_token('project_id',x_project_id) ;
230: ELSIF x_token_1 = 'PRJ' THEN
231: fnd_message.set_token('PRJ',x_project_id) ;
232: END IF;
233:
234: x_err_buff_1 := fnd_message.get;
235: if x_award_number IS NULL Then
230: ELSIF x_token_1 = 'PRJ' THEN
231: fnd_message.set_token('PRJ',x_project_id) ;
232: END IF;
233:
234: x_err_buff_1 := fnd_message.get;
235: if x_award_number IS NULL Then
236: fnd_file.put_line(FND_FILE.OUTPUT,' '||x_err_buff_1);
237: else
238: fnd_file.put_line(FND_FILE.OUTPUT,x_award_number||' '||x_award_name ||' '||x_err_buff_1);