APPS.PA_CONTROL_ITEMS_WORKFLOW dependencies on PA_UTILS

Line 236: PA_UTILS.Add_Message( p_app_short_name => 'PA'

232: );
233:
234: IF l_err_code <> 0 THEN
235:
236: PA_UTILS.Add_Message( p_app_short_name => 'PA'
237: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
238: x_return_status := FND_API.G_RET_STS_ERROR;
239:
240:

Line 1196: PA_UTILS.ADD_MESSAGE

1192: IF (p_item_type IS NULL) OR
1193: (p_process_name IS NULL) OR
1194: (p_ci_id IS NULL)
1195: THEN
1196: PA_UTILS.ADD_MESSAGE
1197: (p_app_short_name => 'PA',
1198: p_msg_name => 'PA_INV_PARAM_PASSED');
1199: RAISE Invalid_Arg_Exc_CI;
1200: END IF;

Line 1254: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1250: IF l_debug_mode = 'Y' THEN
1251: pa_debug.g_err_stage:= 'Error calling pa_control_item_workflow.SET_WORKFLOW_ATTRIBUTES';
1252: pa_debug.write('START_NOTIFICATION_WF: ' || l_module_name,pa_debug.g_err_stage,l_debug_level5);
1253:
1254: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1255: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
1256: END IF;
1257: RAISE Invalid_Arg_Exc_CI;
1258: END IF;

Line 1287: PA_UTILS.Add_Message( p_app_short_name => 'PA'

1283: WF_ENGINE.AbortProcess(p_Item_Type
1284: ,l_Item_Key);
1285:
1286: --Log an error message and go to exception section.
1287: PA_UTILS.Add_Message( p_app_short_name => 'PA'
1288: ,p_msg_name => 'PA_PR_CREATE_WF_FAILED');
1289: x_return_status := FND_API.G_RET_STS_ERROR;
1290: Raise Invalid_Arg_Exc_CI;
1291: END IF;

Line 1569: select PA_UTILS.get_party_id(created_by) party_id

1565:
1566: -- This cursor gets the partyid of all the people involved in the hierarchy
1567: Cursor get_parties_in_hierarchy(c_action_id pa_ci_actions.ci_action_id%TYPE)
1568: Is
1569: select PA_UTILS.get_party_id(created_by) party_id
1570: from pa_ci_actions
1571: start with ci_action_id = c_action_id
1572: connect by prior source_ci_action_id = ci_action_id;
1573:

Line 1644: PA_UTILS.ADD_MESSAGE

1640: (p_process_name IS NULL) OR
1641: (p_ci_id IS NULL)
1642: THEN
1643:
1644: PA_UTILS.ADD_MESSAGE
1645: (p_app_short_name => 'PA',
1646: p_msg_name => 'PA_INV_PARAM_PASSED');
1647: RAISE Invalid_Arg_Exc_CI;
1648: END IF;

Line 1668: pa_utils.getprojinfo(rec.project_id, l_project_number, l_project_name);

1664: , p_ci_id);
1665:
1666: FOR rec IN get_ci_info LOOP
1667:
1668: pa_utils.getprojinfo(rec.project_id, l_project_number, l_project_name);
1669: l_owner_id := rec.owner_id;
1670: /* Added for Bug 9689141 */
1671: open get_owner_role(l_owner_id);
1672: fetch get_owner_role into l_owner_role;

Line 2341: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2337: FETCH ci_action INTO l_ci_id, l_type_code, l_assigned_to,
2338: l_date_required, l_sign_off_required_flag, l_source_ci_action_id,
2339: l_created_by, l_creation_date;
2340: IF ci_action%NOTFOUND THEN
2341: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2342: ,p_msg_name => 'PA_NO_ACTION_FOUND');
2343: resultout := wf_engine.eng_completed||':'||'F';
2344: CLOSE ci_action;
2345: return;

Line 2352: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2348: --LOCK the ROW
2349: OPEN check_record_changed(l_ci_action_id,l_record_version_number);
2350: FETCH check_record_changed INTO l_rowid;
2351: IF check_record_changed%NOTFOUND THEN
2352: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2353: ,p_msg_name => 'PA_PR_RECORD_CHANGED');
2354: resultout := wf_engine.eng_completed||':'||'F';
2355: CLOSE check_record_changed;
2356: return;

Line 2588: PA_UTILS.Add_Message( p_app_short_name => 'PA'

2584: FETCH ci_action INTO l_ci_id, l_type_code, l_assigned_to,
2585: l_date_required, l_sign_off_required_flag, l_source_ci_action_id,
2586: l_created_by, l_creation_date;
2587: IF ci_action%NOTFOUND THEN
2588: PA_UTILS.Add_Message( p_app_short_name => 'PA'
2589: ,p_msg_name => 'PA_NO_ACTION_FOUND');
2590: resultout := wf_engine.eng_completed||':'||'F';
2591: CLOSE ci_action;
2592: return;