2388: --
2389: -- this case means, no wic arch and no prt also
2390: g_wng_tbl(g_wng_tbl_cnt).assignment_id := p_assignment_id;
2391: g_wng_tbl(g_wng_tbl_cnt).employee_number := p_employee_number;
2392: g_wng_tbl(g_wng_tbl_cnt).message_text := fnd_message.get_string('PAY','PAY_JP_ITWB_NO_WIC_ARC');
2393: --
2394: g_wng_tbl_cnt := g_wng_tbl_cnt + 1;
2395: g_wng_assignment_action_id := p_assignment_action_id;
2396: --
2402: or g_wng_assignment_action_id <> p_assignment_action_id then
2403: --
2404: g_wng_tbl(g_wng_tbl_cnt).assignment_id := p_assignment_id;
2405: g_wng_tbl(g_wng_tbl_cnt).employee_number := p_employee_number;
2406: g_wng_tbl(g_wng_tbl_cnt).message_text := fnd_message.get_string('PAY','PAY_JP_ITWB_NO_WIC_PRT');
2407: --
2408: g_wng_tbl_cnt := g_wng_tbl_cnt + 1;
2409: g_wng_assignment_action_id := p_assignment_action_id;
2410: --
2759: if l_pjob_cnt > 15 then
2760: --
2761: g_wng_tbl(g_wng_tbl_cnt).assignment_id := p_assignment_id;
2762: g_wng_tbl(g_wng_tbl_cnt).employee_number := p_employee_number;
2763: g_wng_tbl(g_wng_tbl_cnt).message_text := fnd_message.get_string('PAY','PAY_JP_ITWB_PJOB_OVER');
2764: --
2765: g_wng_tbl_cnt := g_wng_tbl_cnt + 1;
2766: --
2767: end if;
5500: open csr_action;
5501: fetch csr_action into l_csr_action;
5502: if csr_action%notfound then
5503: close csr_action;
5504: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
5505: fnd_message.raise_error;
5506: end if;
5507: close csr_action;
5508: --
5501: fetch csr_action into l_csr_action;
5502: if csr_action%notfound then
5503: close csr_action;
5504: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
5505: fnd_message.raise_error;
5506: end if;
5507: close csr_action;
5508: --
5509: g_payroll_action_id := p_payroll_action_id;
5898: -- irregular case
5899: else
5900: --
5901: -- g_payroll_action_id_o must NOT be null, srs validate
5902: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
5903: fnd_message.raise_error;
5904: --
5905: end if;
5906: --
5899: else
5900: --
5901: -- g_payroll_action_id_o must NOT be null, srs validate
5902: fnd_message.set_name('PAY','PAY_34985_INVALID_PAY_ACTION');
5903: fnd_message.raise_error;
5904: --
5905: end if;
5906: --
5907: end if;
5951: open csr_org;
5952: fetch csr_org into l_csr_org;
5953: --
5954: if csr_org%notfound then
5955: fnd_message.set_name('PAY','PAY_JP_INVALID_SWOT');
5956: fnd_message.raise_error;
5957: end if;
5958: --
5959: close csr_org;
5952: fetch csr_org into l_csr_org;
5953: --
5954: if csr_org%notfound then
5955: fnd_message.set_name('PAY','PAY_JP_INVALID_SWOT');
5956: fnd_message.raise_error;
5957: end if;
5958: --
5959: close csr_org;
5960: --
8655: end if;
8656: --
8657: g_wng_tbl(g_wng_tbl_cnt).assignment_id := l_assignment_id;
8658: g_wng_tbl(g_wng_tbl_cnt).employee_number := l_data_tbl(l_data_tbl_cnt).emp_employee_number;
8659: g_wng_tbl(g_wng_tbl_cnt).message_text := fnd_message.get_string('PAY','PAY_JP_ITWB_BON_OVER');
8660: --
8661: g_wng_tbl_cnt := g_wng_tbl_cnt + 1;
8662: --
8663: end if;
9400: end if;
9401: --
9402: g_wng_tbl(g_wng_tbl_cnt).assignment_id := l_assignment_id;
9403: g_wng_tbl(g_wng_tbl_cnt).employee_number := l_data_tbl(l_data_tbl_cnt).emp_employee_number;
9404: g_wng_tbl(g_wng_tbl_cnt).message_text := fnd_message.get_string('PAY','PAY_JP_ITWB_BON_OVER');
9405: --
9406: g_wng_tbl_cnt := g_wng_tbl_cnt + 1;
9407: --
9408: if g_debug
9832: end if;
9833: --
9834: g_wng_tbl(g_wng_tbl_cnt).assignment_id := l_assignment_id;
9835: g_wng_tbl(g_wng_tbl_cnt).employee_number := l_data_tbl(l_data_tbl_cnt).emp_employee_number;
9836: g_wng_tbl(g_wng_tbl_cnt).message_text := fnd_message.get_string('PAY','PAY_JP_ITWB_BON_OVER');
9837: --
9838: g_wng_tbl_cnt := g_wng_tbl_cnt + 1;
9839: --
9840: end if;
10702: end if;
10703: --
10704: g_wng_tbl(g_wng_tbl_cnt).assignment_id := l_assignment_id;
10705: g_wng_tbl(g_wng_tbl_cnt).employee_number := l_data_tbl(l_data_tbl_cnt).emp_employee_number;
10706: g_wng_tbl(g_wng_tbl_cnt).message_text := fnd_message.get_string('PAY','PAY_JP_ITWB_BON_OVER');
10707: --
10708: g_wng_tbl_cnt := g_wng_tbl_cnt + 1;
10709: --
10710: if g_debug
11066: end if;
11067: --
11068: g_wng_tbl(g_wng_tbl_cnt).assignment_id := l_assignment_id;
11069: g_wng_tbl(g_wng_tbl_cnt).employee_number := l_data_tbl(l_data_tbl_cnt).emp_employee_number;
11070: g_wng_tbl(g_wng_tbl_cnt).message_text := fnd_message.get_string('PAY','PAY_JP_ITWB_BON_OVER');
11071: --
11072: g_wng_tbl_cnt := g_wng_tbl_cnt + 1;
11073: --
11074: if g_debug
11953: end if;
11954: --
11955: g_wng_tbl(g_wng_tbl_cnt).assignment_id := l_assignment_id;
11956: g_wng_tbl(g_wng_tbl_cnt).employee_number := l_data_tbl(l_data_tbl_cnt).emp_employee_number;
11957: g_wng_tbl(g_wng_tbl_cnt).message_text := fnd_message.get_string('PAY','PAY_JP_ITWB_BON_OVER');
11958: --
11959: g_wng_tbl_cnt := g_wng_tbl_cnt + 1;
11960: --
11961: end if;