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 QLTTRAFB

Line 263: OP := QLTTRAFB.DECODE_OPERATOR(X_OP_CODE);

259: qa_core_pkg.dsql_add_text(' QRI.' || COL_NAME || ' ');
260: END IF;
261:
262:
263: OP := QLTTRAFB.DECODE_OPERATOR(X_OP_CODE);
264:
265: -- Build the rhs.
266:
267: IF X_OP_CODE NOT IN (7,8) THEN

Line 271: TEMP := QLTTRAFB.DECODE_ACTION_VALUE_LOOKUP(X_LV_LOOKUP_VALUE);

267: IF X_OP_CODE NOT IN (7,8) THEN
268:
269: -- LV
270: IF X_LV_LOOKUP_VALUE IS NOT NULL THEN
271: TEMP := QLTTRAFB.DECODE_ACTION_VALUE_LOOKUP(X_LV_LOOKUP_VALUE);
272: LV1 := 'QC.' || TEMP;
273: LV2 := 'QSC.' || TEMP;
274:
275: IF (X_DATATYPE = 2) THEN

Line 321: TEMP := QLTTRAFB.DECODE_ACTION_VALUE_LOOKUP(X_HV_LOOKUP_VALUE);

317: IF X_OP_CODE IN (9,10) THEN
318:
319: IF X_HV_LOOKUP_VALUE IS NOT NULL THEN
320:
321: TEMP := QLTTRAFB.DECODE_ACTION_VALUE_LOOKUP(X_HV_LOOKUP_VALUE);
322: HV1 := 'QC.' || TEMP;
323: HV2 := 'QSC.' || TEMP;
324:
325: IF (X_DATATYPE = 2) THEN

Line 794: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

790: '(SELECT ''X'' FROM QA_RESULTS_INTERFACE ' ||
791: 'WHERE QRI.' || COL_NAME || ' IS NULL ' ||
792: ' AND QRI.' || REV_COLUMN || ' = 2)';
793:
794: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
795:
796: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL
797: -- in order to bind the value of ERROR_COL_NAME. kabalakr
798:

Line 796: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL

792: ' AND QRI.' || REV_COLUMN || ' = 2)';
793:
794: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
795:
796: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL
797: -- in order to bind the value of ERROR_COL_NAME. kabalakr
798:
799: -- Added the other columns added as a part of Bug 3136107 to
800: -- EXECUTE IMMEDIATE. suramasw

Line 846: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

842: '(SELECT ''X'' FROM QA_RESULTS_INTERFACE ' ||
843: 'WHERE QRI.' || COL_NAME || ' IS NOT NULL ' ||
844: ' AND QRI.' || REV_COLUMN || ' = 1)';
845:
846: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
847:
848: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL
849: -- in order to bind the value of ERROR_COL_NAME. kabalakr
850:

Line 848: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL

844: ' AND QRI.' || REV_COLUMN || ' = 1)';
845:
846: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
847:
848: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL
849: -- in order to bind the value of ERROR_COL_NAME. kabalakr
850:
851: -- Added the other columns added as a part of Bug 3136107 to
852: -- EXECUTE IMMEDIATE. suramasw

Line 1353: IF (QLTTRAFB.VALIDATE_TYPE(VALUE_TABLE(I), X_DATATYPE) = FALSE) THEN

1349: END IF;
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

Line 1479: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

1475: NULL_NUM,
1476: NULL_CHAR,
1477: NULL_DATE;
1478:
1479: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
1480: END FORMAT_DATATYPES;
1481:
1482:
1483: PROCEDURE VALIDATE_LOCATOR(COL_NAME VARCHAR2,

Line 1681: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

1677: X_GROUP_ID,
1678: INTERFACE_ID_TABLE(I),
1679: l_col1, l_col2, l_col3, l_col4, l_col5;
1680:
1681: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
1682:
1683: ELSIF (GEN_LOC_CTRL_TABLE(I) IN (2, 3)) THEN
1684: -- !! maybe should validate mandatory here
1685:

Line 1778: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

1774: X_GROUP_ID,
1775: INTERFACE_ID_TABLE(I),
1776: l_col1, l_col2, l_col3, l_col4, l_col5;
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,

Line 2014: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

2010: X_GROUP_ID,
2011: INTERFACE_ID_TABLE(I),
2012: l_col1, l_col2, l_col3, l_col4, l_col5;
2013:
2014: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
2015:
2016: ELSIF (GEN_LOC_CTRL_TABLE(I) IN (2, 3)) THEN
2017: -- !! maybe should validate mandatory here
2018:

Line 2103: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

2099: X_GROUP_ID,
2100: INTERFACE_ID_TABLE(I),
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,

Line 2420: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

2416: INTERFACE_ID_TABLE(I),
2417: l_col1, l_col2, l_col3, l_col4, l_col5;
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,

Line 2676: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

2672: X_GROUP_ID,
2673: INTERFACE_ID_TABLE(I),
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,

Line 2864: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

2860: X_GROUP_ID,
2861: INTERFACE_ID_TABLE(I),
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,

Line 2941: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

2937: '(SELECT /*+ NO_UNNEST PUSH_SUBQ */ ''X'' ' ||
2938: 'FROM ' || FROM_CLAUSE ||
2939: ' WHERE (' || WHERE_CLAUSE || '))';
2940:
2941: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
2942:
2943: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL
2944: -- in order to bind the value of ERROR_COL_NAME. kabalakr
2945:

Line 2943: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL

2939: ' WHERE (' || WHERE_CLAUSE || '))';
2940:
2941: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
2942:
2943: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL
2944: -- in order to bind the value of ERROR_COL_NAME. kabalakr
2945:
2946: -- Added the other columns added as a part of Bug 3136107 to
2947: -- EXECUTE IMMEDIATE. suramasw

Line 3030: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

3026: ' AND MISVV.INVENTORY_ITEM_ID = ' ||
3027: 'QRI.' || COMP_STRING || 'ITEM_ID ' ||
3028: ' AND MISVV.SECONDARY_INVENTORY_NAME = QRI.' || COL_NAME || ')';
3029:
3030: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
3031:
3032: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL
3033: -- in order to bind the value of ERROR_COL_NAME. kabalakr
3034:

Line 3032: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL

3028: ' AND MISVV.SECONDARY_INVENTORY_NAME = QRI.' || COL_NAME || ')';
3029:
3030: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
3031:
3032: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL
3033: -- in order to bind the value of ERROR_COL_NAME. kabalakr
3034:
3035: -- Added the other columns added as a part of Bug 3136107 to
3036: -- EXECUTE IMMEDIATE. suramasw

Line 3087: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

3083: X_PROGRAM_ID,
3084: X_GROUP_ID,
3085: l_col1, l_col2, l_col3, l_col4, l_col5;
3086:
3087: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
3088:
3089: END VALIDATE_SUBINVENTORY;
3090:
3091: -- Start of inclusions for NCM Hardcode Elements.

Line 3158: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

3154: ' AND MISVV.INVENTORY_ITEM_ID = ' ||
3155: 'QRI.ITEM_ID ' ||
3156: ' AND MISVV.SECONDARY_INVENTORY_NAME = QRI.' || COL_NAME || ')';
3157:
3158: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
3159:
3160: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL
3161: -- in order to bind the value of ERROR_COL_NAME. kabalakr
3162:

Line 3160: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL

3156: ' AND MISVV.SECONDARY_INVENTORY_NAME = QRI.' || COL_NAME || ')';
3157:
3158: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
3159:
3160: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL
3161: -- in order to bind the value of ERROR_COL_NAME. kabalakr
3162:
3163: -- Added the other columns added as a part of Bug 3136107 to
3164: -- EXECUTE IMMEDIATE. suramasw

Line 3213: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

3209: X_PROGRAM_ID,
3210: X_GROUP_ID,
3211: l_col1, l_col2, l_col3, l_col4, l_col5;
3212:
3213: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
3214:
3215: END VALIDATE_TO_SUBINVENTORY;
3216:
3217: -- End of inclusions for NCM Hardcode Elements.

Line 3270: FORMATTED_SQL_STRING := QLTTRAFB.FORMAT_SQL_VALIDATION_STRING(

3266: BEGIN
3267: -- Bug 3136107.SQL Bind project.
3268: parse_error_columns(error_col_list, l_col1, l_col2, l_col3, l_col4, l_col5);
3269:
3270: FORMATTED_SQL_STRING := QLTTRAFB.FORMAT_SQL_VALIDATION_STRING(
3271: X_SQL_VALIDATION_STRING);
3272:
3273: -- Bug 3136107.
3274: -- SQL Bind project. Code modified to use bind variables instead of literals

Line 3314: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

3310: -- string. Please see bug # 1680481 for details.
3311: --
3312: -- ORASHID
3313:
3314: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
3315:
3316: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL
3317: -- in order to bind the value of ERROR_COL_NAME. kabalakr
3318:

Line 3316: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL

3312: -- ORASHID
3313:
3314: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
3315:
3316: -- Bug 2976810. Using EXECUTE IMMEDIATE instead of QLTTRAFB.EXEC_SQL
3317: -- in order to bind the value of ERROR_COL_NAME. kabalakr
3318:
3319: -- Added the other columns added as a part of Bug 3136107 to
3320: -- EXECUTE IMMEDIATE. suramasw

Line 3399: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

3395: X_PROGRAM_ID,
3396: X_GROUP_ID,
3397: l_col1, l_col2, l_col3, l_col4, l_col5;
3398:
3399: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
3400:
3401: END DERIVE_IDS;
3402:
3403: /* derive_job

Line 3460: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

3456: X_PROGRAM_ID,
3457: X_GROUP_ID,
3458: l_col1, l_col2, l_col3, l_col4, l_col5;
3459:
3460: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
3461: END DERIVE_JOB;
3462:
3463:
3464: -- given a developer_name, finds its location in the developer name table

Line 3709: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

3705:
3706: If (sql%rowcount >0) THEN
3707: QLTTRAMB.qa_import_log('invalid validate reasonable limits ERROR_COL_NAME :'|| ERROR_COL_NAME||' Error count :' ||sql%rowcount);
3708: END IF;
3709: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
3710: END VALIDATE_REASONABLE_LIMITS;
3711:
3712:
3713: PROCEDURE VALIDATE_STEPS (X_ENABLED_FLAG NUMBER, X_MANDATORY_FLAG NUMBER,

Line 3789: QLTTRAFB.VALIDATE_DISABLED(COL_NAME, ERROR_COL_NAME, ERROR_DISABLED,

3785: -- if disabled, validate that all values are null
3786:
3787: IF (X_ENABLED_FLAG = 2) THEN
3788: BEGIN
3789: QLTTRAFB.VALIDATE_DISABLED(COL_NAME, ERROR_COL_NAME, ERROR_DISABLED,
3790: X_GROUP_ID, X_USER_ID,
3791: X_LAST_UPDATE_LOGIN, X_REQUEST_ID, X_PROGRAM_APPLICATION_ID,
3792: X_PROGRAM_ID);
3793: exception when others then

Line 3794: QLTTRAMB.qa_import_log('Error - Call to QLTTRAFB.VALIDATE_DISABLED failed');

3790: X_GROUP_ID, X_USER_ID,
3791: X_LAST_UPDATE_LOGIN, X_REQUEST_ID, X_PROGRAM_APPLICATION_ID,
3792: X_PROGRAM_ID);
3793: exception when others then
3794: QLTTRAMB.qa_import_log('Error - Call to QLTTRAFB.VALIDATE_DISABLED failed');
3795: QLTTRAMB.qa_import_log('The call is made to validate that the values in element and dependent elements are null if disabled');
3796: end;
3797: ELSE
3798:

Line 3804: QLTTRAFB.VALIDATE_PARENT_ENTERED(COL_NAME, ERROR_COL_NAME,

3800: -- validate that non-null values have non-null parent (for child only)
3801:
3802: IF (PARENT_COL IS NOT NULL) THEN
3803: BEGIN
3804: QLTTRAFB.VALIDATE_PARENT_ENTERED(COL_NAME, ERROR_COL_NAME,
3805: ERROR_NEED_PARENT, X_GROUP_ID,
3806: X_USER_ID, X_LAST_UPDATE_LOGIN, X_REQUEST_ID,
3807: X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID, PARENT_COL, ERROR_COL_LIST);
3808: exception when others then

Line 3809: QLTTRAMB.qa_import_log('Error - Call to QLTTRAFB.VALIDATE_PARENT_ENTERED failed');

3805: ERROR_NEED_PARENT, X_GROUP_ID,
3806: X_USER_ID, X_LAST_UPDATE_LOGIN, X_REQUEST_ID,
3807: X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID, PARENT_COL, ERROR_COL_LIST);
3808: exception when others then
3809: QLTTRAMB.qa_import_log('Error - Call to QLTTRAFB.VALIDATE_PARENT_ENTERED failed');
3810: QLTTRAMB.qa_import_log('The call is made to validate if the parent is entered');
3811: end;
3812: END IF;
3813:

Line 3846: QLTTRAFB.VALIDATE_READ_ONLY(COL_NAME, ERROR_COL_NAME, ERROR_READ_ONLY,

3842:
3843:
3844: IF (X_READ_ONLY_FLAG = 1) AND (RO_MUST_BE_NULL = TRUE) THEN
3845: BEGIN
3846: QLTTRAFB.VALIDATE_READ_ONLY(COL_NAME, ERROR_COL_NAME, ERROR_READ_ONLY,
3847: X_GROUP_ID, X_USER_ID,
3848: X_LAST_UPDATE_LOGIN, X_REQUEST_ID, X_PROGRAM_APPLICATION_ID,
3849: X_PROGRAM_ID, PARENT_COL, ERROR_COL_LIST);
3850: exception when others then

Line 3851: QLTTRAMB.qa_import_log('Error - Call to QLTTRAFB.VALIDATE_READ_ONLY failed');

3847: X_GROUP_ID, X_USER_ID,
3848: X_LAST_UPDATE_LOGIN, X_REQUEST_ID, X_PROGRAM_APPLICATION_ID,
3849: X_PROGRAM_ID, PARENT_COL, ERROR_COL_LIST);
3850: exception when others then
3851: QLTTRAMB.qa_import_log('Error - Call to QLTTRAFB.VALIDATE_READ_ONLY failed');
3852: QLTTRAMB.qa_import_log('The call is made to validate if element is read only');
3853: end;
3854: END IF;
3855:

Line 3928: QLTTRAFB.VALIDATE_MANDATORY(COL_NAME, ERROR_COL_NAME, ERROR_MANDATORY,

3924: -- if not revision and it's mandatory, validate no null values
3925:
3926: ELSIF (X_MANDATORY_FLAG = 1) THEN
3927: BEGIN
3928: QLTTRAFB.VALIDATE_MANDATORY(COL_NAME, ERROR_COL_NAME, ERROR_MANDATORY,
3929: X_GROUP_ID, X_USER_ID,
3930: X_LAST_UPDATE_LOGIN, X_REQUEST_ID, X_PROGRAM_APPLICATION_ID,
3931: X_PROGRAM_ID, PARENT_COL, ERROR_COL_LIST);
3932: exception when others then

Line 3933: QLTTRAMB.qa_import_log('Error - Call to QLTTRAFB.VALIDATE_MANDATORY failed');

3929: X_GROUP_ID, X_USER_ID,
3930: X_LAST_UPDATE_LOGIN, X_REQUEST_ID, X_PROGRAM_APPLICATION_ID,
3931: X_PROGRAM_ID, PARENT_COL, ERROR_COL_LIST);
3932: exception when others then
3933: QLTTRAMB.qa_import_log('Error - Call to QLTTRAFB.VALIDATE_MANDATORY failed');
3934: QLTTRAMB.qa_import_log('The call is made to validate the mandatory element');
3935: end;
3936: END IF; -- mandatory test
3937:

Line 4020: QLTTRAFB.VALIDATE_LOOKUPS(COL_NAME, ERROR_COL_NAME,

4016: 'ECO_NAME')) THEN
4017:
4018: IF (X_VALUES_EXIST_FLAG = 1) THEN
4019: BEGIN
4020: QLTTRAFB.VALIDATE_LOOKUPS(COL_NAME, ERROR_COL_NAME,
4021: ERROR_INVALID_VALUE, X_GROUP_ID,
4022: X_USER_ID, X_LAST_UPDATE_LOGIN, X_REQUEST_ID,
4023: X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4024: X_CHAR_ID, X_PLAN_ID, ERROR_COL_LIST);

Line 4026: QLTTRAMB.qa_import_log('Error - Call to QLTTRAFB.VALIDATE_LOOKUPS failed');

4022: X_USER_ID, X_LAST_UPDATE_LOGIN, X_REQUEST_ID,
4023: X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4024: X_CHAR_ID, X_PLAN_ID, ERROR_COL_LIST);
4025: exception when others then
4026: QLTTRAMB.qa_import_log('Error - Call to QLTTRAFB.VALIDATE_LOOKUPS failed');
4027: QLTTRAMB.qa_import_log('The call is made to validate the lookup values');
4028: end;
4029: ELSIF (X_SQL_VALIDATION_STRING IS NOT NULL) THEN
4030: BEGIN

Line 4307: QLTTRAFB.VALIDATE_READ_ONLY(P_COL_NAME => P_COL_NAME,

4303: IF MUST_BE_NULL THEN
4304: ERROR_COL_NAME := dequote(P_CHAR_NAME) || ' (' || P_COL_NAME || ')';
4305: ERROR_COL_LIST := 'NULL, ' || '''' || ERROR_COL_NAME || '''';
4306:
4307: QLTTRAFB.VALIDATE_READ_ONLY(P_COL_NAME => P_COL_NAME,
4308: P_ERROR_COL_NAME => ERROR_COL_NAME,
4309: P_ERROR_MESSAGE => ERROR_SEQUENCE,
4310: P_GROUP_ID => P_GROUP_ID,
4311: P_USER_ID => P_USER_ID,

Line 4969: -- QLTTRAFB.EXEC_SQL(UPDATE_STMT);

4965: '_V" V ' || 'WHERE V.ROW_ID IN ' || STMT_OF_ROWIDS ||
4966: ') WHERE QRI.GROUP_ID = '||X_GROUP_ID;
4967: */
4968:
4969: -- QLTTRAFB.EXEC_SQL(UPDATE_STMT);
4970:
4971: QLTTRAMB.qa_import_log('Procedure RETRIEVE_UPDATE_RECORDS completed');
4972: QLTTRAMB.qa_import_log('--------------------------------------------');
4973:

Line 7835: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

7831: X_PROGRAM_ID,
7832: L_ROWID,
7833: X_GROUP_ID;
7834:
7835: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
7836: END LOOP;
7837:
7838: END POPULATE_HISTORY_TABLE;
7839:

Line 8147: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

8143: DBMS_SQL.CLOSE_CURSOR(update_qri_cur);
8144: END IF;
8145:
8146:
8147: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
8148:
8149: -- msg('Update_valid_rows successfully executed the query...');
8150: -- Bug 2302539
8151: -- To process History records in Parent-child

Line 8552: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);

8548: X_GROUP_ID;
8549:
8550: QLTTRAMB.qa_import_log('After executing insert');
8551:
8552: -- QLTTRAFB.EXEC_SQL(SQL_STATEMENT);
8553:
8554: -- Gapless Sequence Proj. rponnusa Wed Jul 30 04:52:45 PDT 2003
8555: -- call api to generate seq. value for all the records identified by txn_header_id
8556: -- we can safely call sequence api before inserting history/automatic records

Line 9032: -- qlttrafb.exec_sql('alter session set nls_numeric_characters='',.''');

9028:
9029: -- get the translated message text
9030:
9031: -- Just a test 'bso delete this later
9032: -- qlttrafb.exec_sql('alter session set nls_numeric_characters='',.''');
9033:
9034: ERROR_REJECT := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_REJECT'));
9035: ERROR_DISABLED := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_DISABLED'));
9036: ERROR_MANDATORY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_MANDATORY'));