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 819: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||

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

Line 833: 'FROM QA_INTERFACE_ERRORS QIE ' ||

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

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

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

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

909: -- no lot control, and 2 means that it is full control.
910:
911: IF (X_MANDATORY = 1) THEN
912: SQL_STATEMENT :=
913: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
914: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
915: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
916: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
917: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 927: 'FROM QA_INTERFACE_ERRORS QIE ' ||

923: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
924: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
925: ' AND NOT EXISTS
926: (SELECT ''X'' ' ||
927: 'FROM QA_INTERFACE_ERRORS QIE ' ||
928: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
929: 'QRI.TRANSACTION_INTERFACE_ID ' ||
930: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
931: ' AND QRI.' || COL_NAME || ' IS NULL ' ||

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

947: -- second, give errors for cases where lot is entered for an
948: -- item that is not under lot control
949:
950: SQL_STATEMENT :=
951: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
952: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
953: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
954: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
955: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 965: 'FROM QA_INTERFACE_ERRORS QIE ' ||

961: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
962: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
963: ' AND NOT EXISTS
964: (SELECT ''X'' ' ||
965: 'FROM QA_INTERFACE_ERRORS QIE ' ||
966: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
967: 'QRI.TRANSACTION_INTERFACE_ID ' ||
968: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
969: ' AND QRI.'|| COL_NAME || ' IS NOT NULL '||

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

985: -- If item is lot controlled and lot is entered validate the value entered.
986:
987:
988: SQL_STATEMENT :=
989: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
990: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
991: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
992: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
993: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 1003: 'FROM QA_INTERFACE_ERRORS QIE ' ||

999: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1000: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1001: ' AND NOT EXISTS
1002: (SELECT ''X'' ' ||
1003: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1004: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1005: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1006: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
1007: ' AND QRI.'|| COL_NAME || ' IS NOT NULL '||

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

1068:
1069:
1070: IF (X_MANDATORY = 1) THEN
1071: SQL_STATEMENT :=
1072: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
1073: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
1074: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
1075: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
1076: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 1086: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1082: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1083: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1084: ' AND NOT EXISTS
1085: (SELECT ''X'' ' ||
1086: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1087: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1088: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1089: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
1090: ' AND QRI.' || COL_NAME || ' IS NULL ' ||

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

1106: -- item that is not under SERIAL control
1107:
1108:
1109: SQL_STATEMENT :=
1110: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
1111: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
1112: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
1113: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
1114: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 1124: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1120: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1121: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1122: ' AND NOT EXISTS
1123: (SELECT ''X'' ' ||
1124: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1125: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1126: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1127: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
1128: ' AND QRI.'|| COL_NAME || ' IS NOT NULL '||

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

1159: -- If Lot Number and item are not passed
1160: -- saugupta Tue, 09 Oct 2007 07:11:47 -0700 PDT
1161:
1162: SQL_STATEMENT :=
1163: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
1164: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
1165: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
1166: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
1167: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 1177: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1173: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
1174: ' AND QRI.' || PARENT_COL_NAME || ' IS NOT NULL' ||
1175: ' AND NOT EXISTS
1176: (SELECT ''X'' ' ||
1177: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1178: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1179: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1180: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
1181: ' AND QRI.'|| COL_NAME || ' IS NOT NULL '||

Line 1251: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1247: ' AND QRI.PROCESS_STATUS = 2 ' ||
1248: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
1249: ' AND NOT EXISTS
1250: (SELECT ''X'' ' ||
1251: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1252: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1253: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1254: 'AND QIE.ERROR_COLUMN IN ( :ERROR_COL_NAME, NULL))';
1255:

Line 1298: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

1294:
1295:
1296: FOR I IN 1..NUM_ROWS LOOP
1297: IF (QLTTRAFB.VALIDATE_TYPE(VALUE_TABLE(I), X_DATATYPE) = FALSE) THEN
1298: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
1299: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1300: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
1301: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
1302: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERRMSG,

Line 1394: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1390: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
1391: ' AND QRI.PROCESS_STATUS = 2 ' ||
1392: 'AND NOT EXISTS
1393: (SELECT ''X'' ' ||
1394: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1395: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1396: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1397: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
1398:

Line 1494: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1490: ' AND QRI.PROCESS_STATUS = 2 ' ||
1491: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
1492: ' AND NOT EXISTS
1493: (SELECT ''X'' ' ||
1494: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1495: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1496: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1497: 'AND QIE.ERROR_COLUMN IN ( :ERROR_COL_NAME, NULL)) '||
1498: ' AND QRI.ORGANIZATION_ID = MP.ORGANIZATION_ID';

Line 1565: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

1561: IF (GEN_LOC_CTRL_TABLE(I) = 1) THEN
1562: -- not under locator control. locator must be null
1563:
1564: IF (SEGS_TABLE(I) IS NOT NULL) THEN
1565: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
1566: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1567: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
1568: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
1569: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_CANT_HAVE_LOC,

Line 1590: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1586: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
1587: ' AND QRI.PROCESS_STATUS = 2 ' ||
1588: 'AND NOT EXISTS
1589: (SELECT ''X'' ' ||
1590: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1591: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1592: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1593: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
1594:

Line 1686: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1682: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
1683: ' AND QRI.PROCESS_STATUS = 2 ' ||
1684: 'AND NOT EXISTS
1685: (SELECT ''X'' ' ||
1686: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1687: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1688: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1689: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
1690:

Line 1704: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

1700:
1701: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
1702:
1703: ELSE
1704: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
1705: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1706: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
1707: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
1708: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

Line 1724: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

1720: -- Below introducing a new if condition to handle if validate_segs returns
1721: -- false value in V
1722: -- saugupta Fri, 30 Jul 2004 03:10:01 -0700 PDT
1723: ELSE
1724: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
1725: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1726: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
1727: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
1728: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

Line 1819: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1815: ' AND QRI.PROCESS_STATUS = 2 ' ||
1816: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
1817: ' AND NOT EXISTS
1818: (SELECT ''X'' ' ||
1819: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1820: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1821: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1822: 'AND QIE.ERROR_COLUMN IN ( :ERROR_COL_NAME, NULL))' ||
1823: ' AND QRI.ORGANIZATION_ID = MP.ORGANIZATION_ID';

Line 1889: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

1885:
1886: -- not under locator control. locator must be null
1887:
1888: IF (SEGS_TABLE(I) IS NOT NULL) THEN
1889: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
1890: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1891: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
1892: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
1893: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_CANT_HAVE_LOC,

Line 1913: 'FROM QA_INTERFACE_ERRORS QIE ' ||

1909: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
1910: ' AND QRI.PROCESS_STATUS = 2 ' ||
1911: 'AND NOT EXISTS
1912: (SELECT ''X'' ' ||
1913: 'FROM QA_INTERFACE_ERRORS QIE ' ||
1914: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
1915: 'QRI.TRANSACTION_INTERFACE_ID ' ||
1916: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
1917:

Line 2001: 'FROM QA_INTERFACE_ERRORS QIE ' ||

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

Line 2018: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

2014: l_col1, l_col2, l_col3, l_col4, l_col5;
2015:
2016: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
2017: ELSE
2018: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
2019: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2020: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
2021: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
2022: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

Line 2039: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

2035: -- Below introducing a new if condition to handle if validate_segs returns
2036: -- false value in V
2037: -- saugupta Fri, 30 Jul 2004 03:10:01 -0700 PDT
2038: ELSE
2039: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
2040: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2041: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
2042: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
2043: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

Line 2160: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2156: ' AND QRI.PROCESS_STATUS = 2 ' ||
2157: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
2158: ' AND NOT EXISTS
2159: (SELECT ''X'' ' ||
2160: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2161: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2162: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2163: 'AND QIE.ERROR_COLUMN IN ( :ERROR_COL_NAME, NULL))';
2164:

Line 2303: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2299: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
2300: ' AND QRI.PROCESS_STATUS = 2 ' ||
2301: 'AND NOT EXISTS
2302: (SELECT ''X'' ' ||
2303: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2304: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2305: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2306: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
2307:

Line 2329: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

2325:
2326:
2327: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
2328: ELSE
2329: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
2330: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2331: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
2332: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
2333: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

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

2351: -- srhariha. Wed Aug 4 23:33:07 PDT 2004.
2352:
2353: IF ( COL_NAME = 'COMP_ITEM') THEN
2354: SQL_STATEMENT :=
2355: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
2356: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
2357: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
2358: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
2359: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 2368: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2364: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2365: ' AND QRI.PROCESS_STATUS = :PROCESS_STATUS ' ||
2366: ' AND NOT EXISTS ' ||
2367: '(SELECT ''X'' ' ||
2368: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2369: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2370: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2371: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
2372: ' AND QRI.' || ID_FIELD || ' IS NOT NULL ' ||

Line 2478: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2474: ' AND QRI.PROCESS_STATUS = 2 ' ||
2475: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
2476: ' AND NOT EXISTS
2477: (SELECT ''X'' ' ||
2478: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2479: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2480: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2481: 'AND QIE.ERROR_COLUMN IN ( :ERROR_COL_NAME, NULL)) ';
2482:

Line 2563: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2559: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
2560: ' AND QRI.PROCESS_STATUS = 2 ' ||
2561: 'AND NOT EXISTS
2562: (SELECT ''X'' ' ||
2563: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2564: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2565: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2566: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
2567: EXECUTE IMMEDIATE SQL_STATEMENT USING X_LAST_UPDATE_LOGIN,

Line 2578: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

2574: l_col1, l_col2, l_col3, l_col4, l_col5;
2575:
2576: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
2577: ELSE
2578: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
2579: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2580: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
2581: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
2582: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

Line 2657: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2653: ' AND QRI.PROCESS_STATUS = 2 ' ||
2654: ' AND QRI.' || COL_NAME || ' IS NOT NULL ' ||
2655: ' AND NOT EXISTS
2656: (SELECT ''X'' ' ||
2657: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2658: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2659: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2660: 'AND QIE.ERROR_COLUMN IN ( :ERROR_COL_NAME, NULL))';
2661:

Line 2746: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2742: ' AND QRI.TRANSACTION_INTERFACE_ID = :INTERFACE_ID_TABLE ' ||
2743: ' AND QRI.PROCESS_STATUS = 2 ' ||
2744: 'AND NOT EXISTS
2745: (SELECT ''X'' ' ||
2746: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2747: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2748: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2749: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
2750:

Line 2762: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,

2758: l_col1, l_col2, l_col3, l_col4, l_col5;
2759:
2760: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
2761: ELSE
2762: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID,
2763: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2764: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
2765: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) VALUES
2766: (INTERFACE_ID_TABLE(I), ERROR_COL_NAME, ERROR_INVALID_VALUE,

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

2802: -- Same as the fix done for Bug 3079312.suramasw.
2803: -- Also replaced :1 introduced in the version 115.63 by :ERROR_COL_NAME
2804:
2805: SQL_STATEMENT :=
2806: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
2807: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
2808: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
2809: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
2810: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 2819: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2815: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2816: ' AND QRI.PROCESS_STATUS = 2 ' ||
2817: 'AND NOT EXISTS
2818: (SELECT ''X'' ' ||
2819: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2820: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2821: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2822: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
2823: 'AND QRI.' || COL_NAME || ' IS NOT NULL ' ||

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

2878:
2879: -- Also replaced :1 introduced in the version 115.63 by :ERROR_COL_NAME
2880:
2881: SQL_STATEMENT :=
2882: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
2883: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
2884: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
2885: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
2886: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 2895: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2891: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2892: ' AND QRI.PROCESS_STATUS = 2 ' ||
2893: 'AND NOT EXISTS
2894: (SELECT ''X'' ' ||
2895: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2896: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2897: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2898: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
2899: 'AND QRI.' || COL_NAME || ' IS NOT NULL ' ||

Line 2957: 'FROM QA_INTERFACE_ERRORS QIE ' ||

2953: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
2954: ' AND QRI.PROCESS_STATUS = 2 ' ||
2955: 'AND NOT EXISTS
2956: (SELECT ''X'' ' ||
2957: 'FROM QA_INTERFACE_ERRORS QIE ' ||
2958: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
2959: 'QRI.TRANSACTION_INTERFACE_ID ' ||
2960: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
2961:

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

3003: -- Same as the fix done for Bug 3079312.suramasw.
3004: -- Also replaced :1 introduced in the version 115.63 by :ERROR_COL_NAME
3005:
3006: SQL_STATEMENT :=
3007: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
3008: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
3009: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
3010: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
3011: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 3020: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3016: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3017: ' AND QRI.PROCESS_STATUS = 2 ' ||
3018: 'AND NOT EXISTS
3019: (SELECT ''X'' ' ||
3020: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3021: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3022: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3023: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
3024: 'AND QRI.' || COL_NAME || ' IS NOT NULL ' ||

Line 3079: 'FROM QA_INTERFACE_ERRORS QIE ' ||

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

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

3150: -- Same as the fix done for Bug 3079312.suramasw.
3151: -- Also replaced :1 introduced in the version 115.63 by :ERROR_COL_NAME
3152:
3153: SQL_STATEMENT :=
3154: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
3155: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
3156: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
3157: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
3158: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 3167: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3163: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3164: ' AND QRI.PROCESS_STATUS = 2 ' ||
3165: 'AND NOT EXISTS
3166: (SELECT ''X'' ' ||
3167: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3168: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3169: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3170: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5)) ' ||
3171: 'AND QRI.' || COL_NAME || ' IS NOT NULL ' ||

Line 3251: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3247: WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3248: ' AND QRI.PROCESS_STATUS = 2 ' ||
3249: 'AND NOT EXISTS
3250: (SELECT ''X'' ' ||
3251: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3252: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3253: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3254: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
3255:

Line 3312: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3308: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3309: ' AND QRI.PROCESS_STATUS = 2 ' ||
3310: 'AND NOT EXISTS
3311: (SELECT ''X'' ' ||
3312: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3313: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3314: 'QRI.TRANSACTION_INTERFACE_ID ' ||
3315: 'AND QIE.ERROR_COLUMN IN (:c1,:c2,:c3,:c4,:c5))';
3316:

Line 3364: FROM qa_interface_errors qie

3360: PROGRAM_ID = X_PROGRAM_ID,
3361: PROGRAM_UPDATE_DATE = SYSDATE
3362: WHERE qri.GROUP_ID = X_GROUP_ID AND EXISTS
3363: (SELECT 1
3364: FROM qa_interface_errors qie
3365: WHERE qie.transaction_interface_id = qri.transaction_interface_id);
3366:
3367: -- Bug 1558445, slow performance.
3368: -- AND TRANSACTION_INTERFACE_ID IN

Line 3370: -- FROM QA_INTERFACE_ERRORS);

3366:
3367: -- Bug 1558445, slow performance.
3368: -- AND TRANSACTION_INTERFACE_ID IN
3369: -- (SELECT TRANSACTION_INTERFACE_ID
3370: -- FROM QA_INTERFACE_ERRORS);
3371: ELSE
3372: UPDATE QA_RESULTS_INTERFACE QRI
3373: SET PROCESS_STATUS = 3,
3374: LAST_UPDATE_DATE = SYSDATE,

Line 3383: FROM QA_INTERFACE_ERRORS QIE

3379: PROGRAM_UPDATE_DATE = SYSDATE
3380: WHERE GROUP_ID = X_GROUP_ID
3381: AND EXISTS
3382: (SELECT TRANSACTION_INTERFACE_ID, ERROR_COLUMN
3383: FROM QA_INTERFACE_ERRORS QIE
3384: WHERE QIE.TRANSACTION_INTERFACE_ID =
3385: QRI.TRANSACTION_INTERFACE_ID
3386: AND QIE.ERROR_COLUMN = X_COLUMN_NAME);
3387: END IF;

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

3428: -- SQL Bind project. Code modified to use bind variables instead of literals
3429: -- Same as the fix done for Bug 3079312.suramasw.
3430:
3431: SQL_STATEMENT :=
3432: 'INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ' ||
3433: 'ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY, ' ||
3434: 'CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, ' ||
3435: 'PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) ' ||
3436: 'SELECT QRI.TRANSACTION_INTERFACE_ID, :ERROR_COL_NAME, ' ||

Line 3445: 'FROM QA_INTERFACE_ERRORS QIE ' ||

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

Line 3966: 'FROM QA_INTERFACE_ERRORS QIE ' ||

3962: X_COL_NAME || ' = :NEW_SEQUENCE ' ||
3963: ' WHERE QRI.GROUP_ID = :GROUP_ID ' ||
3964: ' AND QRI.PROCESS_STATUS = 2 ' ||
3965: 'AND NOT EXISTS (SELECT ''X'' ' ||
3966: 'FROM QA_INTERFACE_ERRORS QIE ' ||
3967: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
3968: 'QRI.TRANSACTION_INTERFACE_ID )';
3969:
3970:

Line 4387: INSERT INTO QA_INTERFACE_ERRORS

4383:
4384: EXCEPTION
4385: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
4386:
4387: INSERT INTO QA_INTERFACE_ERRORS
4388: (TRANSACTION_INTERFACE_ID,
4389: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4390: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
4391: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE)

Line 4408: INSERT INTO QA_INTERFACE_ERRORS

4404: RETURN '';
4405:
4406: WHEN MATCHING_ERROR THEN
4407:
4408: INSERT INTO QA_INTERFACE_ERRORS
4409: (TRANSACTION_INTERFACE_ID,
4410: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4411: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
4412: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE)

Line 4429: INSERT INTO QA_INTERFACE_ERRORS

4425: RETURN '';
4426:
4427: WHEN NO_ROWIDS_ERROR THEN
4428:
4429: INSERT INTO QA_INTERFACE_ERRORS
4430: (TRANSACTION_INTERFACE_ID,
4431: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4432: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
4433: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE)

Line 4450: INSERT INTO QA_INTERFACE_ERRORS

4446: RETURN '';
4447:
4448: WHEN MORE_THAN_ONE_ROWID_ERROR THEN
4449:
4450: INSERT INTO QA_INTERFACE_ERRORS
4451: (TRANSACTION_INTERFACE_ID,
4452: ERROR_COLUMN, ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4453: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
4454: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE)

Line 4775: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,

4771: -- Added the condition INSERT_TYPE <> 2 as QA_CREATED_BY_NAME should be validated
4772: -- only during Insert transaction.
4773: -- Bug 3663648.suramasw.
4774:
4775: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
4776: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4777: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
4778: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
4779: PROGRAM_UPDATE_DATE)

Line 4791: FROM QA_INTERFACE_ERRORS QIE

4787: AND QRI.PROCESS_STATUS = 2
4788: AND QRI.INSERT_TYPE <> 2 -- added for 3663648
4789: AND NOT EXISTS
4790: (SELECT 'X'
4791: FROM QA_INTERFACE_ERRORS QIE
4792: WHERE QIE.TRANSACTION_INTERFACE_ID =
4793: QRI.TRANSACTION_INTERFACE_ID
4794: AND QIE.ERROR_COLUMN IN ('QA_CREATED_BY_NAME', NULL))
4795: AND NOT EXISTS

Line 4833: FROM QA_INTERFACE_ERRORS QIE

4829: AND QRI.PROCESS_STATUS = 2
4830: AND QRI.INSERT_TYPE <> 2 -- added for 3663648
4831: AND NOT EXISTS
4832: (SELECT 'X'
4833: FROM QA_INTERFACE_ERRORS QIE
4834: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID
4835: AND QIE.ERROR_COLUMN IN ('QA_CREATED_BY_NAME', NULL));
4836:
4837: -- set qa_last_updated_by_name and _id to the current user if they are null

Line 4858: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,

4854: -- Added the condition INSERT_TYPE = 2 because QA_LAST_UPDATED_BY_NAME
4855: -- should be validated only during update transaction.
4856: -- Bug 3663648.suramasw.
4857:
4858: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
4859: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4860: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
4861: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
4862: PROGRAM_UPDATE_DATE)

Line 4874: FROM QA_INTERFACE_ERRORS QIE

4870: AND QRI.PROCESS_STATUS = 2
4871: AND QRI.INSERT_TYPE = 2 -- added for 3663648
4872: AND NOT EXISTS
4873: (SELECT 'X'
4874: FROM QA_INTERFACE_ERRORS QIE
4875: WHERE QIE.TRANSACTION_INTERFACE_ID =
4876: QRI.TRANSACTION_INTERFACE_ID
4877: AND QIE.ERROR_COLUMN IN ('QA_LAST_UPDATED_BY_NAME', NULL))
4878: AND NOT EXISTS

Line 4912: FROM QA_INTERFACE_ERRORS QIE

4908: AND QRI.PROCESS_STATUS = 2
4909: AND QRI.INSERT_TYPE = 2 -- added for 3663648
4910: AND NOT EXISTS
4911: (SELECT 'X'
4912: FROM QA_INTERFACE_ERRORS QIE
4913: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID
4914: AND QIE.ERROR_COLUMN IN ('QA_LAST_UPDATED_BY_NAME', NULL));
4915:
4916:

Line 4920: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,

4916:
4917: -- group validation for organization_code
4918: -- Bug 4958776. SQL Repository Fix SQL ID: 15009159
4919: -- replaced ORG_ORGANIZATION_DEFINITIONS with MTL_PARAMETERS
4920: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
4921: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
4922: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
4923: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
4924: PROGRAM_UPDATE_DATE)

Line 4935: FROM QA_INTERFACE_ERRORS QIE

4931: WHERE QRI.GROUP_ID = X_GROUP_ID
4932: AND QRI.PROCESS_STATUS = 2
4933: AND NOT EXISTS
4934: (SELECT 'X'
4935: FROM QA_INTERFACE_ERRORS QIE
4936: WHERE QIE.TRANSACTION_INTERFACE_ID =
4937: QRI.TRANSACTION_INTERFACE_ID
4938: AND QIE.ERROR_COLUMN IN ('ORGANIZATION_CODE', NULL))
4939: AND NOT EXISTS

Line 4963: FROM QA_INTERFACE_ERRORS QIE

4959: WHERE QRI.GROUP_ID = X_GROUP_ID
4960: AND QRI.PROCESS_STATUS = 2
4961: AND NOT EXISTS
4962: (SELECT 'X'
4963: FROM QA_INTERFACE_ERRORS QIE
4964: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID
4965: AND QIE.ERROR_COLUMN IN ('ORGANIZATION_CODE', NULL));
4966:
4967: -- set process_status to 3 for all rows where org_code had an error.

Line 5034: INSERT INTO qa_interface_errors(

5030: qri.process_status = 2 AND
5031: qri.operating_unit IS NOT NULL AND
5032: qri.operating_unit_id IS NULL;
5033:
5034: INSERT INTO qa_interface_errors(
5035: transaction_interface_id,
5036: error_column,
5037: error_message,
5038: last_update_date,

Line 5073: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,

5069: ----------------------------------------------------------------------------
5070:
5071: -- group validation for plan_name
5072:
5073: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
5074: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
5075: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
5076: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
5077: PROGRAM_UPDATE_DATE)

Line 5088: FROM QA_INTERFACE_ERRORS QIE

5084: WHERE QRI.GROUP_ID = X_GROUP_ID
5085: AND QRI.PROCESS_STATUS = 2
5086: AND NOT EXISTS
5087: (SELECT 'X'
5088: FROM QA_INTERFACE_ERRORS QIE
5089: WHERE QIE.TRANSACTION_INTERFACE_ID =
5090: QRI.TRANSACTION_INTERFACE_ID
5091: AND QIE.ERROR_COLUMN IN ('PLAN_NAME', NULL))
5092: AND NOT EXISTS

Line 5116: FROM QA_INTERFACE_ERRORS QIE

5112: WHERE QRI.GROUP_ID = X_GROUP_ID
5113: AND QRI.PROCESS_STATUS = 2
5114: AND NOT EXISTS
5115: (SELECT 'X'
5116: FROM QA_INTERFACE_ERRORS QIE
5117: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID
5118: AND QIE.ERROR_COLUMN IN ('PLAN_NAME', NULL));
5119:
5120: -- group validation for spec_name

Line 5128: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,

5124: -- subquery. It uses too much shared memory. Replaced with
5125: -- QA_SPECS and appended the effective date validation.
5126: -- bso Mon Nov 25 18:15:12 PST 2002
5127: --
5128: INSERT INTO QA_INTERFACE_ERRORS (TRANSACTION_INTERFACE_ID, ERROR_COLUMN,
5129: ERROR_MESSAGE, LAST_UPDATE_DATE, LAST_UPDATED_BY,
5130: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
5131: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,
5132: PROGRAM_UPDATE_DATE)

Line 5143: FROM QA_INTERFACE_ERRORS QIE

5139: WHERE QRI.GROUP_ID = X_GROUP_ID
5140: AND QRI.PROCESS_STATUS = 2
5141: AND NOT EXISTS
5142: (SELECT 'X'
5143: FROM QA_INTERFACE_ERRORS QIE
5144: WHERE QIE.TRANSACTION_INTERFACE_ID =
5145: QRI.TRANSACTION_INTERFACE_ID
5146: AND QIE.ERROR_COLUMN IN ('SPEC_NAME', NULL))
5147: AND (QRI.SPEC_NAME IS NOT NULL

Line 5184: FROM QA_INTERFACE_ERRORS QIE

5180: WHERE QRI.GROUP_ID = X_GROUP_ID
5181: AND QRI.PROCESS_STATUS = 2
5182: AND NOT EXISTS
5183: (SELECT 'X'
5184: FROM QA_INTERFACE_ERRORS QIE
5185: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID
5186: AND QIE.ERROR_COLUMN IN ('SPEC_NAME', NULL));
5187:
5188: -- set process_status to 3 for all rows where plan_name or spec_name

Line 5209: FROM QA_INTERFACE_ERRORS QIE

5205: FROM QA_RESULTS_INTERFACE QRI
5206: WHERE QRI.GROUP_ID = X_GROUP_ID
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 ('ORGANIZATION_CODE', 'PLAN_NAME',
5213: 'SPEC_NAME', NULL));

Line 7459: 'FROM QA_INTERFACE_ERRORS QIE ' ||

7455: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
7456: ' AND QRI.PROCESS_STATUS = 2 ' ||
7457: ' AND NOT EXISTS
7458: (SELECT ''X'' ' ||
7459: 'FROM QA_INTERFACE_ERRORS QIE ' ||
7460: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
7461: 'QRI.TRANSACTION_INTERFACE_ID )';
7462:
7463: SOURCE_CURSOR := DBMS_SQL.OPEN_CURSOR;

Line 7517: FROM QA_INTERFACE_ERRORS QIE

7513: WHERE QRI.GROUP_ID = X_GROUP_ID
7514: AND QRI.TRANSACTION_INTERFACE_ID = INTERFACE_ID_TABLE(J)
7515: AND NOT EXISTS
7516: (SELECT 'X'
7517: FROM QA_INTERFACE_ERRORS QIE
7518: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID);
7519:
7520: -- End of changes for bug 2548710.
7521:

Line 7649: INSERT INTO QA_INTERFACE_ERRORS

7645: QA_PARENT_CHILD_PKG.insert_history_auto_rec(X_PLAN_ID, X_TXN_HEADER_ID, 1, 4) ;
7646: EXCEPTION
7647:
7648: WHEN resource_busy THEN
7649: INSERT INTO QA_INTERFACE_ERRORS
7650: (TRANSACTION_INTERFACE_ID, ERROR_MESSAGE, ERROR_COLUMN,
7651: LAST_UPDATE_DATE, LAST_UPDATED_BY,
7652: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
7653: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,

Line 7889: 'FROM QA_INTERFACE_ERRORS QIE ' ||

7885: 'WHERE QRI.GROUP_ID = :GROUP_ID ' ||
7886: ' AND QRI.PROCESS_STATUS = 2 ' ||
7887: ' AND NOT EXISTS
7888: (SELECT ''X'' ' ||
7889: 'FROM QA_INTERFACE_ERRORS QIE ' ||
7890: 'WHERE QIE.TRANSACTION_INTERFACE_ID = ' ||
7891: 'QRI.TRANSACTION_INTERFACE_ID )';
7892:
7893:

Line 7948: FROM QA_INTERFACE_ERRORS QIE

7944: WHERE QRI.GROUP_ID = X_GROUP_ID
7945: AND QRI.TRANSACTION_INTERFACE_ID = INTERFACE_ID_TABLE(J)
7946: AND NOT EXISTS
7947: (SELECT 'X'
7948: FROM QA_INTERFACE_ERRORS QIE
7949: WHERE QIE.TRANSACTION_INTERFACE_ID = QRI.TRANSACTION_INTERFACE_ID);
7950:
7951: -- End of changes for bug 2548710.
7952: */

Line 8104: DELETE FROM QA_INTERFACE_ERRORS

8100: -- delete rows from the errors table that are associated with the
8101: -- rows we are about to validate. we do this so that old errors will
8102: -- not stick around after the user has resubmitted a record.
8103:
8104: DELETE FROM QA_INTERFACE_ERRORS
8105: WHERE TRANSACTION_INTERFACE_ID IN
8106: (SELECT TRANSACTION_INTERFACE_ID
8107: FROM QA_RESULTS_INTERFACE
8108: WHERE GROUP_ID = X_GROUP_ID);

Line 8216: DELETE FROM QA_INTERFACE_ERRORS

8212: AND PROCESS_STATUS = 2;
8213:
8214: -- delete any error messages still around for successfully-validated rows
8215:
8216: DELETE FROM QA_INTERFACE_ERRORS
8217: WHERE TRANSACTION_INTERFACE_ID IN
8218: (SELECT TRANSACTION_INTERFACE_ID
8219: FROM QA_RESULTS_INTERFACE
8220: WHERE PROCESS_STATUS = 4);

Line 8247: INSERT INTO qa_interface_errors

8243: WHEN user_sql_error THEN
8244:
8245: l_error_message := error_bad_sql || ' ' || g_sqlerrm;
8246:
8247: INSERT INTO qa_interface_errors
8248: (transaction_interface_id, error_message, error_column,
8249: last_update_date, last_updated_by,
8250: creation_date, created_by, last_update_login,
8251: request_id, program_application_id, program_id,

Line 8268: INSERT INTO QA_INTERFACE_ERRORS

8264: COMMIT;
8265: RETURN FALSE;
8266:
8267: WHEN OTHERS THEN
8268: INSERT INTO QA_INTERFACE_ERRORS
8269: (TRANSACTION_INTERFACE_ID, ERROR_MESSAGE, ERROR_COLUMN,
8270: LAST_UPDATE_DATE, LAST_UPDATED_BY,
8271: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
8272: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID,