DBA Data[Home] [Help]

APPS.IEM_CONCURRENT_NEXT_GEN_PVT dependencies on FND_FILE

Line 30: fnd_file.put_line(fnd_file.log, 'p_delay_worker_start_time = ' || p_delay_worker_start_time);

26: UPDATE IEM_COMP_RT_STATS -- New table name
27: set VALUE='T'
28: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
29:
30: fnd_file.put_line(fnd_file.log, 'p_delay_worker_start_time = ' || p_delay_worker_start_time);
31: fnd_file.put_line(fnd_file.log, 'p_schedule_worker_stop_date = ' || p_schedule_worker_stop_date);
32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));

Line 31: fnd_file.put_line(fnd_file.log, 'p_schedule_worker_stop_date = ' || p_schedule_worker_stop_date);

27: set VALUE='T'
28: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
29:
30: fnd_file.put_line(fnd_file.log, 'p_delay_worker_start_time = ' || p_delay_worker_start_time);
31: fnd_file.put_line(fnd_file.log, 'p_schedule_worker_stop_date = ' || p_schedule_worker_stop_date);
32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
35:

Line 32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));

28: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
29:
30: fnd_file.put_line(fnd_file.log, 'p_delay_worker_start_time = ' || p_delay_worker_start_time);
31: fnd_file.put_line(fnd_file.log, 'p_schedule_worker_stop_date = ' || p_schedule_worker_stop_date);
32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
35:
36: fnd_file.put_line(fnd_file.log, 'Starting Processing');

Line 33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));

29:
30: fnd_file.put_line(fnd_file.log, 'p_delay_worker_start_time = ' || p_delay_worker_start_time);
31: fnd_file.put_line(fnd_file.log, 'p_schedule_worker_stop_date = ' || p_schedule_worker_stop_date);
32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
35:
36: fnd_file.put_line(fnd_file.log, 'Starting Processing');
37:

Line 34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));

30: fnd_file.put_line(fnd_file.log, 'p_delay_worker_start_time = ' || p_delay_worker_start_time);
31: fnd_file.put_line(fnd_file.log, 'p_schedule_worker_stop_date = ' || p_schedule_worker_stop_date);
32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
35:
36: fnd_file.put_line(fnd_file.log, 'Starting Processing');
37:
38:

Line 36: fnd_file.put_line(fnd_file.log, 'Starting Processing');

32: fnd_file.put_line(fnd_file.log, 'p_period_to_wake_up = ' || to_char(p_period_to_wake_up));
33: fnd_file.put_line(fnd_file.log, 'p_number_of_threads = ' || to_char(p_number_of_threads));
34: fnd_file.put_line(fnd_file.log, 'p_number_of_msgs = ' || to_char(p_number_of_msgs));
35:
36: fnd_file.put_line(fnd_file.log, 'Starting Processing');
37:
38:
39: FOR i in 1..p_number_of_threads loop
40:

Line 51: fnd_file.put_line(fnd_file.log, 'Worker number ' || to_char(i) || ' Request Id ' || to_char(l_request_id));

47: rollback;
48: raise REPEAT_OPTIONS_NOT_SET;
49: end if;
50:
51: fnd_file.put_line(fnd_file.log, 'Worker number ' || to_char(i) || ' Request Id ' || to_char(l_request_id));
52:
53: if l_request_id = 0 then
54: rollback;
55: raise WORKER_NOT_SUBMITTED;

Line 63: fnd_file.put_line(fnd_file.log, 'Controller Exited');

59:
60: end loop;
61:
62: Commit work;
63: fnd_file.put_line(fnd_file.log, 'Controller Exited');
64:
65: EXCEPTION
66: WHEN INVALID_HOUR THEN
67: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_HOUR');

Line 69: fnd_file.put_line(fnd_file.log, l_Error_Message);

65: EXCEPTION
66: WHEN INVALID_HOUR THEN
67: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_HOUR');
68: l_Error_Message := FND_MESSAGE.GET;
69: fnd_file.put_line(fnd_file.log, l_Error_Message);
70: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
71:
72: WHEN INVALID_MINUTE THEN
73: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_MINUTE');

Line 75: fnd_file.put_line(fnd_file.log, l_Error_Message);

71:
72: WHEN INVALID_MINUTE THEN
73: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_INVALID_MINUTE');
74: l_Error_Message := FND_MESSAGE.GET;
75: fnd_file.put_line(fnd_file.log, l_Error_Message);
76: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
77:
78: WHEN REPEAT_OPTIONS_NOT_SET THEN
79: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_REPEAT_OPTIONS_NOT_SET');

Line 81: fnd_file.put_line(fnd_file.log, l_Error_Message);

77:
78: WHEN REPEAT_OPTIONS_NOT_SET THEN
79: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_REPEAT_OPTIONS_NOT_SET');
80: l_Error_Message := FND_MESSAGE.GET;
81: fnd_file.put_line(fnd_file.log, l_Error_Message);
82: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
83:
84: WHEN MAIN_WORKER_NOT_SUBMITTED THEN
85: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_MAIN_WORKER_NOT_SUBMITTED');

Line 87: fnd_file.put_line(fnd_file.log, l_Error_Message);

83:
84: WHEN MAIN_WORKER_NOT_SUBMITTED THEN
85: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_MAIN_WORKER_NOT_SUBMITTED');
86: l_Error_Message := FND_MESSAGE.GET;
87: fnd_file.put_line(fnd_file.log, l_Error_Message);
88: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
89:
90: WHEN WORKER_NOT_SUBMITTED THEN
91: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_WORKER_NOT_SUBMITTED');

Line 93: fnd_file.put_line(fnd_file.log, l_Error_Message);

89:
90: WHEN WORKER_NOT_SUBMITTED THEN
91: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_WORKER_NOT_SUBMITTED');
92: l_Error_Message := FND_MESSAGE.GET;
93: fnd_file.put_line(fnd_file.log, l_Error_Message);
94: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
95:
96: /*
97: WHEN RETRY_NOT_SUBMITTED THEN

Line 100: fnd_file.put_line(fnd_file.log, l_Error_Message);

96: /*
97: WHEN RETRY_NOT_SUBMITTED THEN
98: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_RETRY_NOT_SUBMITTED');
99: l_Error_Message := FND_MESSAGE.GET;
100: fnd_file.put_line(fnd_file.log, l_Error_Message);
101: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
102: */
103: WHEN OTHERS THEN
104: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_UNXP_ERROR');

Line 106: fnd_file.put_line(fnd_file.log, l_Error_Message);

102: */
103: WHEN OTHERS THEN
104: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_UNXP_ERROR');
105: l_Error_Message := FND_MESSAGE.GET;
106: fnd_file.put_line(fnd_file.log, l_Error_Message);
107: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_Error_Message);
108: END StartProcess;
109:
110: END IEM_CONCURRENT_NEXT_GEN_PVT;