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)
4392: SELECT QRI.TRANSACTION_INTERFACE_ID, 'GROUP_ID',
4393: FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_INVALID_VALUE'),
4394: SYSDATE, X_USER_ID,
4395: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4396: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4397: SYSDATE
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)
4413: SELECT QRI.TRANSACTION_INTERFACE_ID, 'MATCHING_ELEMENTS',
4414: FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_INVALID_VALUE'),
4415: SYSDATE, X_USER_ID,
4416: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4417: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4418: SYSDATE
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)
4434: SELECT QRI.TRANSACTION_INTERFACE_ID, 'MATCHING_ELEMENTS',
4435: FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_NO_MATCH'),
4436: SYSDATE, X_USER_ID,
4437: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4438: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4439: SYSDATE
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)
4455: SELECT QRI.TRANSACTION_INTERFACE_ID, 'MATCHING_ELEMENTS',
4456: FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_MANY_MATCHES'),
4457: SYSDATE, X_USER_ID,
4458: SYSDATE, X_USER_ID, X_LAST_UPDATE_LOGIN,
4459: X_REQUEST_ID, X_PROGRAM_APPLICATION_ID, X_PROGRAM_ID,
4460: SYSDATE
8369:
8370: -- Just a test 'bso delete this later
8371: -- qlttrafb.exec_sql('alter session set nls_numeric_characters='',.''');
8372:
8373: ERROR_REJECT := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_REJECT'));
8374: ERROR_DISABLED := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_DISABLED'));
8375: ERROR_MANDATORY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_MANDATORY'));
8376: ERROR_NEED_PARENT := dequote(FND_MESSAGE.GET_STRING('QA',
8377: 'QA_INTERFACE_NEED_PARENT'));
8370: -- Just a test 'bso delete this later
8371: -- qlttrafb.exec_sql('alter session set nls_numeric_characters='',.''');
8372:
8373: ERROR_REJECT := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_REJECT'));
8374: ERROR_DISABLED := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_DISABLED'));
8375: ERROR_MANDATORY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_MANDATORY'));
8376: ERROR_NEED_PARENT := dequote(FND_MESSAGE.GET_STRING('QA',
8377: 'QA_INTERFACE_NEED_PARENT'));
8378: ERROR_INVALID_VALUE := dequote(FND_MESSAGE.GET_STRING('QA',
8371: -- qlttrafb.exec_sql('alter session set nls_numeric_characters='',.''');
8372:
8373: ERROR_REJECT := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_REJECT'));
8374: ERROR_DISABLED := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_DISABLED'));
8375: ERROR_MANDATORY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_MANDATORY'));
8376: ERROR_NEED_PARENT := dequote(FND_MESSAGE.GET_STRING('QA',
8377: 'QA_INTERFACE_NEED_PARENT'));
8378: ERROR_INVALID_VALUE := dequote(FND_MESSAGE.GET_STRING('QA',
8379: 'QA_INTERFACE_INVALID_VALUE'));
8372:
8373: ERROR_REJECT := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_REJECT'));
8374: ERROR_DISABLED := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_DISABLED'));
8375: ERROR_MANDATORY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_MANDATORY'));
8376: ERROR_NEED_PARENT := dequote(FND_MESSAGE.GET_STRING('QA',
8377: 'QA_INTERFACE_NEED_PARENT'));
8378: ERROR_INVALID_VALUE := dequote(FND_MESSAGE.GET_STRING('QA',
8379: 'QA_INTERFACE_INVALID_VALUE'));
8380: ERROR_OUTSIDE_LIMITS := dequote(FND_MESSAGE.GET_STRING('QA',
8374: ERROR_DISABLED := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_DISABLED'));
8375: ERROR_MANDATORY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_MANDATORY'));
8376: ERROR_NEED_PARENT := dequote(FND_MESSAGE.GET_STRING('QA',
8377: 'QA_INTERFACE_NEED_PARENT'));
8378: ERROR_INVALID_VALUE := dequote(FND_MESSAGE.GET_STRING('QA',
8379: 'QA_INTERFACE_INVALID_VALUE'));
8380: ERROR_OUTSIDE_LIMITS := dequote(FND_MESSAGE.GET_STRING('QA',
8381: 'QA_INTERFACE_OUTSIDE_LIMITS'));
8382: ERROR_CRITICAL := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_CRITICAL'));
8376: ERROR_NEED_PARENT := dequote(FND_MESSAGE.GET_STRING('QA',
8377: 'QA_INTERFACE_NEED_PARENT'));
8378: ERROR_INVALID_VALUE := dequote(FND_MESSAGE.GET_STRING('QA',
8379: 'QA_INTERFACE_INVALID_VALUE'));
8380: ERROR_OUTSIDE_LIMITS := dequote(FND_MESSAGE.GET_STRING('QA',
8381: 'QA_INTERFACE_OUTSIDE_LIMITS'));
8382: ERROR_CRITICAL := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_CRITICAL'));
8383: ERROR_INVALID_NUMBER := dequote(FND_MESSAGE.GET_STRING('QA',
8384: 'QA_INTERFACE_INVALID_NUMBER'));
8378: ERROR_INVALID_VALUE := dequote(FND_MESSAGE.GET_STRING('QA',
8379: 'QA_INTERFACE_INVALID_VALUE'));
8380: ERROR_OUTSIDE_LIMITS := dequote(FND_MESSAGE.GET_STRING('QA',
8381: 'QA_INTERFACE_OUTSIDE_LIMITS'));
8382: ERROR_CRITICAL := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_CRITICAL'));
8383: ERROR_INVALID_NUMBER := dequote(FND_MESSAGE.GET_STRING('QA',
8384: 'QA_INTERFACE_INVALID_NUMBER'));
8385: ERROR_INVALID_DATE := dequote(FND_MESSAGE.GET_STRING('QA',
8386: 'QA_INTERFACE_INVALID_DATE'));
8379: 'QA_INTERFACE_INVALID_VALUE'));
8380: ERROR_OUTSIDE_LIMITS := dequote(FND_MESSAGE.GET_STRING('QA',
8381: 'QA_INTERFACE_OUTSIDE_LIMITS'));
8382: ERROR_CRITICAL := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_CRITICAL'));
8383: ERROR_INVALID_NUMBER := dequote(FND_MESSAGE.GET_STRING('QA',
8384: 'QA_INTERFACE_INVALID_NUMBER'));
8385: ERROR_INVALID_DATE := dequote(FND_MESSAGE.GET_STRING('QA',
8386: 'QA_INTERFACE_INVALID_DATE'));
8387:
8381: 'QA_INTERFACE_OUTSIDE_LIMITS'));
8382: ERROR_CRITICAL := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_CRITICAL'));
8383: ERROR_INVALID_NUMBER := dequote(FND_MESSAGE.GET_STRING('QA',
8384: 'QA_INTERFACE_INVALID_NUMBER'));
8385: ERROR_INVALID_DATE := dequote(FND_MESSAGE.GET_STRING('QA',
8386: 'QA_INTERFACE_INVALID_DATE'));
8387:
8388: ERROR_NEED_REV := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_NEED_REV'));
8389: ERROR_CANT_HAVE_REV := dequote(FND_MESSAGE.GET_STRING('QA',
8384: 'QA_INTERFACE_INVALID_NUMBER'));
8385: ERROR_INVALID_DATE := dequote(FND_MESSAGE.GET_STRING('QA',
8386: 'QA_INTERFACE_INVALID_DATE'));
8387:
8388: ERROR_NEED_REV := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_NEED_REV'));
8389: ERROR_CANT_HAVE_REV := dequote(FND_MESSAGE.GET_STRING('QA',
8390: 'QA_INTERFACE_CANT_HAVE_REV'));
8391: ERROR_CANT_HAVE_LOC := dequote(FND_MESSAGE.GET_STRING('QA',
8392: 'QA_INTERFACE_CANT_HAVE_LOC'));
8385: ERROR_INVALID_DATE := dequote(FND_MESSAGE.GET_STRING('QA',
8386: 'QA_INTERFACE_INVALID_DATE'));
8387:
8388: ERROR_NEED_REV := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_NEED_REV'));
8389: ERROR_CANT_HAVE_REV := dequote(FND_MESSAGE.GET_STRING('QA',
8390: 'QA_INTERFACE_CANT_HAVE_REV'));
8391: ERROR_CANT_HAVE_LOC := dequote(FND_MESSAGE.GET_STRING('QA',
8392: 'QA_INTERFACE_CANT_HAVE_LOC'));
8393: ERROR_BUSY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_BUSY'));
8387:
8388: ERROR_NEED_REV := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_NEED_REV'));
8389: ERROR_CANT_HAVE_REV := dequote(FND_MESSAGE.GET_STRING('QA',
8390: 'QA_INTERFACE_CANT_HAVE_REV'));
8391: ERROR_CANT_HAVE_LOC := dequote(FND_MESSAGE.GET_STRING('QA',
8392: 'QA_INTERFACE_CANT_HAVE_LOC'));
8393: ERROR_BUSY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_BUSY'));
8394: ERROR_BAD_SQL := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_BAD_USER_SQL'));
8395:
8389: ERROR_CANT_HAVE_REV := dequote(FND_MESSAGE.GET_STRING('QA',
8390: 'QA_INTERFACE_CANT_HAVE_REV'));
8391: ERROR_CANT_HAVE_LOC := dequote(FND_MESSAGE.GET_STRING('QA',
8392: 'QA_INTERFACE_CANT_HAVE_LOC'));
8393: ERROR_BUSY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_BUSY'));
8394: ERROR_BAD_SQL := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_BAD_USER_SQL'));
8395:
8396: -- Gapless Sequence Proj. rponnusa Wed Jul 30 04:52:45 PDT 2003
8397: G_SEQUENCE_DEFAULT := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_SEQ_DEFAULT'));
8390: 'QA_INTERFACE_CANT_HAVE_REV'));
8391: ERROR_CANT_HAVE_LOC := dequote(FND_MESSAGE.GET_STRING('QA',
8392: 'QA_INTERFACE_CANT_HAVE_LOC'));
8393: ERROR_BUSY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_BUSY'));
8394: ERROR_BAD_SQL := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_BAD_USER_SQL'));
8395:
8396: -- Gapless Sequence Proj. rponnusa Wed Jul 30 04:52:45 PDT 2003
8397: G_SEQUENCE_DEFAULT := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_SEQ_DEFAULT'));
8398:
8393: ERROR_BUSY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_BUSY'));
8394: ERROR_BAD_SQL := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_BAD_USER_SQL'));
8395:
8396: -- Gapless Sequence Proj. rponnusa Wed Jul 30 04:52:45 PDT 2003
8397: G_SEQUENCE_DEFAULT := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_SEQ_DEFAULT'));
8398:
8399: -- Tracking Bug : 3104827. Review Tracking Bug : 3148873
8400: -- Added to Get Error Message String for Read Only Flag Collection Plan Elements
8401: -- saugupta Wed Aug 27 07:25:51 PDT 2003.
8398:
8399: -- Tracking Bug : 3104827. Review Tracking Bug : 3148873
8400: -- Added to Get Error Message String for Read Only Flag Collection Plan Elements
8401: -- saugupta Wed Aug 27 07:25:51 PDT 2003.
8402: ERROR_READ_ONLY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_READ_ONLY'));
8403:
8404: -- Bug 3069404 ksoh Tue Mar 16 10:43:36 PST 2004
8405: -- Error message for importing sequence element
8406: ERROR_SEQUENCE := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_SEQUENCE'));
8402: ERROR_READ_ONLY := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_READ_ONLY'));
8403:
8404: -- Bug 3069404 ksoh Tue Mar 16 10:43:36 PST 2004
8405: -- Error message for importing sequence element
8406: ERROR_SEQUENCE := dequote(FND_MESSAGE.GET_STRING('QA', 'QA_INTERFACE_SEQUENCE'));
8407:
8408: -- For Timezone Compliance bug 3179845. Error used for invalid date and Time.
8409: -- kabalakr Mon Oct 27 04:33:49 PST 2003.
8410:
8407:
8408: -- For Timezone Compliance bug 3179845. Error used for invalid date and Time.
8409: -- kabalakr Mon Oct 27 04:33:49 PST 2003.
8410:
8411: ERROR_INVALID_DATETIME := dequote(FND_MESSAGE.GET_STRING('QA',
8412: 'QA_INTERFACE_INVALID_DATETIME'));
8413:
8414:
8415: --