208: fetch l_get_instance_id into g_root_process_id;
209: if l_get_instance_id%notfound then
210: -- error the root process specified does not exist
211: close l_get_instance_id;
212: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
213: fnd_message.set_token('PROCEDURE', 'internal error');
214: fnd_message.set_token('STEP','10');
215: fnd_message.raise_error;
216: end if;
209: if l_get_instance_id%notfound then
210: -- error the root process specified does not exist
211: close l_get_instance_id;
212: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
213: fnd_message.set_token('PROCEDURE', 'internal error');
214: fnd_message.set_token('STEP','10');
215: fnd_message.raise_error;
216: end if;
217: close l_get_instance_id;
210: -- error the root process specified does not exist
211: close l_get_instance_id;
212: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
213: fnd_message.set_token('PROCEDURE', 'internal error');
214: fnd_message.set_token('STEP','10');
215: fnd_message.raise_error;
216: end if;
217: close l_get_instance_id;
218: hr_utility.set_location('Leaving:'||l_proc, 20);
211: close l_get_instance_id;
212: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
213: fnd_message.set_token('PROCEDURE', 'internal error');
214: fnd_message.set_token('STEP','10');
215: fnd_message.raise_error;
216: end if;
217: close l_get_instance_id;
218: hr_utility.set_location('Leaving:'||l_proc, 20);
219: end set_root_process_activity_id;
277: ,p_item_type_display_name => g_item_type_display_name
278: ,p_activity_display_name => g_activity_display_name
279: ,p_process_display_name => g_process_display_name);
280: --
281: fnd_message.set_name(g_hr_app, 'HR_52950_WKF2TSK_NO_ROOT_SEL');
282: fnd_message.set_token(g_process_name, g_activity_display_name);
283: fnd_message.set_token(g_item_type, g_item_type_display_name);
284: fnd_message.raise_error;
285: elsif l_index > 1 then
278: ,p_activity_display_name => g_activity_display_name
279: ,p_process_display_name => g_process_display_name);
280: --
281: fnd_message.set_name(g_hr_app, 'HR_52950_WKF2TSK_NO_ROOT_SEL');
282: fnd_message.set_token(g_process_name, g_activity_display_name);
283: fnd_message.set_token(g_item_type, g_item_type_display_name);
284: fnd_message.raise_error;
285: elsif l_index > 1 then
286: -- more than one root selector exists error
279: ,p_process_display_name => g_process_display_name);
280: --
281: fnd_message.set_name(g_hr_app, 'HR_52950_WKF2TSK_NO_ROOT_SEL');
282: fnd_message.set_token(g_process_name, g_activity_display_name);
283: fnd_message.set_token(g_item_type, g_item_type_display_name);
284: fnd_message.raise_error;
285: elsif l_index > 1 then
286: -- more than one root selector exists error
287: -- select the root process details that is in error
280: --
281: fnd_message.set_name(g_hr_app, 'HR_52950_WKF2TSK_NO_ROOT_SEL');
282: fnd_message.set_token(g_process_name, g_activity_display_name);
283: fnd_message.set_token(g_item_type, g_item_type_display_name);
284: fnd_message.raise_error;
285: elsif l_index > 1 then
286: -- more than one root selector exists error
287: -- select the root process details that is in error
288: get_item_act_display_names
290: ,p_item_type_display_name => g_item_type_display_name
291: ,p_activity_display_name => g_activity_display_name
292: ,p_process_display_name => g_process_display_name);
293: --
294: fnd_message.set_name(g_hr_app, 'HR_52951_WKF2TSK_ROOT_SELS');
295: fnd_message.set_token(g_process_name, g_activity_display_name);
296: fnd_message.set_token(g_item_type, g_item_type_display_name);
297: fnd_message.raise_error;
298: end if;
291: ,p_activity_display_name => g_activity_display_name
292: ,p_process_display_name => g_process_display_name);
293: --
294: fnd_message.set_name(g_hr_app, 'HR_52951_WKF2TSK_ROOT_SELS');
295: fnd_message.set_token(g_process_name, g_activity_display_name);
296: fnd_message.set_token(g_item_type, g_item_type_display_name);
297: fnd_message.raise_error;
298: end if;
299: hr_utility.set_location(l_proc, 25);
292: ,p_process_display_name => g_process_display_name);
293: --
294: fnd_message.set_name(g_hr_app, 'HR_52951_WKF2TSK_ROOT_SELS');
295: fnd_message.set_token(g_process_name, g_activity_display_name);
296: fnd_message.set_token(g_item_type, g_item_type_display_name);
297: fnd_message.raise_error;
298: end if;
299: hr_utility.set_location(l_proc, 25);
300: -- now that we have found the selector activity we must determine the
293: --
294: fnd_message.set_name(g_hr_app, 'HR_52951_WKF2TSK_ROOT_SELS');
295: fnd_message.set_token(g_process_name, g_activity_display_name);
296: fnd_message.set_token(g_item_type, g_item_type_display_name);
297: fnd_message.raise_error;
298: end if;
299: hr_utility.set_location(l_proc, 25);
300: -- now that we have found the selector activity we must determine the
301: -- root form
322: ,p_item_type_display_name => g_item_type_display_name
323: ,p_activity_display_name => g_activity_display_name
324: ,p_process_display_name => g_process_display_name);
325: --
326: fnd_message.set_name(g_hr_app, 'HR_52952_WKF2TSK_ROOT_SEL_TRAN');
327: fnd_message.set_token(g_process_name, g_activity_display_name);
328: fnd_message.set_token(g_item_type, g_item_type_display_name);
329: fnd_message.raise_error;
330: elsif l_index > 1 then
323: ,p_activity_display_name => g_activity_display_name
324: ,p_process_display_name => g_process_display_name);
325: --
326: fnd_message.set_name(g_hr_app, 'HR_52952_WKF2TSK_ROOT_SEL_TRAN');
327: fnd_message.set_token(g_process_name, g_activity_display_name);
328: fnd_message.set_token(g_item_type, g_item_type_display_name);
329: fnd_message.raise_error;
330: elsif l_index > 1 then
331: -- the root selector transitions to more than one form so error
324: ,p_process_display_name => g_process_display_name);
325: --
326: fnd_message.set_name(g_hr_app, 'HR_52952_WKF2TSK_ROOT_SEL_TRAN');
327: fnd_message.set_token(g_process_name, g_activity_display_name);
328: fnd_message.set_token(g_item_type, g_item_type_display_name);
329: fnd_message.raise_error;
330: elsif l_index > 1 then
331: -- the root selector transitions to more than one form so error
332: -- select the root process details that is in error
325: --
326: fnd_message.set_name(g_hr_app, 'HR_52952_WKF2TSK_ROOT_SEL_TRAN');
327: fnd_message.set_token(g_process_name, g_activity_display_name);
328: fnd_message.set_token(g_item_type, g_item_type_display_name);
329: fnd_message.raise_error;
330: elsif l_index > 1 then
331: -- the root selector transitions to more than one form so error
332: -- select the root process details that is in error
333: get_item_act_display_names
335: ,p_item_type_display_name => g_item_type_display_name
336: ,p_activity_display_name => g_activity_display_name
337: ,p_process_display_name => g_process_display_name);
338: --
339: fnd_message.set_name(g_hr_app, 'HR_52953_WKF2TSK_ROOT_SEL_TRAS');
340: fnd_message.set_token(g_process_name, g_activity_display_name);
341: fnd_message.set_token(g_item_type, g_item_type_display_name);
342: fnd_message.raise_error;
343: end if;
336: ,p_activity_display_name => g_activity_display_name
337: ,p_process_display_name => g_process_display_name);
338: --
339: fnd_message.set_name(g_hr_app, 'HR_52953_WKF2TSK_ROOT_SEL_TRAS');
340: fnd_message.set_token(g_process_name, g_activity_display_name);
341: fnd_message.set_token(g_item_type, g_item_type_display_name);
342: fnd_message.raise_error;
343: end if;
344: hr_utility.set_location(l_proc, 40);
337: ,p_process_display_name => g_process_display_name);
338: --
339: fnd_message.set_name(g_hr_app, 'HR_52953_WKF2TSK_ROOT_SEL_TRAS');
340: fnd_message.set_token(g_process_name, g_activity_display_name);
341: fnd_message.set_token(g_item_type, g_item_type_display_name);
342: fnd_message.raise_error;
343: end if;
344: hr_utility.set_location(l_proc, 40);
345: -- ensure that the activity selected is a form and the transition matches the activity name
338: --
339: fnd_message.set_name(g_hr_app, 'HR_52953_WKF2TSK_ROOT_SEL_TRAS');
340: fnd_message.set_token(g_process_name, g_activity_display_name);
341: fnd_message.set_token(g_item_type, g_item_type_display_name);
342: fnd_message.raise_error;
343: end if;
344: hr_utility.set_location(l_proc, 40);
345: -- ensure that the activity selected is a form and the transition matches the activity name
346: open g_get_process_activity(g_root_form_activity_id);
347: fetch g_get_process_activity into g_process_activity_rec;
348: if g_get_process_activity%notfound then
349: close g_get_process_activity;
350: -- the instance_id does not exist this is a serious internal error
351: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE', 'internal error');
353: fnd_message.set_token('STEP','40');
354: fnd_message.raise_error;
355: end if;
348: if g_get_process_activity%notfound then
349: close g_get_process_activity;
350: -- the instance_id does not exist this is a serious internal error
351: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE', 'internal error');
353: fnd_message.set_token('STEP','40');
354: fnd_message.raise_error;
355: end if;
356: close g_get_process_activity;
349: close g_get_process_activity;
350: -- the instance_id does not exist this is a serious internal error
351: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE', 'internal error');
353: fnd_message.set_token('STEP','40');
354: fnd_message.raise_error;
355: end if;
356: close g_get_process_activity;
357: hr_utility.set_location(l_proc, 45);
350: -- the instance_id does not exist this is a serious internal error
351: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE', 'internal error');
353: fnd_message.set_token('STEP','40');
354: fnd_message.raise_error;
355: end if;
356: close g_get_process_activity;
357: hr_utility.set_location(l_proc, 45);
358: if g_process_activity_rec.activity_name <> l_result_code then
363: ,p_item_type_display_name => g_item_type_display_name
364: ,p_activity_display_name => g_activity_display_name
365: ,p_process_display_name => g_process_display_name);
366: --
367: fnd_message.set_name(g_hr_app, 'HR_52954_WKF2TSK_ROOT_WRN_SEL');
368: fnd_message.set_token(g_process_name, g_activity_display_name);
369: fnd_message.set_token(g_item_type, g_item_type_display_name);
370: fnd_message.raise_error;
371: end if;
364: ,p_activity_display_name => g_activity_display_name
365: ,p_process_display_name => g_process_display_name);
366: --
367: fnd_message.set_name(g_hr_app, 'HR_52954_WKF2TSK_ROOT_WRN_SEL');
368: fnd_message.set_token(g_process_name, g_activity_display_name);
369: fnd_message.set_token(g_item_type, g_item_type_display_name);
370: fnd_message.raise_error;
371: end if;
372: hr_utility.set_location('Leaving:'||l_proc, 50);
365: ,p_process_display_name => g_process_display_name);
366: --
367: fnd_message.set_name(g_hr_app, 'HR_52954_WKF2TSK_ROOT_WRN_SEL');
368: fnd_message.set_token(g_process_name, g_activity_display_name);
369: fnd_message.set_token(g_item_type, g_item_type_display_name);
370: fnd_message.raise_error;
371: end if;
372: hr_utility.set_location('Leaving:'||l_proc, 50);
373: end set_root_form_activity_id;
366: --
367: fnd_message.set_name(g_hr_app, 'HR_52954_WKF2TSK_ROOT_WRN_SEL');
368: fnd_message.set_token(g_process_name, g_activity_display_name);
369: fnd_message.set_token(g_item_type, g_item_type_display_name);
370: fnd_message.raise_error;
371: end if;
372: hr_utility.set_location('Leaving:'||l_proc, 50);
373: end set_root_form_activity_id;
374: -- ----------------------------------------------------------------------------
431: into g_workflow_id
432: from sys.dual;
433: exception
434: when others then
435: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
436: fnd_message.set_token('PROCEDURE', l_proc);
437: fnd_message.set_token('STEP','10');
438: fnd_message.raise_error;
439: end;
432: from sys.dual;
433: exception
434: when others then
435: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
436: fnd_message.set_token('PROCEDURE', l_proc);
437: fnd_message.set_token('STEP','10');
438: fnd_message.raise_error;
439: end;
440: hr_utility.set_location(l_proc, 20);
433: exception
434: when others then
435: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
436: fnd_message.set_token('PROCEDURE', l_proc);
437: fnd_message.set_token('STEP','10');
438: fnd_message.raise_error;
439: end;
440: hr_utility.set_location(l_proc, 20);
441: -- the workflow does not exist so create it
434: when others then
435: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
436: fnd_message.set_token('PROCEDURE', l_proc);
437: fnd_message.set_token('STEP','10');
438: fnd_message.raise_error;
439: end;
440: hr_utility.set_location(l_proc, 20);
441: -- the workflow does not exist so create it
442: insert into hr_workflows (workflow_id, workflow_name) values (g_workflow_id, p_process_name);
892: ,p_item_type_display_name => g_item_type_display_name
893: ,p_activity_display_name => g_activity_display_name
894: ,p_process_display_name => g_process_display_name);
895: -- get the TO_FORM_ACTIVITY details
896: fnd_message.set_name(g_hr_app, 'HR_52955_WKF2TSK_SAME_SQLFORM');
897: fnd_message.set_token(g_process_name, g_process_display_name);
898: fnd_message.set_token(g_item_type, g_item_type_display_name);
899: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
900: -- get the TO_FORM_ACTIVITY details
893: ,p_activity_display_name => g_activity_display_name
894: ,p_process_display_name => g_process_display_name);
895: -- get the TO_FORM_ACTIVITY details
896: fnd_message.set_name(g_hr_app, 'HR_52955_WKF2TSK_SAME_SQLFORM');
897: fnd_message.set_token(g_process_name, g_process_display_name);
898: fnd_message.set_token(g_item_type, g_item_type_display_name);
899: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
900: -- get the TO_FORM_ACTIVITY details
901: get_item_act_display_names
894: ,p_process_display_name => g_process_display_name);
895: -- get the TO_FORM_ACTIVITY details
896: fnd_message.set_name(g_hr_app, 'HR_52955_WKF2TSK_SAME_SQLFORM');
897: fnd_message.set_token(g_process_name, g_process_display_name);
898: fnd_message.set_token(g_item_type, g_item_type_display_name);
899: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
900: -- get the TO_FORM_ACTIVITY details
901: get_item_act_display_names
902: (p_instance_id => p_to_process_activity
895: -- get the TO_FORM_ACTIVITY details
896: fnd_message.set_name(g_hr_app, 'HR_52955_WKF2TSK_SAME_SQLFORM');
897: fnd_message.set_token(g_process_name, g_process_display_name);
898: fnd_message.set_token(g_item_type, g_item_type_display_name);
899: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
900: -- get the TO_FORM_ACTIVITY details
901: get_item_act_display_names
902: (p_instance_id => p_to_process_activity
903: ,p_item_type_display_name => g_item_type_display_name
903: ,p_item_type_display_name => g_item_type_display_name
904: ,p_activity_display_name => g_activity_display_name
905: ,p_process_display_name => g_process_display_name);
906: --
907: fnd_message.set_token(g_to_form_activity, g_item_type_display_name);
908: fnd_message.raise_error;
909: end if;
910: end if;
911: end loop;
904: ,p_activity_display_name => g_activity_display_name
905: ,p_process_display_name => g_process_display_name);
906: --
907: fnd_message.set_token(g_to_form_activity, g_item_type_display_name);
908: fnd_message.raise_error;
909: end if;
910: end if;
911: end loop;
912: end if;
980: if csr_attivity_type%notfound then
981: -- the activity does not exist. this is a serious internal
982: -- error which we must report
983: close csr_attivity_type;
984: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
985: fnd_message.set_token('PROCEDURE', l_proc);
986: fnd_message.set_token('STEP','10');
987: fnd_message.raise_error;
988: end if;
981: -- the activity does not exist. this is a serious internal
982: -- error which we must report
983: close csr_attivity_type;
984: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
985: fnd_message.set_token('PROCEDURE', l_proc);
986: fnd_message.set_token('STEP','10');
987: fnd_message.raise_error;
988: end if;
989: close csr_attivity_type;
982: -- error which we must report
983: close csr_attivity_type;
984: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
985: fnd_message.set_token('PROCEDURE', l_proc);
986: fnd_message.set_token('STEP','10');
987: fnd_message.raise_error;
988: end if;
989: close csr_attivity_type;
990: hr_utility.set_location(l_proc, 40);
983: close csr_attivity_type;
984: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
985: fnd_message.set_token('PROCEDURE', l_proc);
986: fnd_message.set_token('STEP','10');
987: fnd_message.raise_error;
988: end if;
989: close csr_attivity_type;
990: hr_utility.set_location(l_proc, 40);
991: -- check to see if the activity is not a PROCESS
1065: ,p_item_type_display_name => g_item_type_display_name
1066: ,p_activity_display_name => g_activity_display_name
1067: ,p_process_display_name => g_process_display_name);
1068: -- get the TO_FORM_ACTIVITY details
1069: fnd_message.set_name(g_hr_app, 'HR_52956_WKF2TSK_WRONG_SQLFORM');
1070: fnd_message.set_token(g_process_name, g_process_display_name);
1071: fnd_message.set_token(g_item_type, g_item_type_display_name);
1072: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
1073: -- get the TO_FORM_ACTIVITY details
1066: ,p_activity_display_name => g_activity_display_name
1067: ,p_process_display_name => g_process_display_name);
1068: -- get the TO_FORM_ACTIVITY details
1069: fnd_message.set_name(g_hr_app, 'HR_52956_WKF2TSK_WRONG_SQLFORM');
1070: fnd_message.set_token(g_process_name, g_process_display_name);
1071: fnd_message.set_token(g_item_type, g_item_type_display_name);
1072: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
1073: -- get the TO_FORM_ACTIVITY details
1074: get_item_act_display_names
1067: ,p_process_display_name => g_process_display_name);
1068: -- get the TO_FORM_ACTIVITY details
1069: fnd_message.set_name(g_hr_app, 'HR_52956_WKF2TSK_WRONG_SQLFORM');
1070: fnd_message.set_token(g_process_name, g_process_display_name);
1071: fnd_message.set_token(g_item_type, g_item_type_display_name);
1072: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
1073: -- get the TO_FORM_ACTIVITY details
1074: get_item_act_display_names
1075: (p_instance_id => l_result_csr.to_process_activity
1068: -- get the TO_FORM_ACTIVITY details
1069: fnd_message.set_name(g_hr_app, 'HR_52956_WKF2TSK_WRONG_SQLFORM');
1070: fnd_message.set_token(g_process_name, g_process_display_name);
1071: fnd_message.set_token(g_item_type, g_item_type_display_name);
1072: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
1073: -- get the TO_FORM_ACTIVITY details
1074: get_item_act_display_names
1075: (p_instance_id => l_result_csr.to_process_activity
1076: ,p_item_type_display_name => g_item_type_display_name
1076: ,p_item_type_display_name => g_item_type_display_name
1077: ,p_activity_display_name => g_activity_display_name
1078: ,p_process_display_name => g_process_display_name);
1079: --
1080: fnd_message.set_token(g_to_form_activity, g_item_type_display_name);
1081: fnd_message.raise_error;
1082: else
1083: hr_utility.set_location(l_proc, 20);
1084: -- delete the results stack
1077: ,p_activity_display_name => g_activity_display_name
1078: ,p_process_display_name => g_process_display_name);
1079: --
1080: fnd_message.set_token(g_to_form_activity, g_item_type_display_name);
1081: fnd_message.raise_error;
1082: else
1083: hr_utility.set_location(l_proc, 20);
1084: -- delete the results stack
1085: zap_result_stack;
1131: ,p_item_type_display_name => g_item_type_display_name
1132: ,p_activity_display_name => g_activity_display_name
1133: ,p_process_display_name => g_process_display_name);
1134: -- get the TO_FORM_ACTIVITY details
1135: fnd_message.set_name(g_hr_app, 'HR_52956_WKF2TSK_WRONG_SQLFORM');
1136: fnd_message.set_token(g_process_name, g_process_display_name);
1137: fnd_message.set_token(g_item_type, g_item_type_display_name);
1138: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
1139: -- get the TO_FORM_ACTIVITY details
1132: ,p_activity_display_name => g_activity_display_name
1133: ,p_process_display_name => g_process_display_name);
1134: -- get the TO_FORM_ACTIVITY details
1135: fnd_message.set_name(g_hr_app, 'HR_52956_WKF2TSK_WRONG_SQLFORM');
1136: fnd_message.set_token(g_process_name, g_process_display_name);
1137: fnd_message.set_token(g_item_type, g_item_type_display_name);
1138: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
1139: -- get the TO_FORM_ACTIVITY details
1140: get_item_act_display_names
1133: ,p_process_display_name => g_process_display_name);
1134: -- get the TO_FORM_ACTIVITY details
1135: fnd_message.set_name(g_hr_app, 'HR_52956_WKF2TSK_WRONG_SQLFORM');
1136: fnd_message.set_token(g_process_name, g_process_display_name);
1137: fnd_message.set_token(g_item_type, g_item_type_display_name);
1138: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
1139: -- get the TO_FORM_ACTIVITY details
1140: get_item_act_display_names
1141: (p_instance_id => l_pop_to_process_activity
1134: -- get the TO_FORM_ACTIVITY details
1135: fnd_message.set_name(g_hr_app, 'HR_52956_WKF2TSK_WRONG_SQLFORM');
1136: fnd_message.set_token(g_process_name, g_process_display_name);
1137: fnd_message.set_token(g_item_type, g_item_type_display_name);
1138: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
1139: -- get the TO_FORM_ACTIVITY details
1140: get_item_act_display_names
1141: (p_instance_id => l_pop_to_process_activity
1142: ,p_item_type_display_name => g_item_type_display_name
1142: ,p_item_type_display_name => g_item_type_display_name
1143: ,p_activity_display_name => g_activity_display_name
1144: ,p_process_display_name => g_process_display_name);
1145: --
1146: fnd_message.set_token(g_to_form_activity, g_item_type_display_name);
1147: fnd_message.raise_error;
1148: elsif l_activity_type = 'PROCESS' then
1149: hr_utility.set_location(l_proc, 45);
1150: l_dummy := set_visit_activity(l_pop_to_process_activity);
1143: ,p_activity_display_name => g_activity_display_name
1144: ,p_process_display_name => g_process_display_name);
1145: --
1146: fnd_message.set_token(g_to_form_activity, g_item_type_display_name);
1147: fnd_message.raise_error;
1148: elsif l_activity_type = 'PROCESS' then
1149: hr_utility.set_location(l_proc, 45);
1150: l_dummy := set_visit_activity(l_pop_to_process_activity);
1151: -- push each start activity results
1201: ,p_item_type_display_name => g_item_type_display_name
1202: ,p_activity_display_name => g_activity_display_name
1203: ,p_process_display_name => g_process_display_name);
1204: --
1205: fnd_message.set_name(g_hr_app, 'HR_52959_WKF2TSK_NO_ROOT');
1206: fnd_message.set_token(g_process_name, g_process_display_name);
1207: fnd_message.set_token(g_item_type, g_item_type_display_name);
1208: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
1209: get_item_act_display_names
1202: ,p_activity_display_name => g_activity_display_name
1203: ,p_process_display_name => g_process_display_name);
1204: --
1205: fnd_message.set_name(g_hr_app, 'HR_52959_WKF2TSK_NO_ROOT');
1206: fnd_message.set_token(g_process_name, g_process_display_name);
1207: fnd_message.set_token(g_item_type, g_item_type_display_name);
1208: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
1209: get_item_act_display_names
1210: (p_instance_id => g_root_form_activity_id
1203: ,p_process_display_name => g_process_display_name);
1204: --
1205: fnd_message.set_name(g_hr_app, 'HR_52959_WKF2TSK_NO_ROOT');
1206: fnd_message.set_token(g_process_name, g_process_display_name);
1207: fnd_message.set_token(g_item_type, g_item_type_display_name);
1208: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
1209: get_item_act_display_names
1210: (p_instance_id => g_root_form_activity_id
1211: ,p_item_type_display_name => g_item_type_display_name
1204: --
1205: fnd_message.set_name(g_hr_app, 'HR_52959_WKF2TSK_NO_ROOT');
1206: fnd_message.set_token(g_process_name, g_process_display_name);
1207: fnd_message.set_token(g_item_type, g_item_type_display_name);
1208: fnd_message.set_token(g_from_form_activity, g_activity_display_name);
1209: get_item_act_display_names
1210: (p_instance_id => g_root_form_activity_id
1211: ,p_item_type_display_name => g_item_type_display_name
1212: ,p_activity_display_name => g_activity_display_name
1210: (p_instance_id => g_root_form_activity_id
1211: ,p_item_type_display_name => g_item_type_display_name
1212: ,p_activity_display_name => g_activity_display_name
1213: ,p_process_display_name => g_process_display_name);
1214: fnd_message.set_token(g_to_form_activity, g_activity_display_name);
1215: fnd_message.raise_error;
1216: end if;
1217: end loop;
1218: -- correct the parent buttons
1211: ,p_item_type_display_name => g_item_type_display_name
1212: ,p_activity_display_name => g_activity_display_name
1213: ,p_process_display_name => g_process_display_name);
1214: fnd_message.set_token(g_to_form_activity, g_activity_display_name);
1215: fnd_message.raise_error;
1216: end if;
1217: end loop;
1218: -- correct the parent buttons
1219: correct_parent_buttons;
1329: into l_nav_node_usage_id
1330: from sys.dual;
1331: exception
1332: when others then
1333: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
1334: fnd_message.set_token('PROCEDURE', l_proc);
1335: fnd_message.set_token('STEP','10');
1336: fnd_message.raise_error;
1337: end;
1330: from sys.dual;
1331: exception
1332: when others then
1333: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
1334: fnd_message.set_token('PROCEDURE', l_proc);
1335: fnd_message.set_token('STEP','10');
1336: fnd_message.raise_error;
1337: end;
1338: hr_utility.set_location(l_proc, 20);
1331: exception
1332: when others then
1333: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
1334: fnd_message.set_token('PROCEDURE', l_proc);
1335: fnd_message.set_token('STEP','10');
1336: fnd_message.raise_error;
1337: end;
1338: hr_utility.set_location(l_proc, 20);
1339: -- insert the node usage
1332: when others then
1333: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
1334: fnd_message.set_token('PROCEDURE', l_proc);
1335: fnd_message.set_token('STEP','10');
1336: fnd_message.raise_error;
1337: end;
1338: hr_utility.set_location(l_proc, 20);
1339: -- insert the node usage
1340: insert into hr_navigation_node_usages
1584: ,p_item_type_display_name => g_item_type_display_name
1585: ,p_activity_display_name => g_activity_display_name
1586: ,p_process_display_name => g_process_display_name);
1587: --
1588: fnd_message.set_name(g_hr_app, 'HR_52957_WKF2TSK_INC_SQLFORM');
1589: fnd_message.set_token('ACTIVITY_NAME', g_activity_display_name);
1590: fnd_message.set_token(g_process_name, g_process_display_name);
1591: fnd_message.set_token(g_item_type, g_item_type_display_name);
1592: fnd_message.raise_error;
1585: ,p_activity_display_name => g_activity_display_name
1586: ,p_process_display_name => g_process_display_name);
1587: --
1588: fnd_message.set_name(g_hr_app, 'HR_52957_WKF2TSK_INC_SQLFORM');
1589: fnd_message.set_token('ACTIVITY_NAME', g_activity_display_name);
1590: fnd_message.set_token(g_process_name, g_process_display_name);
1591: fnd_message.set_token(g_item_type, g_item_type_display_name);
1592: fnd_message.raise_error;
1593: end if;
1586: ,p_process_display_name => g_process_display_name);
1587: --
1588: fnd_message.set_name(g_hr_app, 'HR_52957_WKF2TSK_INC_SQLFORM');
1589: fnd_message.set_token('ACTIVITY_NAME', g_activity_display_name);
1590: fnd_message.set_token(g_process_name, g_process_display_name);
1591: fnd_message.set_token(g_item_type, g_item_type_display_name);
1592: fnd_message.raise_error;
1593: end if;
1594: close l_csr_nav_unit_id;
1587: --
1588: fnd_message.set_name(g_hr_app, 'HR_52957_WKF2TSK_INC_SQLFORM');
1589: fnd_message.set_token('ACTIVITY_NAME', g_activity_display_name);
1590: fnd_message.set_token(g_process_name, g_process_display_name);
1591: fnd_message.set_token(g_item_type, g_item_type_display_name);
1592: fnd_message.raise_error;
1593: end if;
1594: close l_csr_nav_unit_id;
1595: -- the activity was a TF function activity so we must now determine
1588: fnd_message.set_name(g_hr_app, 'HR_52957_WKF2TSK_INC_SQLFORM');
1589: fnd_message.set_token('ACTIVITY_NAME', g_activity_display_name);
1590: fnd_message.set_token(g_process_name, g_process_display_name);
1591: fnd_message.set_token(g_item_type, g_item_type_display_name);
1592: fnd_message.raise_error;
1593: end if;
1594: close l_csr_nav_unit_id;
1595: -- the activity was a TF function activity so we must now determine
1596: -- if the customization is valid
1642: into l_nextval
1643: from sys.dual;
1644: exception
1645: when others then
1646: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
1647: fnd_message.set_token('PROCEDURE', l_proc);
1648: fnd_message.set_token('STEP','10');
1649: fnd_message.raise_error;
1650: end;
1643: from sys.dual;
1644: exception
1645: when others then
1646: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
1647: fnd_message.set_token('PROCEDURE', l_proc);
1648: fnd_message.set_token('STEP','10');
1649: fnd_message.raise_error;
1650: end;
1651: hr_utility.set_location(l_proc, 60);
1644: exception
1645: when others then
1646: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
1647: fnd_message.set_token('PROCEDURE', l_proc);
1648: fnd_message.set_token('STEP','10');
1649: fnd_message.raise_error;
1650: end;
1651: hr_utility.set_location(l_proc, 60);
1652: l_navigation_node_name := l_taskflow_actvity_name||l_nextval;
1645: when others then
1646: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
1647: fnd_message.set_token('PROCEDURE', l_proc);
1648: fnd_message.set_token('STEP','10');
1649: fnd_message.raise_error;
1650: end;
1651: hr_utility.set_location(l_proc, 60);
1652: l_navigation_node_name := l_taskflow_actvity_name||l_nextval;
1653: -- the navigation node does not exist so we need to insert it
1702: from sys.dual;
1703: exception
1704: when others then
1705: -- error lang does not exist
1706: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
1707: fnd_message.set_token('PROCEDURE', l_proc);
1708: fnd_message.set_token('STEP','10');
1709: fnd_message.raise_error;
1710: end;
1703: exception
1704: when others then
1705: -- error lang does not exist
1706: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
1707: fnd_message.set_token('PROCEDURE', l_proc);
1708: fnd_message.set_token('STEP','10');
1709: fnd_message.raise_error;
1710: end;
1711: -- set the business legislation
1704: when others then
1705: -- error lang does not exist
1706: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
1707: fnd_message.set_token('PROCEDURE', l_proc);
1708: fnd_message.set_token('STEP','10');
1709: fnd_message.raise_error;
1710: end;
1711: -- set the business legislation
1712: set_business_legislation
1705: -- error lang does not exist
1706: fnd_message.set_name(g_hr_app, 'HR_6153_ALL_PROCEDURE_FAIL');
1707: fnd_message.set_token('PROCEDURE', l_proc);
1708: fnd_message.set_token('STEP','10');
1709: fnd_message.raise_error;
1710: end;
1711: -- set the business legislation
1712: set_business_legislation
1713: (p_business_group_id => p_business_group_id
1747: end loop;
1748: -- check to see if process name was specified and if it was found
1749: if NOT l_found and p_root_process_name is not null then
1750: -- error the root process specified does not exist
1751: fnd_message.set_name(g_hr_app, 'HR_52958_WKF2TSK_INC_PROCESS');
1752: fnd_message.set_token(g_item_type, g_item_type_display_name);
1753: fnd_message.set_token(g_process_name, p_root_process_name);
1754: fnd_message.raise_error;
1755: end if;
1748: -- check to see if process name was specified and if it was found
1749: if NOT l_found and p_root_process_name is not null then
1750: -- error the root process specified does not exist
1751: fnd_message.set_name(g_hr_app, 'HR_52958_WKF2TSK_INC_PROCESS');
1752: fnd_message.set_token(g_item_type, g_item_type_display_name);
1753: fnd_message.set_token(g_process_name, p_root_process_name);
1754: fnd_message.raise_error;
1755: end if;
1756: hr_utility.set_location('Leaving:'||l_proc, 40);
1749: if NOT l_found and p_root_process_name is not null then
1750: -- error the root process specified does not exist
1751: fnd_message.set_name(g_hr_app, 'HR_52958_WKF2TSK_INC_PROCESS');
1752: fnd_message.set_token(g_item_type, g_item_type_display_name);
1753: fnd_message.set_token(g_process_name, p_root_process_name);
1754: fnd_message.raise_error;
1755: end if;
1756: hr_utility.set_location('Leaving:'||l_proc, 40);
1757: end transfer_workflow;
1750: -- error the root process specified does not exist
1751: fnd_message.set_name(g_hr_app, 'HR_52958_WKF2TSK_INC_PROCESS');
1752: fnd_message.set_token(g_item_type, g_item_type_display_name);
1753: fnd_message.set_token(g_process_name, p_root_process_name);
1754: fnd_message.raise_error;
1755: end if;
1756: hr_utility.set_location('Leaving:'||l_proc, 40);
1757: end transfer_workflow;
1758: -- ----------------------------------------------------------------------------