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

Line 403: x_return_status := FND_API.G_RET_STS_SUCCESS;

399:
400:
401: BEGIN
402:
403: x_return_status := FND_API.G_RET_STS_SUCCESS;
404:
405: d_progress := 10;
406: PO_UDA_DEFAULTING_PKG.DEBUG('Starting PO_UDA_DEFAULTING_PKG.CONSTRUCT_USAGE_OBJECT_ARRAY with parameters' , d_progress);
407: PO_UDA_DEFAULTING_PKG.DEBUG('p_pk1_value :' || p_pk1_value, d_progress);

Line 628: x_return_status := FND_API.G_RET_STS_SUCCESS;

624: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs are as Follows', d_progress);
625: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
626: d_progress := 10;
627:
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629:
630: IF p_template_id IS NULL THEN
631: d_progress := 20;
632: x_return_status := 'E';

Line 898: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

894: d_progress := 580;
895: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized objects l_attributes_row_table, l_attr_name_value_pairs' , d_progress);
896:
897: PO_UDA_DEFAULTING_PKG.DEBUG('x_return_status : ' || x_return_status , d_progress);
898: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
899:
900: d_progress := 590;
901: PO_UDA_DEFAULTING_PKG.DEBUG('Before ego_user_attrs_data_pub.Get_User_Attrs_Data', d_progress);
902: PO_UDA_DEFAULTING_PKG.DEBUG('p_object_name : ' || PO_UDA_DATA_UTIL.g_object_dff_tl(l_entity_code).l_object_name, d_progress);

Line 940: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

936: END IF;
937:
938: d_progress := 610;
939:
940: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
941: d_progress := 620;
942: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XSC) ' || x_return_status, d_progress);
943: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
944: (

Line 1054: g_xsc_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;

1050: l_vendor_id NUMBER;
1051: l_vendor_site_id NUMBER;
1052: l_vendor_contact_id NUMBER;
1053:
1054: g_xsc_return_status VARCHAR2(3) := FND_API.G_RET_STS_SUCCESS;
1055: ext_name_val_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
1056:
1057: l_err_txt VARCHAR2(2000);
1058:

Line 1068: x_return_status := FND_API.G_RET_STS_SUCCESS;

1064: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows ', d_progress);
1065: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1066: d_progress := 10;
1067:
1068: x_return_status := FND_API.G_RET_STS_SUCCESS;
1069: BEGIN
1070: d_progress := 20;
1071: SELECT VENDOR_ID, VENDOR_SITE_ID, VENDOR_CONTACT_ID
1072: INTO l_vendor_id, l_vendor_site_id, l_vendor_contact_id

Line 1089: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, x_external_attr_value_pairs);

1085: RAISE;
1086: END;
1087: d_progress := 50;
1088:
1089: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, x_external_attr_value_pairs);
1090: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', x_external_attr_value_pairs);
1091: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', x_external_attr_value_pairs);
1092: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', x_external_attr_value_pairs);
1093: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('VENDOR_CONTACT_ID', l_vendor_contact_id || '', x_external_attr_value_pairs);

Line 1148: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN -- LOOP FOR ALL THE LINES DEFUALTING

1144: g_xsc_return_status := ext_name_val_obj.VALUE ;
1145:
1146: d_progress := 150;
1147: PO_UDA_DEFAULTING_PKG.DEBUG('Looping for Submission Check for lines', d_progress);
1148: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN -- LOOP FOR ALL THE LINES DEFUALTING
1149: d_progress := 160;
1150: FOR c_get_lines_rec IN c_get_lines(p_po_header_id, p_draft_id) LOOP
1151: d_progress := 170;
1152: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('ITEM_ID', c_get_lines_rec.ITEM_ID || '', x_external_attr_value_pairs);

Line 1192: IF g_xsc_return_status = FND_API.G_RET_STS_SUCCESS THEN

1188: );
1189: d_progress := 240;
1190: PO_UDA_DEFAULTING_PKG.DEBUG('After UDA_SUBMISSION_CHECK for line : ' || x_return_status, d_progress);
1191: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', x_external_attr_value_pairs, ext_name_val_obj);
1192: IF g_xsc_return_status = FND_API.G_RET_STS_SUCCESS THEN
1193: d_progress := 250;
1194: g_xsc_return_status := ext_name_val_obj.VALUE ;
1195: END IF;
1196:

Line 1199: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN -- LOOP FOR ALL THE SHIPMENTS DEFUALTING

1195: END IF;
1196:
1197: d_progress := 260;
1198: PO_UDA_DEFAULTING_PKG.DEBUG('Looping for Submission Check for Shipments', d_progress);
1199: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN -- LOOP FOR ALL THE SHIPMENTS DEFUALTING
1200: d_progress := 270;
1201: FOR c_get_shipments_rec IN c_get_shipments(p_po_header_id, c_get_lines_rec.PO_LINE_ID, p_draft_id) LOOP
1202: d_progress := 280;
1203: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('SHIP_TO_LOC_ID', c_get_lines_rec.ITEM_ID || '', x_external_attr_value_pairs);

Line 1241: IF g_xsc_return_status = FND_API.G_RET_STS_SUCCESS THEN

1237: );
1238: d_progress := 340;
1239: PO_UDA_DEFAULTING_PKG.DEBUG('After UDA_SUBMISSION_CHECK for shipment : ' || x_return_status, d_progress);
1240: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', x_external_attr_value_pairs, ext_name_val_obj);
1241: IF g_xsc_return_status = FND_API.G_RET_STS_SUCCESS THEN
1242: d_progress := 350;
1243: g_xsc_return_status := ext_name_val_obj.VALUE ;
1244: END IF;
1245:

Line 1351: x_return_status := FND_API.G_RET_STS_SUCCESS;

1347: PO_UDA_DEFAULTING_PKG.DEBUG('Starting PO_UDA_DEFAULTING_PKG.DEFAULTING_NON_RENDERERED_AGS with parameters' , d_progress);
1348: PO_UDA_DEFAULTING_PKG.DEBUG(' p_po_header_id :' || p_po_header_id, d_progress);
1349: PO_UDA_DEFAULTING_PKG.DEBUG(' p_draft_id :' || p_draft_id, d_progress);
1350: PO_UDA_DEFAULTING_PKG.DEBUG(' p_doc_type :' || p_doc_type, d_progress);
1351: x_return_status := FND_API.G_RET_STS_SUCCESS;
1352:
1353: d_progress := 20;
1354: BEGIN
1355: d_progress := 30;

Line 1493: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN -- LOOP FOR ALL THE LINES DEFUALTING

1489: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('AGENT_ID', l_agent_id || '', x_external_attr_value_pairs);
1490: END;
1491: d_progress := 200;
1492: PO_UDA_DEFAULTING_PKG.DEBUG('Before Looping for Lines', d_progress);
1493: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN -- LOOP FOR ALL THE LINES DEFUALTING
1494: d_progress := 210;
1495: FOR c_get_lines_rec IN c_get_lines(p_po_header_id, p_draft_id) LOOP
1496: d_progress := 220;
1497: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('ITEM_ID', c_get_lines_rec.ITEM_ID || '', x_external_attr_value_pairs);

Line 1587: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN -- LOOP FOR ALL THE SHIPMENTS DEFUALTING

1583: NULL; -- (In case Line is not dirty)
1584: END;
1585: PO_UDA_DEFAULTING_PKG.DEBUG('Before Looping for Shipments', d_progress);
1586: d_progress := 330;
1587: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN -- LOOP FOR ALL THE SHIPMENTS DEFUALTING
1588: d_progress := 340;
1589: FOR c_get_shipments_rec IN c_get_shipments(p_po_header_id, c_get_lines_rec.PO_LINE_ID, p_draft_id) LOOP
1590: d_progress := 350;
1591: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('SHIP_TO_LOC_ID', c_get_shipments_rec.SHIP_TO_LOCATION_ID || '', x_external_attr_value_pairs);

Line 1774: x_return_status := FND_API.G_RET_STS_SUCCESS;

1770: PO_UDA_DEFAULTING_PKG.DEBUG('p_address_lookup_type : ' || p_address_lookup_type, d_progress);
1771: PO_UDA_DEFAULTING_PKG.DEBUG('x_external_attr_value_pairs is as follows :', d_progress);
1772: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1773:
1774: x_return_status := FND_API.G_RET_STS_SUCCESS;
1775: d_progress := 20;
1776: IF p_template_id IS NULL THEN
1777: d_progress := 30;
1778: x_return_status := 'E';

Line 1801: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1797: );
1798: d_progress := 50;
1799: PO_UDA_DEFAULTING_PKG.DEBUG('After CONSTRUCT_USAGE_OBJECT_ARRAY ' || x_return_status, d_progress);
1800:
1801: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1802: d_progress := 60;
1803: PO_UDA_DEFAULTING_PKG.DEBUG('Before DEFAULT_AGS_FROM_USAGE_OBJECT ' || x_return_status, d_progress);
1804: PO_UDA_DEFAULTING_PKG.DEFAULT_AGS_FROM_USAGE_OBJECT
1805: (

Line 1923: x_return_status := FND_API.G_RET_STS_SUCCESS;

1919: PO_UDA_DEFAULTING_PKG.DEBUG(x_external_attr_value_pairs, d_progress);
1920: PO_UDA_DEFAULTING_PKG.DEBUG('x_po_uda_usage_object_array is as follows :', d_progress);
1921: PO_UDA_DEFAULTING_PKG.DEBUG(x_po_uda_usage_object_array, d_progress);
1922:
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924: BEGIN
1925: d_progress := 20;
1926: SELECT ENTITY_CODE
1927: INTO l_entity_code

Line 1974: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, x_external_attr_value_pairs);

1970: l_base_object_name := PO_UDA_DATA_UTIL.g_object_dff_tl(l_entity_code).l_object_name;
1971: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name is : ' || l_base_object_name, d_progress);
1972: d_progress := 100;
1973:
1974: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, x_external_attr_value_pairs);
1975: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', x_external_attr_value_pairs);
1976: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', x_external_attr_value_pairs);
1977: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', x_external_attr_value_pairs);
1978: d_progress := 110;

Line 1980: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1976: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', x_external_attr_value_pairs);
1977: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', x_external_attr_value_pairs);
1978: d_progress := 110;
1979:
1980: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1981: d_progress := 120;
1982: PO_UDA_DEFAULTING_PKG.DEBUG('Before POPULATE_EMPTY_AGS ' || x_return_status, d_progress);
1983: PO_UDA_IMPORT_PKG.POPULATE_EMPTY_AGS
1984: (

Line 2001: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1997: d_progress := 130;
1998: PO_UDA_DEFAULTING_PKG.DEBUG('After POPULATE_EMPTY_AGS ' || x_return_status, d_progress);
1999: END IF;
2000: d_progress := 140;
2001: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2002: d_progress := 150;
2003: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XD) ' || x_return_status, d_progress);
2004: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
2005: (

Line 2021: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2017: d_progress := 160;
2018: PO_UDA_DEFAULTING_PKG.DEBUG('After EXECUTE_IMPORT_UDA_FUNCTION (XD) ' || x_return_status, d_progress);
2019: END IF;
2020: d_progress := 170;
2021: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2022: d_progress := 180;
2023: PO_UDA_DEFAULTING_PKG.DEBUG('Before VALIDATE_ROW ' || x_return_status, d_progress);
2024: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
2025: IF l_attributes_row_table.COUNT > 0 THEN

Line 2046: ,p_validate_only => FND_API.G_TRUE

2042: ,p_attributes_row_table => l_attributes_row_table
2043: ,p_attributes_data_table => l_attr_name_value_pairs
2044: ,p_pk_column_name_value_pairs => l_pk_column_name_value_pairs
2045: ,p_class_code_name_value_pairs => l_class_code_name_value_pairs
2046: ,p_validate_only => FND_API.G_TRUE
2047: ,x_failed_row_id_list => l_failed_row_id_list
2048: ,x_return_status => x_return_status
2049: ,x_errorcode => x_errorcode
2050: ,x_msg_count => x_msg_count

Line 2067: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2063: d_progress := 230;
2064: PO_UDA_DEFAULTING_PKG.DEBUG('After VALIDATE_ROW ' || x_return_status, d_progress);
2065: END IF;
2066:
2067: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2068: d_progress := 240;
2069: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XV) ' || x_return_status, d_progress);
2070: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
2071: IF l_attributes_row_table.COUNT > 0 THEN

Line 2097: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND ext_name_val_obj.VALUE = FND_API.G_RET_STS_SUCCESS THEN

2093: END IF;
2094: d_progress := 290;
2095:
2096: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', x_external_attr_value_pairs, ext_name_val_obj);
2097: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND ext_name_val_obj.VALUE = FND_API.G_RET_STS_SUCCESS THEN
2098: d_progress := 300;
2099: PO_UDA_DEFAULTING_PKG.DEBUG('Before Process_User_Attrs_Data ' || x_return_status, d_progress);
2100: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
2101: IF l_attributes_row_table.COUNT > 0 THEN

Line 2140: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2136: PO_UDA_DEFAULTING_PKG.DEBUG('Not calling EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data as l_attributes_row_table.COUNT <=0', d_progress);
2137: END IF;
2138: END IF;
2139: d_progress := 350;
2140: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2141: d_progress := 360;
2142: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION (XPD) ' || x_return_status, d_progress);
2143: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
2144: IF l_attributes_row_table.COUNT > 0 THEN

Line 2267: x_return_status := FND_API.G_RET_STS_SUCCESS;

2263: PO_UDA_DEFAULTING_PKG.DEBUG('p_event_type :' || p_event_type, d_progress);
2264:
2265: d_progress := 10;
2266:
2267: x_return_status := FND_API.G_RET_STS_SUCCESS;
2268: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
2269: l_attr_group_request_table := EGO_ATTR_GROUP_REQUEST_TABLE();
2270:
2271: PO_UDA_DEFAULTING_PKG.DEBUG('Initialized l_pk_column_name_value_pairs, l_attr_group_request_table', d_progress);

Line 2517: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);

2513: ,p_template_id || ''
2514: )
2515: );
2516:
2517: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', FND_API.G_RET_STS_SUCCESS, l_external_attr_value_pairs);
2518: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_errorcode', '0', l_external_attr_value_pairs);
2519: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_count', '0', l_external_attr_value_pairs);
2520: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('x_msg_data', 'SUCCESS', l_external_attr_value_pairs);
2521:

Line 2531: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2527:
2528: l_base_object_name := PO_UDA_DATA_UTIL.g_object_dff_tl(l_entity_code).l_object_name;
2529: PO_UDA_DEFAULTING_PKG.DEBUG('l_base_object_name is : ' || l_base_object_name, d_progress);
2530:
2531: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2532:
2533: PO_UDA_DEFAULTING_PKG.DEBUG('Before ego_user_attrs_data_pub.Get_User_Attrs_Data', d_progress);
2534: PO_UDA_DEFAULTING_PKG.DEBUG('p_object_name : ' || PO_UDA_DATA_UTIL.g_object_dff_tl(l_entity_code).l_object_name, d_progress);
2535: PO_UDA_DEFAULTING_PKG.DEBUG('l_pk_column_name_value_pairs is as follows ', d_progress);

Line 2571: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

2567: END IF;
2568:
2569: d_progress := 120;
2570:
2571: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2572: PO_UDA_DEFAULTING_PKG.DEBUG('Before EXECUTE_IMPORT_UDA_FUNCTION '||p_event_type||' ' || x_return_status, d_progress);
2573: PO_UDA_IMPORT_PKG.EXECUTE_IMPORT_UDA_FUNCTION
2574: (
2575: p_template_id => l_class_code_name_value_pairs(l_class_code_name_value_pairs.FIRST).VALUE

Line 2591: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND ext_name_val_obj.VALUE = FND_API.G_RET_STS_SUCCESS AND p_write_to = 'TRUE' THEN

2587: d_progress := 140;
2588: END IF;
2589:
2590: PO_UDA_DEFAULTING_PKG.GET_EXT_ATTR_NAME_VALUE_PAIR('x_return_status', l_external_attr_value_pairs, ext_name_val_obj);
2591: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND ext_name_val_obj.VALUE = FND_API.G_RET_STS_SUCCESS AND p_write_to = 'TRUE' THEN
2592: d_progress := 300;
2593: PO_UDA_DEFAULTING_PKG.DEBUG('Before Process_User_Attrs_Data ' || x_return_status, d_progress);
2594: PO_UDA_DEFAULTING_PKG.DEBUG('l_attributes_row_table.COUNT ' || l_attributes_row_table.COUNT, d_progress);
2595: IF l_attributes_row_table.COUNT > 0 THEN

Line 2700: x_return_status := FND_API.G_RET_STS_SUCCESS;

2696:
2697: PO_UDA_DEFAULTING_PKG.DEBUG('Starting PO_UDA_DEFAULTING_PKG.PO_UDA_EXECUTE_ACTIONS with parameters' , d_progress);
2698: PO_UDA_DEFAULTING_PKG.DEBUG(' p_po_header_id :' || p_po_header_id, d_progress);
2699:
2700: x_return_status := FND_API.G_RET_STS_SUCCESS;
2701: BEGIN
2702: SELECT UDA_TEMPLATE_ID
2703: INTO l_template_id
2704: FROM po_headers_all

Line 2733: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN -- LOOP FOR ALL THE LINES DEFUALTING

2729:
2730: d_progress := 50;
2731:
2732: PO_UDA_DEFAULTING_PKG.DEBUG('Looping for executing actions for lines', d_progress);
2733: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN -- LOOP FOR ALL THE LINES DEFUALTING
2734: FOR c_get_lines_rec IN c_get_lines(p_po_header_id) LOOP
2735:
2736: BEGIN
2737: SELECT UDA_TEMPLATE_ID

Line 2768: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN -- LOOP FOR ALL THE SHIPMENTS DEFUALTING

2764: PO_UDA_DEFAULTING_PKG.DEBUG('After UDA_EXECUTE_ACTIONS for line : ' || x_return_status, d_progress);
2765: d_progress := 70;
2766:
2767: PO_UDA_DEFAULTING_PKG.DEBUG('Looping for executing actions for Shipments', d_progress);
2768: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN -- LOOP FOR ALL THE SHIPMENTS DEFUALTING
2769:
2770: FOR c_get_shipments_rec IN c_get_shipments(p_po_header_id, c_get_lines_rec.PO_LINE_ID) LOOP
2771:
2772: BEGIN