103: l_org_id NUMBER;
104: l_status CN_PAYRUNS.STATUS%TYPE;
105:
106: l_payrun_name cn_payruns.name%TYPE;
107: l_OAI_array JTF_USR_HKS.oai_data_array_type;
108: l_bind_data_id NUMBER;
109: l_ovn Number ;
110:
111: l_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtSub_PUB';
160: --
161: -- User hooks
162: --
163:
164: IF JTF_USR_HKS.Ok_to_Execute('CN_PMTSUB_PUB',
165: 'PAY',
166: 'B',
167: 'C')
168: THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: END IF;
190: END IF;
191:
192: IF JTF_USR_HKS.Ok_to_Execute('CN_PMTSUB_PUB',
193: 'PAY',
194: 'B',
195: 'V')
196: THEN
275: -- Post processing hooks
276: --
277:
278:
279: IF JTF_USR_HKS.Ok_to_Execute('CN_PMTSUB_PUB',
280: 'PAY',
281: 'A',
282: 'V')
283: THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305: END IF;
306:
307: IF JTF_USR_HKS.Ok_to_Execute('CN_PMTSUB_PUB',
308: 'PAY',
309: 'A',
310: 'C')
311: THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: END IF;
334:
335: IF JTF_USR_HKS.Ok_to_execute('CN_PMTSUB_PUB',
336: 'PAY',
337: 'M',
338: 'M')
339: THEN
340: IF cn_pmtsub_pub_cuhk.ok_to_generate_msg
341: (p_payrun_name => l_payrun_name)
342: THEN
343: -- Get a ID for workflow/ business object instance
344: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
345:
346: -- Do this for all the bind variables in the Business Object
347: JTF_USR_HKS.load_bind_data
348: ( l_bind_data_id, 'PAYRUN_NAME', l_payrun_name, 'S', 'S');
343: -- Get a ID for workflow/ business object instance
344: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
345:
346: -- Do this for all the bind variables in the Business Object
347: JTF_USR_HKS.load_bind_data
348: ( l_bind_data_id, 'PAYRUN_NAME', l_payrun_name, 'S', 'S');
349:
350: -- Message generation API
351: JTF_USR_HKS.generate_message
347: JTF_USR_HKS.load_bind_data
348: ( l_bind_data_id, 'PAYRUN_NAME', l_payrun_name, 'S', 'S');
349:
350: -- Message generation API
351: JTF_USR_HKS.generate_message
352: (p_prod_code => 'CN',
353: p_bus_obj_code => 'PAYRUN',
354: p_bus_obj_name => 'PAYRUN',
355: p_action_code => 'I',