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 1137: UPDATE pa_transaction_interface_all

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

Line 1171: UPDATE pa_transaction_interface_all

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

Line 1204: UPDATE pa_transaction_interface_all

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

Line 1300: UPDATE pa_transaction_interface_all

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

Line 1401: UPDATE pa_transaction_interface_all

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

Line 1425: UPDATE pa_transaction_interface_all

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

Line 1461: UPDATE pa_transaction_interface_all

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

Line 1492: FROM pa_transaction_interface_all

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