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.OZF_WEBADI_INTERFACE_PVT dependencies on FND_MESSAGE

Line 319: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_ERROR');

315: l_message := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
316: raise_application_error( -20000, l_message);
317: END IF;
318: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
319: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_ERROR');
320: l_message := fnd_message.get();
321: raise_application_error( -20000, l_message);
322: END IF;
323: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 320: l_message := fnd_message.get();

316: raise_application_error( -20000, l_message);
317: END IF;
318: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
319: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_ERROR');
320: l_message := fnd_message.get();
321: raise_application_error( -20000, l_message);
322: END IF;
323: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN
324: FOR i IN 1 .. l_code_conversion_id_tbl.count

Line 330: fnd_message.set_name ('OZF', 'OZF_REQ_PARAM_MISSING');

326: OZF_UTILITY_PVT.debug_message('Code Conversion ID ' || l_code_conversion_id_tbl(i) );
327: END LOOP;
328: END IF;
329: ELSE
330: fnd_message.set_name ('OZF', 'OZF_REQ_PARAM_MISSING');
331: l_message := fnd_message.get();
332: raise_application_error( -20000, l_message);
333: END IF;
334:

Line 331: l_message := fnd_message.get();

327: END LOOP;
328: END IF;
329: ELSE
330: fnd_message.set_name ('OZF', 'OZF_REQ_PARAM_MISSING');
331: l_message := fnd_message.get();
332: raise_application_error( -20000, l_message);
333: END IF;
334:
335: ELSE

Line 360: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_ERROR');

356: l_message := substr(l_message,1,30);
357: END IF;
358: raise_application_error( -20000, l_message);
359: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
360: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_ERROR');
361: l_message := fnd_message.get();
362: raise_application_error( -20000, l_message);
363: END IF;
364:

Line 361: l_message := fnd_message.get();

357: END IF;
358: raise_application_error( -20000, l_message);
359: ELSIF x_return_Status = FND_API.G_RET_STS_UNEXP_ERROR THEN
360: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_ERROR');
361: l_message := fnd_message.get();
362: raise_application_error( -20000, l_message);
363: END IF;
364:
365: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low) THEN

Line 387: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));

383: raise_application_error( -20000, l_message);
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: IF length( SQLERRM) > 30 THEN
386: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
387: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
388: ELSE
389: fnd_message.set_name ('OZF', SQLERRM);
390: END IF;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 389: fnd_message.set_name ('OZF', SQLERRM);

385: IF length( SQLERRM) > 30 THEN
386: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
387: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
388: ELSE
389: fnd_message.set_name ('OZF', SQLERRM);
390: END IF;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: WHEN OTHERS THEN
393: IF length( SQLERRM) > 30 THEN

Line 395: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));

391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: WHEN OTHERS THEN
393: IF length( SQLERRM) > 30 THEN
394: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
395: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
396: ELSE
397: fnd_message.set_name ('OZF', SQLERRM);
398: END IF;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 397: fnd_message.set_name ('OZF', SQLERRM);

393: IF length( SQLERRM) > 30 THEN
394: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
395: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
396: ELSE
397: fnd_message.set_name ('OZF', SQLERRM);
398: END IF;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: END CODE_CONVERSION_WEBADI;
401:

Line 719: fnd_message.set_name ('OZF', 'OZF_ENTER_OPEARTING_UNIT');

715: x_return_status := FND_API.G_RET_STS_SUCCESS;
716:
717: -- R12 MOAC Enhancement (+)
718: IF P_ORG_ID IS NULL THEN
719: fnd_message.set_name ('OZF', 'OZF_ENTER_OPEARTING_UNIT');
720: l_error_message := fnd_message.get();
721: raise_application_error( -20000, l_error_message);
722: END IF;
723:

Line 720: l_error_message := fnd_message.get();

716:
717: -- R12 MOAC Enhancement (+)
718: IF P_ORG_ID IS NULL THEN
719: fnd_message.set_name ('OZF', 'OZF_ENTER_OPEARTING_UNIT');
720: l_error_message := fnd_message.get();
721: raise_application_error( -20000, l_error_message);
722: END IF;
723:
724: OPEN csr_get_org_id(P_ORG_ID);

Line 731: fnd_message.set_name ('OZF', 'OZF_ENTER_OPERATING_UNIT');

727:
728: --l_org_id := MO_GLOBAL.get_valid_org(p_org_id);
729:
730: IF l_org_id IS NULL THEN
731: fnd_message.set_name ('OZF', 'OZF_ENTER_OPERATING_UNIT');
732: l_error_message := fnd_message.get();
733: raise_application_error( -20000, l_error_message);
734: --x_return_status := FND_API.G_RET_STS_ERROR;
735: --RAISE FND_API.G_EXC_ERROR;

Line 732: l_error_message := fnd_message.get();

728: --l_org_id := MO_GLOBAL.get_valid_org(p_org_id);
729:
730: IF l_org_id IS NULL THEN
731: fnd_message.set_name ('OZF', 'OZF_ENTER_OPERATING_UNIT');
732: l_error_message := fnd_message.get();
733: raise_application_error( -20000, l_error_message);
734: --x_return_status := FND_API.G_RET_STS_ERROR;
735: --RAISE FND_API.G_EXC_ERROR;
736: END IF;

Line 745: fnd_message.set_name ('OZF', 'OZF_ENTER_REPORT_START_DATE');

741:
742: -- Batch Level Required Value Validation
743:
744: IF p_report_start_date IS NULL THEN
745: fnd_message.set_name ('OZF', 'OZF_ENTER_REPORT_START_DATE');
746: l_error_message := fnd_message.get();
747: raise_application_error( -20000, l_error_message);
748: END IF;
749:

Line 746: l_error_message := fnd_message.get();

742: -- Batch Level Required Value Validation
743:
744: IF p_report_start_date IS NULL THEN
745: fnd_message.set_name ('OZF', 'OZF_ENTER_REPORT_START_DATE');
746: l_error_message := fnd_message.get();
747: raise_application_error( -20000, l_error_message);
748: END IF;
749:
750: IF p_report_end_date IS NULL THEN

Line 751: fnd_message.set_name ('OZF', 'OZF_ENTER_REPORT_END_DATE');

747: raise_application_error( -20000, l_error_message);
748: END IF;
749:
750: IF p_report_end_date IS NULL THEN
751: fnd_message.set_name ('OZF', 'OZF_ENTER_REPORT_END_DATE');
752: l_error_message := fnd_message.get();
753: raise_application_error( -20000, l_error_message);
754: END IF;
755:

Line 752: l_error_message := fnd_message.get();

748: END IF;
749:
750: IF p_report_end_date IS NULL THEN
751: fnd_message.set_name ('OZF', 'OZF_ENTER_REPORT_END_DATE');
752: l_error_message := fnd_message.get();
753: raise_application_error( -20000, l_error_message);
754: END IF;
755:
756: IF p_report_start_date > p_report_end_date THEN

Line 757: fnd_message.set_name ('OZF', 'OZF_END_DATE_LESS_START_DATE');

753: raise_application_error( -20000, l_error_message);
754: END IF;
755:
756: IF p_report_start_date > p_report_end_date THEN
757: fnd_message.set_name ('OZF', 'OZF_END_DATE_LESS_START_DATE');
758: l_error_message := fnd_message.get();
759: raise_application_error( -20000, l_error_message);
760: END IF;
761:

Line 758: l_error_message := fnd_message.get();

754: END IF;
755:
756: IF p_report_start_date > p_report_end_date THEN
757: fnd_message.set_name ('OZF', 'OZF_END_DATE_LESS_START_DATE');
758: l_error_message := fnd_message.get();
759: raise_application_error( -20000, l_error_message);
760: END IF;
761:
762: IF p_partner_party_id IS NULL THEN

Line 763: fnd_message.set_name ('OZF', 'OZF_ENTER_PARTNER_ID');

759: raise_application_error( -20000, l_error_message);
760: END IF;
761:
762: IF p_partner_party_id IS NULL THEN
763: fnd_message.set_name ('OZF', 'OZF_ENTER_PARTNER_ID');
764: l_error_message := fnd_message.get();
765: raise_application_error( -20000, l_error_message);
766: END IF;
767:

Line 764: l_error_message := fnd_message.get();

760: END IF;
761:
762: IF p_partner_party_id IS NULL THEN
763: fnd_message.set_name ('OZF', 'OZF_ENTER_PARTNER_ID');
764: l_error_message := fnd_message.get();
765: raise_application_error( -20000, l_error_message);
766: END IF;
767:
768: IF p_batch_type IS NULL AND p_transaction_type IS NULL THEN

Line 769: fnd_message.set_name ('OZF', 'OZF_ENTER_BATCH_TYPE');

765: raise_application_error( -20000, l_error_message);
766: END IF;
767:
768: IF p_batch_type IS NULL AND p_transaction_type IS NULL THEN
769: fnd_message.set_name ('OZF', 'OZF_ENTER_BATCH_TYPE');
770: l_error_message := fnd_message.get();
771: raise_application_error( -20000, l_error_message);
772: END IF;
773:

Line 770: l_error_message := fnd_message.get();

766: END IF;
767:
768: IF p_batch_type IS NULL AND p_transaction_type IS NULL THEN
769: fnd_message.set_name ('OZF', 'OZF_ENTER_BATCH_TYPE');
770: l_error_message := fnd_message.get();
771: raise_application_error( -20000, l_error_message);
772: END IF;
773:
774: -- Line Level Required Value Validation

Line 778: fnd_message.set_name ('OZF', 'OZF_ENTER_ITEM_NUMBER');

774: -- Line Level Required Value Validation
775:
776: IF p_item_description IS NULL THEN
777: IF p_orig_system_item_number IS NULL THEN
778: fnd_message.set_name ('OZF', 'OZF_ENTER_ITEM_NUMBER');
779: l_error_message := fnd_message.get();
780: raise_application_error( -20000, l_error_message);
781: END IF;
782: END IF;

Line 779: l_error_message := fnd_message.get();

775:
776: IF p_item_description IS NULL THEN
777: IF p_orig_system_item_number IS NULL THEN
778: fnd_message.set_name ('OZF', 'OZF_ENTER_ITEM_NUMBER');
779: l_error_message := fnd_message.get();
780: raise_application_error( -20000, l_error_message);
781: END IF;
782: END IF;
783:

Line 786: fnd_message.set_name ('OZF', 'OZF_ENTER_QUANTITY');

782: END IF;
783:
784: IF p_quantity IS NULL THEN
785: IF p_orig_system_quantity IS NULL THEN
786: fnd_message.set_name ('OZF', 'OZF_ENTER_QUANTITY');
787: l_error_message := fnd_message.get();
788: raise_application_error( -20000, l_error_message);
789: END IF;
790: END IF;

Line 787: l_error_message := fnd_message.get();

783:
784: IF p_quantity IS NULL THEN
785: IF p_orig_system_quantity IS NULL THEN
786: fnd_message.set_name ('OZF', 'OZF_ENTER_QUANTITY');
787: l_error_message := fnd_message.get();
788: raise_application_error( -20000, l_error_message);
789: END IF;
790: END IF;
791:

Line 793: fnd_message.set_name ('OZF', 'OZF_ENTER_ORDER_NUMBER');

789: END IF;
790: END IF;
791:
792: IF p_order_number IS NULL THEN
793: fnd_message.set_name ('OZF', 'OZF_ENTER_ORDER_NUMBER');
794: l_error_message := fnd_message.get();
795: raise_application_error( -20000, l_error_message);
796: END IF;
797: IF p_date_ordered IS NULL THEN

Line 794: l_error_message := fnd_message.get();

790: END IF;
791:
792: IF p_order_number IS NULL THEN
793: fnd_message.set_name ('OZF', 'OZF_ENTER_ORDER_NUMBER');
794: l_error_message := fnd_message.get();
795: raise_application_error( -20000, l_error_message);
796: END IF;
797: IF p_date_ordered IS NULL THEN
798: fnd_message.set_name ('OZF', 'OZF_ENTER_ORDER_DATE');

Line 798: fnd_message.set_name ('OZF', 'OZF_ENTER_ORDER_DATE');

794: l_error_message := fnd_message.get();
795: raise_application_error( -20000, l_error_message);
796: END IF;
797: IF p_date_ordered IS NULL THEN
798: fnd_message.set_name ('OZF', 'OZF_ENTER_ORDER_DATE');
799: l_error_message := fnd_message.get();
800: raise_application_error( -20000, l_error_message);
801: END IF;
802:

Line 799: l_error_message := fnd_message.get();

795: raise_application_error( -20000, l_error_message);
796: END IF;
797: IF p_date_ordered IS NULL THEN
798: fnd_message.set_name ('OZF', 'OZF_ENTER_ORDER_DATE');
799: l_error_message := fnd_message.get();
800: raise_application_error( -20000, l_error_message);
801: END IF;
802:
803: IF p_date_ordered < p_report_start_date THEN

Line 804: fnd_message.set_name ('OZF', 'OZF_ORDER_DATE_LESS_START_DATE');

800: raise_application_error( -20000, l_error_message);
801: END IF;
802:
803: IF p_date_ordered < p_report_start_date THEN
804: fnd_message.set_name ('OZF', 'OZF_ORDER_DATE_LESS_START_DATE');
805: l_error_message := fnd_message.get();
806: raise_application_error( -20000, l_error_message);
807: END IF;
808:

Line 805: l_error_message := fnd_message.get();

801: END IF;
802:
803: IF p_date_ordered < p_report_start_date THEN
804: fnd_message.set_name ('OZF', 'OZF_ORDER_DATE_LESS_START_DATE');
805: l_error_message := fnd_message.get();
806: raise_application_error( -20000, l_error_message);
807: END IF;
808:
809: IF p_date_ordered > p_report_end_date THEN

Line 810: fnd_message.set_name ('OZF', 'OZF_ORDER_DATE_GRT_END_DATE');

806: raise_application_error( -20000, l_error_message);
807: END IF;
808:
809: IF p_date_ordered > p_report_end_date THEN
810: fnd_message.set_name ('OZF', 'OZF_ORDER_DATE_GRT_END_DATE');
811: l_error_message := fnd_message.get();
812: raise_application_error( -20000, l_error_message);
813: END IF;
814:

Line 811: l_error_message := fnd_message.get();

807: END IF;
808:
809: IF p_date_ordered > p_report_end_date THEN
810: fnd_message.set_name ('OZF', 'OZF_ORDER_DATE_GRT_END_DATE');
811: l_error_message := fnd_message.get();
812: raise_application_error( -20000, l_error_message);
813: END IF;
814:
815: IF p_currency IS NULL THEN

Line 816: fnd_message.set_name ('OZF', 'OZF_ENTER_CURRENCY');

812: raise_application_error( -20000, l_error_message);
813: END IF;
814:
815: IF p_currency IS NULL THEN
816: fnd_message.set_name ('OZF', 'OZF_ENTER_CURRENCY');
817: l_error_message := fnd_message.get();
818: raise_application_error( -20000, l_error_message);
819: END IF;
820:

Line 817: l_error_message := fnd_message.get();

813: END IF;
814:
815: IF p_currency IS NULL THEN
816: fnd_message.set_name ('OZF', 'OZF_ENTER_CURRENCY');
817: l_error_message := fnd_message.get();
818: raise_application_error( -20000, l_error_message);
819: END IF;
820:
821: -- Writing to a file to record the data and debug for any problems

Line 1293: fnd_message.set_name ('OZF', 'OZF_WADI_CANNOT_UPDATE');

1289: OZF_UTILITY_PVT.debug_message('batch status '|| l_batch_status);
1290: -- Transaction Purpose Code Validations
1291: IF l_batch_status IS NOT NULL THEN
1292: IF l_batch_status = 'CLOSED' THEN
1293: fnd_message.set_name ('OZF', 'OZF_WADI_CANNOT_UPDATE');
1294: l_error_message := fnd_message.get();
1295: RAISE_APPLICATION_ERROR( -20000, l_error_message);
1296: ELSIF l_batch_status IN ('NEW','OPEN','PROCESSED','DISPUTED') THEN
1297: l_status_code := l_batch_status;

Line 1294: l_error_message := fnd_message.get();

1290: -- Transaction Purpose Code Validations
1291: IF l_batch_status IS NOT NULL THEN
1292: IF l_batch_status = 'CLOSED' THEN
1293: fnd_message.set_name ('OZF', 'OZF_WADI_CANNOT_UPDATE');
1294: l_error_message := fnd_message.get();
1295: RAISE_APPLICATION_ERROR( -20000, l_error_message);
1296: ELSIF l_batch_status IN ('NEW','OPEN','PROCESSED','DISPUTED') THEN
1297: l_status_code := l_batch_status;
1298: -- [BEGIN OF BUG 4212707 FIXING] by mchang

Line 1301: FND_MESSAGE.set_name('OZF', 'OZF_WADI_BATCH_NO_UPLOAD');

1297: l_status_code := l_batch_status;
1298: -- [BEGIN OF BUG 4212707 FIXING] by mchang
1299: ELSE
1300: /*
1301: FND_MESSAGE.set_name('OZF', 'OZF_WADI_BATCH_NO_UPLOAD');
1302: FND_MESSAGE.set_token( 'NUMBER', P_BATCH_NUMBER);
1303: FND_MESSAGE.set_token( 'STATUS'
1304: , OZF_UTILITY_PVT.get_lookup_meaning('OZF_RESALE_BATCH_STATUS'
1305: ,l_batch_status

Line 1302: FND_MESSAGE.set_token( 'NUMBER', P_BATCH_NUMBER);

1298: -- [BEGIN OF BUG 4212707 FIXING] by mchang
1299: ELSE
1300: /*
1301: FND_MESSAGE.set_name('OZF', 'OZF_WADI_BATCH_NO_UPLOAD');
1302: FND_MESSAGE.set_token( 'NUMBER', P_BATCH_NUMBER);
1303: FND_MESSAGE.set_token( 'STATUS'
1304: , OZF_UTILITY_PVT.get_lookup_meaning('OZF_RESALE_BATCH_STATUS'
1305: ,l_batch_status
1306: )

Line 1303: FND_MESSAGE.set_token( 'STATUS'

1299: ELSE
1300: /*
1301: FND_MESSAGE.set_name('OZF', 'OZF_WADI_BATCH_NO_UPLOAD');
1302: FND_MESSAGE.set_token( 'NUMBER', P_BATCH_NUMBER);
1303: FND_MESSAGE.set_token( 'STATUS'
1304: , OZF_UTILITY_PVT.get_lookup_meaning('OZF_RESALE_BATCH_STATUS'
1305: ,l_batch_status
1306: )
1307: );

Line 1309: --l_error_message := FND_MESSAGE.get();

1305: ,l_batch_status
1306: )
1307: );
1308: */
1309: --l_error_message := FND_MESSAGE.get();
1310: l_batch_status_n := OZF_UTILITY_PVT.get_lookup_meaning('OZF_RESALE_BATCH_STATUS'
1311: ,l_batch_status
1312: );
1313: l_error_message := 'Cannot update '||l_batch_status_n||' batch';

Line 1452: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_BATCH_ERROR');

1448: EXCEPTION
1449:
1450: WHEN OTHERS THEN
1451: l_text := l_text||'Error in Create Batch '||SQLERRM||' \n ';
1452: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_BATCH_ERROR');
1453: l_error_message := fnd_message.get();
1454: raise_application_error( -20000, l_error_message);
1455: END;
1456:

Line 1453: l_error_message := fnd_message.get();

1449:
1450: WHEN OTHERS THEN
1451: l_text := l_text||'Error in Create Batch '||SQLERRM||' \n ';
1452: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_BATCH_ERROR');
1453: l_error_message := fnd_message.get();
1454: raise_application_error( -20000, l_error_message);
1455: END;
1456:
1457: END IF; -- l_batch_count = 0

Line 1496: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_LINE_ERROR');

1492: x_msg_data => l_msg_data );
1493:
1494: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1495: l_text := l_text||'Error in Create Line '||SQLERRM||' \n ';
1496: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_LINE_ERROR');
1497: l_error_message := fnd_message.get();
1498: raise_application_error( -20000, l_error_message);
1499: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1497: l_error_message := fnd_message.get();

1493:
1494: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1495: l_text := l_text||'Error in Create Line '||SQLERRM||' \n ';
1496: fnd_message.set_name ('OZF', 'OZF_WADI_CREATE_LINE_ERROR');
1497: l_error_message := fnd_message.get();
1498: raise_application_error( -20000, l_error_message);
1499: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1501: END IF;

Line 1561: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_BATCH_ERROR');

1557: );
1558:
1559: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1560: l_text := l_text||'Error in Update Batch '||SQLERRM||' \n ';
1561: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_BATCH_ERROR');
1562: l_error_message := fnd_message.get();
1563: raise_application_error( -20000, l_error_message);
1564: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1562: l_error_message := fnd_message.get();

1558:
1559: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1560: l_text := l_text||'Error in Update Batch '||SQLERRM||' \n ';
1561: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_BATCH_ERROR');
1562: l_error_message := fnd_message.get();
1563: raise_application_error( -20000, l_error_message);
1564: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;

Line 1586: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_LINE_ERROR');

1582: );
1583:
1584: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1585: l_text := l_text||'Error in Update Line '||SQLERRM||' \n ';
1586: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_LINE_ERROR');
1587: l_error_message := fnd_message.get();
1588: raise_application_error( -20000, l_error_message);
1589: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1587: l_error_message := fnd_message.get();

1583:
1584: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1585: l_text := l_text||'Error in Update Line '||SQLERRM||' \n ';
1586: fnd_message.set_name ('OZF', 'OZF_WADI_UPDATE_LINE_ERROR');
1587: l_error_message := fnd_message.get();
1588: raise_application_error( -20000, l_error_message);
1589: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1591: END IF;

Line 1628: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));

1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625: UTL_FILE.FCLOSE(l_file);
1626: IF length( SQLERRM) > 30 THEN
1627: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
1628: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
1629: ELSE
1630: fnd_message.set_name ('OZF', SQLERRM);
1631: END IF;
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1630: fnd_message.set_name ('OZF', SQLERRM);

1626: IF length( SQLERRM) > 30 THEN
1627: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
1628: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
1629: ELSE
1630: fnd_message.set_name ('OZF', SQLERRM);
1631: END IF;
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1633: WHEN OTHERS THEN
1634: UTL_FILE.FCLOSE(l_file);

Line 1637: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));

1633: WHEN OTHERS THEN
1634: UTL_FILE.FCLOSE(l_file);
1635: IF length( SQLERRM) > 30 THEN
1636: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
1637: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
1638: ELSE
1639: fnd_message.set_name ('OZF', SQLERRM);
1640: END IF;
1641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1639: fnd_message.set_name ('OZF', SQLERRM);

1635: IF length( SQLERRM) > 30 THEN
1636: ozf_utility_pvt.debug_message(substr(SQLERRM,12,30));
1637: fnd_message.set_name ('OZF', substr(SQLERRM,12,30));
1638: ELSE
1639: fnd_message.set_name ('OZF', SQLERRM);
1640: END IF;
1641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1642:
1643: END RESALE_WEBADI;