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.QP_BULK_VALIDATE dependencies on FND_API

Line 49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

45: EXCEPTION
46: WHEN No_Data_Found
47: THEN
48: qp_bulk_loader_pub.write_log(l_routine || 'no line in qp_interface_list_lines for ' || p_orig_sys_line_ref_a);
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: WHEN OTHERS
51: THEN
52: qp_bulk_loader_pub.write_log(l_routine || '#100 Unexpected exception ' || SQLERRM);
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: WHEN OTHERS
51: THEN
52: qp_bulk_loader_pub.write_log(l_routine || '#100 Unexpected exception ' || SQLERRM);
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END;
55:
56: --fetching dates for second line, that can be either in interface table or setup table
57: BEGIN --begin1

Line 77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

73: EXCEPTION --begin2
74: WHEN No_Data_Found
75: THEN
76: qp_bulk_loader_pub.write_log(l_routine || ' date not found in qp_list_lines and qp_interface_list_lines');
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END; --begin2
79: END; --begin1
80:
81: l_a_start_date_active := Trunc(l_a_start_date_active); --truncate the dates, to remove time part

Line 103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

99: EXCEPTION
100: WHEN OTHERS
101: THEN
102: qp_bulk_loader_pub.write_log(l_routine || '#200 Unexpected exception ' || SQLERRM);
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END CHECK_DATES_OVERLAP; --check_dates_overlap;
105:
106: --mark duplicate line - insert into qp_interface_errors
107: PROCEDURE mark_dup_line(p_request_id NUMBER,

Line 144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

140: EXCEPTION
141: WHEN OTHERS
142: THEN
143: qp_bulk_loader_pub.write_log(l_routine || 'Unexpected exception ' || SQLERRM);
144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
145: END mark_dup_line;
146:
147: PROCEDURE dup_line_check(p_request_id NUMBER)
148: IS

Line 505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

501: EXCEPTION
502: WHEN OTHERS
503: THEN
504: qp_bulk_loader_pub.write_log(l_routine || 'Unexpected Exception ' || SQLERRM);
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END dup_line_check; -- dup_line_check
507: --End Bug No: 8854118, shaneed
508:
509: FUNCTION GET_FLEX_ENABLED_FLAG(p_flex_name VARCHAR2)

Line 672: IF p_attribute1 = FND_API.G_MISS_CHAR THEN

668: g_attribute13_name := 'ATTRIBUTE13';
669: g_attribute14_name := 'ATTRIBUTE14';
670: g_attribute15_name := 'ATTRIBUTE15';
671:
672: IF p_attribute1 = FND_API.G_MISS_CHAR THEN
673:
674: l_column_value := null;
675:
676: ELSE

Line 687: IF p_attribute2 = FND_API.G_MISS_CHAR THEN

683: FND_FLEX_DESCVAL.Set_Column_Value
684: ( column_name => 'ATTRIBUTE1'
685: , column_value => l_column_value);
686:
687: IF p_attribute2 = FND_API.G_MISS_CHAR THEN
688:
689: l_column_value := null;
690:
691: ELSE

Line 702: IF p_attribute3 = FND_API.G_MISS_CHAR THEN

698: FND_FLEX_DESCVAL.Set_Column_Value
699: ( column_name => 'ATTRIBUTE2'
700: , column_value => l_column_value);
701:
702: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
703:
704: l_column_value := null;
705:
706: ELSE

Line 717: IF p_attribute4 = FND_API.G_MISS_CHAR THEN

713: FND_FLEX_DESCVAL.Set_Column_Value
714: ( column_name => 'ATTRIBUTE3'
715: , column_value => l_column_value);
716:
717: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
718:
719: l_column_value := null;
720:
721: ELSE

Line 732: IF p_attribute5 = FND_API.G_MISS_CHAR THEN

728: FND_FLEX_DESCVAL.Set_Column_Value
729: ( column_name => 'ATTRIBUTE4'
730: , column_value => l_column_value);
731:
732: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
733:
734: l_column_value := null;
735:
736: ELSE

Line 747: IF p_attribute6 = FND_API.G_MISS_CHAR THEN

743: FND_FLEX_DESCVAL.Set_Column_Value
744: ( column_name => 'ATTRIBUTE5'
745: , column_value => l_column_value);
746:
747: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
748:
749: l_column_value := null;
750:
751: ELSE

Line 762: IF p_attribute7 = FND_API.G_MISS_CHAR THEN

758: FND_FLEX_DESCVAL.Set_Column_Value
759: ( column_name => 'ATTRIBUTE6'
760: , column_value => l_column_value);
761:
762: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
763:
764: l_column_value := null;
765:
766: ELSE

Line 777: IF p_attribute8 = FND_API.G_MISS_CHAR THEN

773: FND_FLEX_DESCVAL.Set_Column_Value
774: ( column_name => 'ATTRIBUTE7'
775: , column_value => l_column_value);
776:
777: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
778:
779: l_column_value := null;
780:
781: ELSE

Line 792: IF p_attribute9 = FND_API.G_MISS_CHAR THEN

788: FND_FLEX_DESCVAL.Set_Column_Value
789: ( column_name => 'ATTRIBUTE8'
790: , column_value => l_column_value);
791:
792: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
793:
794: l_column_value := null;
795:
796: ELSE

Line 807: IF p_attribute10 = FND_API.G_MISS_CHAR THEN

803: FND_FLEX_DESCVAL.Set_Column_Value
804: ( column_name => 'ATTRIBUTE9'
805: , column_value => l_column_value);
806:
807: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
808:
809: l_column_value := null;
810:
811: ELSE

Line 822: IF p_attribute11 = FND_API.G_MISS_CHAR THEN

818: FND_FLEX_DESCVAL.Set_Column_Value
819: ( column_name => 'ATTRIBUTE10'
820: , column_value => l_column_value);
821:
822: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
823:
824: l_column_value := null;
825:
826: ELSE

Line 837: IF p_attribute12 = FND_API.G_MISS_CHAR THEN

833: FND_FLEX_DESCVAL.Set_Column_Value
834: ( column_name => 'ATTRIBUTE11'
835: , column_value => l_column_value);
836:
837: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
838:
839: l_column_value := null;
840:
841: ELSE

Line 852: IF p_attribute13 = FND_API.G_MISS_CHAR THEN

848: FND_FLEX_DESCVAL.Set_Column_Value
849: ( column_name => 'ATTRIBUTE12'
850: , column_value => l_column_value);
851:
852: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
853:
854: l_column_value := null;
855:
856: ELSE

Line 867: IF p_attribute14 = FND_API.G_MISS_CHAR THEN

863: FND_FLEX_DESCVAL.Set_Column_Value
864: ( column_name => 'ATTRIBUTE13'
865: , column_value => l_column_value);
866:
867: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
868:
869: l_column_value := null;
870:
871: ELSE

Line 882: IF p_attribute15 = FND_API.G_MISS_CHAR THEN

878: FND_FLEX_DESCVAL.Set_Column_Value
879: ( column_name => 'ATTRIBUTE14'
880: , column_value => l_column_value);
881:
882: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
883:
884: l_column_value := null;
885:
886: ELSE

Line 897: IF p_context = FND_API.G_MISS_CHAR THEN

893: FND_FLEX_DESCVAL.Set_Column_Value
894: ( column_name => 'ATTRIBUTE15'
895: , column_value => l_column_value);
896:
897: IF p_context = FND_API.G_MISS_CHAR THEN
898:
899: l_column_value := null;
900:
901: ELSE

Line 1576: OR p_header_rec.context(i) = FND_API.G_MISS_CHAR THEN

1572:
1573: ELSE -- if the flex validation is successfull
1574:
1575: IF p_header_rec.context(i) IS NULL
1576: OR p_header_rec.context(i) = FND_API.G_MISS_CHAR THEN
1577: p_header_rec.context(i) := g_context;
1578: END IF;
1579:
1580: IF p_header_rec.attribute1(i) IS NULL

Line 1581: OR p_header_rec.attribute1(i) = FND_API.G_MISS_CHAR THEN

1577: p_header_rec.context(i) := g_context;
1578: END IF;
1579:
1580: IF p_header_rec.attribute1(i) IS NULL
1581: OR p_header_rec.attribute1(i) = FND_API.G_MISS_CHAR THEN
1582: p_header_rec.attribute1(i) := g_attribute1;
1583: END IF;
1584:
1585: IF p_header_rec.attribute2(i) IS NULL

Line 1586: OR p_header_rec.attribute2(i) = FND_API.G_MISS_CHAR THEN

1582: p_header_rec.attribute1(i) := g_attribute1;
1583: END IF;
1584:
1585: IF p_header_rec.attribute2(i) IS NULL
1586: OR p_header_rec.attribute2(i) = FND_API.G_MISS_CHAR THEN
1587: p_header_rec.attribute2(i) := g_attribute2;
1588: END IF;
1589:
1590: IF p_header_rec.attribute3(i) IS NULL

Line 1591: OR p_header_rec.attribute3(i) = FND_API.G_MISS_CHAR THEN

1587: p_header_rec.attribute2(i) := g_attribute2;
1588: END IF;
1589:
1590: IF p_header_rec.attribute3(i) IS NULL
1591: OR p_header_rec.attribute3(i) = FND_API.G_MISS_CHAR THEN
1592: p_header_rec.attribute3(i) := g_attribute3;
1593: END IF;
1594:
1595: IF p_header_rec.attribute4(i) IS NULL

Line 1596: OR p_header_rec.attribute4(i) = FND_API.G_MISS_CHAR THEN

1592: p_header_rec.attribute3(i) := g_attribute3;
1593: END IF;
1594:
1595: IF p_header_rec.attribute4(i) IS NULL
1596: OR p_header_rec.attribute4(i) = FND_API.G_MISS_CHAR THEN
1597: p_header_rec.attribute4(i) := g_attribute4;
1598: END IF;
1599:
1600: IF p_header_rec.attribute5(i) IS NULL

Line 1601: OR p_header_rec.attribute5(i) = FND_API.G_MISS_CHAR THEN

1597: p_header_rec.attribute4(i) := g_attribute4;
1598: END IF;
1599:
1600: IF p_header_rec.attribute5(i) IS NULL
1601: OR p_header_rec.attribute5(i) = FND_API.G_MISS_CHAR THEN
1602: p_header_rec.attribute5(i) := g_attribute5;
1603: END IF;
1604:
1605: IF p_header_rec.attribute6(i) IS NULL

Line 1606: OR p_header_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN

1602: p_header_rec.attribute5(i) := g_attribute5;
1603: END IF;
1604:
1605: IF p_header_rec.attribute6(i) IS NULL
1606: OR p_header_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
1607: p_header_rec.attribute6(i) := g_attribute6;
1608: END IF;
1609: IF p_header_rec.attribute7(i) IS NULL
1610: OR p_header_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN

Line 1610: OR p_header_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN

1606: OR p_header_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
1607: p_header_rec.attribute6(i) := g_attribute6;
1608: END IF;
1609: IF p_header_rec.attribute7(i) IS NULL
1610: OR p_header_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN
1611: p_header_rec.attribute7(i) := g_attribute7;
1612: END IF;
1613:
1614: IF p_header_rec.attribute8(i) IS NULL

Line 1615: OR p_header_rec.attribute8(i) = FND_API.G_MISS_CHAR THEN

1611: p_header_rec.attribute7(i) := g_attribute7;
1612: END IF;
1613:
1614: IF p_header_rec.attribute8(i) IS NULL
1615: OR p_header_rec.attribute8(i) = FND_API.G_MISS_CHAR THEN
1616: p_header_rec.attribute8(i) := g_attribute8;
1617: END IF;
1618:
1619: IF p_header_rec.attribute9(i) IS NULL

Line 1620: OR p_header_rec.attribute9(i) = FND_API.G_MISS_CHAR THEN

1616: p_header_rec.attribute8(i) := g_attribute8;
1617: END IF;
1618:
1619: IF p_header_rec.attribute9(i) IS NULL
1620: OR p_header_rec.attribute9(i) = FND_API.G_MISS_CHAR THEN
1621: p_header_rec.attribute9(i) := g_attribute9;
1622: END IF;
1623:
1624: IF p_header_rec.attribute10(i) IS NULL

Line 1625: OR p_header_rec.attribute10(i) = FND_API.G_MISS_CHAR THEN

1621: p_header_rec.attribute9(i) := g_attribute9;
1622: END IF;
1623:
1624: IF p_header_rec.attribute10(i) IS NULL
1625: OR p_header_rec.attribute10(i) = FND_API.G_MISS_CHAR THEN
1626: p_header_rec.attribute10(i) := G_attribute10;
1627: End IF;
1628:
1629: IF p_header_rec.attribute11(i) IS NULL

Line 1630: OR p_header_rec.attribute11(i) = FND_API.G_MISS_CHAR THEN

1626: p_header_rec.attribute10(i) := G_attribute10;
1627: End IF;
1628:
1629: IF p_header_rec.attribute11(i) IS NULL
1630: OR p_header_rec.attribute11(i) = FND_API.G_MISS_CHAR THEN
1631: p_header_rec.attribute11(i) := g_attribute11;
1632: END IF;
1633:
1634: IF p_header_rec.attribute12(i) IS NULL

Line 1635: OR p_header_rec.attribute12(i) = FND_API.G_MISS_CHAR THEN

1631: p_header_rec.attribute11(i) := g_attribute11;
1632: END IF;
1633:
1634: IF p_header_rec.attribute12(i) IS NULL
1635: OR p_header_rec.attribute12(i) = FND_API.G_MISS_CHAR THEN
1636: p_header_rec.attribute12(i) := g_attribute12;
1637: END IF;
1638:
1639: IF p_header_rec.attribute13(i) IS NULL

Line 1640: OR p_header_rec.attribute13(i) = FND_API.G_MISS_CHAR THEN

1636: p_header_rec.attribute12(i) := g_attribute12;
1637: END IF;
1638:
1639: IF p_header_rec.attribute13(i) IS NULL
1640: OR p_header_rec.attribute13(i) = FND_API.G_MISS_CHAR THEN
1641: p_header_rec.attribute13(i) := g_attribute13;
1642: END IF;
1643:
1644: IF p_header_rec.attribute14(i) IS NULL

Line 1645: OR p_header_rec.attribute14(i) = FND_API.G_MISS_CHAR THEN

1641: p_header_rec.attribute13(i) := g_attribute13;
1642: END IF;
1643:
1644: IF p_header_rec.attribute14(i) IS NULL
1645: OR p_header_rec.attribute14(i) = FND_API.G_MISS_CHAR THEN
1646: p_header_rec.attribute14(i) := g_attribute14;
1647: END IF;
1648:
1649: IF p_header_rec.attribute15(i) IS NULL

Line 1650: OR p_header_rec.attribute15(i) = FND_API.G_MISS_CHAR THEN

1646: p_header_rec.attribute14(i) := g_attribute14;
1647: END IF;
1648:
1649: IF p_header_rec.attribute15(i) IS NULL
1650: OR p_header_rec.attribute15(i) = FND_API.G_MISS_CHAR THEN
1651: p_header_rec.attribute15(i) := g_attribute15;
1652: END IF;
1653: END IF;
1654: END IF; --l_header_flex_enabled = 'Y'

Line 1694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1690:
1691: qp_bulk_loader_pub.write_log('Leaving Entity_header validation');
1692:
1693: EXCEPTION
1694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1695: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_HEADER:'||sqlerrm);
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: WHEN OTHERS THEN
1698: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_HEADER:'||sqlerrm);

Line 1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1692:
1693: EXCEPTION
1694: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1695: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_HEADER:'||sqlerrm);
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: WHEN OTHERS THEN
1698: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_HEADER:'||sqlerrm);
1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1700: END ENTITY_HEADER;

Line 1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1695: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_HEADER:'||sqlerrm);
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: WHEN OTHERS THEN
1698: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_HEADER:'||sqlerrm);
1699: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1700: END ENTITY_HEADER;
1701:
1702:
1703: PROCEDURE ENTITY_LINE

Line 2481: OR p_line_rec.context(i) = FND_API.G_MISS_CHAR THEN

2477:
2478: ELSE -- if the flex validation is successfull
2479:
2480: IF p_line_rec.context(i) IS NULL
2481: OR p_line_rec.context(i) = FND_API.G_MISS_CHAR THEN
2482: p_line_rec.context(i) := g_context;
2483: END IF;
2484:
2485: IF p_line_rec.attribute1(i) IS NULL

Line 2486: OR p_line_rec.attribute1(i) = FND_API.G_MISS_CHAR THEN

2482: p_line_rec.context(i) := g_context;
2483: END IF;
2484:
2485: IF p_line_rec.attribute1(i) IS NULL
2486: OR p_line_rec.attribute1(i) = FND_API.G_MISS_CHAR THEN
2487: p_line_rec.attribute1(i) := g_attribute1;
2488: END IF;
2489:
2490: IF p_line_rec.attribute2(i) IS NULL

Line 2491: OR p_line_rec.attribute2(i) = FND_API.G_MISS_CHAR THEN

2487: p_line_rec.attribute1(i) := g_attribute1;
2488: END IF;
2489:
2490: IF p_line_rec.attribute2(i) IS NULL
2491: OR p_line_rec.attribute2(i) = FND_API.G_MISS_CHAR THEN
2492: p_line_rec.attribute2(i) := g_attribute2;
2493: END IF;
2494:
2495: IF p_line_rec.attribute3(i) IS NULL

Line 2496: OR p_line_rec.attribute3(i) = FND_API.G_MISS_CHAR THEN

2492: p_line_rec.attribute2(i) := g_attribute2;
2493: END IF;
2494:
2495: IF p_line_rec.attribute3(i) IS NULL
2496: OR p_line_rec.attribute3(i) = FND_API.G_MISS_CHAR THEN
2497: p_line_rec.attribute3(i) := g_attribute3;
2498: END IF;
2499:
2500: IF p_line_rec.attribute4(i) IS NULL

Line 2501: OR p_line_rec.attribute4(i) = FND_API.G_MISS_CHAR THEN

2497: p_line_rec.attribute3(i) := g_attribute3;
2498: END IF;
2499:
2500: IF p_line_rec.attribute4(i) IS NULL
2501: OR p_line_rec.attribute4(i) = FND_API.G_MISS_CHAR THEN
2502: p_line_rec.attribute4(i) := g_attribute4;
2503: END IF;
2504:
2505: IF p_line_rec.attribute5(i) IS NULL

Line 2506: OR p_line_rec.attribute5(i) = FND_API.G_MISS_CHAR THEN

2502: p_line_rec.attribute4(i) := g_attribute4;
2503: END IF;
2504:
2505: IF p_line_rec.attribute5(i) IS NULL
2506: OR p_line_rec.attribute5(i) = FND_API.G_MISS_CHAR THEN
2507: p_line_rec.attribute5(i) := g_attribute5;
2508: END IF;
2509:
2510: IF p_line_rec.attribute6(i) IS NULL

Line 2511: OR p_line_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN

2507: p_line_rec.attribute5(i) := g_attribute5;
2508: END IF;
2509:
2510: IF p_line_rec.attribute6(i) IS NULL
2511: OR p_line_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
2512: p_line_rec.attribute6(i) := g_attribute6;
2513: END IF;
2514: IF p_line_rec.attribute7(i) IS NULL
2515: OR p_line_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN

Line 2515: OR p_line_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN

2511: OR p_line_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
2512: p_line_rec.attribute6(i) := g_attribute6;
2513: END IF;
2514: IF p_line_rec.attribute7(i) IS NULL
2515: OR p_line_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN
2516: p_line_rec.attribute7(i) := g_attribute7;
2517: END IF;
2518:
2519: IF p_line_rec.attribute8(i) IS NULL

Line 2520: OR p_line_rec.attribute8(i) = FND_API.G_MISS_CHAR THEN

2516: p_line_rec.attribute7(i) := g_attribute7;
2517: END IF;
2518:
2519: IF p_line_rec.attribute8(i) IS NULL
2520: OR p_line_rec.attribute8(i) = FND_API.G_MISS_CHAR THEN
2521: p_line_rec.attribute8(i) := g_attribute8;
2522: END IF;
2523:
2524: IF p_line_rec.attribute9(i) IS NULL

Line 2525: OR p_line_rec.attribute9(i) = FND_API.G_MISS_CHAR THEN

2521: p_line_rec.attribute8(i) := g_attribute8;
2522: END IF;
2523:
2524: IF p_line_rec.attribute9(i) IS NULL
2525: OR p_line_rec.attribute9(i) = FND_API.G_MISS_CHAR THEN
2526: p_line_rec.attribute9(i) := g_attribute9;
2527: END IF;
2528:
2529: IF p_line_rec.attribute10(i) IS NULL

Line 2530: OR p_line_rec.attribute10(i) = FND_API.G_MISS_CHAR THEN

2526: p_line_rec.attribute9(i) := g_attribute9;
2527: END IF;
2528:
2529: IF p_line_rec.attribute10(i) IS NULL
2530: OR p_line_rec.attribute10(i) = FND_API.G_MISS_CHAR THEN
2531: p_line_rec.attribute10(i) := G_attribute10;
2532: End IF;
2533:
2534: IF p_line_rec.attribute11(i) IS NULL

Line 2535: OR p_line_rec.attribute11(i) = FND_API.G_MISS_CHAR THEN

2531: p_line_rec.attribute10(i) := G_attribute10;
2532: End IF;
2533:
2534: IF p_line_rec.attribute11(i) IS NULL
2535: OR p_line_rec.attribute11(i) = FND_API.G_MISS_CHAR THEN
2536: p_line_rec.attribute11(i) := g_attribute11;
2537: END IF;
2538:
2539: IF p_line_rec.attribute12(i) IS NULL

Line 2540: OR p_line_rec.attribute12(i) = FND_API.G_MISS_CHAR THEN

2536: p_line_rec.attribute11(i) := g_attribute11;
2537: END IF;
2538:
2539: IF p_line_rec.attribute12(i) IS NULL
2540: OR p_line_rec.attribute12(i) = FND_API.G_MISS_CHAR THEN
2541: p_line_rec.attribute12(i) := g_attribute12;
2542: END IF;
2543:
2544: IF p_line_rec.attribute13(i) IS NULL

Line 2545: OR p_line_rec.attribute13(i) = FND_API.G_MISS_CHAR THEN

2541: p_line_rec.attribute12(i) := g_attribute12;
2542: END IF;
2543:
2544: IF p_line_rec.attribute13(i) IS NULL
2545: OR p_line_rec.attribute13(i) = FND_API.G_MISS_CHAR THEN
2546: p_line_rec.attribute13(i) := g_attribute13;
2547: END IF;
2548:
2549: IF p_line_rec.attribute14(i) IS NULL

Line 2550: OR p_line_rec.attribute14(i) = FND_API.G_MISS_CHAR THEN

2546: p_line_rec.attribute13(i) := g_attribute13;
2547: END IF;
2548:
2549: IF p_line_rec.attribute14(i) IS NULL
2550: OR p_line_rec.attribute14(i) = FND_API.G_MISS_CHAR THEN
2551: p_line_rec.attribute14(i) := g_attribute14;
2552: END IF;
2553:
2554: IF p_line_rec.attribute15(i) IS NULL

Line 2555: OR p_line_rec.attribute15(i) = FND_API.G_MISS_CHAR THEN

2551: p_line_rec.attribute14(i) := g_attribute14;
2552: END IF;
2553:
2554: IF p_line_rec.attribute15(i) IS NULL
2555: OR p_line_rec.attribute15(i) = FND_API.G_MISS_CHAR THEN
2556: p_line_rec.attribute15(i) := g_attribute15;
2557: END IF;
2558: END IF;
2559: END IF;

Line 2592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2588:
2589: qp_bulk_loader_pub.write_log('Leaving entity line validation');
2590:
2591: EXCEPTION
2592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2593: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_LINE:'||sqlerrm);
2594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2595: WHEN OTHERS THEN
2596: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_LINE:'||sqlerrm);

Line 2594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2590:
2591: EXCEPTION
2592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2593: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_LINE:'||sqlerrm);
2594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2595: WHEN OTHERS THEN
2596: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_LINE:'||sqlerrm);
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598: END ENTITY_LINE;

Line 2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2593: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_LINE:'||sqlerrm);
2594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2595: WHEN OTHERS THEN
2596: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_LINE:'||sqlerrm);
2597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2598: END ENTITY_LINE;
2599:
2600:
2601: PROCEDURE ENTITY_QUALIFIER

Line 3255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3251:
3252: qp_bulk_loader_pub.write_log('Leaving Entity qualifier validation');
3253:
3254: EXCEPTION
3255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3256: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_QUALIFIER:'||sqlerrm);
3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3258: WHEN OTHERS THEN
3259: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_QUALIFIER:'||sqlerrm);

Line 3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3253:
3254: EXCEPTION
3255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3256: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_QUALIFIER:'||sqlerrm);
3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3258: WHEN OTHERS THEN
3259: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_QUALIFIER:'||sqlerrm);
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261:

Line 3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3256: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_QUALIFIER:'||sqlerrm);
3257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3258: WHEN OTHERS THEN
3259: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_QUALIFIER:'||sqlerrm);
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261:
3262:
3263: END ENTITY_QUALIFIER;
3264:

Line 3297: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3293: l_sourcing_method VARCHAR2(30);
3294: --smbalara 9458481/10152629 /10152629 START
3295: l_min_date DATE;
3296: l_max_date DATE;
3297: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3298: l_start_date_active DATE;
3299: l_end_date_active DATE;
3300: l_edate DATE;
3301: l_sdate DATE;

Line 4276: l_return_status := FND_API.G_RET_STS_ERROR;

4272: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id(I);
4273: EXCEPTION
4274: WHEN OTHERS THEN
4275: qp_bulk_loader_pub.write_log('9458481/10152629 smbalara 1 ');
4276: l_return_status := FND_API.G_RET_STS_ERROR;
4277: END;
4278:
4279: qp_bulk_loader_pub.write_log('9458481/10152629 smbalara 2 :'||l_primary_uom_flag);
4280: --check for dates overlapping for lines with primary uom flag checked --smbalara 9458481/10152629 START

Line 4864: OR p_pricing_attr_rec.context(i) = FND_API.G_MISS_CHAR THEN

4860:
4861: ELSE -- if the flex validation is successfull
4862:
4863: IF p_pricing_attr_rec.context(i) IS NULL
4864: OR p_pricing_attr_rec.context(i) = FND_API.G_MISS_CHAR THEN
4865: p_pricing_attr_rec.context(i) := g_context;
4866: END IF;
4867:
4868: IF p_pricing_attr_rec.attribute1(i) IS NULL

Line 4869: OR p_pricing_attr_rec.attribute1(i) = FND_API.G_MISS_CHAR THEN

4865: p_pricing_attr_rec.context(i) := g_context;
4866: END IF;
4867:
4868: IF p_pricing_attr_rec.attribute1(i) IS NULL
4869: OR p_pricing_attr_rec.attribute1(i) = FND_API.G_MISS_CHAR THEN
4870: p_pricing_attr_rec.attribute1(i) := g_attribute1;
4871: END IF;
4872:
4873: IF p_pricing_attr_rec.attribute2(i) IS NULL

Line 4874: OR p_pricing_attr_rec.attribute2(i) = FND_API.G_MISS_CHAR THEN

4870: p_pricing_attr_rec.attribute1(i) := g_attribute1;
4871: END IF;
4872:
4873: IF p_pricing_attr_rec.attribute2(i) IS NULL
4874: OR p_pricing_attr_rec.attribute2(i) = FND_API.G_MISS_CHAR THEN
4875: p_pricing_attr_rec.attribute2(i) := g_attribute2;
4876: END IF;
4877:
4878: IF p_pricing_attr_rec.attribute3(i) IS NULL

Line 4879: OR p_pricing_attr_rec.attribute3(i) = FND_API.G_MISS_CHAR THEN

4875: p_pricing_attr_rec.attribute2(i) := g_attribute2;
4876: END IF;
4877:
4878: IF p_pricing_attr_rec.attribute3(i) IS NULL
4879: OR p_pricing_attr_rec.attribute3(i) = FND_API.G_MISS_CHAR THEN
4880: p_pricing_attr_rec.attribute3(i) := g_attribute3;
4881: END IF;
4882:
4883: IF p_pricing_attr_rec.attribute4(i) IS NULL

Line 4884: OR p_pricing_attr_rec.attribute4(i) = FND_API.G_MISS_CHAR THEN

4880: p_pricing_attr_rec.attribute3(i) := g_attribute3;
4881: END IF;
4882:
4883: IF p_pricing_attr_rec.attribute4(i) IS NULL
4884: OR p_pricing_attr_rec.attribute4(i) = FND_API.G_MISS_CHAR THEN
4885: p_pricing_attr_rec.attribute4(i) := g_attribute4;
4886: END IF;
4887:
4888: IF p_pricing_attr_rec.attribute5(i) IS NULL

Line 4889: OR p_pricing_attr_rec.attribute5(i) = FND_API.G_MISS_CHAR THEN

4885: p_pricing_attr_rec.attribute4(i) := g_attribute4;
4886: END IF;
4887:
4888: IF p_pricing_attr_rec.attribute5(i) IS NULL
4889: OR p_pricing_attr_rec.attribute5(i) = FND_API.G_MISS_CHAR THEN
4890: p_pricing_attr_rec.attribute5(i) := g_attribute5;
4891: END IF;
4892:
4893: IF p_pricing_attr_rec.attribute6(i) IS NULL

Line 4894: OR p_pricing_attr_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN

4890: p_pricing_attr_rec.attribute5(i) := g_attribute5;
4891: END IF;
4892:
4893: IF p_pricing_attr_rec.attribute6(i) IS NULL
4894: OR p_pricing_attr_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
4895: p_pricing_attr_rec.attribute6(i) := g_attribute6;
4896: END IF;
4897: IF p_pricing_attr_rec.attribute7(i) IS NULL
4898: OR p_pricing_attr_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN

Line 4898: OR p_pricing_attr_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN

4894: OR p_pricing_attr_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
4895: p_pricing_attr_rec.attribute6(i) := g_attribute6;
4896: END IF;
4897: IF p_pricing_attr_rec.attribute7(i) IS NULL
4898: OR p_pricing_attr_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN
4899: p_pricing_attr_rec.attribute7(i) := g_attribute7;
4900: END IF;
4901:
4902: IF p_pricing_attr_rec.attribute8(i) IS NULL

Line 4903: OR p_pricing_attr_rec.attribute8(i) = FND_API.G_MISS_CHAR THEN

4899: p_pricing_attr_rec.attribute7(i) := g_attribute7;
4900: END IF;
4901:
4902: IF p_pricing_attr_rec.attribute8(i) IS NULL
4903: OR p_pricing_attr_rec.attribute8(i) = FND_API.G_MISS_CHAR THEN
4904: p_pricing_attr_rec.attribute8(i) := g_attribute8;
4905: END IF;
4906:
4907: IF p_pricing_attr_rec.attribute9(i) IS NULL

Line 4908: OR p_pricing_attr_rec.attribute9(i) = FND_API.G_MISS_CHAR THEN

4904: p_pricing_attr_rec.attribute8(i) := g_attribute8;
4905: END IF;
4906:
4907: IF p_pricing_attr_rec.attribute9(i) IS NULL
4908: OR p_pricing_attr_rec.attribute9(i) = FND_API.G_MISS_CHAR THEN
4909: p_pricing_attr_rec.attribute9(i) := g_attribute9;
4910: END IF;
4911:
4912: IF p_pricing_attr_rec.attribute10(i) IS NULL

Line 4913: OR p_pricing_attr_rec.attribute10(i) = FND_API.G_MISS_CHAR THEN

4909: p_pricing_attr_rec.attribute9(i) := g_attribute9;
4910: END IF;
4911:
4912: IF p_pricing_attr_rec.attribute10(i) IS NULL
4913: OR p_pricing_attr_rec.attribute10(i) = FND_API.G_MISS_CHAR THEN
4914: p_pricing_attr_rec.attribute10(i) := G_attribute10;
4915: End IF;
4916:
4917: IF p_pricing_attr_rec.attribute11(i) IS NULL

Line 4918: OR p_pricing_attr_rec.attribute11(i) = FND_API.G_MISS_CHAR THEN

4914: p_pricing_attr_rec.attribute10(i) := G_attribute10;
4915: End IF;
4916:
4917: IF p_pricing_attr_rec.attribute11(i) IS NULL
4918: OR p_pricing_attr_rec.attribute11(i) = FND_API.G_MISS_CHAR THEN
4919: p_pricing_attr_rec.attribute11(i) := g_attribute11;
4920: END IF;
4921:
4922: IF p_pricing_attr_rec.attribute12(i) IS NULL

Line 4923: OR p_pricing_attr_rec.attribute12(i) = FND_API.G_MISS_CHAR THEN

4919: p_pricing_attr_rec.attribute11(i) := g_attribute11;
4920: END IF;
4921:
4922: IF p_pricing_attr_rec.attribute12(i) IS NULL
4923: OR p_pricing_attr_rec.attribute12(i) = FND_API.G_MISS_CHAR THEN
4924: p_pricing_attr_rec.attribute12(i) := g_attribute12;
4925: END IF;
4926:
4927: IF p_pricing_attr_rec.attribute13(i) IS NULL

Line 4928: OR p_pricing_attr_rec.attribute13(i) = FND_API.G_MISS_CHAR THEN

4924: p_pricing_attr_rec.attribute12(i) := g_attribute12;
4925: END IF;
4926:
4927: IF p_pricing_attr_rec.attribute13(i) IS NULL
4928: OR p_pricing_attr_rec.attribute13(i) = FND_API.G_MISS_CHAR THEN
4929: p_pricing_attr_rec.attribute13(i) := g_attribute13;
4930: END IF;
4931:
4932: IF p_pricing_attr_rec.attribute14(i) IS NULL

Line 4933: OR p_pricing_attr_rec.attribute14(i) = FND_API.G_MISS_CHAR THEN

4929: p_pricing_attr_rec.attribute13(i) := g_attribute13;
4930: END IF;
4931:
4932: IF p_pricing_attr_rec.attribute14(i) IS NULL
4933: OR p_pricing_attr_rec.attribute14(i) = FND_API.G_MISS_CHAR THEN
4934: p_pricing_attr_rec.attribute14(i) := g_attribute14;
4935: END IF;
4936:
4937: IF p_pricing_attr_rec.attribute15(i) IS NULL

Line 4938: OR p_pricing_attr_rec.attribute15(i) = FND_API.G_MISS_CHAR THEN

4934: p_pricing_attr_rec.attribute14(i) := g_attribute14;
4935: END IF;
4936:
4937: IF p_pricing_attr_rec.attribute15(i) IS NULL
4938: OR p_pricing_attr_rec.attribute15(i) = FND_API.G_MISS_CHAR THEN
4939: p_pricing_attr_rec.attribute15(i) := g_attribute15;
4940: END IF;
4941: END IF;
4942: END IF;

Line 5062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5058:
5059: qp_bulk_loader_pub.write_log( 'Leaving Entity Pricing Attr validation');
5060:
5061: EXCEPTION
5062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5063: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_PRICING_ATTR:'||sqlerrm);
5064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5065: WHEN OTHERS THEN
5066: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_PRICING_ATTR:'||sqlerrm);

Line 5064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5060:
5061: EXCEPTION
5062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5063: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_PRICING_ATTR:'||sqlerrm);
5064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5065: WHEN OTHERS THEN
5066: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_PRICING_ATTR:'||sqlerrm);
5067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5068:

Line 5067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5063: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_PRICING_ATTR:'||sqlerrm);
5064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5065: WHEN OTHERS THEN
5066: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_PRICING_ATTR:'||sqlerrm);
5067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5068:
5069:
5070: END ENTITY_PRICING_ATTR;
5071:

Line 5725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5721:
5722: qp_bulk_loader_pub.write_log('Leaving Attribute Header validation');
5723:
5724: EXCEPTION
5725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5726: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_HEADER:'||sqlerrm);
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: WHEN OTHERS THEN
5729: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_HEADER:'||sqlerrm);

Line 5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5723:
5724: EXCEPTION
5725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5726: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_HEADER:'||sqlerrm);
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: WHEN OTHERS THEN
5729: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_HEADER:'||sqlerrm);
5730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5731:

Line 5730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5726: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_HEADER:'||sqlerrm);
5727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5728: WHEN OTHERS THEN
5729: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_HEADER:'||sqlerrm);
5730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5731:
5732: END ATTRIBUTE_HEADER;
5733:
5734:

Line 5966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5962:
5963: qp_bulk_loader_pub.write_log('Leaving Attribute qualifier validation');
5964:
5965: EXCEPTION
5966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5967: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_QUALIFIER:'||sqlerrm);
5968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5969: WHEN OTHERS THEN
5970: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_QUALIFIER:'||sqlerrm);

Line 5968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5964:
5965: EXCEPTION
5966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5967: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_QUALIFIER:'||sqlerrm);
5968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5969: WHEN OTHERS THEN
5970: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_QUALIFIER:'||sqlerrm);
5971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5972:

Line 5971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5967: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_QUALIFIER:'||sqlerrm);
5968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5969: WHEN OTHERS THEN
5970: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_QUALIFIER:'||sqlerrm);
5971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5972:
5973: END ATTRIBUTE_QUALIFIER;
5974:
5975:

Line 6689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6685: --Bug# 5456164 END RAVI
6686:
6687: qp_bulk_loader_pub.write_log('Leaving Attribute Line validation');
6688: EXCEPTION
6689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6690: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_LINE:'||sqlerrm);
6691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6692: WHEN OTHERS THEN
6693: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_LINE:'||sqlerrm);

Line 6691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6687: qp_bulk_loader_pub.write_log('Leaving Attribute Line validation');
6688: EXCEPTION
6689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6690: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_LINE:'||sqlerrm);
6691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6692: WHEN OTHERS THEN
6693: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_LINE:'||sqlerrm);
6694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6695: END ATTRIBUTE_LINE;

Line 6694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6690: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_LINE:'||sqlerrm);
6691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6692: WHEN OTHERS THEN
6693: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_LINE:'||sqlerrm);
6694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6695: END ATTRIBUTE_LINE;
6696:
6697:
6698: PROCEDURE MARK_ERRORED_INTERFACE_RECORD

Line 6765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6761:
6762: qp_bulk_loader_pub.write_log('Entering Mark errored inreface record');
6763:
6764: EXCEPTION
6765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6766: qp_bulk_loader_pub.write_log(
6767: 'UNEXCPECTED ERROR IN PROCEDURE MARK_ERRORED_INTERFACE_RECORD:'||sqlerrm);
6768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6769: WHEN OTHERS THEN

Line 6768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6764: EXCEPTION
6765: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6766: qp_bulk_loader_pub.write_log(
6767: 'UNEXCPECTED ERROR IN PROCEDURE MARK_ERRORED_INTERFACE_RECORD:'||sqlerrm);
6768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6769: WHEN OTHERS THEN
6770: qp_bulk_loader_pub.write_log(
6771: 'UNEXCPECTED ERROR IN PROCEDURE MARK_ERRORED_INTERFACE_RECORD:'||sqlerrm);
6772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6769: WHEN OTHERS THEN
6770: qp_bulk_loader_pub.write_log(
6771: 'UNEXCPECTED ERROR IN PROCEDURE MARK_ERRORED_INTERFACE_RECORD:'||sqlerrm);
6772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6773:
6774: END MARK_ERRORED_INTERFACE_RECORD;
6775:
6776: END QP_BULK_VALIDATE;