DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on FND_API

Line 657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

653: dbms_session.set_sql_trace(FALSE);
654: qp_bulk_loader_pub.write_log('Leaving Duplicate line check');
655:
656: EXCEPTION
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE DUP_LINE_CHECK:'||sqlerrm);
659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
660: WHEN OTHERS THEN
661: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE DUP_LINE_CHECK:'||sqlerrm);

Line 659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

655:
656: EXCEPTION
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE DUP_LINE_CHECK:'||sqlerrm);
659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
660: WHEN OTHERS THEN
661: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE DUP_LINE_CHECK:'||sqlerrm);
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: END DUP_LINE_CHECK;

Line 662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

658: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE DUP_LINE_CHECK:'||sqlerrm);
659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
660: WHEN OTHERS THEN
661: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE DUP_LINE_CHECK:'||sqlerrm);
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: END DUP_LINE_CHECK;
664:
665: FUNCTION GET_FLEX_ENABLED_FLAG(p_flex_name VARCHAR2)
666: RETURN VARCHAR2

Line 828: IF p_attribute1 = FND_API.G_MISS_CHAR THEN

824: g_attribute13_name := 'ATTRIBUTE13';
825: g_attribute14_name := 'ATTRIBUTE14';
826: g_attribute15_name := 'ATTRIBUTE15';
827:
828: IF p_attribute1 = FND_API.G_MISS_CHAR THEN
829:
830: l_column_value := null;
831:
832: ELSE

Line 843: IF p_attribute2 = FND_API.G_MISS_CHAR THEN

839: FND_FLEX_DESCVAL.Set_Column_Value
840: ( column_name => 'ATTRIBUTE1'
841: , column_value => l_column_value);
842:
843: IF p_attribute2 = FND_API.G_MISS_CHAR THEN
844:
845: l_column_value := null;
846:
847: ELSE

Line 858: IF p_attribute3 = FND_API.G_MISS_CHAR THEN

854: FND_FLEX_DESCVAL.Set_Column_Value
855: ( column_name => 'ATTRIBUTE2'
856: , column_value => l_column_value);
857:
858: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
859:
860: l_column_value := null;
861:
862: ELSE

Line 873: IF p_attribute4 = FND_API.G_MISS_CHAR THEN

869: FND_FLEX_DESCVAL.Set_Column_Value
870: ( column_name => 'ATTRIBUTE3'
871: , column_value => l_column_value);
872:
873: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
874:
875: l_column_value := null;
876:
877: ELSE

Line 888: IF p_attribute5 = FND_API.G_MISS_CHAR THEN

884: FND_FLEX_DESCVAL.Set_Column_Value
885: ( column_name => 'ATTRIBUTE4'
886: , column_value => l_column_value);
887:
888: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
889:
890: l_column_value := null;
891:
892: ELSE

Line 903: IF p_attribute6 = FND_API.G_MISS_CHAR THEN

899: FND_FLEX_DESCVAL.Set_Column_Value
900: ( column_name => 'ATTRIBUTE5'
901: , column_value => l_column_value);
902:
903: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
904:
905: l_column_value := null;
906:
907: ELSE

Line 918: IF p_attribute7 = FND_API.G_MISS_CHAR THEN

914: FND_FLEX_DESCVAL.Set_Column_Value
915: ( column_name => 'ATTRIBUTE6'
916: , column_value => l_column_value);
917:
918: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
919:
920: l_column_value := null;
921:
922: ELSE

Line 933: IF p_attribute8 = FND_API.G_MISS_CHAR THEN

929: FND_FLEX_DESCVAL.Set_Column_Value
930: ( column_name => 'ATTRIBUTE7'
931: , column_value => l_column_value);
932:
933: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
934:
935: l_column_value := null;
936:
937: ELSE

Line 948: IF p_attribute9 = FND_API.G_MISS_CHAR THEN

944: FND_FLEX_DESCVAL.Set_Column_Value
945: ( column_name => 'ATTRIBUTE8'
946: , column_value => l_column_value);
947:
948: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
949:
950: l_column_value := null;
951:
952: ELSE

Line 963: IF p_attribute10 = FND_API.G_MISS_CHAR THEN

959: FND_FLEX_DESCVAL.Set_Column_Value
960: ( column_name => 'ATTRIBUTE9'
961: , column_value => l_column_value);
962:
963: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
964:
965: l_column_value := null;
966:
967: ELSE

Line 978: IF p_attribute11 = FND_API.G_MISS_CHAR THEN

974: FND_FLEX_DESCVAL.Set_Column_Value
975: ( column_name => 'ATTRIBUTE10'
976: , column_value => l_column_value);
977:
978: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
979:
980: l_column_value := null;
981:
982: ELSE

Line 993: IF p_attribute12 = FND_API.G_MISS_CHAR THEN

989: FND_FLEX_DESCVAL.Set_Column_Value
990: ( column_name => 'ATTRIBUTE11'
991: , column_value => l_column_value);
992:
993: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
994:
995: l_column_value := null;
996:
997: ELSE

Line 1008: IF p_attribute13 = FND_API.G_MISS_CHAR THEN

1004: FND_FLEX_DESCVAL.Set_Column_Value
1005: ( column_name => 'ATTRIBUTE12'
1006: , column_value => l_column_value);
1007:
1008: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
1009:
1010: l_column_value := null;
1011:
1012: ELSE

Line 1023: IF p_attribute14 = FND_API.G_MISS_CHAR THEN

1019: FND_FLEX_DESCVAL.Set_Column_Value
1020: ( column_name => 'ATTRIBUTE13'
1021: , column_value => l_column_value);
1022:
1023: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
1024:
1025: l_column_value := null;
1026:
1027: ELSE

Line 1038: IF p_attribute15 = FND_API.G_MISS_CHAR THEN

1034: FND_FLEX_DESCVAL.Set_Column_Value
1035: ( column_name => 'ATTRIBUTE14'
1036: , column_value => l_column_value);
1037:
1038: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
1039:
1040: l_column_value := null;
1041:
1042: ELSE

Line 1053: IF p_context = FND_API.G_MISS_CHAR THEN

1049: FND_FLEX_DESCVAL.Set_Column_Value
1050: ( column_name => 'ATTRIBUTE15'
1051: , column_value => l_column_value);
1052:
1053: IF p_context = FND_API.G_MISS_CHAR THEN
1054:
1055: l_column_value := null;
1056:
1057: ELSE

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

1728:
1729: ELSE -- if the flex validation is successfull
1730:
1731: IF p_header_rec.context(i) IS NULL
1732: OR p_header_rec.context(i) = FND_API.G_MISS_CHAR THEN
1733: p_header_rec.context(i) := g_context;
1734: END IF;
1735:
1736: IF p_header_rec.attribute1(i) IS NULL

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

1733: p_header_rec.context(i) := g_context;
1734: END IF;
1735:
1736: IF p_header_rec.attribute1(i) IS NULL
1737: OR p_header_rec.attribute1(i) = FND_API.G_MISS_CHAR THEN
1738: p_header_rec.attribute1(i) := g_attribute1;
1739: END IF;
1740:
1741: IF p_header_rec.attribute2(i) IS NULL

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

1738: p_header_rec.attribute1(i) := g_attribute1;
1739: END IF;
1740:
1741: IF p_header_rec.attribute2(i) IS NULL
1742: OR p_header_rec.attribute2(i) = FND_API.G_MISS_CHAR THEN
1743: p_header_rec.attribute2(i) := g_attribute2;
1744: END IF;
1745:
1746: IF p_header_rec.attribute3(i) IS NULL

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

1743: p_header_rec.attribute2(i) := g_attribute2;
1744: END IF;
1745:
1746: IF p_header_rec.attribute3(i) IS NULL
1747: OR p_header_rec.attribute3(i) = FND_API.G_MISS_CHAR THEN
1748: p_header_rec.attribute3(i) := g_attribute3;
1749: END IF;
1750:
1751: IF p_header_rec.attribute4(i) IS NULL

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

1748: p_header_rec.attribute3(i) := g_attribute3;
1749: END IF;
1750:
1751: IF p_header_rec.attribute4(i) IS NULL
1752: OR p_header_rec.attribute4(i) = FND_API.G_MISS_CHAR THEN
1753: p_header_rec.attribute4(i) := g_attribute4;
1754: END IF;
1755:
1756: IF p_header_rec.attribute5(i) IS NULL

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

1753: p_header_rec.attribute4(i) := g_attribute4;
1754: END IF;
1755:
1756: IF p_header_rec.attribute5(i) IS NULL
1757: OR p_header_rec.attribute5(i) = FND_API.G_MISS_CHAR THEN
1758: p_header_rec.attribute5(i) := g_attribute5;
1759: END IF;
1760:
1761: IF p_header_rec.attribute6(i) IS NULL

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

1758: p_header_rec.attribute5(i) := g_attribute5;
1759: END IF;
1760:
1761: IF p_header_rec.attribute6(i) IS NULL
1762: OR p_header_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
1763: p_header_rec.attribute6(i) := g_attribute6;
1764: END IF;
1765: IF p_header_rec.attribute7(i) IS NULL
1766: OR p_header_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN

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

1762: OR p_header_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
1763: p_header_rec.attribute6(i) := g_attribute6;
1764: END IF;
1765: IF p_header_rec.attribute7(i) IS NULL
1766: OR p_header_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN
1767: p_header_rec.attribute7(i) := g_attribute7;
1768: END IF;
1769:
1770: IF p_header_rec.attribute8(i) IS NULL

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

1767: p_header_rec.attribute7(i) := g_attribute7;
1768: END IF;
1769:
1770: IF p_header_rec.attribute8(i) IS NULL
1771: OR p_header_rec.attribute8(i) = FND_API.G_MISS_CHAR THEN
1772: p_header_rec.attribute8(i) := g_attribute8;
1773: END IF;
1774:
1775: IF p_header_rec.attribute9(i) IS NULL

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

1772: p_header_rec.attribute8(i) := g_attribute8;
1773: END IF;
1774:
1775: IF p_header_rec.attribute9(i) IS NULL
1776: OR p_header_rec.attribute9(i) = FND_API.G_MISS_CHAR THEN
1777: p_header_rec.attribute9(i) := g_attribute9;
1778: END IF;
1779:
1780: IF p_header_rec.attribute10(i) IS NULL

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

1777: p_header_rec.attribute9(i) := g_attribute9;
1778: END IF;
1779:
1780: IF p_header_rec.attribute10(i) IS NULL
1781: OR p_header_rec.attribute10(i) = FND_API.G_MISS_CHAR THEN
1782: p_header_rec.attribute10(i) := G_attribute10;
1783: End IF;
1784:
1785: IF p_header_rec.attribute11(i) IS NULL

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

1782: p_header_rec.attribute10(i) := G_attribute10;
1783: End IF;
1784:
1785: IF p_header_rec.attribute11(i) IS NULL
1786: OR p_header_rec.attribute11(i) = FND_API.G_MISS_CHAR THEN
1787: p_header_rec.attribute11(i) := g_attribute11;
1788: END IF;
1789:
1790: IF p_header_rec.attribute12(i) IS NULL

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

1787: p_header_rec.attribute11(i) := g_attribute11;
1788: END IF;
1789:
1790: IF p_header_rec.attribute12(i) IS NULL
1791: OR p_header_rec.attribute12(i) = FND_API.G_MISS_CHAR THEN
1792: p_header_rec.attribute12(i) := g_attribute12;
1793: END IF;
1794:
1795: IF p_header_rec.attribute13(i) IS NULL

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

1792: p_header_rec.attribute12(i) := g_attribute12;
1793: END IF;
1794:
1795: IF p_header_rec.attribute13(i) IS NULL
1796: OR p_header_rec.attribute13(i) = FND_API.G_MISS_CHAR THEN
1797: p_header_rec.attribute13(i) := g_attribute13;
1798: END IF;
1799:
1800: IF p_header_rec.attribute14(i) IS NULL

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

1797: p_header_rec.attribute13(i) := g_attribute13;
1798: END IF;
1799:
1800: IF p_header_rec.attribute14(i) IS NULL
1801: OR p_header_rec.attribute14(i) = FND_API.G_MISS_CHAR THEN
1802: p_header_rec.attribute14(i) := g_attribute14;
1803: END IF;
1804:
1805: IF p_header_rec.attribute15(i) IS NULL

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

1802: p_header_rec.attribute14(i) := g_attribute14;
1803: END IF;
1804:
1805: IF p_header_rec.attribute15(i) IS NULL
1806: OR p_header_rec.attribute15(i) = FND_API.G_MISS_CHAR THEN
1807: p_header_rec.attribute15(i) := g_attribute15;
1808: END IF;
1809: END IF;
1810: END IF; --l_header_flex_enabled = 'Y'

Line 1850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1846:
1847: qp_bulk_loader_pub.write_log('Leaving Entity_header validation');
1848:
1849: EXCEPTION
1850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1851: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_HEADER:'||sqlerrm);
1852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1853: WHEN OTHERS THEN
1854: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_HEADER:'||sqlerrm);

Line 1852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1848:
1849: EXCEPTION
1850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1851: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_HEADER:'||sqlerrm);
1852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1853: WHEN OTHERS THEN
1854: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_HEADER:'||sqlerrm);
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END ENTITY_HEADER;

Line 1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1851: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_HEADER:'||sqlerrm);
1852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1853: WHEN OTHERS THEN
1854: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_HEADER:'||sqlerrm);
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END ENTITY_HEADER;
1857:
1858:
1859: PROCEDURE ENTITY_LINE

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

2605:
2606: ELSE -- if the flex validation is successfull
2607:
2608: IF p_line_rec.context(i) IS NULL
2609: OR p_line_rec.context(i) = FND_API.G_MISS_CHAR THEN
2610: p_line_rec.context(i) := g_context;
2611: END IF;
2612:
2613: IF p_line_rec.attribute1(i) IS NULL

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

2610: p_line_rec.context(i) := g_context;
2611: END IF;
2612:
2613: IF p_line_rec.attribute1(i) IS NULL
2614: OR p_line_rec.attribute1(i) = FND_API.G_MISS_CHAR THEN
2615: p_line_rec.attribute1(i) := g_attribute1;
2616: END IF;
2617:
2618: IF p_line_rec.attribute2(i) IS NULL

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

2615: p_line_rec.attribute1(i) := g_attribute1;
2616: END IF;
2617:
2618: IF p_line_rec.attribute2(i) IS NULL
2619: OR p_line_rec.attribute2(i) = FND_API.G_MISS_CHAR THEN
2620: p_line_rec.attribute2(i) := g_attribute2;
2621: END IF;
2622:
2623: IF p_line_rec.attribute3(i) IS NULL

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

2620: p_line_rec.attribute2(i) := g_attribute2;
2621: END IF;
2622:
2623: IF p_line_rec.attribute3(i) IS NULL
2624: OR p_line_rec.attribute3(i) = FND_API.G_MISS_CHAR THEN
2625: p_line_rec.attribute3(i) := g_attribute3;
2626: END IF;
2627:
2628: IF p_line_rec.attribute4(i) IS NULL

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

2625: p_line_rec.attribute3(i) := g_attribute3;
2626: END IF;
2627:
2628: IF p_line_rec.attribute4(i) IS NULL
2629: OR p_line_rec.attribute4(i) = FND_API.G_MISS_CHAR THEN
2630: p_line_rec.attribute4(i) := g_attribute4;
2631: END IF;
2632:
2633: IF p_line_rec.attribute5(i) IS NULL

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

2630: p_line_rec.attribute4(i) := g_attribute4;
2631: END IF;
2632:
2633: IF p_line_rec.attribute5(i) IS NULL
2634: OR p_line_rec.attribute5(i) = FND_API.G_MISS_CHAR THEN
2635: p_line_rec.attribute5(i) := g_attribute5;
2636: END IF;
2637:
2638: IF p_line_rec.attribute6(i) IS NULL

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

2635: p_line_rec.attribute5(i) := g_attribute5;
2636: END IF;
2637:
2638: IF p_line_rec.attribute6(i) IS NULL
2639: OR p_line_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
2640: p_line_rec.attribute6(i) := g_attribute6;
2641: END IF;
2642: IF p_line_rec.attribute7(i) IS NULL
2643: OR p_line_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN

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

2639: OR p_line_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
2640: p_line_rec.attribute6(i) := g_attribute6;
2641: END IF;
2642: IF p_line_rec.attribute7(i) IS NULL
2643: OR p_line_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN
2644: p_line_rec.attribute7(i) := g_attribute7;
2645: END IF;
2646:
2647: IF p_line_rec.attribute8(i) IS NULL

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

2644: p_line_rec.attribute7(i) := g_attribute7;
2645: END IF;
2646:
2647: IF p_line_rec.attribute8(i) IS NULL
2648: OR p_line_rec.attribute8(i) = FND_API.G_MISS_CHAR THEN
2649: p_line_rec.attribute8(i) := g_attribute8;
2650: END IF;
2651:
2652: IF p_line_rec.attribute9(i) IS NULL

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

2649: p_line_rec.attribute8(i) := g_attribute8;
2650: END IF;
2651:
2652: IF p_line_rec.attribute9(i) IS NULL
2653: OR p_line_rec.attribute9(i) = FND_API.G_MISS_CHAR THEN
2654: p_line_rec.attribute9(i) := g_attribute9;
2655: END IF;
2656:
2657: IF p_line_rec.attribute10(i) IS NULL

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

2654: p_line_rec.attribute9(i) := g_attribute9;
2655: END IF;
2656:
2657: IF p_line_rec.attribute10(i) IS NULL
2658: OR p_line_rec.attribute10(i) = FND_API.G_MISS_CHAR THEN
2659: p_line_rec.attribute10(i) := G_attribute10;
2660: End IF;
2661:
2662: IF p_line_rec.attribute11(i) IS NULL

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

2659: p_line_rec.attribute10(i) := G_attribute10;
2660: End IF;
2661:
2662: IF p_line_rec.attribute11(i) IS NULL
2663: OR p_line_rec.attribute11(i) = FND_API.G_MISS_CHAR THEN
2664: p_line_rec.attribute11(i) := g_attribute11;
2665: END IF;
2666:
2667: IF p_line_rec.attribute12(i) IS NULL

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

2664: p_line_rec.attribute11(i) := g_attribute11;
2665: END IF;
2666:
2667: IF p_line_rec.attribute12(i) IS NULL
2668: OR p_line_rec.attribute12(i) = FND_API.G_MISS_CHAR THEN
2669: p_line_rec.attribute12(i) := g_attribute12;
2670: END IF;
2671:
2672: IF p_line_rec.attribute13(i) IS NULL

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

2669: p_line_rec.attribute12(i) := g_attribute12;
2670: END IF;
2671:
2672: IF p_line_rec.attribute13(i) IS NULL
2673: OR p_line_rec.attribute13(i) = FND_API.G_MISS_CHAR THEN
2674: p_line_rec.attribute13(i) := g_attribute13;
2675: END IF;
2676:
2677: IF p_line_rec.attribute14(i) IS NULL

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

2674: p_line_rec.attribute13(i) := g_attribute13;
2675: END IF;
2676:
2677: IF p_line_rec.attribute14(i) IS NULL
2678: OR p_line_rec.attribute14(i) = FND_API.G_MISS_CHAR THEN
2679: p_line_rec.attribute14(i) := g_attribute14;
2680: END IF;
2681:
2682: IF p_line_rec.attribute15(i) IS NULL

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

2679: p_line_rec.attribute14(i) := g_attribute14;
2680: END IF;
2681:
2682: IF p_line_rec.attribute15(i) IS NULL
2683: OR p_line_rec.attribute15(i) = FND_API.G_MISS_CHAR THEN
2684: p_line_rec.attribute15(i) := g_attribute15;
2685: END IF;
2686: END IF;
2687: END IF;

Line 2720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2716:
2717: qp_bulk_loader_pub.write_log('Leaving entity line validation');
2718:
2719: EXCEPTION
2720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2721: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_LINE:'||sqlerrm);
2722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2723: WHEN OTHERS THEN
2724: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_LINE:'||sqlerrm);

Line 2722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2718:
2719: EXCEPTION
2720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2721: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_LINE:'||sqlerrm);
2722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2723: WHEN OTHERS THEN
2724: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_LINE:'||sqlerrm);
2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: END ENTITY_LINE;

Line 2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2721: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_LINE:'||sqlerrm);
2722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2723: WHEN OTHERS THEN
2724: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_LINE:'||sqlerrm);
2725: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2726: END ENTITY_LINE;
2727:
2728:
2729: PROCEDURE ENTITY_QUALIFIER

Line 3382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3378:
3379: qp_bulk_loader_pub.write_log('Leaving Entity qualifier validation');
3380:
3381: EXCEPTION
3382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3383: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_QUALIFIER:'||sqlerrm);
3384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3385: WHEN OTHERS THEN
3386: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_QUALIFIER:'||sqlerrm);

Line 3384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3380:
3381: EXCEPTION
3382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3383: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_QUALIFIER:'||sqlerrm);
3384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3385: WHEN OTHERS THEN
3386: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_QUALIFIER:'||sqlerrm);
3387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3388:

Line 3387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3383: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_QUALIFIER:'||sqlerrm);
3384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3385: WHEN OTHERS THEN
3386: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_QUALIFIER:'||sqlerrm);
3387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3388:
3389:
3390: END ENTITY_QUALIFIER;
3391:

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

4872:
4873: ELSE -- if the flex validation is successfull
4874:
4875: IF p_pricing_attr_rec.context(i) IS NULL
4876: OR p_pricing_attr_rec.context(i) = FND_API.G_MISS_CHAR THEN
4877: p_pricing_attr_rec.context(i) := g_context;
4878: END IF;
4879:
4880: IF p_pricing_attr_rec.attribute1(i) IS NULL

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

4877: p_pricing_attr_rec.context(i) := g_context;
4878: END IF;
4879:
4880: IF p_pricing_attr_rec.attribute1(i) IS NULL
4881: OR p_pricing_attr_rec.attribute1(i) = FND_API.G_MISS_CHAR THEN
4882: p_pricing_attr_rec.attribute1(i) := g_attribute1;
4883: END IF;
4884:
4885: IF p_pricing_attr_rec.attribute2(i) IS NULL

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

4882: p_pricing_attr_rec.attribute1(i) := g_attribute1;
4883: END IF;
4884:
4885: IF p_pricing_attr_rec.attribute2(i) IS NULL
4886: OR p_pricing_attr_rec.attribute2(i) = FND_API.G_MISS_CHAR THEN
4887: p_pricing_attr_rec.attribute2(i) := g_attribute2;
4888: END IF;
4889:
4890: IF p_pricing_attr_rec.attribute3(i) IS NULL

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

4887: p_pricing_attr_rec.attribute2(i) := g_attribute2;
4888: END IF;
4889:
4890: IF p_pricing_attr_rec.attribute3(i) IS NULL
4891: OR p_pricing_attr_rec.attribute3(i) = FND_API.G_MISS_CHAR THEN
4892: p_pricing_attr_rec.attribute3(i) := g_attribute3;
4893: END IF;
4894:
4895: IF p_pricing_attr_rec.attribute4(i) IS NULL

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

4892: p_pricing_attr_rec.attribute3(i) := g_attribute3;
4893: END IF;
4894:
4895: IF p_pricing_attr_rec.attribute4(i) IS NULL
4896: OR p_pricing_attr_rec.attribute4(i) = FND_API.G_MISS_CHAR THEN
4897: p_pricing_attr_rec.attribute4(i) := g_attribute4;
4898: END IF;
4899:
4900: IF p_pricing_attr_rec.attribute5(i) IS NULL

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

4897: p_pricing_attr_rec.attribute4(i) := g_attribute4;
4898: END IF;
4899:
4900: IF p_pricing_attr_rec.attribute5(i) IS NULL
4901: OR p_pricing_attr_rec.attribute5(i) = FND_API.G_MISS_CHAR THEN
4902: p_pricing_attr_rec.attribute5(i) := g_attribute5;
4903: END IF;
4904:
4905: IF p_pricing_attr_rec.attribute6(i) IS NULL

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

4902: p_pricing_attr_rec.attribute5(i) := g_attribute5;
4903: END IF;
4904:
4905: IF p_pricing_attr_rec.attribute6(i) IS NULL
4906: OR p_pricing_attr_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
4907: p_pricing_attr_rec.attribute6(i) := g_attribute6;
4908: END IF;
4909: IF p_pricing_attr_rec.attribute7(i) IS NULL
4910: OR p_pricing_attr_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN

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

4906: OR p_pricing_attr_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
4907: p_pricing_attr_rec.attribute6(i) := g_attribute6;
4908: END IF;
4909: IF p_pricing_attr_rec.attribute7(i) IS NULL
4910: OR p_pricing_attr_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN
4911: p_pricing_attr_rec.attribute7(i) := g_attribute7;
4912: END IF;
4913:
4914: IF p_pricing_attr_rec.attribute8(i) IS NULL

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

4911: p_pricing_attr_rec.attribute7(i) := g_attribute7;
4912: END IF;
4913:
4914: IF p_pricing_attr_rec.attribute8(i) IS NULL
4915: OR p_pricing_attr_rec.attribute8(i) = FND_API.G_MISS_CHAR THEN
4916: p_pricing_attr_rec.attribute8(i) := g_attribute8;
4917: END IF;
4918:
4919: IF p_pricing_attr_rec.attribute9(i) IS NULL

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

4916: p_pricing_attr_rec.attribute8(i) := g_attribute8;
4917: END IF;
4918:
4919: IF p_pricing_attr_rec.attribute9(i) IS NULL
4920: OR p_pricing_attr_rec.attribute9(i) = FND_API.G_MISS_CHAR THEN
4921: p_pricing_attr_rec.attribute9(i) := g_attribute9;
4922: END IF;
4923:
4924: IF p_pricing_attr_rec.attribute10(i) IS NULL

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

4921: p_pricing_attr_rec.attribute9(i) := g_attribute9;
4922: END IF;
4923:
4924: IF p_pricing_attr_rec.attribute10(i) IS NULL
4925: OR p_pricing_attr_rec.attribute10(i) = FND_API.G_MISS_CHAR THEN
4926: p_pricing_attr_rec.attribute10(i) := G_attribute10;
4927: End IF;
4928:
4929: IF p_pricing_attr_rec.attribute11(i) IS NULL

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

4926: p_pricing_attr_rec.attribute10(i) := G_attribute10;
4927: End IF;
4928:
4929: IF p_pricing_attr_rec.attribute11(i) IS NULL
4930: OR p_pricing_attr_rec.attribute11(i) = FND_API.G_MISS_CHAR THEN
4931: p_pricing_attr_rec.attribute11(i) := g_attribute11;
4932: END IF;
4933:
4934: IF p_pricing_attr_rec.attribute12(i) IS NULL

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

4931: p_pricing_attr_rec.attribute11(i) := g_attribute11;
4932: END IF;
4933:
4934: IF p_pricing_attr_rec.attribute12(i) IS NULL
4935: OR p_pricing_attr_rec.attribute12(i) = FND_API.G_MISS_CHAR THEN
4936: p_pricing_attr_rec.attribute12(i) := g_attribute12;
4937: END IF;
4938:
4939: IF p_pricing_attr_rec.attribute13(i) IS NULL

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

4936: p_pricing_attr_rec.attribute12(i) := g_attribute12;
4937: END IF;
4938:
4939: IF p_pricing_attr_rec.attribute13(i) IS NULL
4940: OR p_pricing_attr_rec.attribute13(i) = FND_API.G_MISS_CHAR THEN
4941: p_pricing_attr_rec.attribute13(i) := g_attribute13;
4942: END IF;
4943:
4944: IF p_pricing_attr_rec.attribute14(i) IS NULL

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

4941: p_pricing_attr_rec.attribute13(i) := g_attribute13;
4942: END IF;
4943:
4944: IF p_pricing_attr_rec.attribute14(i) IS NULL
4945: OR p_pricing_attr_rec.attribute14(i) = FND_API.G_MISS_CHAR THEN
4946: p_pricing_attr_rec.attribute14(i) := g_attribute14;
4947: END IF;
4948:
4949: IF p_pricing_attr_rec.attribute15(i) IS NULL

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

4946: p_pricing_attr_rec.attribute14(i) := g_attribute14;
4947: END IF;
4948:
4949: IF p_pricing_attr_rec.attribute15(i) IS NULL
4950: OR p_pricing_attr_rec.attribute15(i) = FND_API.G_MISS_CHAR THEN
4951: p_pricing_attr_rec.attribute15(i) := g_attribute15;
4952: END IF;
4953: END IF;
4954: END IF;

Line 5074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5070:
5071: qp_bulk_loader_pub.write_log( 'Leaving Entity Pricing Attr validation');
5072:
5073: EXCEPTION
5074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5075: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_PRICING_ATTR:'||sqlerrm);
5076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5077: WHEN OTHERS THEN
5078: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_PRICING_ATTR:'||sqlerrm);

Line 5076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5072:
5073: EXCEPTION
5074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5075: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_PRICING_ATTR:'||sqlerrm);
5076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5077: WHEN OTHERS THEN
5078: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_PRICING_ATTR:'||sqlerrm);
5079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5080:

Line 5079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5075: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_PRICING_ATTR:'||sqlerrm);
5076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5077: WHEN OTHERS THEN
5078: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ENTITY_PRICING_ATTR:'||sqlerrm);
5079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5080:
5081:
5082: END ENTITY_PRICING_ATTR;
5083:

Line 5737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5733:
5734: qp_bulk_loader_pub.write_log('Leaving Attribute Header validation');
5735:
5736: EXCEPTION
5737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5738: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_HEADER:'||sqlerrm);
5739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5740: WHEN OTHERS THEN
5741: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_HEADER:'||sqlerrm);

Line 5739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5735:
5736: EXCEPTION
5737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5738: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_HEADER:'||sqlerrm);
5739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5740: WHEN OTHERS THEN
5741: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_HEADER:'||sqlerrm);
5742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5743:

Line 5742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5738: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_HEADER:'||sqlerrm);
5739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5740: WHEN OTHERS THEN
5741: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_HEADER:'||sqlerrm);
5742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5743:
5744: END ATTRIBUTE_HEADER;
5745:
5746:

Line 5978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5974:
5975: qp_bulk_loader_pub.write_log('Leaving Attribute qualifier validation');
5976:
5977: EXCEPTION
5978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5979: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_QUALIFIER:'||sqlerrm);
5980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5981: WHEN OTHERS THEN
5982: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_QUALIFIER:'||sqlerrm);

Line 5980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5976:
5977: EXCEPTION
5978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5979: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_QUALIFIER:'||sqlerrm);
5980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5981: WHEN OTHERS THEN
5982: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_QUALIFIER:'||sqlerrm);
5983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5984:

Line 5983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5979: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_QUALIFIER:'||sqlerrm);
5980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5981: WHEN OTHERS THEN
5982: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_QUALIFIER:'||sqlerrm);
5983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5984:
5985: END ATTRIBUTE_QUALIFIER;
5986:
5987:

Line 6701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6697: --Bug# 5456164 END RAVI
6698:
6699: qp_bulk_loader_pub.write_log('Leaving Attribute Line validation');
6700: EXCEPTION
6701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6702: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_LINE:'||sqlerrm);
6703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6704: WHEN OTHERS THEN
6705: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_LINE:'||sqlerrm);

Line 6703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6699: qp_bulk_loader_pub.write_log('Leaving Attribute Line validation');
6700: EXCEPTION
6701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6702: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_LINE:'||sqlerrm);
6703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6704: WHEN OTHERS THEN
6705: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_LINE:'||sqlerrm);
6706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6707: END ATTRIBUTE_LINE;

Line 6706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6702: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_LINE:'||sqlerrm);
6703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6704: WHEN OTHERS THEN
6705: qp_bulk_loader_pub.write_log( 'UNEXCPECTED ERROR IN PROCEDURE ATTRIBUTE_LINE:'||sqlerrm);
6706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6707: END ATTRIBUTE_LINE;
6708:
6709:
6710: PROCEDURE MARK_ERRORED_INTERFACE_RECORD

Line 6775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6771:
6772: qp_bulk_loader_pub.write_log('Entering Mark errored inreface record');
6773:
6774: EXCEPTION
6775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6776: qp_bulk_loader_pub.write_log(
6777: 'UNEXCPECTED ERROR IN PROCEDURE MARK_ERRORED_INTERFACE_RECORD:'||sqlerrm);
6778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6779: WHEN OTHERS THEN

Line 6778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6774: EXCEPTION
6775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6776: qp_bulk_loader_pub.write_log(
6777: 'UNEXCPECTED ERROR IN PROCEDURE MARK_ERRORED_INTERFACE_RECORD:'||sqlerrm);
6778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6779: WHEN OTHERS THEN
6780: qp_bulk_loader_pub.write_log(
6781: 'UNEXCPECTED ERROR IN PROCEDURE MARK_ERRORED_INTERFACE_RECORD:'||sqlerrm);
6782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 6782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6779: WHEN OTHERS THEN
6780: qp_bulk_loader_pub.write_log(
6781: 'UNEXCPECTED ERROR IN PROCEDURE MARK_ERRORED_INTERFACE_RECORD:'||sqlerrm);
6782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6783:
6784: END MARK_ERRORED_INTERFACE_RECORD;
6785:
6786: END QP_BULK_VALIDATE;