eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL dependencies on FND_API

Line 53: x_return_status := FND_API.G_RET_STS_SUCCESS;

49: l_start_prefix VARCHAR2(30);
50: l_end_prefix VARCHAR2(30);
51: l_start_numeric NUMBER;
52: BEGIN
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54:
55: -- Determine the start number prefix
56: l_start_prefix := rtrim(fm_x_number, '0123456789');
57:

Line 169: x_return_status := FND_API.G_RET_STS_SUCCESS;

165: IF (l_debug = 1) THEN
166: trace(' In Get_type_to_print,busFlow,lableTypeID,Manualformat,ManualPrinter= '
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

Line 472: x_return_status := FND_API.G_RET_STS_SUCCESS;

468: l_transaction_id NUMBER;
469: x_variable_content_long LONG;
470: BEGIN
471: -- Initialize API return status to success
472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474: IF p_label_type_info.label_type_id = 1 THEN
475: BEGIN
476: INV_LABEL_PVT1.get_variable_data(

Line 491: x_return_status := FND_API.G_RET_STS_ERROR;

487: trace('Got variable from type 1, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
488: END IF;
489: EXCEPTION
490: WHEN OTHERS THEN
491: x_return_status := FND_API.G_RET_STS_ERROR;
492: IF (l_debug = 1) THEN
493: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
494: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
495: END IF;

Line 515: x_return_status := FND_API.G_RET_STS_ERROR;

511: trace('Got variable from type 2, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
512: END IF;
513: EXCEPTION
514: WHEN OTHERS THEN
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: IF (l_debug = 1) THEN
517: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
518: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
519: END IF;

Line 539: x_return_status := FND_API.G_RET_STS_ERROR;

535: trace('Got variable from type 3, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
536: END IF;
537: EXCEPTION
538: WHEN OTHERS THEN
539: x_return_status := FND_API.G_RET_STS_ERROR;
540: IF (l_debug = 1) THEN
541: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
542: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
543: END IF;

Line 563: x_return_status := FND_API.G_RET_STS_ERROR;

559: trace('Got variable from type 4, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
560: END IF;
561: EXCEPTION
562: WHEN OTHERS THEN
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: IF (l_debug = 1) THEN
565: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
566: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
567: END IF;

Line 587: x_return_status := FND_API.G_RET_STS_ERROR;

583: trace('Got variable from type 5, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
584: END IF;
585: EXCEPTION
586: WHEN OTHERS THEN
587: x_return_status := FND_API.G_RET_STS_ERROR;
588: IF (l_debug = 1) THEN
589: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
590: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
591: END IF;

Line 611: x_return_status := FND_API.G_RET_STS_ERROR;

607: trace('Got variable from type 6, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
608: END IF;
609: EXCEPTION
610: WHEN OTHERS THEN
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: IF (l_debug = 1) THEN
613: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
614: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
615: END IF;

Line 635: x_return_status := FND_API.G_RET_STS_ERROR;

631: trace('Got variable from type 7, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
632: END IF;
633: EXCEPTION
634: WHEN OTHERS THEN
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: IF (l_debug = 1) THEN
637: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
638: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
639: END IF;

Line 659: x_return_status := FND_API.G_RET_STS_ERROR;

655: trace('Got variable from type 8, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
656: END IF;
657: EXCEPTION
658: WHEN OTHERS THEN
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: IF (l_debug = 1) THEN
661: trace('Error in calling PVT8 get_variable_data, ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
662: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
663: END IF;

Line 683: x_return_status := FND_API.G_RET_STS_ERROR;

679: trace('Got variable from type 9, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
680: END IF;
681: EXCEPTION
682: WHEN OTHERS THEN
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: IF (l_debug = 1) THEN
685: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
686: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
687: END IF;

Line 707: x_return_status := FND_API.G_RET_STS_ERROR;

703: trace('Got variable from type 10, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
704: END IF;
705: EXCEPTION
706: WHEN OTHERS THEN
707: x_return_status := FND_API.G_RET_STS_ERROR;
708: IF (l_debug = 1) THEN
709: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
710: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
711: END IF;

Line 732: x_return_status := FND_API.G_RET_STS_ERROR;

728: trace('Got variable from type 11/12, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
729: END IF;
730: EXCEPTION
731: WHEN OTHERS THEN
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: IF (l_debug = 1) THEN
734: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
735: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
736: END IF;

Line 756: x_return_status := FND_API.G_RET_STS_ERROR;

752: trace('Got variable from type 13/14, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
753: END IF;
754: EXCEPTION
755: WHEN OTHERS THEN
756: x_return_status := FND_API.G_RET_STS_ERROR;
757: IF (l_debug = 1) THEN
758: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
759: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
760: END IF;

Line 780: x_return_status := FND_API.G_RET_STS_ERROR;

776: trace('Got variable from type 15, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
777: END IF;
778: EXCEPTION
779: WHEN OTHERS THEN
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: IF (l_debug = 1) THEN
782: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
783: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
784: END IF;

Line 806: x_return_status := FND_API.G_RET_STS_ERROR;

802: trace('Got variable from type 16, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
803: END IF;
804: EXCEPTION
805: WHEN OTHERS THEN
806: x_return_status := FND_API.G_RET_STS_ERROR;
807: IF (l_debug = 1) THEN
808: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
809: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
810: END IF;

Line 1401: WHEN fnd_api.g_exc_error THEN

1397: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
1398: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
1399: END IF;
1400:
1401: WHEN fnd_api.g_exc_error THEN
1402: IF (l_debug = 1) THEN
1403: trace(' Expected Error In '|| G_PKG_NAME||'.WriteIntoFile', TRACE_PROMPT, TRACE_LEVEL);
1404: END IF;
1405: IF (utl_file.IS_OPEN(l_file)) THEN

Line 1413: WHEN fnd_api.g_exc_unexpected_error THEN

1409: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
1410: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
1411: END IF;
1412:
1413: WHEN fnd_api.g_exc_unexpected_error THEN
1414: IF (l_debug = 1) THEN
1415: trace(' Unexpected Error In '|| G_PKG_NAME||'.WriteIntoFile', TRACE_PROMPT, TRACE_LEVEL);
1416: END IF;
1417: IF (utl_file.IS_OPEN(l_file)) THEN

Line 1826: x_return_status := fnd_api.g_ret_sts_success;

1822: l_label_type NUMBER;
1823:
1824:
1825: BEGIN
1826: x_return_status := fnd_api.g_ret_sts_success;
1827: -- If wms is not installed, the rules engine will not
1828: -- be applied
1829: -- Get label Request ID
1830:

Line 2045: p_init_msg_list =>fnd_api.g_false,

2041: END IF;
2042: -- Then apply rules engine to obtain the label format
2043: WMS_RULE_PVT.ApplyLabel(
2044: p_api_version =>1.0,
2045: p_init_msg_list =>fnd_api.g_false,
2046: p_commit =>fnd_api.g_false,
2047: p_validation_level=>0,
2048: p_LABEL_REQUEST_id=>l_LABEL_REQUEST_id,
2049: x_return_status =>l_return_status,

Line 2046: p_commit =>fnd_api.g_false,

2042: -- Then apply rules engine to obtain the label format
2043: WMS_RULE_PVT.ApplyLabel(
2044: p_api_version =>1.0,
2045: p_init_msg_list =>fnd_api.g_false,
2046: p_commit =>fnd_api.g_false,
2047: p_validation_level=>0,
2048: p_LABEL_REQUEST_id=>l_LABEL_REQUEST_id,
2049: x_return_status =>l_return_status,
2050: x_msg_count =>l_msg_count,

Line 2098: x_return_status := FND_API.G_RET_STS_ERROR;

2094:
2095:
2096: EXCEPTION
2097: WHEN OTHERS THEN
2098: x_return_status := FND_API.G_RET_STS_ERROR;
2099: IF (l_debug = 1) THEN
2100: trace('error in calling rules engine',TRACE_PROMPT, TRACE_LEVEL);
2101: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
2102: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 2140: x_return_status := FND_API.G_RET_STS_SUCCESS;

2136: ||p_business_flow_code||','||p_transaction_id||','|| p_transaction_identifier , TRACE_PROMPT, TRACE_LEVEL);
2137: END IF;
2138:
2139: -- Initialize API return status to success
2140: x_return_status := FND_API.G_RET_STS_SUCCESS;
2141:
2142: l_transaction_id(1) := p_transaction_id;
2143: l_transaction_identifier := p_transaction_identifier;
2144:

Line 2170: x_return_status := FND_API.G_RET_STS_ERROR;

2166: , p_transaction_identifier => l_transaction_identifier
2167: );
2168: EXCEPTION
2169: WHEN OTHERS THEN
2170: x_return_status := FND_API.G_RET_STS_ERROR;
2171: IF (l_debug = 1) THEN
2172: trace('error in PRINT_LABEL_WRAP',TRACE_PROMPT, TRACE_LEVEL);
2173: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
2174: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 2279: x_return_status := FND_API.G_RET_STS_SUCCESS;

2275: trace('**From Serial Number pased in : ' || p_fm_serial_number,TRACE_PROMPT, TRACE_LEVEL);
2276: END IF;
2277:
2278: -- Initialize API return status to success
2279: x_return_status := FND_API.G_RET_STS_SUCCESS;
2280: IF (p_fm_serial_number IS NOT NULL) THEN
2281: IF (p_to_serial_number IS NOT NULL)
2282: AND (p_fm_serial_number <> p_to_serial_number) THEN
2283: Begin

Line 2451: x_return_status := FND_API.G_RET_STS_ERROR;

2447: ,p_format_id => p_format_id -- Added for the Add Printer and Format Project.
2448: ,p_printer_name => p_printer_name); -- Added for the Add Printer and Format Project.
2449: EXCEPTION
2450: WHEN OTHERS THEN
2451: x_return_status := FND_API.G_RET_STS_ERROR;
2452: IF (l_debug = 1) THEN
2453: trace('error in PRINT_LABEL_MANUAL_WRAP',TRACE_PROMPT, TRACE_LEVEL);
2454: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
2455: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 2476: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2472: , x_msg_count OUT NOCOPY NUMBER
2473: , x_msg_data OUT NOCOPY VARCHAR2
2474: , x_label_status OUT NOCOPY VARCHAR2
2475: , p_api_version IN NUMBER
2476: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2477: , p_commit IN VARCHAR2 := fnd_api.g_false
2478: , p_print_mode IN NUMBER
2479: , p_business_flow_code IN NUMBER
2480: , p_transaction_id IN transaction_id_rec_type

Line 2477: , p_commit IN VARCHAR2 := fnd_api.g_false

2473: , x_msg_data OUT NOCOPY VARCHAR2
2474: , x_label_status OUT NOCOPY VARCHAR2
2475: , p_api_version IN NUMBER
2476: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2477: , p_commit IN VARCHAR2 := fnd_api.g_false
2478: , p_print_mode IN NUMBER
2479: , p_business_flow_code IN NUMBER
2480: , p_transaction_id IN transaction_id_rec_type
2481: , p_input_param_rec IN input_parameter_rec_type

Line 2533: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2529: , x_msg_data OUT NOCOPY VARCHAR2
2530: , x_label_status OUT NOCOPY VARCHAR2
2531: , x_label_request_id OUT NOCOPY NUMBER -- added by fabdi
2532: , p_api_version IN NUMBER
2533: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2534: , p_commit IN VARCHAR2 := fnd_api.g_false
2535: , p_print_mode IN NUMBER
2536: , p_business_flow_code IN NUMBER
2537: , p_transaction_id IN transaction_id_rec_type

Line 2534: , p_commit IN VARCHAR2 := fnd_api.g_false

2530: , x_label_status OUT NOCOPY VARCHAR2
2531: , x_label_request_id OUT NOCOPY NUMBER -- added by fabdi
2532: , p_api_version IN NUMBER
2533: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2534: , p_commit IN VARCHAR2 := fnd_api.g_false
2535: , p_print_mode IN NUMBER
2536: , p_business_flow_code IN NUMBER
2537: , p_transaction_id IN transaction_id_rec_type
2538: , p_input_param_rec IN input_parameter_rec_type

Line 2614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2610: OR (p_transaction_id.count = 0) THEN
2611: IF (l_debug = 1) THEN
2612: trace(' Not enough input, missing transaction_id or business_flow_code' , TRACE_PROMPT, TRACE_LEVEL);
2613: END IF;
2614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2615: END IF;
2616: ELSIF p_print_mode =2 THEN
2617: -- On demand, should provide input_param_rec and label_type
2618: IF (p_input_param_rec.count = 0 ) OR

Line 2623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2619: ((p_label_type_id IS NULL OR p_label_type_id=0) AND (p_business_flow_code IS NULL)) THEN
2620: IF (l_debug = 1) THEN
2621: trace(' Not enough input, missing input_param or label_type' , TRACE_PROMPT, TRACE_LEVEL);
2622: END IF;
2623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2624: END IF;
2625: ELSE
2626: IF (l_debug = 1) THEN
2627: trace(' Invalid value for p_print_mode, should be 1 or 2' , TRACE_PROMPT, TRACE_LEVEL);

Line 2629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2625: ELSE
2626: IF (l_debug = 1) THEN
2627: trace(' Invalid value for p_print_mode, should be 1 or 2' , TRACE_PROMPT, TRACE_LEVEL);
2628: END IF;
2629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2630: END IF;
2631:
2632: IF (l_debug = 1) THEN
2633: trace(' Passed input parameter validation, Start ' , TRACE_PROMPT, TRACE_LEVEL);

Line 2639: IF NOT FND_API.Compatible_API_Call

2635: -- Standard Start of API savepoint
2636: SAVEPOINT CREATE_XML_LABEL;
2637:
2638: -- Standard call to check for call compatibility.
2639: IF NOT FND_API.Compatible_API_Call
2640: ( l_api_version,
2641: p_api_version,
2642: l_api_name,
2643: G_PKG_NAME)

Line 2650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2646: --FND_MSG_PUB.ADD;
2647: IF (l_debug = 1) THEN
2648: trace(' Incompatible API ' , TRACE_PROMPT, TRACE_LEVEL);
2649: END IF;
2650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2651: END IF;
2652: -- Initialize message list if p_init_msg_list is set to TRUE.
2653: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2654: FND_MSG_PUB.initialize;

Line 2653: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2649: END IF;
2650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2651: END IF;
2652: -- Initialize message list if p_init_msg_list is set to TRUE.
2653: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2654: FND_MSG_PUB.initialize;
2655: END IF;
2656:
2657: -- Initialize API return status to success

Line 2658: x_return_status := FND_API.G_RET_STS_SUCCESS;

2654: FND_MSG_PUB.initialize;
2655: END IF;
2656:
2657: -- Initialize API return status to success
2658: x_return_status := FND_API.G_RET_STS_SUCCESS;
2659:
2660: -- Get global variables
2661: IF (l_debug = 1) THEN
2662: trace(' Set and get global variables for date,time,user,encoding,profile values', TRACE_PROMPT, TRACE_LEVEL);

Line 2698: RAISE FND_API.G_EXC_ERROR;

2694: IF l_return_status <> 'S' THEN
2695: IF (l_debug = 1) THEN
2696: trace(' Get Type Failed ', TRACE_PROMPT, TRACE_LEVEL);
2697: END IF;
2698: RAISE FND_API.G_EXC_ERROR;
2699: END IF;
2700: --BUG#3055877
2701: /* inline branch the code so that we select the records from rti for *
2702: * patchset level below J, and from rt for Patchset J and above *

Line 2867: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN

2863: END IF;
2864: -- Proceed sending request for printing only if the label status is not an ERROR
2865: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
2866: -- l_variable_data(k).label_status would indicate success.
2867: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
2868: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
2869: IF (l_debug = 1) THEN
2870: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 4 ', TRACE_PROMPT, TRACE_LEVEL);
2871: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_REQUEST() ', TRACE_PROMPT, TRACE_LEVEL);

Line 2868: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN

2864: -- Proceed sending request for printing only if the label status is not an ERROR
2865: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
2866: -- l_variable_data(k).label_status would indicate success.
2867: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
2868: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
2869: IF (l_debug = 1) THEN
2870: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 4 ', TRACE_PROMPT, TRACE_LEVEL);
2871: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_REQUEST() ', TRACE_PROMPT, TRACE_LEVEL);
2872: END IF;

Line 2917: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN

2913: END IF;
2914: -- Proceed writing the XML file only if the label status is not an ERROR
2915: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
2916: -- l_variable_data(k).label_status would indicate success.
2917: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
2918: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
2919: IF (l_debug = 1) THEN
2920: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 8 ', TRACE_PROMPT, TRACE_LEVEL);
2921: trace('Custom Labels Trace [INVLABPB.pls]: Before calling WRITE_XML() ', TRACE_PROMPT, TRACE_LEVEL);

Line 2918: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN

2914: -- Proceed writing the XML file only if the label status is not an ERROR
2915: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
2916: -- l_variable_data(k).label_status would indicate success.
2917: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
2918: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
2919: IF (l_debug = 1) THEN
2920: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 8 ', TRACE_PROMPT, TRACE_LEVEL);
2921: trace('Custom Labels Trace [INVLABPB.pls]: Before calling WRITE_XML() ', TRACE_PROMPT, TRACE_LEVEL);
2922: END IF;

Line 2985: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN

2981: END IF;
2982: -- Proceed TCP/IP printing only if the label status is not an ERROR
2983: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
2984: -- l_variable_data(k).label_status would indicate success.
2985: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
2986: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
2987: IF (l_debug = 1) THEN
2988: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 13 ', TRACE_PROMPT, TRACE_LEVEL);
2989: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_TCPIP() ', TRACE_PROMPT, TRACE_LEVEL);

Line 2986: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN

2982: -- Proceed TCP/IP printing only if the label status is not an ERROR
2983: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
2984: -- l_variable_data(k).label_status would indicate success.
2985: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
2986: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
2987: IF (l_debug = 1) THEN
2988: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 13 ', TRACE_PROMPT, TRACE_LEVEL);
2989: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_TCPIP() ', TRACE_PROMPT, TRACE_LEVEL);
2990: END IF;

Line 3207: --IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN

3203: -- Proceed sending request for printing only if the label status is not an ERROR
3204:
3205: -- Bug Fix 4552112, put a NVL around l_variable_data(k).label_statu since null value for
3206: -- l_variable_data(k).label_status would indicate success.
3207: --IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3208: IF ( nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3209: IF (l_debug = 1) THEN
3210: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 19 ', TRACE_PROMPT, TRACE_LEVEL);
3211: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_REQUEST() ', TRACE_PROMPT, TRACE_LEVEL);

Line 3208: IF ( nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN

3204:
3205: -- Bug Fix 4552112, put a NVL around l_variable_data(k).label_statu since null value for
3206: -- l_variable_data(k).label_status would indicate success.
3207: --IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3208: IF ( nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3209: IF (l_debug = 1) THEN
3210: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 19 ', TRACE_PROMPT, TRACE_LEVEL);
3211: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_REQUEST() ', TRACE_PROMPT, TRACE_LEVEL);
3212: END IF;

Line 3256: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN

3252: END IF;
3253: -- Proceed writing the XML file only if the label status is not an ERROR
3254: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
3255: -- l_variable_data(k).label_status would indicate success.
3256: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3257: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3258: IF (l_debug = 1) THEN
3259: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 23 ', TRACE_PROMPT, TRACE_LEVEL);
3260: trace('Custom Labels Trace [INVLABPB.pls]: Before calling WRITE_XML() ', TRACE_PROMPT, TRACE_LEVEL);

Line 3257: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN

3253: -- Proceed writing the XML file only if the label status is not an ERROR
3254: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
3255: -- l_variable_data(k).label_status would indicate success.
3256: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3257: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3258: IF (l_debug = 1) THEN
3259: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 23 ', TRACE_PROMPT, TRACE_LEVEL);
3260: trace('Custom Labels Trace [INVLABPB.pls]: Before calling WRITE_XML() ', TRACE_PROMPT, TRACE_LEVEL);
3261: END IF;

Line 3323: --IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN

3319: END IF;
3320: -- Proceed TCP/IP printing only if the label status is not an ERROR
3321: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
3322: -- l_variable_data(k).label_status would indicate success.
3323: --IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3324: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3325: IF (l_debug = 1) THEN
3326: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 28 ', TRACE_PROMPT, TRACE_LEVEL);
3327: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_TCPIP() ', TRACE_PROMPT, TRACE_LEVEL);

Line 3324: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN

3320: -- Proceed TCP/IP printing only if the label status is not an ERROR
3321: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
3322: -- l_variable_data(k).label_status would indicate success.
3323: --IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3324: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3325: IF (l_debug = 1) THEN
3326: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 28 ', TRACE_PROMPT, TRACE_LEVEL);
3327: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_TCPIP() ', TRACE_PROMPT, TRACE_LEVEL);
3328: END IF;

Line 3407: WHEN fnd_api.g_exc_error THEN

3403: -- Added for R12 RFID Compliance project
3404: -- Reset the EPC_GROUP_ID
3405: EPC_GROUP_ID := null;
3406: EXCEPTION
3407: WHEN fnd_api.g_exc_error THEN
3408: IF (l_debug = 1) THEN
3409: trace(' Expected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);
3410: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3411: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 3414: WHEN fnd_api.g_exc_unexpected_error THEN

3410: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3411: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
3412: END IF;
3413:
3414: WHEN fnd_api.g_exc_unexpected_error THEN
3415: IF (l_debug = 1) THEN
3416: trace(' Unexpected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);
3417: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3418: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 3468: x_return_status := FND_API.G_RET_STS_SUCCESS;

3464: ||', printer_name='||p_printer_name
3465: ||', no_of_copy='||p_no_of_copy,TRACE_PROMPT, TRACE_LEVEL);
3466: END IF;
3467:
3468: x_return_status := FND_API.G_RET_STS_SUCCESS;
3469:
3470: get_profile_values;
3471: get_date_time_user;
3472:

Line 3480: RAISE fnd_api.g_exc_error;

3476: IF (l_debug = 1) THEN
3477: trace('Can not find history record with request_id='||p_hist_label_request_id,TRACE_PROMPT, TRACE_LEVEL);
3478: END IF;
3479: CLOSE c_hist;
3480: RAISE fnd_api.g_exc_error;
3481: ELSE
3482: CLOSE c_hist;
3483: END IF;
3484: IF (l_debug = 1) THEN

Line 3649: WHEN fnd_api.g_exc_error THEN

3645: END IF;
3646:
3647:
3648: EXCEPTION
3649: WHEN fnd_api.g_exc_error THEN
3650: IF (l_debug = 1) THEN
3651: trace(' Expected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);
3652: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3653: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 3655: x_return_status := fnd_api.g_ret_sts_error ;

3651: trace(' Expected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);
3652: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3653: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
3654: END IF;
3655: x_return_status := fnd_api.g_ret_sts_error ;
3656:
3657: WHEN fnd_api.g_exc_unexpected_error THEN
3658: IF (l_debug = 1) THEN
3659: trace(' Unexpected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);

Line 3657: WHEN fnd_api.g_exc_unexpected_error THEN

3653: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
3654: END IF;
3655: x_return_status := fnd_api.g_ret_sts_error ;
3656:
3657: WHEN fnd_api.g_exc_unexpected_error THEN
3658: IF (l_debug = 1) THEN
3659: trace(' Unexpected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);
3660: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3661: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 3663: x_return_status := fnd_api.g_ret_sts_error ;

3659: trace(' Unexpected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);
3660: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3661: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
3662: END IF;
3663: x_return_status := fnd_api.g_ret_sts_error ;
3664:
3665: WHEN others THEN
3666: IF (l_debug = 1) THEN
3667: trace(' Other Error In '|| G_PKG_NAME||'.' || l_api_name , TRACE_PROMPT, TRACE_LEVEL);

Line 3671: x_return_status := fnd_api.g_ret_sts_error ;

3667: trace(' Other Error In '|| G_PKG_NAME||'.' || l_api_name , TRACE_PROMPT, TRACE_LEVEL);
3668: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3669: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
3670: END IF;
3671: x_return_status := fnd_api.g_ret_sts_error ;
3672:
3673: END RESUBMIT_LABEL_REQUEST;
3674:
3675: /*************************************

Line 3691: x_Status := FND_API.G_RET_STS_SUCCESS;

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 ||
3695: ',LabelTypeID=' || p_label_type_Id ||

Line 3739: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;

3735:
3736: x_Message := 'Selection Criteria Returned Records';
3737: EXCEPTION
3738: WHEN no_data_found THEN
3739: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3740: x_Message := 'Selection Criteria Returned No Records';
3741:
3742: WHEN others THEN
3743: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3743: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;

3739: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3740: x_Message := 'Selection Criteria Returned No Records';
3741:
3742: WHEN others THEN
3743: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3744: x_Message := 'Selection Criteria Returned No Records';
3745:
3746: END INV_LABEL_REQUESTS_REPRINT;
3747:

Line 3772: x_return_status := FND_API.G_RET_STS_SUCCESS;

3768: l_uom_code VARCHAR2(3);
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:

Line 3818: x_return_status := FND_API.G_RET_STS_ERROR;

3814: NULL;
3815: WHEN OTHERS THEN
3816: -- When no data found or Mutiple Rows or others l_gtin_enabled := FASLE;
3817: x_gtin_enabled := FALSE;
3818: x_return_status := FND_API.G_RET_STS_ERROR;
3819: IF (l_debug = 1) THEN
3820: trace('error in IS_ITEM_GTIN_ENABLED',TRACE_PROMPT, TRACE_LEVEL);
3821: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3822: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);