DBA Data[Home] [Help]

APPS.INV_LABEL dependencies on FND_PROFILE

Line 171: --Bug 4553439. Getting the value of org_id from fnd_profile

167: ||p_business_flow||','||p_label_type_id||','||p_format_id||','||p_printer_name, TRACE_PROMPT, TRACE_LEVEL);
168: END IF;
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170:
171: --Bug 4553439. Getting the value of org_id from fnd_profile
172: FND_PROFILE.GET('MFG_ORGANIZATION_ID', l_org_id );
173: IF(l_debug = 1 ) THEN
174: trace('Value of org id from the profile' || l_org_id, TRACE_PROMPT,TRACE_LEVEL);
175: END IF;

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

168: END IF;
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170:
171: --Bug 4553439. Getting the value of org_id from fnd_profile
172: FND_PROFILE.GET('MFG_ORGANIZATION_ID', l_org_id );
173: IF(l_debug = 1 ) THEN
174: trace('Value of org id from the profile' || l_org_id, TRACE_PROMPT,TRACE_LEVEL);
175: END IF;
176: --End of fix for Bug 4553439

Line 1005: FND_PROFILE.GET('WMS_PRINT_MODE', l_print_mode);

1001: l_file_prefix VARCHAR2(100);
1002: l_output_dir VARCHAR2(200);
1003: l_date_mask VARCHAR2(100);
1004: BEGIN
1005: FND_PROFILE.GET('WMS_PRINT_MODE', l_print_mode);
1006: IF (l_debug = 1) THEN
1007: trace('l_print_mode => ' || l_print_mode, TRACE_PROMPT, TRACE_LEVEL);
1008: END IF;
1009:

Line 1010: FND_PROFILE.GET('WMS_LABEL_FILE_PREFIX', l_file_prefix);

1006: IF (l_debug = 1) THEN
1007: trace('l_print_mode => ' || l_print_mode, TRACE_PROMPT, TRACE_LEVEL);
1008: END IF;
1009:
1010: FND_PROFILE.GET('WMS_LABEL_FILE_PREFIX', l_file_prefix);
1011: IF (l_debug = 1) THEN
1012: trace('l_file_prefix => ' || l_file_prefix, TRACE_PROMPT, TRACE_LEVEL);
1013: END IF;
1014:

Line 1015: FND_PROFILE.GET('WMS_LABEL_OUTPUT_DIRECTORY', l_output_dir);

1011: IF (l_debug = 1) THEN
1012: trace('l_file_prefix => ' || l_file_prefix, TRACE_PROMPT, TRACE_LEVEL);
1013: END IF;
1014:
1015: FND_PROFILE.GET('WMS_LABEL_OUTPUT_DIRECTORY', l_output_dir);
1016: IF (l_debug = 1) THEN
1017: trace('l_output_dir => ' || l_output_dir, TRACE_PROMPT, TRACE_LEVEL);
1018: END IF;
1019:

Line 1020: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_mask);

1016: IF (l_debug = 1) THEN
1017: trace('l_output_dir => ' || l_output_dir, TRACE_PROMPT, TRACE_LEVEL);
1018: END IF;
1019:
1020: FND_PROFILE.GET('ICX_DATE_FORMAT_MASK',l_date_mask);
1021: IF (l_debug = 1) THEN
1022: trace('l_date_mask => ' || l_date_mask, TRACE_PROMPT, TRACE_LEVEL);
1023: END IF;
1024:

Line 1330: -- The fnd_profile.get, gets the value for the

1326: l_cur_index NUMBER;
1327:
1328: BEGIN
1329: -- Bug 2449358 : LABELING: LABEL_XML.LOG SHOULD ONLY BE CREATED IF DEBUG IS ON
1330: -- The fnd_profile.get, gets the value for the
1331: -- input('INV_DEBUG_TRACE') based on the current fnd_global.user_id.
1332: -- According to the new design, the LABEL_XML.log will only be generated if the profile option
1333: -- INV: Debug Trace is set to 'Yes'. Hence the IF clause around the existing code.
1334:

Line 1336: fnd_profile.get('INV_DEBUG_TRACE',l_debug_trace);

1332: -- According to the new design, the LABEL_XML.log will only be generated if the profile option
1333: -- INV: Debug Trace is set to 'Yes'. Hence the IF clause around the existing code.
1334:
1335: -- Get INV_DEBUG_TRACE profile for the current user.
1336: fnd_profile.get('INV_DEBUG_TRACE',l_debug_trace);
1337:
1338: --l_debug_trace := fnd_profile.value_specific('INV_DEBUG_TRACE',fnd_global.user_id);
1339: IF (l_debug = 1) THEN
1340: trace('INV_DEBUG_TRACE = ' || l_debug_trace, TRACE_PROMPT, TRACE_LEVEL);

Line 1338: --l_debug_trace := fnd_profile.value_specific('INV_DEBUG_TRACE',fnd_global.user_id);

1334:
1335: -- Get INV_DEBUG_TRACE profile for the current user.
1336: fnd_profile.get('INV_DEBUG_TRACE',l_debug_trace);
1337:
1338: --l_debug_trace := fnd_profile.value_specific('INV_DEBUG_TRACE',fnd_global.user_id);
1339: IF (l_debug = 1) THEN
1340: trace('INV_DEBUG_TRACE = ' || l_debug_trace, TRACE_PROMPT, TRACE_LEVEL);
1341: END IF;
1342:

Line 1347: fnd_profile.get('INV_DEBUG_FILE',l_dir);

1343: IF (l_debug_trace = 1) THEN
1344: -- l_debug_trace = 1 means 'Yes' and 2 means 'No'
1345:
1346: --Get directory from INV_DEBUG_FILE profile
1347: fnd_profile.get('INV_DEBUG_FILE',l_dir);
1348: --l_dir := fnd_profile.value_specific('INV_DEBUG_FILE',fnd_global.user_id);
1349: IF (l_debug = 1) THEN
1350: trace('INV_DEBUG_FILE = ' || l_dir, TRACE_PROMPT, TRACE_LEVEL);
1351: END IF;

Line 1348: --l_dir := fnd_profile.value_specific('INV_DEBUG_FILE',fnd_global.user_id);

1344: -- l_debug_trace = 1 means 'Yes' and 2 means 'No'
1345:
1346: --Get directory from INV_DEBUG_FILE profile
1347: fnd_profile.get('INV_DEBUG_FILE',l_dir);
1348: --l_dir := fnd_profile.value_specific('INV_DEBUG_FILE',fnd_global.user_id);
1349: IF (l_debug = 1) THEN
1350: trace('INV_DEBUG_FILE = ' || l_dir, TRACE_PROMPT, TRACE_LEVEL);
1351: END IF;
1352:

Line 2132: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2128: l_transaction_id INV_LABEL.transaction_id_rec_type;
2129: l_transaction_identifier NUMBER ;
2130:
2131: BEGIN
2132: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2133:
2134: IF (l_debug = 1) THEN
2135: trace('Begin: print_label_wrap() ' || 'p_bus_flow, txn_id, p_transaction_identifier: '
2136: ||p_business_flow_code||','||p_transaction_id||','|| p_transaction_identifier , TRACE_PROMPT, TRACE_LEVEL);

Line 2230: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2226:
2227: BEGIN
2228:
2229:
2230: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2231: IF (l_debug = 1) THEN
2232: trace('Begin : print_label_manual_wrap() input parameters are ' , TRACE_PROMPT, TRACE_LEVEL);
2233: trace(' BusFlow,labelType: '||p_business_flow_code||','||p_label_type,TRACE_PROMPT, TRACE_LEVEL);
2234: trace(' Org,Item,Rev,Lot,fmSer,toSer: '||p_organization_id||','||p_inventory_item_id||','||p_revision||','

Line 2577: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2573: cntr BINARY_INTEGER;
2574:
2575: BEGIN
2576:
2577: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2578: IF (l_debug = 1) THEN
2579: trace(' **** In Print_label ****', TRACE_PROMPT, TRACE_LEVEL);
2580: trace(' p_print_mode, p_label_type_id, p_business_flow_code: '
2581: || p_print_mode ||','||p_label_type_id||','||p_business_flow_code, TRACE_PROMPT, TRACE_LEVEL);

Line 3459: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3455: l_msg_data VARCHAR2(4000);
3456: l_sysdate DATE;
3457:
3458: BEGIN
3459: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3460:
3461: IF (l_debug = 1) THEN
3462: trace('In resubmit label request',TRACE_PROMPT, TRACE_LEVEL);
3463: trace('resubmit, hist_request_id='||p_hist_label_request_id

Line 3690: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3686: x_Status OUT NOCOPY VARCHAR2,
3687: x_Message OUT NOCOPY VARCHAR2
3688: ) IS
3689: BEGIN
3690: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3691: x_Status := FND_API.G_RET_STS_SUCCESS;
3692: IF (l_debug = 1) THEN
3693: trace('Querying label request hist with Printer='|| p_printer_Name||
3694: ',BusFlow=' || p_bus_flow_Code ||

Line 3773: G_PROFILE_GTIN := FND_PROFILE.value('INV:GTIN_CROSS_REFERENCE_TYPE');

3769: BEGIN
3770: trace('p_inventory_item_id : p_organization_id : p_unit_of_measure : p_revision'
3771: || p_inventory_item_id ||','||p_organization_id||','||p_unit_of_measure||','||p_revision, TRACE_PROMPT, TRACE_LEVEL);
3772: x_return_status := FND_API.G_RET_STS_SUCCESS;
3773: G_PROFILE_GTIN := FND_PROFILE.value('INV:GTIN_CROSS_REFERENCE_TYPE');
3774: trace('Profile INV:GTIN_CROSS_REFERENCE_TYPE : '||G_PROFILE_GTIN,TRACE_PROMPT, TRACE_LEVEL);
3775: IF(G_PROFILE_GTIN IS NOT NULL) THEN
3776:
3777: SELECT MCR.CROSS_REFERENCE, MCR.DESCRIPTION, MCR.REVISION_ID, MCR.UOM_CODE