eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_CG_UPGRADE dependencies on FND_API

Line 162: IF l_return_status = fnd_api.g_ret_sts_error THEN

158: , p_encumbrance_account => l_encumbrance_account
159: , p_organization_id => l_organization_id --NULL
160: , p_cost_group_type_id => 3);
161:
162: IF l_return_status = fnd_api.g_ret_sts_error THEN
163: RAISE fnd_api.g_exc_error;
164: END IF ;
165:
166: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 163: RAISE fnd_api.g_exc_error;

159: , p_organization_id => l_organization_id --NULL
160: , p_cost_group_type_id => 3);
161:
162: IF l_return_status = fnd_api.g_ret_sts_error THEN
163: RAISE fnd_api.g_exc_error;
164: END IF ;
165:
166: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
167: /*

Line 166: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

162: IF l_return_status = fnd_api.g_ret_sts_error THEN
163: RAISE fnd_api.g_exc_error;
164: END IF ;
165:
166: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
167: /*
168: dbms_output.put_line('Org:' || to_char(l_organization_id));
169: dbms_output.put_line('Sub:' || l_secondary_inventory_name);
170:

Line 179: RAISE fnd_api.g_exc_unexpected_error;

175: dbms_output.put_line('OPA:' || to_char(l_outside_processing_account));
176: dbms_output.put_line('EA:' || to_char(l_expense_account));
177: dbms_output.put_line('EnA:' || to_char(l_encumbrance_account));
178: */
179: RAISE fnd_api.g_exc_unexpected_error;
180: END IF;
181:
182: /*
183: ** If there is a cost group matching accounts use it else create

Line 206: IF l_return_status = fnd_api.g_ret_sts_error THEN

202: , p_encumbrance_account => l_encumbrance_account
203: , p_organization_id => l_organization_id -- NULL
204: , p_cost_group_type_id => 3);
205:
206: IF l_return_status = fnd_api.g_ret_sts_error THEN
207: RAISE fnd_api.g_exc_error;
208: END IF ;
209:
210: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 207: RAISE fnd_api.g_exc_error;

203: , p_organization_id => l_organization_id -- NULL
204: , p_cost_group_type_id => 3);
205:
206: IF l_return_status = fnd_api.g_ret_sts_error THEN
207: RAISE fnd_api.g_exc_error;
208: END IF ;
209:
210: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
211: RAISE fnd_api.g_exc_unexpected_error;

Line 210: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

206: IF l_return_status = fnd_api.g_ret_sts_error THEN
207: RAISE fnd_api.g_exc_error;
208: END IF ;
209:
210: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
211: RAISE fnd_api.g_exc_unexpected_error;
212: END IF;
213: end if;
214:

Line 211: RAISE fnd_api.g_exc_unexpected_error;

207: RAISE fnd_api.g_exc_error;
208: END IF ;
209:
210: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
211: RAISE fnd_api.g_exc_unexpected_error;
212: END IF;
213: end if;
214:
215:

Line 240: when fnd_api.g_exc_error THEN

236: COMMIT;
237:
238: EXCEPTION
239:
240: when fnd_api.g_exc_error THEN
241:
242: rollback;
243: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
244: x_return_status := fnd_api.g_ret_sts_error ;

Line 244: x_return_status := fnd_api.g_ret_sts_error ;

240: when fnd_api.g_exc_error THEN
241:
242: rollback;
243: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
244: x_return_status := fnd_api.g_ret_sts_error ;
245: -- Get message count and data
246: fnd_msg_pub.count_and_get
247: ( p_count => l_msg_count
248: , p_data => l_msg_data

Line 262: when fnd_api.g_exc_unexpected_error THEN

258: p_proc_name => l_procedure_name);
259:
260: raise_application_error(-20000,l_return_err);
261:
262: when fnd_api.g_exc_unexpected_error THEN
263:
264: rollback;
265: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
266: x_return_status := fnd_api.g_ret_sts_error ;

Line 266: x_return_status := fnd_api.g_ret_sts_error ;

262: when fnd_api.g_exc_unexpected_error THEN
263:
264: rollback;
265: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
266: x_return_status := fnd_api.g_ret_sts_error ;
267:
268: -- Get message count and data
269: fnd_msg_pub.count_and_get
270: ( p_count => l_msg_count

Line 287: x_return_status := fnd_api.g_ret_sts_error ;

283:
284: when others then
285: rollback;
286: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
287: x_return_status := fnd_api.g_ret_sts_error ;
288: l_return_err := 'mtl_secondary_inventories default cost group upgrade:'||
289: substrb(sqlerrm,1,55);
290: INS_ERROR(p_table_name => l_table_name,
291: p_ROWID => l_rowid_info,

Line 631: when fnd_api.g_exc_error THEN

627:
628: end if;
629: exception
630:
631: when fnd_api.g_exc_error THEN
632: rollback;
633:
634: IF(group_cursor%isopen) THEN CLOSE group_cursor; END IF;
635: IF(mps_cursor%isopen) THEN CLOSE mps_cursor; END IF;

Line 636: x_return_status := fnd_api.g_ret_sts_error ;

632: rollback;
633:
634: IF(group_cursor%isopen) THEN CLOSE group_cursor; END IF;
635: IF(mps_cursor%isopen) THEN CLOSE mps_cursor; END IF;
636: x_return_status := fnd_api.g_ret_sts_error ;
637: -- Get message count and data
638: fnd_msg_pub.count_and_get
639: ( p_count => l_msg_count
640: , p_data => l_msg_data

Line 656: when fnd_api.g_exc_unexpected_error THEN

652:
653:
654: raise_application_error(-20000,l_return_err);
655:
656: when fnd_api.g_exc_unexpected_error THEN
657:
658: rollback;
659:
660: IF(group_cursor%isopen) THEN CLOSE group_cursor; END IF;

Line 663: x_return_status := fnd_api.g_ret_sts_error ;

659:
660: IF(group_cursor%isopen) THEN CLOSE group_cursor; END IF;
661: IF(mps_cursor%isopen) THEN CLOSE mps_cursor; END IF;
662:
663: x_return_status := fnd_api.g_ret_sts_error ;
664: -- Get message count and data
665: fnd_msg_pub.count_and_get
666: ( p_count => l_msg_count
667: , p_data => l_msg_data

Line 688: x_return_status := fnd_api.g_ret_sts_error ;

684:
685: IF(group_cursor%isopen) THEN CLOSE group_cursor; END IF;
686: IF(mps_cursor%isopen) THEN CLOSE mps_cursor; END IF;
687:
688: x_return_status := fnd_api.g_ret_sts_error ;
689: /*
690: dbms_output.put_line('Org:' || to_char(l_organization_id));
691: dbms_output.put_line('Sub:' || l_secondary_inventory);
692: */

Line 860: IF l_return_status = fnd_api.g_ret_sts_error THEN

856: , p_encumbrance_account => l_encumbrance_account
857: , p_organization_id => l_organization_id --NULL
858: , p_cost_group_type_id => 3);
859:
860: IF l_return_status = fnd_api.g_ret_sts_error THEN
861: RAISE fnd_api.g_exc_error;
862: END IF ;
863:
864: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 861: RAISE fnd_api.g_exc_error;

857: , p_organization_id => l_organization_id --NULL
858: , p_cost_group_type_id => 3);
859:
860: IF l_return_status = fnd_api.g_ret_sts_error THEN
861: RAISE fnd_api.g_exc_error;
862: END IF ;
863:
864: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
865: /*

Line 864: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

860: IF l_return_status = fnd_api.g_ret_sts_error THEN
861: RAISE fnd_api.g_exc_error;
862: END IF ;
863:
864: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
865: /*
866: dbms_output.put_line('Org:' || to_char(l_organization_id));
867:
868: dbms_output.put_line('MA:' || to_char(l_material_account));

Line 876: RAISE fnd_api.g_exc_unexpected_error;

872: dbms_output.put_line('OPA:' || to_char(l_outside_processing_account));
873: dbms_output.put_line('EA:' || to_char(l_expense_account));
874: dbms_output.put_line('EnA:' || to_char(l_encumbrance_account));
875: */
876: RAISE fnd_api.g_exc_unexpected_error;
877: END IF;
878:
879:
880: -- ** If there's a cost group matching accounts use it else create

Line 903: IF l_return_status = fnd_api.g_ret_sts_error THEN

899: , p_organization_id => l_organization_id
900: , p_cost_group_type_id => 3);
901:
902: -- dbms_output.put_line('after create cost group');
903: IF l_return_status = fnd_api.g_ret_sts_error THEN
904: RAISE fnd_api.g_exc_error;
905: END IF ;
906:
907: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 904: RAISE fnd_api.g_exc_error;

900: , p_cost_group_type_id => 3);
901:
902: -- dbms_output.put_line('after create cost group');
903: IF l_return_status = fnd_api.g_ret_sts_error THEN
904: RAISE fnd_api.g_exc_error;
905: END IF ;
906:
907: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
908: RAISE fnd_api.g_exc_unexpected_error;

Line 907: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

903: IF l_return_status = fnd_api.g_ret_sts_error THEN
904: RAISE fnd_api.g_exc_error;
905: END IF ;
906:
907: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
908: RAISE fnd_api.g_exc_unexpected_error;
909: END IF;
910: end if;
911:

Line 908: RAISE fnd_api.g_exc_unexpected_error;

904: RAISE fnd_api.g_exc_error;
905: END IF ;
906:
907: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
908: RAISE fnd_api.g_exc_unexpected_error;
909: END IF;
910: end if;
911:
912:

Line 935: when fnd_api.g_exc_error THEN

931:
932: COMMIT;
933: exception
934:
935: when fnd_api.g_exc_error THEN
936: rollback;
937:
938: IF(org_cursor%isopen) THEN CLOSE org_cursor; END IF;
939: x_return_status := fnd_api.g_ret_sts_error ;

Line 939: x_return_status := fnd_api.g_ret_sts_error ;

935: when fnd_api.g_exc_error THEN
936: rollback;
937:
938: IF(org_cursor%isopen) THEN CLOSE org_cursor; END IF;
939: x_return_status := fnd_api.g_ret_sts_error ;
940: -- Get message count and data
941: fnd_msg_pub.count_and_get
942: ( p_count => l_msg_count
943: , p_data => l_msg_data

Line 958: when fnd_api.g_exc_unexpected_error THEN

954: -- l_return_err := 'mtl_parameters default cost group upgrade:'|| l_msg_data;
955:
956: raise_application_error(-20000,l_return_err);
957:
958: when fnd_api.g_exc_unexpected_error THEN
959:
960: rollback;
961:
962: IF(org_cursor%isopen) THEN CLOSE org_cursor; END IF;

Line 964: x_return_status := fnd_api.g_ret_sts_error ;

960: rollback;
961:
962: IF(org_cursor%isopen) THEN CLOSE org_cursor; END IF;
963:
964: x_return_status := fnd_api.g_ret_sts_error ;
965:
966:
967: -- Get message count and data
968: fnd_msg_pub.count_and_get

Line 990: x_return_status := fnd_api.g_ret_sts_error ;

986: rollback;
987:
988: IF(org_cursor%isopen) THEN CLOSE org_cursor; END IF;
989:
990: x_return_status := fnd_api.g_ret_sts_error ;
991: -- l_return_err := 'mtl_parameters default cost group upgrade:'||
992: -- substrb(sqlerrm,1,55);
993:
994:

Line 1222: when fnd_api.g_exc_error THEN

1218: */
1219:
1220: exception
1221:
1222: when fnd_api.g_exc_error THEN
1223: rollback;
1224:
1225: IF(moq_cursor%isopen) THEN CLOSE moq_cursor; END IF;
1226:

Line 1227: x_return_status := fnd_api.g_ret_sts_error ;

1223: rollback;
1224:
1225: IF(moq_cursor%isopen) THEN CLOSE moq_cursor; END IF;
1226:
1227: x_return_status := fnd_api.g_ret_sts_error ;
1228: -- Get message count and data
1229: fnd_msg_pub.count_and_get
1230: ( p_count => l_msg_count
1231: , p_data => l_msg_data

Line 1247: when fnd_api.g_exc_unexpected_error THEN

1243: p_proc_name => l_procedure_name);
1244:
1245: raise_application_error(-20000,l_return_err);
1246:
1247: when fnd_api.g_exc_unexpected_error THEN
1248:
1249: rollback;
1250:
1251: IF(moq_cursor%isopen) THEN CLOSE moq_cursor; END IF;

Line 1252: x_return_status := fnd_api.g_ret_sts_error ;

1248:
1249: rollback;
1250:
1251: IF(moq_cursor%isopen) THEN CLOSE moq_cursor; END IF;
1252: x_return_status := fnd_api.g_ret_sts_error ;
1253: -- Get message count and data
1254: fnd_msg_pub.count_and_get
1255: ( p_count => l_msg_count
1256: , p_data => l_msg_data

Line 1276: x_return_status := fnd_api.g_ret_sts_error ;

1272: rollback;
1273:
1274: IF(moq_cursor%isopen) THEN CLOSE moq_cursor; END IF;
1275:
1276: x_return_status := fnd_api.g_ret_sts_error ;
1277: /*
1278: dbms_output.put_line('Org:' || to_char(l_organization_id));
1279: dbms_output.put_line('Sub:' || l_subinventory_code);
1280: dbms_output.put_line('Loc:' || to_char(l_locator_id));

Line 1761: when fnd_api.g_exc_error THEN

1757:
1758:
1759: exception
1760:
1761: when fnd_api.g_exc_error THEN
1762: rollback;
1763:
1764: IF(mmt_cursor%isopen) THEN CLOSE mmt_cursor; END IF;
1765: IF(mmt_nodate_cursor%isopen) THEN CLOSE mmt_nodate_cursor; END IF;

Line 1768: x_return_status := fnd_api.g_ret_sts_error ;

1764: IF(mmt_cursor%isopen) THEN CLOSE mmt_cursor; END IF;
1765: IF(mmt_nodate_cursor%isopen) THEN CLOSE mmt_nodate_cursor; END IF;
1766: IF(ms_cursor%isopen) THEN CLOSE ms_cursor; END IF;
1767: if(acct_cursor%isopen) then CLOSE acct_cursor; end if;
1768: x_return_status := fnd_api.g_ret_sts_error ;
1769:
1770: -- Get message count and data
1771: fnd_msg_pub.count_and_get
1772: ( p_count => l_msg_count

Line 1789: when fnd_api.g_exc_unexpected_error THEN

1785: p_proc_name => l_procedure_name);
1786:
1787: raise_application_error(-20000,l_return_err);
1788:
1789: when fnd_api.g_exc_unexpected_error THEN
1790:
1791: rollback;
1792:
1793: IF(mmt_cursor%isopen) THEN CLOSE mmt_cursor; END IF;

Line 1796: x_return_status := fnd_api.g_ret_sts_error ;

1792:
1793: IF(mmt_cursor%isopen) THEN CLOSE mmt_cursor; END IF;
1794: IF(ms_cursor%isopen) THEN CLOSE ms_cursor; END IF;
1795: if(acct_cursor%isopen) then CLOSE acct_cursor; end if;
1796: x_return_status := fnd_api.g_ret_sts_error ;
1797: -- Get message count and data
1798: fnd_msg_pub.count_and_get
1799: ( p_count => l_msg_count
1800: , p_data => l_msg_data

Line 1823: x_return_status := fnd_api.g_ret_sts_error ;

1819:
1820: IF(mmt_cursor%isopen) THEN CLOSE mmt_cursor; END IF;
1821: IF(ms_cursor%isopen) THEN CLOSE ms_cursor; END IF;
1822: if(acct_cursor%isopen) then CLOSE acct_cursor; end if;
1823: x_return_status := fnd_api.g_ret_sts_error ;
1824: /*
1825: dbms_output.put_line('TID:' || to_char(l_transaction_id));
1826: dbms_output.put_line('Org:' || to_char(l_organization_id));
1827: dbms_output.put_line('Sub:' || l_subinventory_code);

Line 1889: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop ; end if;

1885: return_status,
1886: msg_count,
1887: msg_data
1888: );
1889: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop ; end if;
1890: inv_cg_upgrade.invmpsb( org_id,
1891: user_name,
1892: password,
1893: return_status,

Line 1897: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop ; end if;

1893: return_status,
1894: msg_count,
1895: msg_data
1896: );
1897: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop ; end if;
1898: inv_cg_upgrade.invmoqsb( org_id,
1899: l_cost_method,
1900: user_name,
1901: password,

Line 1906: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop; end if;

1902: return_status,
1903: msg_count,
1904: msg_data
1905: );
1906: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop; end if;
1907: /*
1908: if ( p_open_periods_only <> 1 ) then
1909: inv_cg_upgrade.invmpssb( org_id,
1910: l_cost_method,

Line 1918: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop; end if;

1914: msg_count,
1915: msg_data
1916: );
1917:
1918: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop; end if;
1919: end if;
1920: */
1921: inv_cg_upgrade.invmmtsb( org_id,
1922: l_cost_method,

Line 1931: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop; end if;

1927: msg_count,
1928: msg_data
1929: );
1930:
1931: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop; end if;
1932: inv_cg_upgrade.INVMCCESB (
1933: org_id,
1934: l_cost_method,
1935: USER_NAME,

Line 1941: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop; end if;

1937: return_status,
1938: msg_count,
1939: msg_data) ;
1940:
1941: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop; end if;
1942: inv_cg_upgrade.INVMPASB (
1943: org_id,
1944: l_cost_method,
1945: USER_NAME,

Line 1951: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop; end if;

1947: return_status,
1948: msg_count,
1949: msg_data) ;
1950:
1951: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop; end if;
1952: inv_cg_upgrade.INVMPITSB (
1953: org_id,
1954: l_cost_method,
1955: USER_NAME,

Line 2190: when fnd_api.g_exc_error THEN

2186: */
2187:
2188: exception
2189:
2190: when fnd_api.g_exc_error THEN
2191: rollback;
2192:
2193: IF(mcce_cursor%isopen) THEN CLOSE mcce_cursor; END IF;
2194:

Line 2195: x_return_status := fnd_api.g_ret_sts_error ;

2191: rollback;
2192:
2193: IF(mcce_cursor%isopen) THEN CLOSE mcce_cursor; END IF;
2194:
2195: x_return_status := fnd_api.g_ret_sts_error ;
2196: -- Get message count and data
2197: fnd_msg_pub.count_and_get
2198: ( p_count => l_msg_count
2199: , p_data => l_msg_data

Line 2215: when fnd_api.g_exc_unexpected_error THEN

2211: p_proc_name => l_procedure_name);
2212:
2213: raise_application_error(-20000,l_return_err);
2214:
2215: when fnd_api.g_exc_unexpected_error THEN
2216:
2217: rollback;
2218:
2219: IF(mcce_cursor%isopen) THEN CLOSE mcce_cursor; END IF;

Line 2220: x_return_status := fnd_api.g_ret_sts_error ;

2216:
2217: rollback;
2218:
2219: IF(mcce_cursor%isopen) THEN CLOSE mcce_cursor; END IF;
2220: x_return_status := fnd_api.g_ret_sts_error ;
2221: -- Get message count and data
2222: fnd_msg_pub.count_and_get
2223: ( p_count => l_msg_count
2224: , p_data => l_msg_data

Line 2244: x_return_status := fnd_api.g_ret_sts_error ;

2240: rollback;
2241:
2242: IF(mcce_cursor%isopen) THEN CLOSE mcce_cursor; END IF;
2243:
2244: x_return_status := fnd_api.g_ret_sts_error ;
2245: /*
2246: dbms_output.put_line('Org:' || to_char(l_organization_id));
2247: dbms_output.put_line('Sub:' || l_subinventory_code);
2248: dbms_output.put_line('Loc:' || to_char(l_locator_id));

Line 2479: when fnd_api.g_exc_error THEN

2475: */
2476:
2477: exception
2478:
2479: when fnd_api.g_exc_error THEN
2480: rollback;
2481:
2482: IF(mpa_cursor%isopen) THEN CLOSE mpa_cursor; END IF;
2483:

Line 2484: x_return_status := fnd_api.g_ret_sts_error ;

2480: rollback;
2481:
2482: IF(mpa_cursor%isopen) THEN CLOSE mpa_cursor; END IF;
2483:
2484: x_return_status := fnd_api.g_ret_sts_error ;
2485: -- Get message count and data
2486: fnd_msg_pub.count_and_get
2487: ( p_count => l_msg_count
2488: , p_data => l_msg_data

Line 2504: when fnd_api.g_exc_unexpected_error THEN

2500: p_proc_name => l_procedure_name);
2501:
2502: raise_application_error(-20000,l_return_err);
2503:
2504: when fnd_api.g_exc_unexpected_error THEN
2505:
2506: rollback;
2507:
2508: IF(mpa_cursor%isopen) THEN CLOSE mpa_cursor; END IF;

Line 2509: x_return_status := fnd_api.g_ret_sts_error ;

2505:
2506: rollback;
2507:
2508: IF(mpa_cursor%isopen) THEN CLOSE mpa_cursor; END IF;
2509: x_return_status := fnd_api.g_ret_sts_error ;
2510: -- Get message count and data
2511: fnd_msg_pub.count_and_get
2512: ( p_count => l_msg_count
2513: , p_data => l_msg_data

Line 2533: x_return_status := fnd_api.g_ret_sts_error ;

2529: rollback;
2530:
2531: IF(mpa_cursor%isopen) THEN CLOSE mpa_cursor; END IF;
2532:
2533: x_return_status := fnd_api.g_ret_sts_error ;
2534: /*
2535: dbms_output.put_line('Org:' || to_char(l_organization_id));
2536: dbms_output.put_line('Sub:' || l_subinventory_code);
2537: dbms_output.put_line('Loc:' || to_char(l_locator_id));

Line 2766: when fnd_api.g_exc_error THEN

2762: */
2763:
2764: exception
2765:
2766: when fnd_api.g_exc_error THEN
2767: rollback;
2768:
2769: IF(mpit_cursor%isopen) THEN CLOSE mpit_cursor; END IF;
2770:

Line 2771: x_return_status := fnd_api.g_ret_sts_error ;

2767: rollback;
2768:
2769: IF(mpit_cursor%isopen) THEN CLOSE mpit_cursor; END IF;
2770:
2771: x_return_status := fnd_api.g_ret_sts_error ;
2772: -- Get message count and data
2773: fnd_msg_pub.count_and_get
2774: ( p_count => l_msg_count
2775: , p_data => l_msg_data

Line 2791: when fnd_api.g_exc_unexpected_error THEN

2787: p_proc_name => l_procedure_name);
2788:
2789: raise_application_error(-20000,l_return_err);
2790:
2791: when fnd_api.g_exc_unexpected_error THEN
2792:
2793: rollback;
2794:
2795: IF(mpit_cursor%isopen) THEN CLOSE mpit_cursor; END IF;

Line 2796: x_return_status := fnd_api.g_ret_sts_error ;

2792:
2793: rollback;
2794:
2795: IF(mpit_cursor%isopen) THEN CLOSE mpit_cursor; END IF;
2796: x_return_status := fnd_api.g_ret_sts_error ;
2797: -- Get message count and data
2798: fnd_msg_pub.count_and_get
2799: ( p_count => l_msg_count
2800: , p_data => l_msg_data

Line 2820: x_return_status := fnd_api.g_ret_sts_error ;

2816: rollback;
2817:
2818: IF(mpit_cursor%isopen) THEN CLOSE mpit_cursor; END IF;
2819:
2820: x_return_status := fnd_api.g_ret_sts_error ;
2821: /*
2822: dbms_output.put_line('Org:' || to_char(l_organization_id));
2823: dbms_output.put_line('Sub:' || l_subinventory_code);
2824: dbms_output.put_line('Loc:' || to_char(l_locator_id));