902:
903: -- Read the Profile option value.
904:
905: G_msg_level_threshold :=
906: TO_NUMBER ( FND_PROFILE.VALUE('FND_AS_MSG_LEVEL_THRESHOLD') );
907:
908: IF G_msg_level_threshold IS NULL THEN
909:
910: G_msg_level_threshold := G_MSG_LVL_SUCCESS;
1225: IF l_debug_level > 0 THEN
1226: oe_debug_pub.add( 'L_MSG_DATA='||L_MSG_DATA,3 ) ;
1227: END IF;
1228:
1229: if nvl(fnd_profile.value('CONC_REQUEST_ID'),0) > 0 then
1230:
1231: -- Added below code for bug 12922209
1232: if l_order_source_id = 27 then -- (Retrobilled Orders)
1233: if l_entity_code = 'LINE' then
2301: IF l_debug_level > 0 THEN
2302: oe_debug_pub.add( 'ENTER Save_API_Messages' , 1 ) ;
2303: END IF;
2304:
2305: IF nvl(fnd_profile.value('CONC_REQUEST_ID'),0) > 0
2306: THEN
2307: l_request_id := fnd_profile.value('CONC_REQUEST_ID');
2308: l_message_source_code := 'C';
2309: END IF;
2303: END IF;
2304:
2305: IF nvl(fnd_profile.value('CONC_REQUEST_ID'),0) > 0
2306: THEN
2307: l_request_id := fnd_profile.value('CONC_REQUEST_ID');
2308: l_message_source_code := 'C';
2309: END IF;
2310:
2311: l_errmsg := ltrim(Substr(SQLERRM,1,1000));