APPS.CSI_UTILITY_GRP dependencies on CSI_UTILITY_GRP

Line 1: PACKAGE BODY CSI_UTILITY_GRP AS

1: PACKAGE BODY CSI_UTILITY_GRP AS
2: /* $Header: csigutlb.pls 120.13 2007/02/13 22:22:09 jpwilson ship $ */
3:
4: PROCEDURE debug_con_log(p_message IN varchar2) IS
5: BEGIN

Line 9: -- g_pkg_name VARCHAR2(30) := 'CSI_UTILITY_GRP';

5: BEGIN
6: FND_FILE.PUT_LINE (FND_FILE.LOG, p_message );
7: END debug_con_log;
8:
9: -- g_pkg_name VARCHAR2(30) := 'CSI_UTILITY_GRP';
10:
11:
12: PROCEDURE debug(p_message IN varchar2) IS
13:

Line 266: IF csi_utility_grp.vld_exist_sfm_events(p_inventory_item_id) THEN

262:
263: IF csi_item_instance_vld_pvt.is_trackable(p_inv_item_id => p_inventory_item_id,
264: p_org_id => l_master_org_id) THEN
265: -- Check for READY or ERROR SFM Messages
266: IF csi_utility_grp.vld_exist_sfm_events(p_inventory_item_id) THEN
267: raise sfm_event_error;
268: END IF;
269:
270: -- Chcck for ERROR or PENDING CSI Errors

Line 271: IF csi_utility_grp.vld_exist_txn_errors(p_inventory_item_id) THEN

267: raise sfm_event_error;
268: END IF;
269:
270: -- Chcck for ERROR or PENDING CSI Errors
271: IF csi_utility_grp.vld_exist_txn_errors(p_inventory_item_id) THEN
272: raise csi_exist_txn_error;
273: END IF;
274:
275: -- Check MTL Transaction Interface Table

Line 276: IF csi_utility_grp.vld_exist_mtl_iface_recs(p_inventory_item_id,

272: raise csi_exist_txn_error;
273: END IF;
274:
275: -- Check MTL Transaction Interface Table
276: IF csi_utility_grp.vld_exist_mtl_iface_recs(p_inventory_item_id,
277: p_organization_id) THEN
278: raise mtl_iface_error;
279: END IF;
280:

Line 282: IF csi_utility_grp.vld_exist_mtl_temp_recs(p_inventory_item_id,

278: raise mtl_iface_error;
279: END IF;
280:
281: -- Check MTL Transaction Temp Table
282: IF csi_utility_grp.vld_exist_mtl_temp_recs(p_inventory_item_id,
283: p_organization_id) THEN
284: raise mtl_temp_error;
285: END IF;
286:

Line 288: IF csi_utility_grp.vld_active_ib_inst(p_inventory_item_id) THEN

284: raise mtl_temp_error;
285: END IF;
286:
287: -- Check for Active IB Instances
288: IF csi_utility_grp.vld_active_ib_inst(p_inventory_item_id) THEN
289: raise active_ib_inst_error;
290: END IF;
291: END IF;
292:

Line 613: IF csi_utility_grp.check_inv_inst_cz_keys(p_inventory_item_id,

609:
610: BEGIN
611: -- Check to see if an instance exists and has the Config Keys on it.
612:
613: IF csi_utility_grp.check_inv_inst_cz_keys(p_inventory_item_id,
614: p_organization_id,
615: p_serial_number) THEN
616: raise inv_inst_cz_keys;
617: END IF;

Line 621: IF csi_utility_grp.check_inv_error_cz_keys(p_inventory_item_id,

617: END IF;
618:
619: -- Check to see if an instance exists that has an error and has the Config Keys on it.
620:
621: IF csi_utility_grp.check_inv_error_cz_keys(p_inventory_item_id,
622: p_organization_id,
623: p_serial_number) THEN
624: raise inv_inst_cz_keys;
625: END IF;

Line 630: IF csi_utility_grp.check_inv_sfm_cz_keys(p_inventory_item_id,

626:
627: -- Check to see if an instance exists in a Pending or Failed in the
628: -- Status in the SFM Queue and if it has Config Keys on it.
629:
630: IF csi_utility_grp.check_inv_sfm_cz_keys(p_inventory_item_id,
631: p_organization_id,
632: p_serial_number) THEN
633: raise inv_inst_cz_keys;
634: END IF;

Line 683: l_config_keys csi_utility_grp.config_session_key;

679: p_organization_id IN NUMBER,
680: p_serial_number IN VARCHAR2) RETURN BOOLEAN IS
681:
682:
683: l_config_keys csi_utility_grp.config_session_key;
684: l_return_status VARCHAR2(1);
685:
686: BEGIN
687:

Line 734: l_config_keys csi_utility_grp.config_session_key;

730: p_serial_number IN VARCHAR2) RETURN BOOLEAN IS
731:
732:
733: l_freeze_date DATE;
734: l_config_keys csi_utility_grp.config_session_key;
735: l_return_status VARCHAR2(1);
736:
737: CURSOR msg_cur(pc_freeze_date IN DATE) is
738: SELECT msg_id,

Line 843: l_txn_inst_tbl csi_utility_grp.TXN_INST_TBL;

839:
840: l_api_name CONSTANT VARCHAR2(30) := 'GET_IMPACTED_ITEM_INSTANCES';
841: l_party_found NUMBER;
842: j NUMBER := 1;
843: l_txn_inst_tbl csi_utility_grp.TXN_INST_TBL;
844: l_txn_oks_rec csi_utility_grp.txn_oks_rec;
845: l_return_status VARCHAR2(1);
846: l_error_message VARCHAR2(2000);
847: l_sql_error VARCHAR2(2000);

Line 844: l_txn_oks_rec csi_utility_grp.txn_oks_rec;

840: l_api_name CONSTANT VARCHAR2(30) := 'GET_IMPACTED_ITEM_INSTANCES';
841: l_party_found NUMBER;
842: j NUMBER := 1;
843: l_txn_inst_tbl csi_utility_grp.TXN_INST_TBL;
844: l_txn_oks_rec csi_utility_grp.txn_oks_rec;
845: l_return_status VARCHAR2(1);
846: l_error_message VARCHAR2(2000);
847: l_sql_error VARCHAR2(2000);
848: l_msg_data VARCHAR2(2000);

Line 877: csi_utility_grp.get_instances (p_txn_oks_rec,

873:
874: -- Now build the txn_inst_tbl to be passed out with the impacted instances
875: debug(' Single Instance Usability .. Calling get_instances');
876:
877: csi_utility_grp.get_instances (p_txn_oks_rec,
878: l_txn_inst_tbl,
879: l_return_status,
880: l_msg_count,
881: l_msg_data);

Line 924: csi_utility_grp.get_instances (l_txn_oks_rec,

920: -- Now build the txn_inst_tbl to be passed out with the impacted instances
921:
922: debug(' Mass Update Batch ('||l_txn_oks_rec.batch_id||') .. Calling get_instances');
923:
924: csi_utility_grp.get_instances (l_txn_oks_rec,
925: l_txn_inst_tbl,
926: l_return_status,
927: l_msg_count,
928: l_msg_data);

Line 1443: p_om_txn_info IN csi_utility_grp.om_txn_info_tbl,

1439:
1440: END inv_txn_data_purge;
1441:
1442: PROCEDURE om_txn_data_purge(
1443: p_om_txn_info IN csi_utility_grp.om_txn_info_tbl,
1444: x_return_status OUT NOCOPY varchar2,
1445: x_return_message OUT NOCOPY varchar2) IS
1446:
1447: l_freeze_date DATE;

Line 1811: END CSI_UTILITY_GRP;

1807: debug_con_log('Error: '||fnd_message.get);
1808:
1809: END; -- End of purge_txn_detail_tables
1810:
1811: END CSI_UTILITY_GRP;