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.JMF_GTA_TXT_OPERATOR_PROC dependencies on JMF_GTA_IMPORT_REP_TEMP

Line 875: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ

871: , 'Assign value from TXT to record:'||SQLCODE||':'||SQLERRM);
872: END IF;
873:
874: ROLLBACK TO save_header_trans;
875: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
876: , SUCCEEDED
877: , Customer_Name
878: , Taxpayer_ID
879: , Invoice_Num

Line 884: VALUES(JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL

880: , Invoice_date
881: , Amount
882: , FailedReason
883: )
884: VALUES(JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL
885: , 'N'
886: , l_Customer_Name
887: , l_TP_TAX_REG_NUMBER
888: , l_Invoice_Num

Line 1001: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ

997: , 'Update original record:'||SQLCODE||':'||SQLERRM);
998: END IF;
999:
1000: ROLLBACK TO save_header_trans;
1001: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1002: , SUCCEEDED
1003: , Customer_Name
1004: , Taxpayer_ID
1005: , Invoice_Num

Line 1010: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1006: , Invoice_date
1007: , Amount
1008: , FailedReason
1009: )
1010: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1011: , 'N'
1012: , l_Customer_Name
1013: , l_TP_TAX_REG_NUMBER
1014: , l_Invoice_Num

Line 1033: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ

1029: --insert into GTA table
1030: BEGIN
1031: jmf_gta_trx_util.create_Trx(P_GTA_Trx => l_trx_rec);
1032:
1033: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1034: , SUCCEEDED
1035: , Customer_Name
1036: , Taxpayer_ID
1037: , Invoice_Num

Line 1042: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1038: , Invoice_date
1039: , Amount
1040: , STATUS
1041: )
1042: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1043: , 'Y'
1044: , l_Customer_Name
1045: , l_TP_TAX_REG_NUMBER
1046: , l_Invoice_Num

Line 1067: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ

1063: , 'Insert into base table:'||SQLCODE||':'||SQLERRM);
1064: END IF;
1065:
1066: ROLLBACK TO save_header_trans;
1067: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1068: , SUCCEEDED
1069: , Customer_Name
1070: , Taxpayer_ID
1071: , Invoice_Num

Line 1076: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1072: , Invoice_date
1073: , Amount
1074: , FailedReason
1075: )
1076: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1077: , 'N'
1078: , l_Customer_Name
1079: , l_TP_TAX_REG_NUMBER
1080: , l_Invoice_Num

Line 1100: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ

1096: );
1097:
1098: l_error_msg:=fnd_message.GET;
1099:
1100: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1101: , SUCCEEDED
1102: , Customer_Name
1103: , Taxpayer_ID
1104: , Invoice_Num

Line 1109: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1105: , Invoice_date
1106: , Amount
1107: , FailedReason
1108: )
1109: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1110: , 'N'
1111: , l_Customer_Name
1112: , l_TP_TAX_REG_NUMBER
1113: , l_Invoice_Num

Line 1138: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ

1134: );
1135:
1136: l_error_msg:=fnd_message.GET;
1137:
1138: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1139: , SUCCEEDED
1140: , Customer_Name
1141: , Taxpayer_ID
1142: , Invoice_Num

Line 1147: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1143: , Invoice_date
1144: , Amount
1145: , FailedReason
1146: )
1147: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1148: , 'N'
1149: , l_Customer_Name
1150: , l_TP_TAX_REG_NUMBER
1151: , l_Invoice_Num

Line 1169: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ

1165: ELSE --status error
1166: fnd_message.SET_NAME('JMF','JMF_GTA_WRONG_INV_STATUS');
1167: l_error_msg:=fnd_message.GET;
1168:
1169: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1170: , SUCCEEDED
1171: , Customer_Name
1172: , Taxpayer_ID
1173: , Invoice_Num

Line 1178: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1174: , Invoice_date
1175: , Amount
1176: , FailedReason
1177: )
1178: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1179: , 'N'
1180: , l_Customer_Name
1181: , l_TP_TAX_REG_NUMBER
1182: , l_Invoice_Num

Line 1200: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ

1196: --report JMF_GTA_MOAC_ERROR;
1197: /*fnd_message.SET_NAME('JMF','JMF_GTA_MOAC_FORBID');
1198: l_error_msg:=fnd_message.GET;
1199:
1200: INSERT INTO JMF_GTA_IMPORT_REP_TEMP( SEQ
1201: , SUCCEEDED
1202: , Customer_Name
1203: , Taxpayer_ID
1204: , Invoice_Num

Line 1209: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL

1205: , Invoice_date
1206: , Amount
1207: , FailedReason
1208: )
1209: VALUES( JMF_GTA_IMPORT_REP_TEMP_s.NEXTVAL
1210: , 'N'
1211: , l_Customer_Name
1212: , l_Taxpayer_ID
1213: , l_Invoice_Num

Line 1260: FROM JMF_GTA_IMPORT_REP_TEMP

1256: )
1257: )
1258: )
1259: INTO l_succ_XML
1260: FROM JMF_GTA_IMPORT_REP_TEMP
1261: WHERE SUCCEEDED='Y';
1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: NULL;

Line 1287: FROM JMF_GTA_IMPORT_REP_TEMP

1283: )
1284: )
1285: )
1286: INTO l_failed_XML
1287: FROM JMF_GTA_IMPORT_REP_TEMP
1288: WHERE SUCCEEDED='N';
1289: EXCEPTION
1290: WHEN OTHERS THEN
1291: NULL;