APPS.INV_LABEL_PVT4 dependencies on FND_PROFILE

Line 3112: FND_PROFILE.GET('MFG_ORGANIZATION_ID', l_org_id );

3108:
3109: -- IF clause Added for Add format/printer for manual request
3110: IF p_label_type_info.manual_printer IS NULL THEN
3111: --Bug 6630004 Start
3112: FND_PROFILE.GET('MFG_ORGANIZATION_ID', l_org_id );
3113: trace('l_org_id from FND PROFILE value MFG_ORGANIZATION_ID '||l_org_id);
3114: --Bug 6630004 End
3115: -- The p_label_type_info.manual_printer is the one passed from the manual page.
3116: -- As per the design, if a printer is passed from the manual page, then we use that printer irrespective.

Line 3113: trace('l_org_id from FND PROFILE value MFG_ORGANIZATION_ID '||l_org_id);

3109: -- IF clause Added for Add format/printer for manual request
3110: IF p_label_type_info.manual_printer IS NULL THEN
3111: --Bug 6630004 Start
3112: FND_PROFILE.GET('MFG_ORGANIZATION_ID', l_org_id );
3113: trace('l_org_id from FND PROFILE value MFG_ORGANIZATION_ID '||l_org_id);
3114: --Bug 6630004 End
3115: -- The p_label_type_info.manual_printer is the one passed from the manual page.
3116: -- As per the design, if a printer is passed from the manual page, then we use that printer irrespective.
3117: IF (nvl(l_printer_sub,v_lpn_content.subinventory_code) IS NOT NULL) AND

Line 3150: trace('l_org_id IS NULL FROM FND PROFILES');

3146: END;
3147: l_prev_sub := nvl(l_printer_sub,v_lpn_content.subinventory_code);
3148: ELSIF(l_org_id IS NULL AND NVL(l_printer_sub, v_lpn_content.subinventory_code) IS NULL) THEN --Bug 6630004 Start
3149: IF (l_debug = 1) THEN
3150: trace('l_org_id IS NULL FROM FND PROFILES');
3151: trace('l_printer_sub and v_lpn_content.subinventory_code are NULL');
3152: trace('v_lpn_content.organization_id '|| v_lpn_content.organization_id);
3153: END IF;
3154: BEGIN