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 );
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
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;
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);
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;
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);
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;
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:
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
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
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
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
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');
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;
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:
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
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:
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
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:
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:
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;
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;
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:
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 );
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
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;
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);
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;
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);
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;
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:
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
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
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
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
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:
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
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:
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;
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;
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: