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

Line 117: IF l_return_status = fnd_api.g_ret_sts_error THEN

113: , p_encumbrance_account => l_encumbrance_account
114: , p_organization_id => l_organization_id --NULL
115: , p_cost_group_type_id => 3);
116:
117: IF l_return_status = fnd_api.g_ret_sts_error THEN
118: RAISE fnd_api.g_exc_error;
119: END IF ;
120:
121: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 118: RAISE fnd_api.g_exc_error;

114: , p_organization_id => l_organization_id --NULL
115: , p_cost_group_type_id => 3);
116:
117: IF l_return_status = fnd_api.g_ret_sts_error THEN
118: RAISE fnd_api.g_exc_error;
119: END IF ;
120:
121: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
122: /*

Line 121: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

117: IF l_return_status = fnd_api.g_ret_sts_error THEN
118: RAISE fnd_api.g_exc_error;
119: END IF ;
120:
121: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
122: /*
123: dbms_output.put_line('Org:' || to_char(l_organization_id));
124: dbms_output.put_line('Sub:' || l_secondary_inventory_name);
125:

Line 134: RAISE fnd_api.g_exc_unexpected_error;

130: dbms_output.put_line('OPA:' || to_char(l_outside_processing_account));
131: dbms_output.put_line('EA:' || to_char(l_expense_account));
132: dbms_output.put_line('EnA:' || to_char(l_encumbrance_account));
133: */
134: RAISE fnd_api.g_exc_unexpected_error;
135: END IF;
136:
137: /*
138: ** If there is a cost group matching accounts use it else create

Line 160: IF l_return_status = fnd_api.g_ret_sts_error THEN

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

Line 161: RAISE fnd_api.g_exc_error;

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

Line 164: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

160: IF l_return_status = fnd_api.g_ret_sts_error THEN
161: RAISE fnd_api.g_exc_error;
162: END IF ;
163:
164: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
165: RAISE fnd_api.g_exc_unexpected_error;
166: END IF;
167: end if;
168:

Line 165: RAISE fnd_api.g_exc_unexpected_error;

161: RAISE fnd_api.g_exc_error;
162: END IF ;
163:
164: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
165: RAISE fnd_api.g_exc_unexpected_error;
166: END IF;
167: end if;
168:
169: /*

Line 184: when fnd_api.g_exc_error THEN

180: COMMIT;
181:
182: EXCEPTION
183:
184: when fnd_api.g_exc_error THEN
185:
186: rollback;
187: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
188: x_return_status := fnd_api.g_ret_sts_error ;

Line 188: x_return_status := fnd_api.g_ret_sts_error ;

184: when fnd_api.g_exc_error THEN
185:
186: rollback;
187: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
188: x_return_status := fnd_api.g_ret_sts_error ;
189: -- Get message count and data
190: fnd_msg_pub.count_and_get
191: ( p_count => l_msg_count
192: , p_data => l_msg_data

Line 206: when fnd_api.g_exc_unexpected_error THEN

202: p_proc_name => l_procedure_name);
203:
204: raise_application_error(-20000,l_return_err);
205:
206: when fnd_api.g_exc_unexpected_error THEN
207:
208: rollback;
209: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
210: x_return_status := fnd_api.g_ret_sts_error ;

Line 210: x_return_status := fnd_api.g_ret_sts_error ;

206: when fnd_api.g_exc_unexpected_error THEN
207:
208: rollback;
209: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
210: x_return_status := fnd_api.g_ret_sts_error ;
211:
212: -- Get message count and data
213: fnd_msg_pub.count_and_get
214: ( p_count => l_msg_count

Line 231: x_return_status := fnd_api.g_ret_sts_error ;

227:
228: when others then
229: rollback;
230: IF(subinventory_cursor%isopen) THEN CLOSE subinventory_cursor; END IF;
231: x_return_status := fnd_api.g_ret_sts_error ;
232: l_return_err := 'mtl_secondary_inventories default cost group upgrade:'||
233: substrb(sqlerrm,1,55);
234: INS_ERROR(p_table_name => l_table_name,
235: p_ROWID => l_rowid_info,

Line 451: when fnd_api.g_exc_error THEN

447: IF(mps_cursor%isopen) THEN CLOSE mps_cursor; END IF;
448: COMMIT;
449: exception
450:
451: when fnd_api.g_exc_error THEN
452: rollback;
453:
454: IF(group_cursor%isopen) THEN CLOSE group_cursor; END IF;
455: IF(mps_cursor%isopen) THEN CLOSE mps_cursor; END IF;

Line 456: x_return_status := fnd_api.g_ret_sts_error ;

452: rollback;
453:
454: IF(group_cursor%isopen) THEN CLOSE group_cursor; END IF;
455: IF(mps_cursor%isopen) THEN CLOSE mps_cursor; END IF;
456: x_return_status := fnd_api.g_ret_sts_error ;
457: -- Get message count and data
458: fnd_msg_pub.count_and_get
459: ( p_count => l_msg_count
460: , p_data => l_msg_data

Line 476: when fnd_api.g_exc_unexpected_error THEN

472:
473:
474: raise_application_error(-20000,l_return_err);
475:
476: when fnd_api.g_exc_unexpected_error THEN
477:
478: rollback;
479:
480: IF(group_cursor%isopen) THEN CLOSE group_cursor; END IF;

Line 483: x_return_status := fnd_api.g_ret_sts_error ;

479:
480: IF(group_cursor%isopen) THEN CLOSE group_cursor; END IF;
481: IF(mps_cursor%isopen) THEN CLOSE mps_cursor; END IF;
482:
483: x_return_status := fnd_api.g_ret_sts_error ;
484: -- Get message count and data
485: fnd_msg_pub.count_and_get
486: ( p_count => l_msg_count
487: , p_data => l_msg_data

Line 508: x_return_status := fnd_api.g_ret_sts_error ;

504:
505: IF(group_cursor%isopen) THEN CLOSE group_cursor; END IF;
506: IF(mps_cursor%isopen) THEN CLOSE mps_cursor; END IF;
507:
508: x_return_status := fnd_api.g_ret_sts_error ;
509: /*
510: dbms_output.put_line('Org:' || to_char(l_organization_id));
511: dbms_output.put_line('Sub:' || l_secondary_inventory);
512: */

Line 647: IF l_return_status = fnd_api.g_ret_sts_error THEN

643: , p_encumbrance_account => l_encumbrance_account
644: , p_organization_id => l_organization_id --NULL
645: , p_cost_group_type_id => 3);
646:
647: IF l_return_status = fnd_api.g_ret_sts_error THEN
648: RAISE fnd_api.g_exc_error;
649: END IF ;
650:
651: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 648: RAISE fnd_api.g_exc_error;

644: , p_organization_id => l_organization_id --NULL
645: , p_cost_group_type_id => 3);
646:
647: IF l_return_status = fnd_api.g_ret_sts_error THEN
648: RAISE fnd_api.g_exc_error;
649: END IF ;
650:
651: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
652: /*

Line 651: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

647: IF l_return_status = fnd_api.g_ret_sts_error THEN
648: RAISE fnd_api.g_exc_error;
649: END IF ;
650:
651: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
652: /*
653: dbms_output.put_line('Org:' || to_char(l_organization_id));
654:
655: dbms_output.put_line('MA:' || to_char(l_material_account));

Line 663: RAISE fnd_api.g_exc_unexpected_error;

659: dbms_output.put_line('OPA:' || to_char(l_outside_processing_account));
660: dbms_output.put_line('EA:' || to_char(l_expense_account));
661: dbms_output.put_line('EnA:' || to_char(l_encumbrance_account));
662: */
663: RAISE fnd_api.g_exc_unexpected_error;
664: END IF;
665:
666:
667: -- ** If there's a cost group matching accounts use it else create

Line 690: IF l_return_status = fnd_api.g_ret_sts_error THEN

686: , p_organization_id => l_organization_id --NULL
687: , p_cost_group_type_id => 3);
688:
689: -- dbms_output.put_line('after create cost group');
690: IF l_return_status = fnd_api.g_ret_sts_error THEN
691: RAISE fnd_api.g_exc_error;
692: END IF ;
693:
694: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 691: RAISE fnd_api.g_exc_error;

687: , p_cost_group_type_id => 3);
688:
689: -- dbms_output.put_line('after create cost group');
690: IF l_return_status = fnd_api.g_ret_sts_error THEN
691: RAISE fnd_api.g_exc_error;
692: END IF ;
693:
694: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
695: RAISE fnd_api.g_exc_unexpected_error;

Line 694: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

690: IF l_return_status = fnd_api.g_ret_sts_error THEN
691: RAISE fnd_api.g_exc_error;
692: END IF ;
693:
694: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
695: RAISE fnd_api.g_exc_unexpected_error;
696: END IF;
697: end if;
698:

Line 695: RAISE fnd_api.g_exc_unexpected_error;

691: RAISE fnd_api.g_exc_error;
692: END IF ;
693:
694: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
695: RAISE fnd_api.g_exc_unexpected_error;
696: END IF;
697: end if;
698:
699:

Line 715: when fnd_api.g_exc_error THEN

711:
712: COMMIT;
713: exception
714:
715: when fnd_api.g_exc_error THEN
716: rollback;
717:
718: IF(org_cursor%isopen) THEN CLOSE org_cursor; END IF;
719: x_return_status := fnd_api.g_ret_sts_error ;

Line 719: x_return_status := fnd_api.g_ret_sts_error ;

715: when fnd_api.g_exc_error THEN
716: rollback;
717:
718: IF(org_cursor%isopen) THEN CLOSE org_cursor; END IF;
719: x_return_status := fnd_api.g_ret_sts_error ;
720: -- Get message count and data
721: fnd_msg_pub.count_and_get
722: ( p_count => l_msg_count
723: , p_data => l_msg_data

Line 738: when fnd_api.g_exc_unexpected_error THEN

734: -- l_return_err := 'mtl_parameters default cost group upgrade:'|| l_msg_data;
735:
736: raise_application_error(-20000,l_return_err);
737:
738: when fnd_api.g_exc_unexpected_error THEN
739:
740: rollback;
741:
742: IF(org_cursor%isopen) THEN CLOSE org_cursor; END IF;

Line 744: x_return_status := fnd_api.g_ret_sts_error ;

740: rollback;
741:
742: IF(org_cursor%isopen) THEN CLOSE org_cursor; END IF;
743:
744: x_return_status := fnd_api.g_ret_sts_error ;
745:
746:
747: -- Get message count and data
748: fnd_msg_pub.count_and_get

Line 770: x_return_status := fnd_api.g_ret_sts_error ;

766: rollback;
767:
768: IF(org_cursor%isopen) THEN CLOSE org_cursor; END IF;
769:
770: x_return_status := fnd_api.g_ret_sts_error ;
771: -- l_return_err := 'mtl_parameters default cost group upgrade:'||
772: -- substrb(sqlerrm,1,55);
773:
774:

Line 991: when fnd_api.g_exc_error THEN

987: */
988:
989: exception
990:
991: when fnd_api.g_exc_error THEN
992: rollback;
993:
994: IF(moq_cursor%isopen) THEN CLOSE moq_cursor; END IF;
995:

Line 996: x_return_status := fnd_api.g_ret_sts_error ;

992: rollback;
993:
994: IF(moq_cursor%isopen) THEN CLOSE moq_cursor; END IF;
995:
996: x_return_status := fnd_api.g_ret_sts_error ;
997: -- Get message count and data
998: fnd_msg_pub.count_and_get
999: ( p_count => l_msg_count
1000: , p_data => l_msg_data

Line 1016: when fnd_api.g_exc_unexpected_error THEN

1012: p_proc_name => l_procedure_name);
1013:
1014: raise_application_error(-20000,l_return_err);
1015:
1016: when fnd_api.g_exc_unexpected_error THEN
1017:
1018: rollback;
1019:
1020: IF(moq_cursor%isopen) THEN CLOSE moq_cursor; END IF;

Line 1021: x_return_status := fnd_api.g_ret_sts_error ;

1017:
1018: rollback;
1019:
1020: IF(moq_cursor%isopen) THEN CLOSE moq_cursor; END IF;
1021: x_return_status := fnd_api.g_ret_sts_error ;
1022: -- Get message count and data
1023: fnd_msg_pub.count_and_get
1024: ( p_count => l_msg_count
1025: , p_data => l_msg_data

Line 1045: x_return_status := fnd_api.g_ret_sts_error ;

1041: rollback;
1042:
1043: IF(moq_cursor%isopen) THEN CLOSE moq_cursor; END IF;
1044:
1045: x_return_status := fnd_api.g_ret_sts_error ;
1046: /*
1047: dbms_output.put_line('Org:' || to_char(l_organization_id));
1048: dbms_output.put_line('Sub:' || l_subinventory_code);
1049: dbms_output.put_line('Loc:' || to_char(l_locator_id));

Line 1338: when fnd_api.g_exc_error THEN

1334: */
1335:
1336: exception
1337:
1338: when fnd_api.g_exc_error THEN
1339: rollback;
1340:
1341: IF(mmt_cursor%isopen) THEN CLOSE mmt_cursor; END IF;
1342: IF(ms_cursor%isopen) THEN CLOSE ms_cursor; END IF;

Line 1344: x_return_status := fnd_api.g_ret_sts_error ;

1340:
1341: IF(mmt_cursor%isopen) THEN CLOSE mmt_cursor; END IF;
1342: IF(ms_cursor%isopen) THEN CLOSE ms_cursor; END IF;
1343:
1344: x_return_status := fnd_api.g_ret_sts_error ;
1345:
1346: -- Get message count and data
1347: fnd_msg_pub.count_and_get
1348: ( p_count => l_msg_count

Line 1365: when fnd_api.g_exc_unexpected_error THEN

1361: p_proc_name => l_procedure_name);
1362:
1363: raise_application_error(-20000,l_return_err);
1364:
1365: when fnd_api.g_exc_unexpected_error THEN
1366:
1367: rollback;
1368:
1369: IF(mmt_cursor%isopen) THEN CLOSE mmt_cursor; END IF;

Line 1372: x_return_status := fnd_api.g_ret_sts_error ;

1368:
1369: IF(mmt_cursor%isopen) THEN CLOSE mmt_cursor; END IF;
1370: IF(ms_cursor%isopen) THEN CLOSE ms_cursor; END IF;
1371:
1372: x_return_status := fnd_api.g_ret_sts_error ;
1373: -- Get message count and data
1374: fnd_msg_pub.count_and_get
1375: ( p_count => l_msg_count
1376: , p_data => l_msg_data

Line 1399: x_return_status := fnd_api.g_ret_sts_error ;

1395:
1396: IF(mmt_cursor%isopen) THEN CLOSE mmt_cursor; END IF;
1397: IF(ms_cursor%isopen) THEN CLOSE ms_cursor; END IF;
1398:
1399: x_return_status := fnd_api.g_ret_sts_error ;
1400: /*
1401: dbms_output.put_line('TID:' || to_char(l_transaction_id));
1402: dbms_output.put_line('Org:' || to_char(l_organization_id));
1403: dbms_output.put_line('Sub:' || l_subinventory_code);

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

1459: return_status,
1460: msg_count,
1461: msg_data
1462: );
1463: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop ; end if;
1464: convert_test.invmpsb( org_id,
1465: user_name,
1466: password,
1467: return_status,

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

1467: return_status,
1468: msg_count,
1469: msg_data
1470: );
1471: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop ; end if;
1472: convert_test.invmoqsb( org_id,
1473: user_name,
1474: password,
1475: return_status,

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

1475: return_status,
1476: msg_count,
1477: msg_data
1478: );
1479: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop; end if;
1480:
1481: convert_test.invmpssb( org_id,
1482: user_name,
1483: password,

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

1484: return_status,
1485: msg_count,
1486: msg_data
1487: );
1488: if ( return_status = fnd_api.g_ret_sts_error ) then GOTO continue_loop; end if;
1489: convert_test.invmmtsb( org_id,
1490: user_name,
1491: password,
1492: return_status,