1112: l_msg_data VARCHAR2(2000);
1113: l_loading_status VARCHAR2(200);
1114:
1115: -- Declaration for user hooks
1116: l_OAI_array JTF_USR_HKS.oai_data_array_type;
1117: l_bind_data_id NUMBER;
1118:
1119: -- get the number of valid transactions to load
1120: CURSOR valid_transactions (p_logical_batch_id NUMBER) IS
1226:
1227: -- User hooks
1228: -- Customer pre-processing section
1229:
1230: IF JTF_USR_HKS.Ok_to_Execute('CN_TRANSACTION_LOAD_PUB',
1231: 'LOAD',
1232: 'B',
1233: 'C')
1234: THEN
1255:
1256:
1257: -- Vertical industry pre-processing section
1258:
1259: IF JTF_USR_HKS.Ok_to_Execute('CN_TRANSACTION_LOAD_PUB',
1260: 'LOAD',
1261: 'B',
1262: 'V')
1263: THEN
1613: -- User hooks
1614:
1615: -- Customer post-processing section
1616:
1617: IF JTF_USR_HKS.Ok_to_Execute('CN_TRANSACTION_LOAD_PUB',
1618: 'LOAD',
1619: 'A',
1620: 'V')
1621: THEN
1642:
1643:
1644: -- Vertical industry post-processing section
1645:
1646: IF JTF_USR_HKS.Ok_to_Execute('CN_TRANSACTION_LOAD_PUB',
1647: 'LOAD',
1648: 'A',
1649: 'C')
1650: THEN
1671:
1672:
1673: -- Message enable hook
1674:
1675: IF JTF_USR_HKS.Ok_to_execute('CN_TRANSACTION_LOAD_PUB',
1676: 'LOAD',
1677: 'M',
1678: 'M')
1679: THEN
1686: -- call this for all bind variables in the business object
1687: -- XMLGEN.setBindValue('SRP_PMT_PLAN_ID', x_srp_pmt_plan_id);
1688:
1689: -- Get a ID for workflow/ business object instance
1690: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1691:
1692: -- Do this for all the bind variables in the Business Object
1693: JTF_USR_HKS.load_bind_data
1694: (l_bind_data_id, 'PROCESS_AUDIT_ID', x_process_audit_id, 'S', 'S');
1689: -- Get a ID for workflow/ business object instance
1690: l_bind_data_id := JTF_USR_HKS.get_bind_data_id;
1691:
1692: -- Do this for all the bind variables in the Business Object
1693: JTF_USR_HKS.load_bind_data
1694: (l_bind_data_id, 'PROCESS_AUDIT_ID', x_process_audit_id, 'S', 'S');
1695:
1696: -- Message generation API
1697: JTF_USR_HKS.generate_message
1693: JTF_USR_HKS.load_bind_data
1694: (l_bind_data_id, 'PROCESS_AUDIT_ID', x_process_audit_id, 'S', 'S');
1695:
1696: -- Message generation API
1697: JTF_USR_HKS.generate_message
1698: (p_prod_code => 'CN',
1699: p_bus_obj_code => 'TRXLOAD',
1700: p_bus_obj_name => 'TRX_LOAD',
1701: p_action_code => 'I',