DBA Data[Home] [Help]

APPS.PA_PERF_NOTIFICATION_PKG dependencies on PA_DEBUG

Line 44: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

40: BEGIN
41:
42: x_msg_count := 0;
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
45:
46: IF l_debug_mode = 'Y' THEN
47: pa_debug.set_curr_function( p_function => 'START_PERF_NOTIFICATION_WF',
48: p_debug_mode => l_debug_mode );

Line 47: pa_debug.set_curr_function( p_function => 'START_PERF_NOTIFICATION_WF',

43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
45:
46: IF l_debug_mode = 'Y' THEN
47: pa_debug.set_curr_function( p_function => 'START_PERF_NOTIFICATION_WF',
48: p_debug_mode => l_debug_mode );
49: END IF;
50:
51: -- Check for business rules violations

Line 54: pa_debug.g_err_stage:= 'Validating input parameters';

50:
51: -- Check for business rules violations
52:
53: IF l_debug_mode = 'Y' THEN
54: pa_debug.g_err_stage:= 'Validating input parameters';
55: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
56: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
57: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
58: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;

Line 55: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

51: -- Check for business rules violations
52:
53: IF l_debug_mode = 'Y' THEN
54: pa_debug.g_err_stage:= 'Validating input parameters';
55: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
56: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
57: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
58: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
59: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 56: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;

52:
53: IF l_debug_mode = 'Y' THEN
54: pa_debug.g_err_stage:= 'Validating input parameters';
55: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
56: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
57: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
58: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
59: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
60: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;

Line 57: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

53: IF l_debug_mode = 'Y' THEN
54: pa_debug.g_err_stage:= 'Validating input parameters';
55: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
56: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
57: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
58: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
59: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
60: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
61: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 58: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;

54: pa_debug.g_err_stage:= 'Validating input parameters';
55: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
56: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
57: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
58: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
59: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
60: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
61: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
62: END IF;

Line 59: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

55: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
56: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
57: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
58: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
59: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
60: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
61: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
62: END IF;
63:

Line 60: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;

56: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
57: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
58: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
59: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
60: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
61: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
62: END IF;
63:
64: IF (p_item_type IS NULL) OR

Line 61: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

57: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
58: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
59: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
60: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
61: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
62: END IF;
63:
64: IF (p_item_type IS NULL) OR
65: (p_process_name IS NULL) OR

Line 87: pa_debug.g_err_stage:= 'x_item_key = '|| x_item_key;

83: x_item_key := To_char(l_item_key);
84:
85:
86: IF l_debug_mode = 'Y' THEN
87: pa_debug.g_err_stage:= 'x_item_key = '|| x_item_key;
88: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
89: END IF;
90:
91: -- create the workflow process

Line 88: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

84:
85:
86: IF l_debug_mode = 'Y' THEN
87: pa_debug.g_err_stage:= 'x_item_key = '|| x_item_key;
88: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
89: END IF;
90:
91: -- create the workflow process
92: WF_ENGINE.CreateProcess( itemtype => p_item_type

Line 110: pa_debug.g_err_stage:= 'Error calling SET_PERF_NOTIFY_WF_ATTRIBUTES';

106: );
107:
108: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
109: IF l_debug_mode = 'Y' THEN
110: pa_debug.g_err_stage:= 'Error calling SET_PERF_NOTIFY_WF_ATTRIBUTES';
111: pa_debug.write('START_PERF_NOTIFICATION_WF: ' || l_module_name,pa_debug.g_err_stage,l_debug_level5);
112:
113: PA_UTILS.Add_Message( p_app_short_name => 'PA'
114: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');

Line 111: pa_debug.write('START_PERF_NOTIFICATION_WF: ' || l_module_name,pa_debug.g_err_stage,l_debug_level5);

107:
108: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
109: IF l_debug_mode = 'Y' THEN
110: pa_debug.g_err_stage:= 'Error calling SET_PERF_NOTIFY_WF_ATTRIBUTES';
111: pa_debug.write('START_PERF_NOTIFICATION_WF: ' || l_module_name,pa_debug.g_err_stage,l_debug_level5);
112:
113: PA_UTILS.Add_Message( p_app_short_name => 'PA'
114: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
115: END IF;

Line 120: pa_debug.g_err_stage:= 'returned from set_perf_notify_wf_attributes';

116: RAISE Invalid_Arg_Exc_CI;
117: END IF;
118:
119: IF l_debug_mode = 'Y' THEN
120: pa_debug.g_err_stage:= 'returned from set_perf_notify_wf_attributes';
121: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
122: END IF;
123:
124:

Line 121: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

117: END IF;
118:
119: IF l_debug_mode = 'Y' THEN
120: pa_debug.g_err_stage:= 'returned from set_perf_notify_wf_attributes';
121: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
122: END IF;
123:
124:
125: WF_ENGINE.StartProcess(itemtype => p_item_type

Line 152: pa_debug.g_err_stage:= 'Exiting START_PERF_NOTIFICATION_WF';

148: END IF;
149:
150:
151: IF l_debug_mode = 'Y' THEN
152: pa_debug.g_err_stage:= 'Exiting START_PERF_NOTIFICATION_WF';
153: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
154: pa_debug.reset_curr_function;
155: END IF;
156:

Line 153: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

149:
150:
151: IF l_debug_mode = 'Y' THEN
152: pa_debug.g_err_stage:= 'Exiting START_PERF_NOTIFICATION_WF';
153: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
154: pa_debug.reset_curr_function;
155: END IF;
156:
157: EXCEPTION

Line 154: pa_debug.reset_curr_function;

150:
151: IF l_debug_mode = 'Y' THEN
152: pa_debug.g_err_stage:= 'Exiting START_PERF_NOTIFICATION_WF';
153: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
154: pa_debug.reset_curr_function;
155: END IF;
156:
157: EXCEPTION
158:

Line 177: pa_debug.reset_curr_function;

173: ELSE
174: x_msg_count := l_msg_count;
175: END IF;
176: IF l_debug_mode = 'Y' THEN
177: pa_debug.reset_curr_function;
178: END IF;
179:
180: RETURN;
181:

Line 194: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

190: ,p_procedure_name => 'START_PERF_NOTIFICATION_WF'
191: ,p_error_text => x_msg_data);
192:
193: IF l_debug_mode = 'Y' THEN
194: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
195: pa_debug.write(l_module_name,pa_debug.g_err_stage,
196: l_debug_level5);
197: pa_debug.reset_curr_function;
198: END IF;

Line 195: pa_debug.write(l_module_name,pa_debug.g_err_stage,

191: ,p_error_text => x_msg_data);
192:
193: IF l_debug_mode = 'Y' THEN
194: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
195: pa_debug.write(l_module_name,pa_debug.g_err_stage,
196: l_debug_level5);
197: pa_debug.reset_curr_function;
198: END IF;
199: RAISE;

Line 197: pa_debug.reset_curr_function;

193: IF l_debug_mode = 'Y' THEN
194: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
195: pa_debug.write(l_module_name,pa_debug.g_err_stage,
196: l_debug_level5);
197: pa_debug.reset_curr_function;
198: END IF;
199: RAISE;
200: END START_PERF_NOTIFICATION_WF;
201:

Line 273: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

269: BEGIN
270:
271: x_msg_count := 0;
272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
274:
275: IF l_debug_mode = 'Y' THEN
276: pa_debug.set_curr_function( p_function => 'set_perf_notify_wf_attributes',
277: p_debug_mode => l_debug_mode );

Line 276: pa_debug.set_curr_function( p_function => 'set_perf_notify_wf_attributes',

272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
274:
275: IF l_debug_mode = 'Y' THEN
276: pa_debug.set_curr_function( p_function => 'set_perf_notify_wf_attributes',
277: p_debug_mode => l_debug_mode );
278: END IF;
279:
280: -- Check for business rules violations

Line 283: pa_debug.g_err_stage:= 'Validating input parameters';

279:
280: -- Check for business rules violations
281:
282: IF l_debug_mode = 'Y' THEN
283: pa_debug.g_err_stage:= 'Validating input parameters';
284: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
285: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
286: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
287: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;

Line 284: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

280: -- Check for business rules violations
281:
282: IF l_debug_mode = 'Y' THEN
283: pa_debug.g_err_stage:= 'Validating input parameters';
284: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
285: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
286: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
287: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
288: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 285: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;

281:
282: IF l_debug_mode = 'Y' THEN
283: pa_debug.g_err_stage:= 'Validating input parameters';
284: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
285: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
286: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
287: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
288: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
289: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;

Line 286: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

282: IF l_debug_mode = 'Y' THEN
283: pa_debug.g_err_stage:= 'Validating input parameters';
284: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
285: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
286: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
287: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
288: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
289: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
290: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 287: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;

283: pa_debug.g_err_stage:= 'Validating input parameters';
284: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
285: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
286: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
287: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
288: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
289: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
290: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
291: END IF;

Line 288: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

284: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
285: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
286: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
287: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
288: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
289: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
290: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
291: END IF;
292:

Line 289: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;

285: pa_debug.g_err_stage:= 'p_item_type = '|| p_item_type;
286: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
287: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
288: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
289: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
290: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
291: END IF;
292:
293: IF (p_item_type IS NULL) OR

Line 290: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

286: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
287: pa_debug.g_err_stage:= 'p_process_name = '|| p_process_name;
288: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
289: pa_debug.g_err_stage:= 'p_project_id = '|| p_project_id;
290: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
291: END IF;
292:
293: IF (p_item_type IS NULL) OR
294: (p_process_name IS NULL) OR

Line 404: pa_debug.write_file('LOG','The notification access list do not have any receipients defined to send the performance status notification for the Project with project Id:'||p_project_id);

400: END IF;
401: l_role_users := l_role_users || l_user_names(i);
402: END LOOP;
403: ELSE
404: pa_debug.write_file('LOG','The notification access list do not have any receipients defined to send the performance status notification for the Project with project Id:'||p_project_id);
405: END IF;
406: END IF;
407:
408: IF (l_role_users is NOT NULL) THEN

Line 419: pa_debug.g_err_stage:= 'Exiting set_perf_notify_wf_attributes';

415: , l_role);
416: END IF;
417:
418: IF l_debug_mode = 'Y' THEN
419: pa_debug.g_err_stage:= 'Exiting set_perf_notify_wf_attributes';
420: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
421: pa_debug.reset_curr_function;
422: END IF;
423: EXCEPTION

Line 420: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

416: END IF;
417:
418: IF l_debug_mode = 'Y' THEN
419: pa_debug.g_err_stage:= 'Exiting set_perf_notify_wf_attributes';
420: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
421: pa_debug.reset_curr_function;
422: END IF;
423: EXCEPTION
424:

Line 421: pa_debug.reset_curr_function;

417:
418: IF l_debug_mode = 'Y' THEN
419: pa_debug.g_err_stage:= 'Exiting set_perf_notify_wf_attributes';
420: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
421: pa_debug.reset_curr_function;
422: END IF;
423: EXCEPTION
424:
425: WHEN Invalid_Arg_Exc_CI THEN

Line 443: pa_debug.reset_curr_function;

439: ELSE
440: x_msg_count := l_msg_count;
441: END IF;
442: IF l_debug_mode = 'Y' THEN
443: pa_debug.reset_curr_function;
444: END IF;
445:
446: RETURN;
447:

Line 460: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;

456: ,p_procedure_name => 'set_perf_notify_wf_attributes'
457: ,p_error_text => x_msg_data);
458:
459: IF l_debug_mode = 'Y' THEN
460: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
461: pa_debug.write(l_module_name,pa_debug.g_err_stage,
462: l_debug_level5);
463: pa_debug.reset_curr_function;
464: END IF;

Line 461: pa_debug.write(l_module_name,pa_debug.g_err_stage,

457: ,p_error_text => x_msg_data);
458:
459: IF l_debug_mode = 'Y' THEN
460: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
461: pa_debug.write(l_module_name,pa_debug.g_err_stage,
462: l_debug_level5);
463: pa_debug.reset_curr_function;
464: END IF;
465: RAISE;

Line 463: pa_debug.reset_curr_function;

459: IF l_debug_mode = 'Y' THEN
460: pa_debug.g_err_stage:= 'Unexpected Error'||x_msg_data;
461: pa_debug.write(l_module_name,pa_debug.g_err_stage,
462: l_debug_level5);
463: pa_debug.reset_curr_function;
464: END IF;
465: RAISE;
466: END set_perf_notify_wf_attributes;
467: