APPS.POA_DBI_COM_C dependencies on BIS_COLLECTION_UTILITIES

Line 31: bis_collection_utilities.log('Retrieved commodity code as "' || v_commodity_code||'"',0);

27:
28: BEGIN
29: -- Get the value of new commodity code into the variable v_commodity_code
30: v_commodity_code := fnd_message.get_string('POA','POA_DBI_DEFAULT_COMMODITY');
31: bis_collection_utilities.log('Retrieved commodity code as "' || v_commodity_code||'"',0);
32: ----Extract 40 characters and Trim the spaces
33: v_commodity_code := trim(substr(v_commodity_code,1,40));
34: bis_collection_utilities.log('Truncated commodity code is "'|| v_commodity_code||'"',0);
35: -- Check if the commodity exists or not

Line 34: bis_collection_utilities.log('Truncated commodity code is "'|| v_commodity_code||'"',0);

30: v_commodity_code := fnd_message.get_string('POA','POA_DBI_DEFAULT_COMMODITY');
31: bis_collection_utilities.log('Retrieved commodity code as "' || v_commodity_code||'"',0);
32: ----Extract 40 characters and Trim the spaces
33: v_commodity_code := trim(substr(v_commodity_code,1,40));
34: bis_collection_utilities.log('Truncated commodity code is "'|| v_commodity_code||'"',0);
35: -- Check if the commodity exists or not
36: SELECT COUNT(*) INTO v_check_flag FROM
37: po_commodities_b WHERE commodity_code=v_commodity_code;
38: IF (v_check_flag=0) THEN

Line 100: bis_collection_utilities.log('Commodity Created',0);

96: lang.installed_flag IN ('I','B')
97: );
98:
99: COMMIT;
100: bis_collection_utilities.log('Commodity Created',0);
101:
102: END IF;
103: -- Calling procedure to assign all unassigned categories of the
104: -- Purchasing category set to the default commodity

Line 187: bis_collection_utilities.log(SQL%ROWCOUNT||' Categories associated with '

183: WHERE pcc.category_id=mcat.category_id)
184: );
185:
186:
187: bis_collection_utilities.log(SQL%ROWCOUNT||' Categories associated with '
188: ||v_commodity_code,0);
189: COMMIT;
190:
191: EXCEPTION