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 170: x_return_status := FND_API.G_RET_STS_SUCCESS;

166: IF (l_debug = 1) THEN
167: trace(' In Get_type_to_print,busFlow,lableTypeID,Manualformat,ManualPrinter= '
168: ||p_business_flow||','||p_label_type_id||','||p_format_id||','||p_printer_name, TRACE_PROMPT, TRACE_LEVEL);
169: END IF;
170: x_return_status := FND_API.G_RET_STS_SUCCESS;
171:
172: --Bug 4553439. Getting the value of org_id from fnd_profile
173: FND_PROFILE.GET('MFG_ORGANIZATION_ID', l_org_id );
174: IF(l_debug = 1 ) THEN

Line 508: x_return_status := FND_API.G_RET_STS_SUCCESS;

504: l_transaction_id NUMBER;
505: x_variable_content_long LONG;
506: BEGIN
507: -- Initialize API return status to success
508: x_return_status := FND_API.G_RET_STS_SUCCESS;
509:
510: IF p_label_type_info.label_type_id = 1 THEN
511: BEGIN
512: INV_LABEL_PVT1.get_variable_data(

Line 527: x_return_status := FND_API.G_RET_STS_ERROR;

523: trace('Got variable from type 1, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
524: END IF;
525: EXCEPTION
526: WHEN OTHERS THEN
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: IF (l_debug = 1) THEN
529: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
530: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
531: END IF;

Line 551: x_return_status := FND_API.G_RET_STS_ERROR;

547: trace('Got variable from type 2, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
548: END IF;
549: EXCEPTION
550: WHEN OTHERS THEN
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: IF (l_debug = 1) THEN
553: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
554: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
555: END IF;

Line 575: x_return_status := FND_API.G_RET_STS_ERROR;

571: trace('Got variable from type 3, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
572: END IF;
573: EXCEPTION
574: WHEN OTHERS THEN
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: IF (l_debug = 1) THEN
577: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
578: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
579: END IF;

Line 599: x_return_status := FND_API.G_RET_STS_ERROR;

595: trace('Got variable from type 4, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
596: END IF;
597: EXCEPTION
598: WHEN OTHERS THEN
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: IF (l_debug = 1) THEN
601: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
602: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
603: END IF;

Line 623: x_return_status := FND_API.G_RET_STS_ERROR;

619: trace('Got variable from type 5, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
620: END IF;
621: EXCEPTION
622: WHEN OTHERS THEN
623: x_return_status := FND_API.G_RET_STS_ERROR;
624: IF (l_debug = 1) THEN
625: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
626: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
627: END IF;

Line 647: x_return_status := FND_API.G_RET_STS_ERROR;

643: trace('Got variable from type 6, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
644: END IF;
645: EXCEPTION
646: WHEN OTHERS THEN
647: x_return_status := FND_API.G_RET_STS_ERROR;
648: IF (l_debug = 1) THEN
649: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
650: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
651: END IF;

Line 671: x_return_status := FND_API.G_RET_STS_ERROR;

667: trace('Got variable from type 7, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
668: END IF;
669: EXCEPTION
670: WHEN OTHERS THEN
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: IF (l_debug = 1) THEN
673: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
674: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
675: END IF;

Line 695: x_return_status := FND_API.G_RET_STS_ERROR;

691: trace('Got variable from type 8, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
692: END IF;
693: EXCEPTION
694: WHEN OTHERS THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: IF (l_debug = 1) THEN
697: trace('Error in calling PVT8 get_variable_data, ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
698: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
699: END IF;

Line 719: x_return_status := FND_API.G_RET_STS_ERROR;

715: trace('Got variable from type 9, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
716: END IF;
717: EXCEPTION
718: WHEN OTHERS THEN
719: x_return_status := FND_API.G_RET_STS_ERROR;
720: IF (l_debug = 1) THEN
721: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
722: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
723: END IF;

Line 743: x_return_status := FND_API.G_RET_STS_ERROR;

739: trace('Got variable from type 10, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
740: END IF;
741: EXCEPTION
742: WHEN OTHERS THEN
743: x_return_status := FND_API.G_RET_STS_ERROR;
744: IF (l_debug = 1) THEN
745: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
746: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
747: END IF;

Line 768: x_return_status := FND_API.G_RET_STS_ERROR;

764: trace('Got variable from type 11/12, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
765: END IF;
766: EXCEPTION
767: WHEN OTHERS THEN
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: IF (l_debug = 1) THEN
770: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
771: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
772: END IF;

Line 792: x_return_status := FND_API.G_RET_STS_ERROR;

788: trace('Got variable from type 13/14, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
789: END IF;
790: EXCEPTION
791: WHEN OTHERS THEN
792: x_return_status := FND_API.G_RET_STS_ERROR;
793: IF (l_debug = 1) THEN
794: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
795: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
796: END IF;

Line 816: x_return_status := FND_API.G_RET_STS_ERROR;

812: trace('Got variable from type 15, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
813: END IF;
814: EXCEPTION
815: WHEN OTHERS THEN
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: IF (l_debug = 1) THEN
818: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
819: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
820: END IF;

Line 842: x_return_status := FND_API.G_RET_STS_ERROR;

838: trace('Got variable from type 16, # of rec: '|| x_variable_content.count(), TRACE_PROMPT, TRACE_LEVEL);
839: END IF;
840: EXCEPTION
841: WHEN OTHERS THEN
842: x_return_status := FND_API.G_RET_STS_ERROR;
843: IF (l_debug = 1) THEN
844: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
845: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
846: END IF;

Line 1462: WHEN fnd_api.g_exc_error THEN

1458: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
1459: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
1460: END IF;
1461:
1462: WHEN fnd_api.g_exc_error THEN
1463: IF (l_debug = 1) THEN
1464: trace(' Expected Error In '|| G_PKG_NAME||'.WriteIntoFile', TRACE_PROMPT, TRACE_LEVEL);
1465: END IF;
1466: IF (utl_file.IS_OPEN(l_file)) THEN

Line 1474: WHEN fnd_api.g_exc_unexpected_error THEN

1470: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
1471: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
1472: END IF;
1473:
1474: WHEN fnd_api.g_exc_unexpected_error THEN
1475: IF (l_debug = 1) THEN
1476: trace(' Unexpected Error In '|| G_PKG_NAME||'.WriteIntoFile', TRACE_PROMPT, TRACE_LEVEL);
1477: END IF;
1478: IF (utl_file.IS_OPEN(l_file)) THEN

Line 1887: x_return_status := fnd_api.g_ret_sts_success;

1883: l_label_type NUMBER;
1884:
1885:
1886: BEGIN
1887: x_return_status := fnd_api.g_ret_sts_success;
1888: -- If wms is not installed, the rules engine will not
1889: -- be applied
1890: -- Get label Request ID
1891:

Line 2106: p_init_msg_list =>fnd_api.g_false,

2102: END IF;
2103: -- Then apply rules engine to obtain the label format
2104: WMS_RULE_PVT.ApplyLabel(
2105: p_api_version =>1.0,
2106: p_init_msg_list =>fnd_api.g_false,
2107: p_commit =>fnd_api.g_false,
2108: p_validation_level=>0,
2109: p_LABEL_REQUEST_id=>l_LABEL_REQUEST_id,
2110: x_return_status =>l_return_status,

Line 2107: p_commit =>fnd_api.g_false,

2103: -- Then apply rules engine to obtain the label format
2104: WMS_RULE_PVT.ApplyLabel(
2105: p_api_version =>1.0,
2106: p_init_msg_list =>fnd_api.g_false,
2107: p_commit =>fnd_api.g_false,
2108: p_validation_level=>0,
2109: p_LABEL_REQUEST_id=>l_LABEL_REQUEST_id,
2110: x_return_status =>l_return_status,
2111: x_msg_count =>l_msg_count,

Line 2159: x_return_status := FND_API.G_RET_STS_ERROR;

2155:
2156:
2157: EXCEPTION
2158: WHEN OTHERS THEN
2159: x_return_status := FND_API.G_RET_STS_ERROR;
2160: IF (l_debug = 1) THEN
2161: trace('error in calling rules engine',TRACE_PROMPT, TRACE_LEVEL);
2162: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
2163: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 2201: x_return_status := FND_API.G_RET_STS_SUCCESS;

2197: ||p_business_flow_code||','||p_transaction_id||','|| p_transaction_identifier , TRACE_PROMPT, TRACE_LEVEL);
2198: END IF;
2199:
2200: -- Initialize API return status to success
2201: x_return_status := FND_API.G_RET_STS_SUCCESS;
2202:
2203: l_transaction_id(1) := p_transaction_id;
2204: l_transaction_identifier := p_transaction_identifier;
2205:

Line 2231: x_return_status := FND_API.G_RET_STS_ERROR;

2227: , p_transaction_identifier => l_transaction_identifier
2228: );
2229: EXCEPTION
2230: WHEN OTHERS THEN
2231: x_return_status := FND_API.G_RET_STS_ERROR;
2232: IF (l_debug = 1) THEN
2233: trace('error in PRINT_LABEL_WRAP',TRACE_PROMPT, TRACE_LEVEL);
2234: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
2235: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 2341: x_return_status := FND_API.G_RET_STS_SUCCESS;

2337: trace('**From Serial Number pased in : ' || p_fm_serial_number,TRACE_PROMPT, TRACE_LEVEL);
2338: END IF;
2339:
2340: -- Initialize API return status to success
2341: x_return_status := FND_API.G_RET_STS_SUCCESS;
2342: IF (p_fm_serial_number IS NOT NULL) THEN
2343: IF (p_to_serial_number IS NOT NULL)
2344: AND (p_fm_serial_number <> p_to_serial_number) THEN
2345: Begin

Line 2520: x_return_status := FND_API.G_RET_STS_ERROR;

2516: ,p_format_id => p_format_id -- Added for the Add Printer and Format Project.
2517: ,p_printer_name => p_printer_name); -- Added for the Add Printer and Format Project.
2518: EXCEPTION
2519: WHEN OTHERS THEN
2520: x_return_status := FND_API.G_RET_STS_ERROR;
2521: IF (l_debug = 1) THEN
2522: trace('error in PRINT_LABEL_MANUAL_WRAP',TRACE_PROMPT, TRACE_LEVEL);
2523: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
2524: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

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

2541: , x_msg_count OUT NOCOPY NUMBER
2542: , x_msg_data OUT NOCOPY VARCHAR2
2543: , x_label_status OUT NOCOPY VARCHAR2
2544: , p_api_version IN NUMBER
2545: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2546: , p_commit IN VARCHAR2 := fnd_api.g_false
2547: , p_print_mode IN NUMBER
2548: , p_business_flow_code IN NUMBER
2549: , p_transaction_id IN transaction_id_rec_type

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

2542: , x_msg_data OUT NOCOPY VARCHAR2
2543: , x_label_status OUT NOCOPY VARCHAR2
2544: , p_api_version IN NUMBER
2545: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2546: , p_commit IN VARCHAR2 := fnd_api.g_false
2547: , p_print_mode IN NUMBER
2548: , p_business_flow_code IN NUMBER
2549: , p_transaction_id IN transaction_id_rec_type
2550: , p_input_param_rec IN input_parameter_rec_type

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

2598: , x_msg_data OUT NOCOPY VARCHAR2
2599: , x_label_status OUT NOCOPY VARCHAR2
2600: , x_label_request_id OUT NOCOPY NUMBER -- added by fabdi
2601: , p_api_version IN NUMBER
2602: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2603: , p_commit IN VARCHAR2 := fnd_api.g_false
2604: , p_print_mode IN NUMBER
2605: , p_business_flow_code IN NUMBER
2606: , p_transaction_id IN transaction_id_rec_type

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

2599: , x_label_status OUT NOCOPY VARCHAR2
2600: , x_label_request_id OUT NOCOPY NUMBER -- added by fabdi
2601: , p_api_version IN NUMBER
2602: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2603: , p_commit IN VARCHAR2 := fnd_api.g_false
2604: , p_print_mode IN NUMBER
2605: , p_business_flow_code IN NUMBER
2606: , p_transaction_id IN transaction_id_rec_type
2607: , p_input_param_rec IN input_parameter_rec_type

Line 2683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2679: OR (p_transaction_id.count = 0) THEN
2680: IF (l_debug = 1) THEN
2681: trace(' Not enough input, missing transaction_id or business_flow_code' , TRACE_PROMPT, TRACE_LEVEL);
2682: END IF;
2683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2684: END IF;
2685: ELSIF p_print_mode =2 THEN
2686: -- On demand, should provide input_param_rec and label_type
2687: IF (p_input_param_rec.count = 0 ) OR

Line 2692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2688: ((p_label_type_id IS NULL OR p_label_type_id=0) AND (p_business_flow_code IS NULL)) THEN
2689: IF (l_debug = 1) THEN
2690: trace(' Not enough input, missing input_param or label_type' , TRACE_PROMPT, TRACE_LEVEL);
2691: END IF;
2692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2693: END IF;
2694: ELSE
2695: IF (l_debug = 1) THEN
2696: trace(' Invalid value for p_print_mode, should be 1 or 2' , TRACE_PROMPT, TRACE_LEVEL);

Line 2698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2694: ELSE
2695: IF (l_debug = 1) THEN
2696: trace(' Invalid value for p_print_mode, should be 1 or 2' , TRACE_PROMPT, TRACE_LEVEL);
2697: END IF;
2698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2699: END IF;
2700:
2701: IF (l_debug = 1) THEN
2702: trace(' Passed input parameter validation, Start ' , TRACE_PROMPT, TRACE_LEVEL);

Line 2708: IF NOT FND_API.Compatible_API_Call

2704: -- Standard Start of API savepoint
2705: SAVEPOINT CREATE_XML_LABEL;
2706:
2707: -- Standard call to check for call compatibility.
2708: IF NOT FND_API.Compatible_API_Call
2709: ( l_api_version,
2710: p_api_version,
2711: l_api_name,
2712: G_PKG_NAME)

Line 2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2715: --FND_MSG_PUB.ADD;
2716: IF (l_debug = 1) THEN
2717: trace(' Incompatible API ' , TRACE_PROMPT, TRACE_LEVEL);
2718: END IF;
2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2720: END IF;
2721: -- Initialize message list if p_init_msg_list is set to TRUE.
2722: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2723: FND_MSG_PUB.initialize;

Line 2722: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2718: END IF;
2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2720: END IF;
2721: -- Initialize message list if p_init_msg_list is set to TRUE.
2722: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2723: FND_MSG_PUB.initialize;
2724: END IF;
2725:
2726: -- Initialize API return status to success

Line 2727: x_return_status := FND_API.G_RET_STS_SUCCESS;

2723: FND_MSG_PUB.initialize;
2724: END IF;
2725:
2726: -- Initialize API return status to success
2727: x_return_status := FND_API.G_RET_STS_SUCCESS;
2728:
2729: -- Get global variables
2730: IF (l_debug = 1) THEN
2731: trace(' Set and get global variables for date,time,user,encoding,profile values', TRACE_PROMPT, TRACE_LEVEL);

Line 2768: RAISE FND_API.G_EXC_ERROR;

2764: IF l_return_status <> 'S' THEN
2765: IF (l_debug = 1) THEN
2766: trace(' Get Type Failed ', TRACE_PROMPT, TRACE_LEVEL);
2767: END IF;
2768: RAISE FND_API.G_EXC_ERROR;
2769: END IF;
2770: --BUG#3055877
2771: /* inline branch the code so that we select the records from rti for *
2772: * patchset level below J, and from rt for Patchset J and above *

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

2933: END IF;
2934: -- Proceed sending request for printing only if the label status is not an ERROR
2935: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
2936: -- l_variable_data(k).label_status would indicate success.
2937: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
2938: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
2939: IF (l_debug = 1) THEN
2940: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 4 ', TRACE_PROMPT, TRACE_LEVEL);
2941: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_REQUEST() ', TRACE_PROMPT, TRACE_LEVEL);

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

2934: -- Proceed sending request for printing only if the label status is not an ERROR
2935: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
2936: -- l_variable_data(k).label_status would indicate success.
2937: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
2938: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
2939: IF (l_debug = 1) THEN
2940: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 4 ', TRACE_PROMPT, TRACE_LEVEL);
2941: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_REQUEST() ', TRACE_PROMPT, TRACE_LEVEL);
2942: END IF;

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

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

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

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

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

3051: END IF;
3052: -- Proceed TCP/IP printing only if the label status is not an ERROR
3053: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
3054: -- l_variable_data(k).label_status would indicate success.
3055: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3056: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3057: IF (l_debug = 1) THEN
3058: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 13 ', TRACE_PROMPT, TRACE_LEVEL);
3059: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_TCPIP() ', TRACE_PROMPT, TRACE_LEVEL);

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

3052: -- Proceed TCP/IP printing only if the label status is not an ERROR
3053: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
3054: -- l_variable_data(k).label_status would indicate success.
3055: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3056: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3057: IF (l_debug = 1) THEN
3058: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 13 ', TRACE_PROMPT, TRACE_LEVEL);
3059: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_TCPIP() ', TRACE_PROMPT, TRACE_LEVEL);
3060: END IF;

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

3275: -- Proceed sending request for printing only if the label status is not an ERROR
3276:
3277: -- Bug Fix 4552112, put a NVL around l_variable_data(k).label_statu since null value for
3278: -- l_variable_data(k).label_status would indicate success.
3279: --IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3280: IF ( nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3281: IF (l_debug = 1) THEN
3282: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 19 ', TRACE_PROMPT, TRACE_LEVEL);
3283: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_REQUEST() ', TRACE_PROMPT, TRACE_LEVEL);

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

3276:
3277: -- Bug Fix 4552112, put a NVL around l_variable_data(k).label_statu since null value for
3278: -- l_variable_data(k).label_status would indicate success.
3279: --IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3280: IF ( nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3281: IF (l_debug = 1) THEN
3282: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 19 ', TRACE_PROMPT, TRACE_LEVEL);
3283: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_REQUEST() ', TRACE_PROMPT, TRACE_LEVEL);
3284: END IF;

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

3324: END IF;
3325: -- Proceed writing the XML file only if the label status is not an ERROR
3326: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
3327: -- l_variable_data(k).label_status would indicate success.
3328: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3329: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3330: IF (l_debug = 1) THEN
3331: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 23 ', TRACE_PROMPT, TRACE_LEVEL);
3332: trace('Custom Labels Trace [INVLABPB.pls]: Before calling WRITE_XML() ', TRACE_PROMPT, TRACE_LEVEL);

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

3325: -- Proceed writing the XML file only if the label status is not an ERROR
3326: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
3327: -- l_variable_data(k).label_status would indicate success.
3328: -- IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3329: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3330: IF (l_debug = 1) THEN
3331: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 23 ', TRACE_PROMPT, TRACE_LEVEL);
3332: trace('Custom Labels Trace [INVLABPB.pls]: Before calling WRITE_XML() ', TRACE_PROMPT, TRACE_LEVEL);
3333: END IF;

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

3391: END IF;
3392: -- Proceed TCP/IP printing only if the label status is not an ERROR
3393: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
3394: -- l_variable_data(k).label_status would indicate success.
3395: --IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3396: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3397: IF (l_debug = 1) THEN
3398: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 28 ', TRACE_PROMPT, TRACE_LEVEL);
3399: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_TCPIP() ', TRACE_PROMPT, TRACE_LEVEL);

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

3392: -- Proceed TCP/IP printing only if the label status is not an ERROR
3393: -- Bug Fix 5330030, put a NVL around l_variable_data(k).label_statu since null value for
3394: -- l_variable_data(k).label_status would indicate success.
3395: --IF ( l_variable_data(k).label_status <> FND_API.G_RET_STS_ERROR ) THEN
3396: IF (nvl(l_variable_data(k).label_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS ) THEN
3397: IF (l_debug = 1) THEN
3398: trace('Custom Labels Trace [INVLABPB.pls]: At Breadcrumb 28 ', TRACE_PROMPT, TRACE_LEVEL);
3399: trace('Custom Labels Trace [INVLABPB.pls]: Before calling SYNC_PRINT_TCPIP() ', TRACE_PROMPT, TRACE_LEVEL);
3400: END IF;

Line 3479: WHEN fnd_api.g_exc_error THEN

3475: -- Added for R12 RFID Compliance project
3476: -- Reset the EPC_GROUP_ID
3477: EPC_GROUP_ID := null;
3478: EXCEPTION
3479: WHEN fnd_api.g_exc_error THEN
3480: IF (l_debug = 1) THEN
3481: trace(' Expected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);
3482: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3483: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 3486: WHEN fnd_api.g_exc_unexpected_error THEN

3482: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3483: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
3484: END IF;
3485:
3486: WHEN fnd_api.g_exc_unexpected_error THEN
3487: IF (l_debug = 1) THEN
3488: trace(' Unexpected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);
3489: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3490: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 3540: x_return_status := FND_API.G_RET_STS_SUCCESS;

3536: ||', printer_name='||p_printer_name
3537: ||', no_of_copy='||p_no_of_copy,TRACE_PROMPT, TRACE_LEVEL);
3538: END IF;
3539:
3540: x_return_status := FND_API.G_RET_STS_SUCCESS;
3541:
3542: get_profile_values;
3543: get_date_time_user;
3544:

Line 3552: RAISE fnd_api.g_exc_error;

3548: IF (l_debug = 1) THEN
3549: trace('Can not find history record with request_id='||p_hist_label_request_id,TRACE_PROMPT, TRACE_LEVEL);
3550: END IF;
3551: CLOSE c_hist;
3552: RAISE fnd_api.g_exc_error;
3553: ELSE
3554: CLOSE c_hist;
3555: END IF;
3556: IF (l_debug = 1) THEN

Line 3722: WHEN fnd_api.g_exc_error THEN

3718: END IF;
3719:
3720:
3721: EXCEPTION
3722: WHEN fnd_api.g_exc_error THEN
3723: IF (l_debug = 1) THEN
3724: trace(' Expected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);
3725: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3726: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 3728: x_return_status := fnd_api.g_ret_sts_error ;

3724: trace(' Expected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);
3725: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3726: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
3727: END IF;
3728: x_return_status := fnd_api.g_ret_sts_error ;
3729:
3730: WHEN fnd_api.g_exc_unexpected_error THEN
3731: IF (l_debug = 1) THEN
3732: trace(' Unexpected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);

Line 3730: WHEN fnd_api.g_exc_unexpected_error THEN

3726: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
3727: END IF;
3728: x_return_status := fnd_api.g_ret_sts_error ;
3729:
3730: WHEN fnd_api.g_exc_unexpected_error THEN
3731: IF (l_debug = 1) THEN
3732: trace(' Unexpected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);
3733: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3734: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);

Line 3736: x_return_status := fnd_api.g_ret_sts_error ;

3732: trace(' Unexpected Error In '|| G_PKG_NAME||'.' || l_api_name, TRACE_PROMPT, TRACE_LEVEL);
3733: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3734: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
3735: END IF;
3736: x_return_status := fnd_api.g_ret_sts_error ;
3737:
3738: WHEN others THEN
3739: IF (l_debug = 1) THEN
3740: trace(' Other Error In '|| G_PKG_NAME||'.' || l_api_name , TRACE_PROMPT, TRACE_LEVEL);

Line 3744: x_return_status := fnd_api.g_ret_sts_error ;

3740: trace(' Other Error In '|| G_PKG_NAME||'.' || l_api_name , TRACE_PROMPT, TRACE_LEVEL);
3741: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3742: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);
3743: END IF;
3744: x_return_status := fnd_api.g_ret_sts_error ;
3745:
3746: END RESUBMIT_LABEL_REQUEST;
3747:
3748: /*************************************

Line 3764: x_Status := FND_API.G_RET_STS_SUCCESS;

3760: x_Message OUT NOCOPY VARCHAR2
3761: ) IS
3762: BEGIN
3763: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3764: x_Status := FND_API.G_RET_STS_SUCCESS;
3765: IF (l_debug = 1) THEN
3766: trace('Querying label request hist with Printer='|| p_printer_Name||
3767: ',BusFlow=' || p_bus_flow_Code ||
3768: ',LabelTypeID=' || p_label_type_Id ||

Line 3812: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;

3808:
3809: x_Message := 'Selection Criteria Returned Records';
3810: EXCEPTION
3811: WHEN no_data_found THEN
3812: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3813: x_Message := 'Selection Criteria Returned No Records';
3814:
3815: WHEN others THEN
3816: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3816: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;

3812: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3813: x_Message := 'Selection Criteria Returned No Records';
3814:
3815: WHEN others THEN
3816: x_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3817: x_Message := 'Selection Criteria Returned No Records';
3818:
3819: END INV_LABEL_REQUESTS_REPRINT;
3820:

Line 3845: x_return_status := FND_API.G_RET_STS_SUCCESS;

3841: l_uom_code VARCHAR2(3);
3842: BEGIN
3843: trace('p_inventory_item_id : p_organization_id : p_unit_of_measure : p_revision'
3844: || p_inventory_item_id ||','||p_organization_id||','||p_unit_of_measure||','||p_revision, TRACE_PROMPT, TRACE_LEVEL);
3845: x_return_status := FND_API.G_RET_STS_SUCCESS;
3846: G_PROFILE_GTIN := FND_PROFILE.value('INV:GTIN_CROSS_REFERENCE_TYPE');
3847: trace('Profile INV:GTIN_CROSS_REFERENCE_TYPE : '||G_PROFILE_GTIN,TRACE_PROMPT, TRACE_LEVEL);
3848: IF(G_PROFILE_GTIN IS NOT NULL) THEN
3849:

Line 3917: x_return_status := FND_API.G_RET_STS_ERROR;

3913: NULL;
3914: WHEN OTHERS THEN
3915: -- When no data found or Mutiple Rows or others l_gtin_enabled := FASLE;
3916: x_gtin_enabled := FALSE;
3917: x_return_status := FND_API.G_RET_STS_ERROR;
3918: IF (l_debug = 1) THEN
3919: trace('error in IS_ITEM_GTIN_ENABLED',TRACE_PROMPT, TRACE_LEVEL);
3920: trace('ERROR CODE = ' || SQLCODE, TRACE_PROMPT, TRACE_LEVEL);
3921: trace('ERROR MESSAGE = ' || SQLERRM, TRACE_PROMPT, TRACE_LEVEL);