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.GMS_LD_PKG dependencies on PA_TRANSACTION_INTERFACE_ALL

Line 172: FROM pa_transaction_interface_all

168: , po_price_type
169: , wip_resource_id
170: , inventory_item_id
171: , unit_of_measure
172: FROM pa_transaction_interface_all
173: WHERE transaction_source = X_transaction_source
174: AND batch_name = current_batch
175: AND transaction_status_code = 'P'
176: AND decode(system_linkage,'OT','ST',system_linkage) =

Line 836: UPDATE pa_transaction_interface_all

832: VALIDATE_TRANSACTION_SOURCE;
833:
834: IF X_STATUS IS NOT NULL THEN
835:
836: UPDATE pa_transaction_interface_all
837: SET transaction_rejection_code = X_status,
838: interface_id = P_xface_id,
839: transaction_status_code = 'R'
840: WHERE transaction_status_code ='P'

Line 869: tabname =>'PA_TRANSACTION_INTERFACE_ALL',

865: /* The following FND_STATS.GATHER_TABLE_STATS procedure call has been modified by VBANDARU for bug 2465932*/
866: /*=============================================================================================================================*/
867:
868: /*FND_STATS.Gather_Table_Stats(ownname=>'PA',
869: tabname =>'PA_TRANSACTION_INTERFACE_ALL',
870: percent =>10,
871: tmode => 'TEMPORARY');*/
872:
873: --FND_STATS.Gather_Table_Stats(ownname=>'PA',

Line 874: -- tabname =>'PA_TRANSACTION_INTERFACE_ALL');

870: percent =>10,
871: tmode => 'TEMPORARY');*/
872:
873: --FND_STATS.Gather_Table_Stats(ownname=>'PA',
874: -- tabname =>'PA_TRANSACTION_INTERFACE_ALL');
875:
876: x_success := 'S' ;
877: FOR eachGroup IN TrxBatches LOOP
878:

Line 963: UPDATE pa_transaction_interface_all

959: ROLLBACK TO SAVE_TrxREC; -- Bug 3035863 : Introduced rollback in case of failure
960:
961: IF PROJ_FAIL THEN
962:
963: UPDATE pa_transaction_interface_all
964: SET transaction_rejection_code = 'INVALID_PROJECT'
965: , interface_id = P_xface_id
966: , expenditure_id = l_enc_id
967: , transaction_status_code = 'R'

Line 972: UPDATE pa_transaction_interface_all

968: WHERE current of TrxRecs ;
969:
970: ELSIF TASK_FAIL THEN
971:
972: UPDATE pa_transaction_interface_all
973: SET transaction_rejection_code = 'INVALID_TASK'
974: , interface_id = P_xface_id
975: , expenditure_id = l_enc_id
976: , transaction_status_code = 'R'

Line 981: UPDATE pa_transaction_interface_all

977: WHERE current of TrxRecs ;
978:
979: ELSE
980:
981: UPDATE pa_transaction_interface_all
982: SET transaction_rejection_code = 'GMS_UNEXPECTED_ERROR'
983: , interface_id = P_xface_id
984: , expenditure_id = l_enc_id
985: , transaction_status_code = 'R'

Line 1134: UPDATE pa_transaction_interface_all

1130: IF X_STATUS IS NOT NULL THEN
1131:
1132: ROLLBACK TO SAVE_TrxREC; -- Bug 3035863 : Introduced rollback in case of failure
1133:
1134: UPDATE pa_transaction_interface_all
1135: SET transaction_rejection_code = X_status
1136: , interface_id = P_xface_id
1137: , expenditure_id = l_enc_id
1138: , transaction_status_code = 'R'

Line 1168: UPDATE pa_transaction_interface_all

1164: write_to_log('GMS :PROC_VALIDATE_LOCAL returned x_success False') ;
1165:
1166: ROLLBACK TO SAVE_TrxREC; -- Bug 3035863 : Introduced rollback in case of failure
1167:
1168: UPDATE pa_transaction_interface_all
1169: SET transaction_rejection_code = DECODE(x_status_code ,NULL,'GMS_UNEXPECTED_ERROR',x_status_code) -- Bug 3465939
1170: , interface_id = P_xface_id
1171: , expenditure_id = l_enc_id
1172: , transaction_status_code = 'R'

Line 1201: UPDATE pa_transaction_interface_all

1197: --*******************************
1198: --*** ERROR
1199: --*** DO Something for failure ;
1200: --*** ****************************
1201: UPDATE pa_transaction_interface_all
1202: SET transaction_rejection_code = 'GMS_UNEXPECTED_ERROR'
1203: , interface_id = P_xface_id
1204: , expenditure_id = l_enc_id
1205: , transaction_status_code = 'R'

Line 1297: UPDATE pa_transaction_interface_all

1293: if x_dummy > 0 then
1294:
1295: ROLLBACK TO SAVE_TrxREC; -- Bug 3035863 : Introduced rollback in case of failure
1296:
1297: UPDATE pa_transaction_interface_all
1298: SET transaction_rejection_code = 'DUPLICATE_ITEM'
1299: , interface_id = P_xface_id
1300: , expenditure_id = l_enc_id
1301: , transaction_status_code = 'R'

Line 1398: UPDATE pa_transaction_interface_all

1394:
1395: pa_cc_utils.log_message('This record validated ' || X_status, 1);
1396:
1397: IF f_create_adls THEN
1398: UPDATE pa_transaction_interface_all
1399: SET transaction_rejection_code = NULL,
1400: interface_id = P_xface_id,
1401: expenditure_id = l_enc_id,
1402: transaction_status_code = 'A',

Line 1422: UPDATE pa_transaction_interface_all

1418: WHERE encumbrance_item_id = l_orig_enc_item_id;
1419:
1420: ELSE
1421: rollback to save_enc_adl_rec ;
1422: UPDATE pa_transaction_interface_all
1423: SET transaction_rejection_code = 'GMS_CREATE_ADL_FAILED'
1424: , interface_id = P_xface_id
1425: , expenditure_id = l_enc_id
1426: , transaction_status_code = 'R'

Line 1458: UPDATE pa_transaction_interface_all

1454: --*** ERROR
1455: --***REJECT ITEM and continue.....
1456: --*** ******************************
1457: ROLLBACK TO SAVE_TrxREC; -- Bug 3035863 : Introduced rollback in case of failure
1458: UPDATE pa_transaction_interface_all
1459: SET transaction_rejection_code = 'GMS_UNEXPECTED_ERROR'
1460: , interface_id = P_xface_id
1461: , expenditure_id = l_enc_id
1462: , transaction_status_code = 'R'

Line 1489: FROM pa_transaction_interface_all

1485: IF NVL(l_purgeable_flag,'N') = 'Y' THEN
1486:
1487: DELETE gms_transaction_interface_all
1488: WHERE txn_interface_id IN (SELECT txn_interface_id
1489: FROM pa_transaction_interface_all
1490: WHERE interface_id = P_XFACE_ID
1491: AND transaction_status_code ='A' );
1492: pa_cc_utils.log_message('GMS_LD_PKG.PRE_PROCESS : Number of success records deleted from Grants interface table :'||SQL%ROWCOUNT);
1493: