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.IGIRSTPT dependencies on IGI_STP_BATCHES

Line 370: UPDATE igi_stp_batches

366: WHEN NO_DATA_FOUND
367: THEN
368: l_message := substr(sqlerrm,1,120)||' : '||'No data found for receivable interface for '||l_value;
369: --fnd_file.put_line(fnd_file.log , l_message);
370: UPDATE igi_stp_batches
371: SET batch_status = 'ARFAILED'
372: WHERE batch_id in
373: (select batch_id
374: from igi_stp_control

Line 391: UPDATE igi_stp_batches

387: THEN
388: l_message := substr(sqlerrm,1,120)||' : '||l_message;
389: --fnd_file.put_line(fnd_file.log , l_message);
390:
391: UPDATE igi_stp_batches
392: SET batch_status = 'ARFAILED'
393: WHERE batch_id in
394: (select batch_id
395: from igi_stp_control

Line 635: UPDATE igi_stp_batches

631: EXCEPTION
632: WHEN NO_DATA_FOUND
633: THEN l_message := substr(sqlerrm,1,120)||'No data found for AP Interfaces';
634: --fnd_file.put_line(fnd_file.log , l_message);
635: UPDATE igi_stp_batches
636: SET batch_status = 'APFAILED'
637: WHERE batch_id in
638: (select batch_id
639: from igi_stp_control

Line 659: UPDATE igi_stp_batches

655: THEN l_message := substr(sqlerrm,1,120)
656: ||l_message;
657: --fnd_file.put_line(fnd_file.log , l_message);
658:
659: UPDATE igi_stp_batches
660: SET batch_status = 'APFAILED'
661: WHERE batch_id in
662: (select batch_id
663: from igi_stp_control

Line 782: UPDATE igi_stp_batches

778: p_currency_code);
779: EXCEPTION
780: WHEN NO_DATA_FOUND THEN
781: if l_flag = 'Y' then
782: UPDATE igi_stp_batches
783: SET batch_status = 'APFAILED'
784: WHERE batch_id in (select batch_id
785: from igi_stp_control
786: where control_id = p_net_batch_id);

Line 822: UPDATE igi_stp_batches

818: raise;
819: end if;
820: WHEN OTHERS THEN
821: if l_flag = 'Y' then
822: UPDATE igi_stp_batches
823: SET batch_status = 'APFAILED'
824: WHERE batch_id in (select batch_id
825: from igi_stp_control
826: where control_id = p_net_batch_id);

Line 872: FROM igi_stp_batches_all

868: --shsaxena for bug 2713715
869: CURSOR Cur_trx_type
870: IS
871: SELECT netting_trx_type_id
872: FROM igi_stp_batches_all
873: WHERE batch_id in
874: (select batch_id
875: from igi_stp_control
876: where control_id =p_net_batch_id)

Line 878: l_trx_type_id igi_stp_batches.netting_trx_type_id%type;

874: (select batch_id
875: from igi_stp_control
876: where control_id =p_net_batch_id)
877: and org_id = p_org_id;
878: l_trx_type_id igi_stp_batches.netting_trx_type_id%type;
879: --shsaxena for bug 2713715
880:
881:
882: p_set_of_books_id number(15);

Line 1066: UPDATE igi_stp_batches

1062: THEN
1063: ROLLBACK;
1064: --fnd_file.put_line(fnd_file.log , 'Submission failed');
1065:
1066: UPDATE igi_stp_batches
1067: SET batch_status = 'APFAILED'
1068: WHERE batch_id in
1069: (select batch_id
1070: from igi_stp_control

Line 1136: -- UPDATE igi_stp_batches

1132: -- then
1133: -- if l_ap_dev_status = 'NORMAL'
1134: -- then
1135: --
1136: -- UPDATE igi_stp_batches
1137: -- SET batch_status = 'COMPLETE'
1138: -- WHERE batch_id in
1139: -- (select batch_id
1140: -- from igi_stp_control

Line 1250: UPDATE igi_stp_batches

1246: IF p_ar_import_request_id = 0
1247: THEN
1248: ROLLBACK;
1249:
1250: UPDATE igi_stp_batches
1251: SET batch_status = 'ARFAILED'
1252: WHERE batch_id in
1253: (select batch_id
1254: from igi_stp_control

Line 1319: -- UPDATE igi_stp_batches

1315: -- then
1316: -- if l_ar_dev_status = 'NORMAL'
1317: -- then
1318: --
1319: -- UPDATE igi_stp_batches
1320: -- SET batch_status = 'COMPLETE'
1321: -- WHERE batch_id in
1322: -- (select batch_id
1323: -- from igi_stp_control

Line 1343: UPDATE igi_stp_batches

1339: THEN
1340: IF (l_ar_dev_phase = 'COMPLETE') AND (l_ar_dev_status = 'NORMAL')
1341: AND (l_ap_dev_phase = 'COMPLETE') AND (l_ap_dev_status = 'NORMAL')
1342: THEN
1343: UPDATE igi_stp_batches
1344: SET batch_status = 'COMPLETE'
1345: WHERE batch_id in
1346: (select batch_id
1347: from igi_stp_control

Line 1359: UPDATE igi_stp_batches

1355: IF l_trx_type_id IN (3,5,6)
1356: THEN
1357: IF (l_ap_dev_phase = 'COMPLETE') AND (l_ap_dev_status = 'NORMAL')
1358: THEN
1359: UPDATE igi_stp_batches
1360: SET batch_status = 'COMPLETE'
1361: WHERE batch_id in
1362: (select batch_id
1363: from igi_stp_control

Line 1374: UPDATE igi_stp_batches

1370: ELSIF l_trx_type_id IN( 4,6)
1371: THEN
1372: IF ( l_ar_dev_phase = 'COMPLETE') AND (l_ar_dev_status = 'NORMAL')
1373: THEN
1374: UPDATE igi_stp_batches
1375: SET batch_status = 'COMPLETE'
1376: WHERE batch_id in
1377: (select batch_id
1378: from igi_stp_control

Line 1391: UPDATE igi_stp_batches

1387:
1388: EXCEPTION
1389: WHEN NO_DATA_FOUND THEN
1390: if l_flag = 'P' then
1391: UPDATE igi_stp_batches
1392: SET batch_status = 'APFAILED'
1393: WHERE batch_id in (select batch_id
1394: from igi_stp_control
1395: where control_id = p_net_batch_id);

Line 1413: UPDATE igi_stp_batches

1409: FND_LOG.MESSAGE ( l_excep_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1410: END IF;
1411: raise_application_error(-20000, 'Procedure Initiate_Interfaces failed '||SQLERRM);
1412: elsif l_flag = 'R' then
1413: UPDATE igi_stp_batches
1414: SET batch_status = 'ARFAILED'
1415: WHERE batch_id in (select batch_id
1416: from igi_stp_control
1417: where control_id = p_net_batch_id);

Line 1439: UPDATE igi_stp_batches

1435: raise;
1436: end if;
1437: WHEN OTHERS THEN
1438: if l_flag = 'P' then
1439: UPDATE igi_stp_batches
1440: SET batch_status = 'APFAILED'
1441: WHERE batch_id in (select batch_id
1442: from igi_stp_control
1443: where control_id = p_net_batch_id);

Line 1461: UPDATE igi_stp_batches

1457: FND_LOG.MESSAGE ( l_unexp_level,'igi.plsql.igistpdb.IGIRSTPT.Initiate_Interfaces',TRUE);
1458: END IF;
1459: raise_application_error(-20000, 'Procedure Initiate_Interfaces failed '||SQLERRM);
1460: elsif l_flag = 'R' then
1461: UPDATE igi_stp_batches
1462: SET batch_status = 'ARFAILED'
1463: WHERE batch_id in (select batch_id
1464: from igi_stp_control
1465: where control_id = p_net_batch_id);