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.QLTTRAWB dependencies on QA_INTERFACE_ERRORS

Line 437: ' FROM QA_INTERFACE_ERRORS QIE ' ||

433: qa_core_pkg.dsql_add_bind(X_GROUP_ID);
434: qa_core_pkg.dsql_add_text(' AND QRI.PROCESS_STATUS = 2 ' ||
435: ' AND NOT EXISTS ' ||
436: ' (SELECT 1 ' ||
437: ' FROM QA_INTERFACE_ERRORS QIE ' ||
438: ' WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
439: ' QRI.TRANSACTION_INTERFACE_ID ' ||
440: ' AND QIE.ERROR_COLUMN IN ( ' );
441: qa_core_pkg.dsql_add_bind(l_col1);

Line 504: qa_core_pkg.dsql_add_text(' INSERT INTO QA_INTERFACE_ERRORS ' ||

500: BEGIN
501: parse_error_columns(ERROR_COL_LIST, l_col1, l_col2, l_col3, l_col4, l_col5);
502: qa_core_pkg.dsql_init;
503:
504: qa_core_pkg.dsql_add_text(' INSERT INTO QA_INTERFACE_ERRORS ' ||
505: '( TRANSACTION_INTERFACE_ID, ' ||
506: ' ERROR_COLUMN, ' ||
507: ' ERROR_MESSAGE, ' ||
508: ' LAST_UPDATE_DATE,' ||

Line 548: ' FROM QA_INTERFACE_ERRORS QIE ' ||

544: qa_core_pkg.dsql_add_text(' AND QRI.PROCESS_STATUS = 2 ' ||
545: ' AND NVL(QRI.MARKER, 0) = 0 ' ||
546: ' AND NOT EXISTS ' ||
547: ' (SELECT 1 ' ||
548: ' FROM QA_INTERFACE_ERRORS QIE ' ||
549: ' WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
550: ' QRI.TRANSACTION_INTERFACE_ID ' ||
551: ' AND QIE.ERROR_COLUMN IN ( ');
552:

Line 771: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

767: -- Also replaced :1 introduced in the version 115.63 by :ERROR_COL_NAME
768:
769: IF (X_MANDATORY = 1) THEN
770: SQL_STATEMENT :=
771: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
772: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
773: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
774: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
775: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 785: 'FROM QA_INTERFACE_ERRORS QIE ' ||

781: ' AND QRI.PROCESS_STATUS = 2 ' ||
782: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
783: ' AND NOT EXISTS
784: (SELECT ''X'' ' ||
785: 'FROM QA_INTERFACE_ERRORS QIE ' ||
786: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
787: 'QRI.TRANSACTION_INTERFACE_ID ' ||
788: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
789: ' AND EXISTS ' ||

Line 823: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

819: -- Same as the fix done for Bug 3079312.suramasw.
820: -- Also replaced :1 introduced in the version 115.63 by :ERROR_COL_NAME
821:
822: SQL_STATEMENT :=
823: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
824: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
825: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
826: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
827: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 837: 'FROM QA_INTERFACE_ERRORS QIE ' ||

833: ' AND QRI.PROCESS_STATUS = 2 ' ||
834: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
835: ' AND NOT EXISTS
836: (SELECT ''X'' ' ||
837: 'FROM QA_INTERFACE_ERRORS QIE ' ||
838: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
839: 'QRI.TRANSACTION_INTERFACE_ID ' ||
840: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
841: ' AND EXISTS ' ||

Line 867: -- Essentially it inserts error message into QA_INTERFACE_ERRORS for the following

863: END VALIDATE_REVISION;
864:
865: -- Bug 3775614. Component lot and serial numbers were not validated properly.
866: -- Added two new procedures to validate lot/serial number.
867: -- Essentially it inserts error message into QA_INTERFACE_ERRORS for the following
868: -- situations
869: -- (1) Lot/Serial number is mandatory and user has entered null value to lot/serial number.
870: -- (2) Item is not lot/serial controlled and user has entered some value to lot/serial number.
871: -- (3) Item is lot/serial controlled and user entered invalid value to lot/serial number.

Line 919: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

915: -- no lot control, and 2 means that it is full control.
916:
917: IF (X_MANDATORY = 1) THEN
918: SQL_STATEMENT :=
919: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
920: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
921: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
922: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
923: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 933: 'FROM QA_INTERFACE_ERRORS QIE ' ||

929: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
930: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
931: ' AND NOT EXISTS
932: (SELECT ''X'' ' ||
933: 'FROM QA_INTERFACE_ERRORS QIE ' ||
934: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
935: 'QRI.TRANSACTION_INTERFACE_ID ' ||
936: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
937: ' AND QRI.' || COL_NAME || ' IS NULL ' ||

Line 961: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

957: -- second, give errors for cases where lot is entered for an
958: -- item that is not under lot control
959:
960: SQL_STATEMENT :=
961: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
962: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
963: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
964: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
965: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 975: 'FROM QA_INTERFACE_ERRORS QIE ' ||

971: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
972: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
973: ' AND NOT EXISTS
974: (SELECT ''X'' ' ||
975: 'FROM QA_INTERFACE_ERRORS QIE ' ||
976: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
977: 'QRI.TRANSACTION_INTERFACE_ID ' ||
978: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
979: ' AND QRI.'|| COL_NAME || ' IS NOT NULL '||

Line 1001: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

997: -- If item is lot controlled and lot is entered validate the value entered.
998:
999:
1000: SQL_STATEMENT :=
1001: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
1002: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
1003: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
1004: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
1005: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 1015: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1011: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1012: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1013: ' AND NOT EXISTS
1014: (SELECT ''X'' ' ||
1015: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1016: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1017: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1018: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
1019: ' AND QRI.'|| COL_NAME || ' IS NOT NULL '||

Line 1087: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

1083:
1084:
1085: IF (X_MANDATORY = 1) THEN
1086: SQL_STATEMENT :=
1087: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
1088: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
1089: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
1090: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
1091: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 1101: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1097: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1098: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1099: ' AND NOT EXISTS
1100: (SELECT ''X'' ' ||
1101: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1102: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1103: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1104: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
1105: ' AND QRI.' || COL_NAME || ' IS NULL ' ||

Line 1129: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

1125: -- item that is not under SERIAL control
1126:
1127:
1128: SQL_STATEMENT :=
1129: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
1130: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
1131: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
1132: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
1133: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 1143: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1139: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1140: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1141: ' AND NOT EXISTS
1142: (SELECT ''X'' ' ||
1143: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1144: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1145: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1146: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
1147: ' AND QRI.'|| COL_NAME || ' IS NOT NULL '||

Line 1186: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

1182: -- If Lot Number and item are not passed
1183: -- saugupta Tue, 09 Oct 2007 07:11:47 -0700 PDT
1184:
1185: SQL_STATEMENT :=
1186: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
1187: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
1188: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
1189: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
1190: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 1200: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1196: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1197: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1198: ' AND NOT EXISTS
1199: (SELECT ''X'' ' ||
1200: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1201: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1202: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1203: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
1204: ' AND QRI.'|| COL_NAME || ' IS NOT NULL '||

Line 1290: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1286: ' AND QRI.PROCESS_STATUS = 2 ' ||
1287: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
1288: ' AND NOT EXISTS
1289: (SELECT ''X'' ' ||
1290: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1291: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1292: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1293: 'AND QIE.ERROR_COLUMN IN ( :ERROR_COL_NAME, NULL))' ||
1294: ' AND to_char(QRI.' || COL_NAME || ') NOT IN (to_char(:NULL_NUM), :NULL_CHAR, to_char(:null_date, ''DD-MON-YYYY HH24:MI:SS''))' ;

Line 1354: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

1350:
1351:
1352: FOR I IN 1..NUM_ROWS LOOP
1353: IF (QLTTRAFB.VALIDATE_TYPE(VALUE_TABLE(I), X_DATATYPE) = FALSE) THEN
1354: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
1355: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1356: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
1357: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
1358: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERRMSG,

Line 1463: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1459: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1460: ' AND QRI.PROCESS_STATUS = 2 ' ||
1461: ' AND NOT EXISTS
1462: (SELECT ''X'' ' ||
1463: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1464: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1465: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1466: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))'||
1467: ' AND to_char(QRI.' || COL_NAME || ') NOT IN (to_char(:null_num), :null_char, to_char(:null_date, ''DD-MON-YYYY HH24:MI:SS''))' ;

Line 1567: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1563: ' AND QRI.PROCESS_STATUS = 2 ' ||
1564: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
1565: ' AND NOT EXISTS
1566: (SELECT ''X'' ' ||
1567: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1568: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1569: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1570: 'AND QIE.ERROR_COLUMN IN ( :ERROR_COL_NAME, NULL)) '||
1571: ' AND QRI.ORGANIZATION_ID = MP.ORGANIZATION_ID';

Line 1638: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

1634: IF (GEN_LOC_CTRL_TABLE(I) = 1) THEN
1635: -- not under locator control. locator must be null
1636:
1637: IF (SEGS_TABLE(I) IS NOT NULL) THEN
1638: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
1639: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1640: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
1641: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
1642: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_CANT_HAVE_LOC,

Line 1667: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1663: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
1664: ' AND QRI.PROCESS_STATUS = 2 ' ||
1665: 'AND NOT EXISTS
1666: (SELECT ''X'' ' ||
1667: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1668: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1669: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1670: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
1671:

Line 1763: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1759: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
1760: ' AND QRI.PROCESS_STATUS = 2 ' ||
1761: 'AND NOT EXISTS
1762: (SELECT ''X'' ' ||
1763: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1764: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1765: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1766: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
1767:

Line 1781: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

1777:
1778: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
1779:
1780: ELSE
1781: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
1782: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1783: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
1784: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
1785: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

Line 1804: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

1800: -- Below introducing a new if condition to handle if validate_segs returns
1801: -- false value in V
1802: -- saugupta Fri, 30 Jul 2004 03:10:01 -0700 PDT
1803: ELSE
1804: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
1805: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1806: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
1807: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
1808: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

Line 1902: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1898: ' AND QRI.PROCESS_STATUS = 2 ' ||
1899: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
1900: ' AND NOT EXISTS
1901: (SELECT ''X'' ' ||
1902: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1903: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1904: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1905: 'AND QIE.ERROR_COLUMN IN ( :ERROR_COL_NAME, NULL))' ||
1906: ' AND QRI.ORGANIZATION_ID = MP.ORGANIZATION_ID';

Line 1972: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

1968:
1969: -- not under locator control. locator must be null
1970:
1971: IF (SEGS_TABLE(I) IS NOT NULL) THEN
1972: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
1973: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1974: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
1975: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
1976: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_CANT_HAVE_LOC,

Line 2000: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1996: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
1997: ' AND QRI.PROCESS_STATUS = 2 ' ||
1998: 'AND NOT EXISTS
1999: (SELECT ''X'' ' ||
2000: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2001: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2002: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2003: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
2004:

Line 2088: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2084: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
2085: ' AND QRI.PROCESS_STATUS = 2 ' ||
2086: 'AND NOT EXISTS
2087: (SELECT ''X'' ' ||
2088: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2089: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2090: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2091: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
2092:

Line 2105: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

2101: l_col1, l_col2, l_col3, l_col4, l_col5;
2102:
2103: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
2104: ELSE
2105: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
2106: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2107: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
2108: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
2109: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

Line 2129: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

2125: -- Below introducing a new if condition to handle if validate_segs returns
2126: -- false value in V
2127: -- saugupta Fri, 30 Jul 2004 03:10:01 -0700 PDT
2128: ELSE
2129: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
2130: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2131: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
2132: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
2133: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

Line 2253: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2249: ' AND QRI.PROCESS_STATUS = 2 ' ||
2250: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
2251: ' AND NOT EXISTS
2252: (SELECT ''X'' ' ||
2253: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2254: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2255: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2256: 'AND QIE.ERROR_COLUMN IN ( :ERROR_COL_NAME, NULL))';
2257:

Line 2396: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2392: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
2393: ' AND QRI.PROCESS_STATUS = 2 ' ||
2394: 'AND NOT EXISTS
2395: (SELECT ''X'' ' ||
2396: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2397: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2398: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2399: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
2400:

Line 2422: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

2418:
2419:
2420: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
2421: ELSE
2422: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
2423: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2424: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
2425: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
2426: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

Line 2452: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

2448: -- srhariha. Wed Aug 4 23:33:07 PDT 2004.
2449:
2450: IF ( COL_NAME = 'COMP_ITEM') THEN
2451: SQL_STATEMENT :=
2452: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
2453: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
2454: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
2455: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
2456: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 2465: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2461: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2462: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
2463: ' AND NOT EXISTS ' ||
2464: '(SELECT ''X'' ' ||
2465: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2466: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2467: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2468: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
2469: ' AND QRI.' || ID_FIELD || ' IS NOT NULL ' ||

Line 2578: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2574: ' AND QRI.PROCESS_STATUS = 2 ' ||
2575: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
2576: ' AND NOT EXISTS
2577: (SELECT ''X'' ' ||
2578: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2579: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2580: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2581: 'AND QIE.ERROR_COLUMN IN ( :ERROR_COL_NAME, NULL)) ';
2582:

Line 2663: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2659: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
2660: ' AND QRI.PROCESS_STATUS = 2 ' ||
2661: 'AND NOT EXISTS
2662: (SELECT ''X'' ' ||
2663: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2664: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2665: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2666: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
2667: EXECUTE IMMEDIATE SQL_STATEMENT USING X_LAST_UPDATE_LOGIN,

Line 2678: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

2674: l_col1, l_col2, l_col3, l_col4, l_col5;
2675:
2676: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
2677: ELSE
2678: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
2679: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2680: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
2681: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
2682: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

Line 2761: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2757: ' AND QRI.PROCESS_STATUS = 2 ' ||
2758: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
2759: ' AND NOT EXISTS
2760: (SELECT ''X'' ' ||
2761: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2762: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2763: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2764: 'AND QIE.ERROR_COLUMN IN ( :ERROR_COL_NAME, NULL))';
2765:

Line 2850: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2846: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
2847: ' AND QRI.PROCESS_STATUS = 2 ' ||
2848: 'AND NOT EXISTS
2849: (SELECT ''X'' ' ||
2850: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2851: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2852: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2853: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
2854:

Line 2866: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

2862: l_col1, l_col2, l_col3, l_col4, l_col5;
2863:
2864: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
2865: ELSE
2866: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
2867: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2868: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
2869: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
2870: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

Line 2914: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

2910: -- Same as the fix done for Bug 3079312.suramasw.
2911: -- Also replaced :1 introduced in the version 115.63 by :ERROR_COL_NAME
2912:
2913: SQL_STATEMENT :=
2914: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
2915: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
2916: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
2917: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
2918: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 2927: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2923: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2924: ' AND QRI.PROCESS_STATUS = 2 ' ||
2925: 'AND NOT EXISTS
2926: (SELECT ''X'' ' ||
2927: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2928: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2929: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2930: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
2931: 'AND QRI.' || COL_NAME || ' IS NOT NULL ' ||

Line 2997: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

2993:
2994: -- Also replaced :1 introduced in the version 115.63 by :ERROR_COL_NAME
2995:
2996: SQL_STATEMENT :=
2997: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
2998: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
2999: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
3000: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
3001: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 3010: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3006: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3007: ' AND QRI.PROCESS_STATUS = 2 ' ||
3008: 'AND NOT EXISTS
3009: (SELECT ''X'' ' ||
3010: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3011: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3012: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3013: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
3014: 'AND QRI.' || COL_NAME || ' IS NOT NULL ' ||

Line 3075: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3071: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3072: ' AND QRI.PROCESS_STATUS = 2 ' ||
3073: 'AND NOT EXISTS
3074: (SELECT ''X'' ' ||
3075: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3076: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3077: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3078: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
3079:

Line 3125: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

3121: -- Same as the fix done for Bug 3079312.suramasw.
3122: -- Also replaced :1 introduced in the version 115.63 by :ERROR_COL_NAME
3123:
3124: SQL_STATEMENT :=
3125: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
3126: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
3127: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
3128: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
3129: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 3138: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3134: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3135: ' AND QRI.PROCESS_STATUS = 2 ' ||
3136: 'AND NOT EXISTS
3137: (SELECT ''X'' ' ||
3138: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3139: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3140: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3141: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
3142: 'AND QRI.' || COL_NAME || ' IS NOT NULL ' ||

Line 3201: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3197: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3198: ' AND QRI.PROCESS_STATUS = 2 ' ||
3199: 'AND NOT EXISTS
3200: (SELECT ''X'' ' ||
3201: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3202: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3203: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3204: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
3205:

Line 3284: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

3280: -- bug 12739071
3281: -- Added to_char() around the variable thats being validated
3282: --
3283: SQL_STATEMENT :=
3284: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
3285: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
3286: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
3287: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
3288: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 3297: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3293: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3294: ' AND QRI.PROCESS_STATUS = 2 ' ||
3295: 'AND NOT EXISTS
3296: (SELECT ''X'' ' ||
3297: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3298: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3299: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3300: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
3301: 'AND QRI.' || COL_NAME || ' IS NOT NULL ' ||

Line 3387: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3383: WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3384: ' AND QRI.PROCESS_STATUS = 2 ' ||
3385: 'AND NOT EXISTS
3386: (SELECT ''X'' ' ||
3387: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3388: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3389: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3390: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
3391:

Line 3448: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3444: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3445: ' AND QRI.PROCESS_STATUS = 2 ' ||
3446: 'AND NOT EXISTS
3447: (SELECT ''X'' ' ||
3448: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3449: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3450: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3451: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
3452:

Line 3503: FROM qa_interface_errors qie

3499: PROGRAM_ID = X_PROGRAM_ID,
3500: PROGRAM_UPDATE_DATE = SYSDATE
3501: WHERE qri.GROUP_ID = X_GROUP_ID AND EXISTS
3502: (SELECT 1
3503: FROM qa_interface_errors qie
3504: WHERE qie.transaction_interface_id = qri.transaction_interface_id);
3505:
3506: IF (sql%rowcount >0) THEN
3507: QLTTRAMB.qa_import_log('In SET_ERROR_STATUS X_COLUMN_NAME is null. Error count :'|| sql%rowcount);

Line 3513: -- FROM QA_INTERFACE_ERRORS);

3509:
3510: -- Bug 1558445, slow performance.
3511: -- AND TRANSACTION_INTERFACE_ID IN
3512: -- (SELECT TRANSACTION_INTERFACE_ID
3513: -- FROM QA_INTERFACE_ERRORS);
3514: ELSE
3515: UPDATE QA_RESULTS_INTERFACE QRI
3516: SET PROCESS_STATUS = 3,
3517: LAST_UPDATE_DATE = SYSDATE,

Line 3526: FROM QA_INTERFACE_ERRORS QIE

3522: PROGRAM_UPDATE_DATE = SYSDATE
3523: WHERE GROUP_ID = X_GROUP_ID
3524: AND EXISTS
3525: (SELECT TRANSACTION_INTERFACE_ID, ERROR_COLUMN
3526: FROM QA_INTERFACE_ERRORS QIE
3527: WHERE QIE.TRANSACTION_INTERFACE_ID =
3528: QRI.TRANSACTION_INTERFACE_ID
3529: AND QIE.ERROR_COLUMN = X_COLUMN_NAME);
3530:

Line 3580: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

3576: -- SQL Bind project. Code modified to use bind variables instead of literals
3577: -- Same as the fix done for Bug 3079312.suramasw.
3578:
3579: SQL_STATEMENT :=
3580: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
3581: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
3582: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
3583: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
3584: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 3593: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3589: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3590: ' AND QRI.PROCESS_STATUS = 2 ' ||
3591: 'AND NOT EXISTS
3592: (SELECT ''X'' ' ||
3593: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3594: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3595: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3596: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))
3597: AND NOT EXISTS ' ||

Line 4247: 'FROM QA_INTERFACE_ERRORS QIE ' ||

4243: X_COL_NAME || ' = :NEW_SEQUENCE ' ||
4244: ' WHERE QRI.GROUP_ID = :GROUP_ID ' ||
4245: ' AND QRI.PROCESS_STATUS = 2 ' ||
4246: 'AND NOT EXISTS (SELECT ''X'' ' ||
4247: 'FROM QA_INTERFACE_ERRORS QIE ' ||
4248: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
4249: 'QRI.TRANSACTION_INTERFACE_ID )';
4250:
4251:

Line 4680: INSERT INTO QA_INTERFACE_ERRORS

4676:
4677: EXCEPTION
4678: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
4679:
4680: INSERT INTO QA_INTERFACE_ERRORS
4681: (TRANSACTION_INTERFACE_ID,
4682: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4683: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
4684: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE)

Line 4706: INSERT INTO QA_INTERFACE_ERRORS

4702: RETURN '';
4703:
4704: WHEN MATCHING_ERROR THEN
4705:
4706: INSERT INTO QA_INTERFACE_ERRORS
4707: (TRANSACTION_INTERFACE_ID,
4708: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4709: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
4710: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE)

Line 4731: INSERT INTO QA_INTERFACE_ERRORS

4727: RETURN '';
4728:
4729: WHEN NO_ROWIDS_ERROR THEN
4730:
4731: INSERT INTO QA_INTERFACE_ERRORS
4732: (TRANSACTION_INTERFACE_ID,
4733: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4734: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
4735: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE)

Line 4757: INSERT INTO QA_INTERFACE_ERRORS

4753: RETURN '';
4754:
4755: WHEN MORE_THAN_ONE_ROWID_ERROR THEN
4756:
4757: INSERT INTO QA_INTERFACE_ERRORS
4758: (TRANSACTION_INTERFACE_ID,
4759: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4760: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
4761: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE)

Line 5106: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,

5102: -- Added the condition INSERT_TYPE <> 2 as QA_CREATED_BY_NAME should be validated
5103: -- only during Insert transaction.
5104: -- Bug 3663648.suramasw.
5105:
5106: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
5107: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
5108: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
5109: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
5110: PROGRAM_UPDATE_DATE)

Line 5122: FROM QA_INTERFACE_ERRORS QIE

5118: AND QRI.PROCESS_STATUS = 2
5119: AND QRI.INSERT_TYPE <> 2 -- added for 3663648
5120: AND NOT EXISTS
5121: (SELECT 'X'
5122: FROM QA_INTERFACE_ERRORS QIE
5123: WHERE QIE.TRANSACTION_INTERFACE_ID =
5124: QRI.TRANSACTION_INTERFACE_ID
5125: AND QIE.ERROR_COLUMN IN ('QA_CREATED_BY_NAME', NULL))
5126: AND NOT EXISTS

Line 5168: FROM QA_INTERFACE_ERRORS QIE

5164: AND QRI.PROCESS_STATUS = 2
5165: AND QRI.INSERT_TYPE <> 2 -- added for 3663648
5166: AND NOT EXISTS
5167: (SELECT 'X'
5168: FROM QA_INTERFACE_ERRORS QIE
5169: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID
5170: AND QIE.ERROR_COLUMN IN ('QA_CREATED_BY_NAME', NULL));
5171:
5172: -- set qa_last_updated_by_name and _id to the current user if they are null

Line 5193: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,

5189: -- Added the condition INSERT_TYPE = 2 because QA_LAST_UPDATED_BY_NAME
5190: -- should be validated only during update transaction.
5191: -- Bug 3663648.suramasw.
5192:
5193: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
5194: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
5195: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
5196: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
5197: PROGRAM_UPDATE_DATE)

Line 5209: FROM QA_INTERFACE_ERRORS QIE

5205: AND QRI.PROCESS_STATUS = 2
5206: AND QRI.INSERT_TYPE = 2 -- added for 3663648
5207: AND NOT EXISTS
5208: (SELECT 'X'
5209: FROM QA_INTERFACE_ERRORS QIE
5210: WHERE QIE.TRANSACTION_INTERFACE_ID =
5211: QRI.TRANSACTION_INTERFACE_ID
5212: AND QIE.ERROR_COLUMN IN ('QA_LAST_UPDATED_BY_NAME', NULL))
5213: AND NOT EXISTS

Line 5251: FROM QA_INTERFACE_ERRORS QIE

5247: AND QRI.PROCESS_STATUS = 2
5248: AND QRI.INSERT_TYPE = 2 -- added for 3663648
5249: AND NOT EXISTS
5250: (SELECT 'X'
5251: FROM QA_INTERFACE_ERRORS QIE
5252: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID
5253: AND QIE.ERROR_COLUMN IN ('QA_LAST_UPDATED_BY_NAME', NULL));
5254:
5255:

Line 5259: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,

5255:
5256: -- group validation for organization_code
5257: -- Bug 4958776. SQL Repository Fix SQL ID: 15009159
5258: -- replaced ORG_ORGANIZATION_DEFINITIONS with MTL_PARAMETERS
5259: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
5260: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
5261: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
5262: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
5263: PROGRAM_UPDATE_DATE)

Line 5274: FROM QA_INTERFACE_ERRORS QIE

5270: WHERE QRI.GROUP_ID = X_GROUP_ID
5271: AND QRI.PROCESS_STATUS = 2
5272: AND NOT EXISTS
5273: (SELECT 'X'
5274: FROM QA_INTERFACE_ERRORS QIE
5275: WHERE QIE.TRANSACTION_INTERFACE_ID =
5276: QRI.TRANSACTION_INTERFACE_ID
5277: AND QIE.ERROR_COLUMN IN ('ORGANIZATION_CODE', NULL))
5278: AND NOT EXISTS

Line 5306: FROM QA_INTERFACE_ERRORS QIE

5302: WHERE QRI.GROUP_ID = X_GROUP_ID
5303: AND QRI.PROCESS_STATUS = 2
5304: AND NOT EXISTS
5305: (SELECT 'X'
5306: FROM QA_INTERFACE_ERRORS QIE
5307: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID
5308: AND QIE.ERROR_COLUMN IN ('ORGANIZATION_CODE', NULL));
5309:
5310: -- set process_status to 3 for all rows where org_code had an error.

Line 5379: INSERT INTO qa_interface_errors(

5375: qri.process_status = 2 AND
5376: qri.operating_unit IS NOT NULL AND
5377: qri.operating_unit_id IS NULL;
5378:
5379: INSERT INTO qa_interface_errors(
5380: transaction_interface_id,
5381: error_column,
5382: error_message,
5383: last_update_date,

Line 5421: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,

5417: ----------------------------------------------------------------------------
5418:
5419: -- group validation for plan_name
5420:
5421: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
5422: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
5423: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
5424: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
5425: PROGRAM_UPDATE_DATE)

Line 5436: FROM QA_INTERFACE_ERRORS QIE

5432: WHERE QRI.GROUP_ID = X_GROUP_ID
5433: AND QRI.PROCESS_STATUS = 2
5434: AND NOT EXISTS
5435: (SELECT 'X'
5436: FROM QA_INTERFACE_ERRORS QIE
5437: WHERE QIE.TRANSACTION_INTERFACE_ID =
5438: QRI.TRANSACTION_INTERFACE_ID
5439: AND QIE.ERROR_COLUMN IN ('PLAN_NAME', NULL))
5440: AND NOT EXISTS

Line 5468: FROM QA_INTERFACE_ERRORS QIE

5464: WHERE QRI.GROUP_ID = X_GROUP_ID
5465: AND QRI.PROCESS_STATUS = 2
5466: AND NOT EXISTS
5467: (SELECT 'X'
5468: FROM QA_INTERFACE_ERRORS QIE
5469: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID
5470: AND QIE.ERROR_COLUMN IN ('PLAN_NAME', NULL));
5471:
5472: -- group validation for spec_name

Line 5480: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,

5476: -- subquery. It uses too much shared memory. Replaced with
5477: -- QA_SPECS and appended the effective date validation.
5478: -- bso Mon Nov 25 18:15:12 PST 2002
5479: --
5480: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
5481: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
5482: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
5483: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
5484: PROGRAM_UPDATE_DATE)

Line 5495: FROM QA_INTERFACE_ERRORS QIE

5491: WHERE QRI.GROUP_ID = X_GROUP_ID
5492: AND QRI.PROCESS_STATUS = 2
5493: AND NOT EXISTS
5494: (SELECT 'X'
5495: FROM QA_INTERFACE_ERRORS QIE
5496: WHERE QIE.TRANSACTION_INTERFACE_ID =
5497: QRI.TRANSACTION_INTERFACE_ID
5498: AND QIE.ERROR_COLUMN IN ('SPEC_NAME', NULL))
5499: AND (QRI.SPEC_NAME IS NOT NULL

Line 5539: FROM QA_INTERFACE_ERRORS QIE

5535: WHERE QRI.GROUP_ID = X_GROUP_ID
5536: AND QRI.PROCESS_STATUS = 2
5537: AND NOT EXISTS
5538: (SELECT 'X'
5539: FROM QA_INTERFACE_ERRORS QIE
5540: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID
5541: AND QIE.ERROR_COLUMN IN ('SPEC_NAME', NULL));
5542:
5543: -- set process_status to 3 for all rows where plan_name or spec_name

Line 5565: FROM QA_INTERFACE_ERRORS QIE

5561: FROM QA_RESULTS_INTERFACE QRI
5562: WHERE QRI.GROUP_ID = X_GROUP_ID
5563: AND NOT EXISTS
5564: (SELECT 'X'
5565: FROM QA_INTERFACE_ERRORS QIE
5566: WHERE QIE.TRANSACTION_INTERFACE_ID =
5567: QRI.TRANSACTION_INTERFACE_ID
5568: AND QIE.ERROR_COLUMN IN ('ORGANIZATION_CODE', 'PLAN_NAME',
5569: 'SPEC_NAME', NULL));

Line 7931: 'FROM QA_INTERFACE_ERRORS QIE ' ||

7927: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
7928: ' AND QRI.PROCESS_STATUS = 2 ' ||
7929: ' AND NOT EXISTS
7930: (SELECT ''X'' ' ||
7931: 'FROM QA_INTERFACE_ERRORS QIE ' ||
7932: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
7933: 'QRI.TRANSACTION_INTERFACE_ID )';
7934:
7935: SOURCE_CURSOR := DBMS_SQL.OPEN_CURSOR;

Line 7989: FROM QA_INTERFACE_ERRORS QIE

7985: WHERE QRI.GROUP_ID = X_GROUP_ID
7986: AND QRI.TRANSACTION_INTERFACE_ID = INTERFACE_ID_TABLE(J)
7987: AND NOT EXISTS
7988: (SELECT 'X'
7989: FROM QA_INTERFACE_ERRORS QIE
7990: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID);
7991:
7992: -- End of changes for bug 2548710.
7993:

Line 8161: INSERT INTO QA_INTERFACE_ERRORS

8157: -- pdube Mon Jun 15 23:07:13 PDT 2009
8158: EXCEPTION
8159:
8160: WHEN resource_busy THEN
8161: INSERT INTO QA_INTERFACE_ERRORS
8162: (TRANSACTION_INTERFACE_ID, ERROR_MESSAGE, ERROR_COLUMN,
8163: LAST_UPDATE_DATE, LAST_UPDATED_BY,
8164: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
8165: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,

Line 8408: 'FROM QA_INTERFACE_ERRORS QIE ' ||

8404: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
8405: ' AND QRI.PROCESS_STATUS = 2 ' ||
8406: ' AND NOT EXISTS
8407: (SELECT ''X'' ' ||
8408: 'FROM QA_INTERFACE_ERRORS QIE ' ||
8409: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
8410: 'QRI.TRANSACTION_INTERFACE_ID )';
8411:
8412:

Line 8467: FROM QA_INTERFACE_ERRORS QIE

8463: WHERE QRI.GROUP_ID = X_GROUP_ID
8464: AND QRI.TRANSACTION_INTERFACE_ID = INTERFACE_ID_TABLE(J)
8465: AND NOT EXISTS
8466: (SELECT 'X'
8467: FROM QA_INTERFACE_ERRORS QIE
8468: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID);
8469:
8470: -- End of changes for bug 2548710.
8471: */

Line 8661: DELETE FROM QA_INTERFACE_ERRORS

8657: -- delete rows from the errors table that are associated with the
8658: -- rows we are about to validate. we do this so that old errors will
8659: -- not stick around after the user has resubmitted a record.
8660:
8661: DELETE FROM QA_INTERFACE_ERRORS
8662: WHERE TRANSACTION_INTERFACE_ID IN
8663: (SELECT TRANSACTION_INTERFACE_ID
8664: FROM QA_RESULTS_INTERFACE
8665: WHERE GROUP_ID = X_GROUP_ID);

Line 8899: INSERT INTO qa_interface_errors

8895: l_error_message := error_bad_sql || ' ' || g_sqlerrm;
8896:
8897: QLTTRAMB.qa_import_log('Exception user_sql_error :'||l_error_message);
8898:
8899: INSERT INTO qa_interface_errors
8900: (transaction_interface_id, error_message, error_column,
8901: last_update_date, last_updated_by,
8902: creation_date, created_by, last_update_login,
8903: request_id, program_application_id, program_id,

Line 8925: INSERT INTO QA_INTERFACE_ERRORS

8921: RETURN FALSE;
8922:
8923: WHEN OTHERS THEN
8924: QLTTRAMB.qa_import_log('Exception when others :'||sqlerrm(sqlcode));
8925: INSERT INTO QA_INTERFACE_ERRORS
8926: (TRANSACTION_INTERFACE_ID, ERROR_MESSAGE, ERROR_COLUMN,
8927: LAST_UPDATE_DATE, LAST_UPDATED_BY,
8928: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
8929: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,

Line 9272: DELETE FROM QA_INTERFACE_ERRORS

9268: AND PROCESS_STATUS = 2;
9269:
9270: -- delete any error messages still around for successfully-validated rows
9271:
9272: DELETE FROM QA_INTERFACE_ERRORS
9273: WHERE TRANSACTION_INTERFACE_ID IN
9274: (SELECT TRANSACTION_INTERFACE_ID
9275: FROM QA_RESULTS_INTERFACE
9276: WHERE PROCESS_STATUS = 4);