DBA Data[Home] [Help]

APPS.PSP_ER_WORKFLOW dependencies on FND_MESSAGE

Line 1421: FND_MESSAGE.set_name('PSP','PSP_ER_EMP_PERCENT_NOT_100');

1417: OPEN person_percent_csr;
1418: FETCH person_percent_csr into l_percent;
1419: CLOSE person_percent_csr;
1420: IF l_percent <> 100 THEN
1421: FND_MESSAGE.set_name('PSP','PSP_ER_EMP_PERCENT_NOT_100');
1422: fnd_message.set_token('EMP_NAME', l_full_name);
1423: fnd_message.set_token('PERCENT', l_percent);
1424: l_error_message := fnd_message.get;
1425: raise_application_error(-20002, l_error_message);

Line 1422: fnd_message.set_token('EMP_NAME', l_full_name);

1418: FETCH person_percent_csr into l_percent;
1419: CLOSE person_percent_csr;
1420: IF l_percent <> 100 THEN
1421: FND_MESSAGE.set_name('PSP','PSP_ER_EMP_PERCENT_NOT_100');
1422: fnd_message.set_token('EMP_NAME', l_full_name);
1423: fnd_message.set_token('PERCENT', l_percent);
1424: l_error_message := fnd_message.get;
1425: raise_application_error(-20002, l_error_message);
1426: END IF;

Line 1423: fnd_message.set_token('PERCENT', l_percent);

1419: CLOSE person_percent_csr;
1420: IF l_percent <> 100 THEN
1421: FND_MESSAGE.set_name('PSP','PSP_ER_EMP_PERCENT_NOT_100');
1422: fnd_message.set_token('EMP_NAME', l_full_name);
1423: fnd_message.set_token('PERCENT', l_percent);
1424: l_error_message := fnd_message.get;
1425: raise_application_error(-20002, l_error_message);
1426: END IF;
1427: END IF;

Line 1424: l_error_message := fnd_message.get;

1420: IF l_percent <> 100 THEN
1421: FND_MESSAGE.set_name('PSP','PSP_ER_EMP_PERCENT_NOT_100');
1422: fnd_message.set_token('EMP_NAME', l_full_name);
1423: fnd_message.set_token('PERCENT', l_percent);
1424: l_error_message := fnd_message.get;
1425: raise_application_error(-20002, l_error_message);
1426: END IF;
1427: END IF;
1428: ELSIF l_hundred_pcrent_eff_flag = 'A' THEN

Line 1442: FND_MESSAGE.set_name('PSP','PSP_ER_ASG_PERCENT_NOT_100');

1438: OPEN assignment_percent_csr;
1439: FETCH assignment_percent_csr into l_percent;
1440: CLOSE assignment_percent_csr;
1441: IF l_percent <> 100 THEN
1442: FND_MESSAGE.set_name('PSP','PSP_ER_ASG_PERCENT_NOT_100');
1443: fnd_message.set_token('EMP_NAME', l_full_name);
1444: fnd_message.set_token('ASG_NUMBER', l_assignemnt_number);
1445: fnd_message.set_token('PERCENT', l_percent);
1446: l_error_message := fnd_message.get;

Line 1443: fnd_message.set_token('EMP_NAME', l_full_name);

1439: FETCH assignment_percent_csr into l_percent;
1440: CLOSE assignment_percent_csr;
1441: IF l_percent <> 100 THEN
1442: FND_MESSAGE.set_name('PSP','PSP_ER_ASG_PERCENT_NOT_100');
1443: fnd_message.set_token('EMP_NAME', l_full_name);
1444: fnd_message.set_token('ASG_NUMBER', l_assignemnt_number);
1445: fnd_message.set_token('PERCENT', l_percent);
1446: l_error_message := fnd_message.get;
1447: raise_application_error(-20002, l_error_message);

Line 1444: fnd_message.set_token('ASG_NUMBER', l_assignemnt_number);

1440: CLOSE assignment_percent_csr;
1441: IF l_percent <> 100 THEN
1442: FND_MESSAGE.set_name('PSP','PSP_ER_ASG_PERCENT_NOT_100');
1443: fnd_message.set_token('EMP_NAME', l_full_name);
1444: fnd_message.set_token('ASG_NUMBER', l_assignemnt_number);
1445: fnd_message.set_token('PERCENT', l_percent);
1446: l_error_message := fnd_message.get;
1447: raise_application_error(-20002, l_error_message);
1448: END IF;

Line 1445: fnd_message.set_token('PERCENT', l_percent);

1441: IF l_percent <> 100 THEN
1442: FND_MESSAGE.set_name('PSP','PSP_ER_ASG_PERCENT_NOT_100');
1443: fnd_message.set_token('EMP_NAME', l_full_name);
1444: fnd_message.set_token('ASG_NUMBER', l_assignemnt_number);
1445: fnd_message.set_token('PERCENT', l_percent);
1446: l_error_message := fnd_message.get;
1447: raise_application_error(-20002, l_error_message);
1448: END IF;
1449: END IF;

Line 1446: l_error_message := fnd_message.get;

1442: FND_MESSAGE.set_name('PSP','PSP_ER_ASG_PERCENT_NOT_100');
1443: fnd_message.set_token('EMP_NAME', l_full_name);
1444: fnd_message.set_token('ASG_NUMBER', l_assignemnt_number);
1445: fnd_message.set_token('PERCENT', l_percent);
1446: l_error_message := fnd_message.get;
1447: raise_application_error(-20002, l_error_message);
1448: END IF;
1449: END IF;
1450: END IF;

Line 1904: fnd_message.set_name('PSP', 'PSP_ER_WF_PROCESS_PARAMETERS');

1900: OPEN get_param_strings;
1901: FETCH get_param_strings INTO l_arg1, l_arg2, l_arg3, /* l_arg4,*/ l_arg5, l_arg6, l_arg7, l_arg8, l_arg9, l_arg10, l_arg11, l_arg12;
1902: CLOSE get_param_strings;
1903:
1904: fnd_message.set_name('PSP', 'PSP_ER_WF_PROCESS_PARAMETERS');
1905: fnd_message.set_token('TEMPLATE_NAME', l_arg1);
1906: fnd_message.set_token('START_DATE', l_arg2);
1907: fnd_message.set_token('END_DATE', l_arg3);
1908: -- fnd_message.set_token('REPORT_LAYOUT', l_arg4);

Line 1905: fnd_message.set_token('TEMPLATE_NAME', l_arg1);

1901: FETCH get_param_strings INTO l_arg1, l_arg2, l_arg3, /* l_arg4,*/ l_arg5, l_arg6, l_arg7, l_arg8, l_arg9, l_arg10, l_arg11, l_arg12;
1902: CLOSE get_param_strings;
1903:
1904: fnd_message.set_name('PSP', 'PSP_ER_WF_PROCESS_PARAMETERS');
1905: fnd_message.set_token('TEMPLATE_NAME', l_arg1);
1906: fnd_message.set_token('START_DATE', l_arg2);
1907: fnd_message.set_token('END_DATE', l_arg3);
1908: -- fnd_message.set_token('REPORT_LAYOUT', l_arg4);
1909: fnd_message.set_token('FIRST_SORT_BY', l_arg5);

Line 1906: fnd_message.set_token('START_DATE', l_arg2);

1902: CLOSE get_param_strings;
1903:
1904: fnd_message.set_name('PSP', 'PSP_ER_WF_PROCESS_PARAMETERS');
1905: fnd_message.set_token('TEMPLATE_NAME', l_arg1);
1906: fnd_message.set_token('START_DATE', l_arg2);
1907: fnd_message.set_token('END_DATE', l_arg3);
1908: -- fnd_message.set_token('REPORT_LAYOUT', l_arg4);
1909: fnd_message.set_token('FIRST_SORT_BY', l_arg5);
1910: fnd_message.set_token('FIRST_ORDER_BY', l_arg6);

Line 1907: fnd_message.set_token('END_DATE', l_arg3);

1903:
1904: fnd_message.set_name('PSP', 'PSP_ER_WF_PROCESS_PARAMETERS');
1905: fnd_message.set_token('TEMPLATE_NAME', l_arg1);
1906: fnd_message.set_token('START_DATE', l_arg2);
1907: fnd_message.set_token('END_DATE', l_arg3);
1908: -- fnd_message.set_token('REPORT_LAYOUT', l_arg4);
1909: fnd_message.set_token('FIRST_SORT_BY', l_arg5);
1910: fnd_message.set_token('FIRST_ORDER_BY', l_arg6);
1911: fnd_message.set_token('SECOND_SORT_BY', l_arg7);

Line 1908: -- fnd_message.set_token('REPORT_LAYOUT', l_arg4);

1904: fnd_message.set_name('PSP', 'PSP_ER_WF_PROCESS_PARAMETERS');
1905: fnd_message.set_token('TEMPLATE_NAME', l_arg1);
1906: fnd_message.set_token('START_DATE', l_arg2);
1907: fnd_message.set_token('END_DATE', l_arg3);
1908: -- fnd_message.set_token('REPORT_LAYOUT', l_arg4);
1909: fnd_message.set_token('FIRST_SORT_BY', l_arg5);
1910: fnd_message.set_token('FIRST_ORDER_BY', l_arg6);
1911: fnd_message.set_token('SECOND_SORT_BY', l_arg7);
1912: fnd_message.set_token('SECOND_ORDER_BY', l_arg8);

Line 1909: fnd_message.set_token('FIRST_SORT_BY', l_arg5);

1905: fnd_message.set_token('TEMPLATE_NAME', l_arg1);
1906: fnd_message.set_token('START_DATE', l_arg2);
1907: fnd_message.set_token('END_DATE', l_arg3);
1908: -- fnd_message.set_token('REPORT_LAYOUT', l_arg4);
1909: fnd_message.set_token('FIRST_SORT_BY', l_arg5);
1910: fnd_message.set_token('FIRST_ORDER_BY', l_arg6);
1911: fnd_message.set_token('SECOND_SORT_BY', l_arg7);
1912: fnd_message.set_token('SECOND_ORDER_BY', l_arg8);
1913: fnd_message.set_token('THIRD_SORT_BY', l_arg9);

Line 1910: fnd_message.set_token('FIRST_ORDER_BY', l_arg6);

1906: fnd_message.set_token('START_DATE', l_arg2);
1907: fnd_message.set_token('END_DATE', l_arg3);
1908: -- fnd_message.set_token('REPORT_LAYOUT', l_arg4);
1909: fnd_message.set_token('FIRST_SORT_BY', l_arg5);
1910: fnd_message.set_token('FIRST_ORDER_BY', l_arg6);
1911: fnd_message.set_token('SECOND_SORT_BY', l_arg7);
1912: fnd_message.set_token('SECOND_ORDER_BY', l_arg8);
1913: fnd_message.set_token('THIRD_SORT_BY', l_arg9);
1914: fnd_message.set_token('THIRD_ORDER_BY', l_arg10);

Line 1911: fnd_message.set_token('SECOND_SORT_BY', l_arg7);

1907: fnd_message.set_token('END_DATE', l_arg3);
1908: -- fnd_message.set_token('REPORT_LAYOUT', l_arg4);
1909: fnd_message.set_token('FIRST_SORT_BY', l_arg5);
1910: fnd_message.set_token('FIRST_ORDER_BY', l_arg6);
1911: fnd_message.set_token('SECOND_SORT_BY', l_arg7);
1912: fnd_message.set_token('SECOND_ORDER_BY', l_arg8);
1913: fnd_message.set_token('THIRD_SORT_BY', l_arg9);
1914: fnd_message.set_token('THIRD_ORDER_BY', l_arg10);
1915: fnd_message.set_token('FOURTH_SORT_BY', l_arg11);

Line 1912: fnd_message.set_token('SECOND_ORDER_BY', l_arg8);

1908: -- fnd_message.set_token('REPORT_LAYOUT', l_arg4);
1909: fnd_message.set_token('FIRST_SORT_BY', l_arg5);
1910: fnd_message.set_token('FIRST_ORDER_BY', l_arg6);
1911: fnd_message.set_token('SECOND_SORT_BY', l_arg7);
1912: fnd_message.set_token('SECOND_ORDER_BY', l_arg8);
1913: fnd_message.set_token('THIRD_SORT_BY', l_arg9);
1914: fnd_message.set_token('THIRD_ORDER_BY', l_arg10);
1915: fnd_message.set_token('FOURTH_SORT_BY', l_arg11);
1916: fnd_message.set_token('FOURTH_ORDER_BY', l_arg12);

Line 1913: fnd_message.set_token('THIRD_SORT_BY', l_arg9);

1909: fnd_message.set_token('FIRST_SORT_BY', l_arg5);
1910: fnd_message.set_token('FIRST_ORDER_BY', l_arg6);
1911: fnd_message.set_token('SECOND_SORT_BY', l_arg7);
1912: fnd_message.set_token('SECOND_ORDER_BY', l_arg8);
1913: fnd_message.set_token('THIRD_SORT_BY', l_arg9);
1914: fnd_message.set_token('THIRD_ORDER_BY', l_arg10);
1915: fnd_message.set_token('FOURTH_SORT_BY', l_arg11);
1916: fnd_message.set_token('FOURTH_ORDER_BY', l_arg12);
1917:

Line 1914: fnd_message.set_token('THIRD_ORDER_BY', l_arg10);

1910: fnd_message.set_token('FIRST_ORDER_BY', l_arg6);
1911: fnd_message.set_token('SECOND_SORT_BY', l_arg7);
1912: fnd_message.set_token('SECOND_ORDER_BY', l_arg8);
1913: fnd_message.set_token('THIRD_SORT_BY', l_arg9);
1914: fnd_message.set_token('THIRD_ORDER_BY', l_arg10);
1915: fnd_message.set_token('FOURTH_SORT_BY', l_arg11);
1916: fnd_message.set_token('FOURTH_ORDER_BY', l_arg12);
1917:
1918: l_param_string := fnd_message.get;

Line 1915: fnd_message.set_token('FOURTH_SORT_BY', l_arg11);

1911: fnd_message.set_token('SECOND_SORT_BY', l_arg7);
1912: fnd_message.set_token('SECOND_ORDER_BY', l_arg8);
1913: fnd_message.set_token('THIRD_SORT_BY', l_arg9);
1914: fnd_message.set_token('THIRD_ORDER_BY', l_arg10);
1915: fnd_message.set_token('FOURTH_SORT_BY', l_arg11);
1916: fnd_message.set_token('FOURTH_ORDER_BY', l_arg12);
1917:
1918: l_param_string := fnd_message.get;
1919:

Line 1916: fnd_message.set_token('FOURTH_ORDER_BY', l_arg12);

1912: fnd_message.set_token('SECOND_ORDER_BY', l_arg8);
1913: fnd_message.set_token('THIRD_SORT_BY', l_arg9);
1914: fnd_message.set_token('THIRD_ORDER_BY', l_arg10);
1915: fnd_message.set_token('FOURTH_SORT_BY', l_arg11);
1916: fnd_message.set_token('FOURTH_ORDER_BY', l_arg12);
1917:
1918: l_param_string := fnd_message.get;
1919:
1920: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',

Line 1918: l_param_string := fnd_message.get;

1914: fnd_message.set_token('THIRD_ORDER_BY', l_arg10);
1915: fnd_message.set_token('FOURTH_SORT_BY', l_arg11);
1916: fnd_message.set_token('FOURTH_ORDER_BY', l_arg12);
1917:
1918: l_param_string := fnd_message.get;
1919:
1920: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
1921: itemKey => l_wf_itemkey,
1922: aname => 'CONC_PARAM_STRING',

Line 2224: fnd_message.set_name('PSP', l_message_name);

2220: l_message_name fnd_new_messages.message_name%TYPE;
2221: l_message_text fnd_new_messages.message_text%TYPE;
2222: BEGIN
2223: l_message_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'INITIATOR_MESSAGE_NAME');
2224: fnd_message.set_name('PSP', l_message_name);
2225: l_message_text := fnd_message.get;
2226: wf_engine.SetItemAttrText(itemtype => itemtype,
2227: itemkey => itemkey,
2228: aname => 'ERROR_MESSAGE',

Line 2225: l_message_text := fnd_message.get;

2221: l_message_text fnd_new_messages.message_text%TYPE;
2222: BEGIN
2223: l_message_name := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'INITIATOR_MESSAGE_NAME');
2224: fnd_message.set_name('PSP', l_message_name);
2225: l_message_text := fnd_message.get;
2226: wf_engine.SetItemAttrText(itemtype => itemtype,
2227: itemkey => itemkey,
2228: aname => 'ERROR_MESSAGE',
2229: avalue => l_message_text);