DBA Data[Home] [Help]

APPS.POA_DBI_COM_C dependencies on FND_MESSAGE

Line 30: v_commodity_code := fnd_message.get_string('POA','POA_DBI_DEFAULT_COMMODITY');

26: v_nextval NUMBER;
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);

Line 153: v_commodity_code := fnd_message.get_string('POA','POA_DBI_DEFAULT_COMMODITY');

149: l_start_time := sysdate;
150: l_login := fnd_global.login_id;
151: l_user := fnd_global.user_id;
152: --Get the value of new commodity code into the variable v_commodity_code
153: v_commodity_code := fnd_message.get_string('POA','POA_DBI_DEFAULT_COMMODITY');
154: --Extract 40 characters and Trim the spaces
155: v_commodity_code := trim(substr(v_commodity_code,1,40));
156: --Store the commodity id into the variable
157: SELECT commodity_id INTO v_commodity_id from po_commodities_b