284: AND a.assignment_status_type_id = past.assignment_status_type_id
285: AND past.per_system_status IN ('ACTIVE_ASSIGN','SUSP_ASSIGN','ACTIVE_CWK');
286:
287: EXCEPTION WHEN no_data_found THEN /* added for bug 6954412 */
288: fnd_message.set_name('PA','PA_NO_ASSIGNMENT');
289: app_exception.raise_exception;
290:
291: END;
292:
1467: (NOT l_result) THEN ** commenting this out for bug 2802847 */
1468:
1469: /* Added the check for l_error_message for bug 2694601 */
1470: IF l_error_message is null THEN
1471: fnd_message.set_name('PA','PA_WF_SETUP_ERROR');
1472: x_error_message := fnd_message.get_encoded;
1473: ELSE
1474: x_error_message := l_error_message;
1475: END IF;
1468:
1469: /* Added the check for l_error_message for bug 2694601 */
1470: IF l_error_message is null THEN
1471: fnd_message.set_name('PA','PA_WF_SETUP_ERROR');
1472: x_error_message := fnd_message.get_encoded;
1473: ELSE
1474: x_error_message := l_error_message;
1475: END IF;
1476: /* 2694601 */
2247: (NOT l_result) THEN ** Commenting this out for bug 2802847 */
2248:
2249: /* Added the check for l_error_message for bug 2694601 */
2250: IF l_error_message is null THEN
2251: fnd_message.set_name('PA','PA_WF_SETUP_ERROR');
2252: x_error_message := fnd_message.get_encoded;
2253: ELSE
2254: x_error_message := l_error_message;
2255: END IF;
2248:
2249: /* Added the check for l_error_message for bug 2694601 */
2250: IF l_error_message is null THEN
2251: fnd_message.set_name('PA','PA_WF_SETUP_ERROR');
2252: x_error_message := fnd_message.get_encoded;
2253: ELSE
2254: x_error_message := l_error_message;
2255: END IF;
2256: /* 2694601*/
2506: -----------------------------------------
2507: -- Set the appropriate message and exit
2508: -----------------------------------------
2509:
2510: fnd_message.set_name('PA','FLEXWF-DEFAULT MISSING');
2511: l_fb_error_msg := fnd_message.get_encoded;
2512: wf_engine.SetItemAttrText( itemtype => p_itemtype,
2513: itemkey => p_itemkey,
2514: aname => 'ERROR_MESSAGE',
2507: -- Set the appropriate message and exit
2508: -----------------------------------------
2509:
2510: fnd_message.set_name('PA','FLEXWF-DEFAULT MISSING');
2511: l_fb_error_msg := fnd_message.get_encoded;
2512: wf_engine.SetItemAttrText( itemtype => p_itemtype,
2513: itemkey => p_itemkey,
2514: aname => 'ERROR_MESSAGE',
2515: avalue => l_fb_error_msg);
2680: -- Error requires an error message to be set so that it can be
2681: -- displayed on the form.
2682:
2683:
2684: fnd_message.set_name('PA','WF_ACC_LOOKUP_TYPE_FAIL');
2685: l_error_message := fnd_message.get_encoded;
2686: wf_engine.SetItemAttrText( itemtype => p_itemtype,
2687: itemkey => p_itemkey,
2688: aname => 'ERROR_MESSAGE',
2681: -- displayed on the form.
2682:
2683:
2684: fnd_message.set_name('PA','WF_ACC_LOOKUP_TYPE_FAIL');
2685: l_error_message := fnd_message.get_encoded;
2686: wf_engine.SetItemAttrText( itemtype => p_itemtype,
2687: itemkey => p_itemkey,
2688: aname => 'ERROR_MESSAGE',
2689: avalue => l_error_message);
2720: itemkey => p_itemkey,
2721: aname => 'ERROR_MESSAGE',
2722: avalue => 'WF_ACC_LOOKUP_CODE_FAIL');
2723:
2724: fnd_message.set_name('PA','WF_ACC_LOOKUP_CODE_FAIL');
2725: l_error_message := fnd_message.get_encoded;
2726: wf_engine.SetItemAttrText( itemtype => p_itemtype,
2727: itemkey => p_itemkey,
2728: aname => 'ERROR_MESSAGE',
2721: aname => 'ERROR_MESSAGE',
2722: avalue => 'WF_ACC_LOOKUP_CODE_FAIL');
2723:
2724: fnd_message.set_name('PA','WF_ACC_LOOKUP_CODE_FAIL');
2725: l_error_message := fnd_message.get_encoded;
2726: wf_engine.SetItemAttrText( itemtype => p_itemtype,
2727: itemkey => p_itemkey,
2728: aname => 'ERROR_MESSAGE',
2729: avalue => l_error_message);
2760: itemkey => p_itemkey,
2761: aname => 'ERROR_MESSAGE',
2762: avalue => 'WF_ACC_LOOKUP_NODATA_FAIL');
2763:
2764: fnd_message.set_name('PA','WF_ACC_LOOKUP_NODATA_FAIL');
2765: l_error_message := fnd_message.get_encoded;
2766: wf_engine.SetItemAttrText( itemtype => p_itemtype,
2767: itemkey => p_itemkey,
2768: aname => 'ERROR_MESSAGE',
2761: aname => 'ERROR_MESSAGE',
2762: avalue => 'WF_ACC_LOOKUP_NODATA_FAIL');
2763:
2764: fnd_message.set_name('PA','WF_ACC_LOOKUP_NODATA_FAIL');
2765: l_error_message := fnd_message.get_encoded;
2766: wf_engine.SetItemAttrText( itemtype => p_itemtype,
2767: itemkey => p_itemkey,
2768: aname => 'ERROR_MESSAGE',
2769: avalue => l_error_message);
3091:
3092: BEGIN
3093: g_error_message := nvl(p_error_message,SUBSTRB(SQLERRM,1,1000));
3094:
3095: fnd_message.set_name('PA','PA_WF_FATAL_ERROR');
3096: fnd_message.set_token('ERROR_STACK',p_error_stack);
3097: fnd_message.set_token('ERROR_STAGE',p_error_stage);
3098: fnd_message.set_token('ERROR_MESSAGE',g_error_message);
3099: fnd_message.set_token('ERROR_ARG1',p_arg1);
3092: BEGIN
3093: g_error_message := nvl(p_error_message,SUBSTRB(SQLERRM,1,1000));
3094:
3095: fnd_message.set_name('PA','PA_WF_FATAL_ERROR');
3096: fnd_message.set_token('ERROR_STACK',p_error_stack);
3097: fnd_message.set_token('ERROR_STAGE',p_error_stage);
3098: fnd_message.set_token('ERROR_MESSAGE',g_error_message);
3099: fnd_message.set_token('ERROR_ARG1',p_arg1);
3100: fnd_message.set_token('ERROR_ARG2',p_arg2);
3093: g_error_message := nvl(p_error_message,SUBSTRB(SQLERRM,1,1000));
3094:
3095: fnd_message.set_name('PA','PA_WF_FATAL_ERROR');
3096: fnd_message.set_token('ERROR_STACK',p_error_stack);
3097: fnd_message.set_token('ERROR_STAGE',p_error_stage);
3098: fnd_message.set_token('ERROR_MESSAGE',g_error_message);
3099: fnd_message.set_token('ERROR_ARG1',p_arg1);
3100: fnd_message.set_token('ERROR_ARG2',p_arg2);
3101:
3094:
3095: fnd_message.set_name('PA','PA_WF_FATAL_ERROR');
3096: fnd_message.set_token('ERROR_STACK',p_error_stack);
3097: fnd_message.set_token('ERROR_STAGE',p_error_stage);
3098: fnd_message.set_token('ERROR_MESSAGE',g_error_message);
3099: fnd_message.set_token('ERROR_ARG1',p_arg1);
3100: fnd_message.set_token('ERROR_ARG2',p_arg2);
3101:
3102: l_result := fnd_message.get_encoded;
3095: fnd_message.set_name('PA','PA_WF_FATAL_ERROR');
3096: fnd_message.set_token('ERROR_STACK',p_error_stack);
3097: fnd_message.set_token('ERROR_STAGE',p_error_stage);
3098: fnd_message.set_token('ERROR_MESSAGE',g_error_message);
3099: fnd_message.set_token('ERROR_ARG1',p_arg1);
3100: fnd_message.set_token('ERROR_ARG2',p_arg2);
3101:
3102: l_result := fnd_message.get_encoded;
3103:
3096: fnd_message.set_token('ERROR_STACK',p_error_stack);
3097: fnd_message.set_token('ERROR_STAGE',p_error_stage);
3098: fnd_message.set_token('ERROR_MESSAGE',g_error_message);
3099: fnd_message.set_token('ERROR_ARG1',p_arg1);
3100: fnd_message.set_token('ERROR_ARG2',p_arg2);
3101:
3102: l_result := fnd_message.get_encoded;
3103:
3104: g_error_message := NULL;
3098: fnd_message.set_token('ERROR_MESSAGE',g_error_message);
3099: fnd_message.set_token('ERROR_ARG1',p_arg1);
3100: fnd_message.set_token('ERROR_ARG2',p_arg2);
3101:
3102: l_result := fnd_message.get_encoded;
3103:
3104: g_error_message := NULL;
3105:
3106: RETURN l_result;