[Home] [Help]
60:
61: l_all_sum_trans_flag boolean := TRUE;
62:
63: BEGIN
64: FND_MSG_PUB.Initialize;
65:
66: /* Check whether timeperiod id given is valid */
67:
68: open get_payroll_id_csr;
68: open get_payroll_id_csr;
69: fetch get_payroll_id_csr into l_start_date,l_end_date, l_payroll_id;
70: if get_payroll_id_csr%NOTFOUND then
71: fnd_message.set_name('PSP','PSP_INVALID_PERIOD');
72: fnd_msg_pub.add;
73: close get_payroll_id_csr;
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: end if;
76:
86: /*************************************************************************************************
87: Message Details would be either Summarize and transfer has already been run , or
88: create dist lines. Need to first rollback CDL, before attempting here
89: **************************************************************************************************/
90: fnd_msg_pub.add;
91: close get_payroll_control_id_csr;
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: end if;
94:
109: If so, need to rollback create distribution lines first
110: ***********************************************************************************************/
111: THEN
112: fnd_message.set_name('PSP','PSP_PAY_RBK_DST');
113: fnd_msg_pub.add;
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115:
116: ELSE
117:
148: *********************************************************************************************** */
149: -- Bug 3950282:raise error only if all rows in Control table are already summerised and transfered.
150: IF l_all_sum_trans_flag = TRUE THEN
151: fnd_message.set_name('PSP','PSP_PAY_RBK_STA');
152: fnd_msg_pub.add;
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155:
156: commit;
160:
161: EXCEPTION
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR then
163:
164: /* fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
165: p_encoded => FND_API.G_FALSE,
166: p_data => l_msg_data,
167: p_msg_index_out => l_msg_count); */
168: