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.

[Home] [Help]

APPS.AMS_LISTIMPORT_PVT dependencies on AMS_LIST_IMPORT_ERRORS

Line 3061: select 'Y' from ams_list_import_errors

3057: SELECT concurrent_program FROM ams_imp_list_import_types
3058: where import_type = l_import_type;
3059:
3060: cursor c_error_exist is
3061: select 'Y' from ams_list_import_errors
3062: where import_list_header_id = p_import_list_header_id
3063: and error_type = 'E'
3064: and rownum < 2;
3065:

Line 3113: delete from ams_list_import_errors where import_list_header_id

3109: p_msg_type => 'DEBUG'
3110: );
3111:
3112: -- Delete all the errors from the errors table which are reloaded.
3113: delete from ams_list_import_errors where import_list_header_id
3114: = p_import_list_header_id and import_source_line_id = 0;
3115: delete from ams_list_import_errors where import_list_header_id
3116: = p_import_list_header_id and import_source_line_id in
3117: (select import_source_line_id from ams_imp_source_lines where

Line 3115: delete from ams_list_import_errors where import_list_header_id

3111:
3112: -- Delete all the errors from the errors table which are reloaded.
3113: delete from ams_list_import_errors where import_list_header_id
3114: = p_import_list_header_id and import_source_line_id = 0;
3115: delete from ams_list_import_errors where import_list_header_id
3116: = p_import_list_header_id and import_source_line_id in
3117: (select import_source_line_id from ams_imp_source_lines where
3118: import_list_header_id = p_import_list_header_id and load_status = G_STATUS_RELOAD);
3119: /*

Line 3245: delete from ams_list_import_errors where import_list_header_id

3241: p_msg_type => 'DEBUG'
3242: );
3243:
3244: -- Delete all the errors from the errors table which are reloaded.
3245: delete from ams_list_import_errors where import_list_header_id
3246: = p_import_list_header_id and import_source_line_id = 0;
3247: delete from ams_list_import_errors where import_list_header_id
3248: = p_import_list_header_id and import_source_line_id in
3249: (select import_source_line_id from ams_imp_source_lines where

Line 3247: delete from ams_list_import_errors where import_list_header_id

3243:
3244: -- Delete all the errors from the errors table which are reloaded.
3245: delete from ams_list_import_errors where import_list_header_id
3246: = p_import_list_header_id and import_source_line_id = 0;
3247: delete from ams_list_import_errors where import_list_header_id
3248: = p_import_list_header_id and import_source_line_id in
3249: (select import_source_line_id from ams_imp_source_lines where
3250: import_list_header_id = p_import_list_header_id and load_status = G_STATUS_RELOAD);
3251:

Line 3381: delete from ams_list_import_errors where import_list_header_id

3377: where import_list_header_id = p_import_list_header_id;
3378: end if;
3379:
3380: -- Delete all the errors from the errors table which are sucessful.
3381: delete from ams_list_import_errors where import_list_header_id
3382: = p_import_list_header_id and import_source_line_id in
3383: (select import_source_line_id from ams_imp_source_lines where
3384: import_list_header_id = p_import_list_header_id and load_status = G_STATUS_SUCCESS);
3385:

Line 4017: select 'Y' from ams_imp_source_lines -- ams_list_import_errors

4013: and rownum < 2;
4014:
4015: /*
4016: cursor c_error_exist is
4017: select 'Y' from ams_imp_source_lines -- ams_list_import_errors
4018: where import_list_header_id = p_import_list_header_id
4019: and load_status = 'ERROR'
4020: -- and error_type = 'E'
4021: and rownum < 2;

Line 4024: select 'Y' from ams_list_import_errors

4020: -- and error_type = 'E'
4021: and rownum < 2;
4022: */
4023: cursor c_error_exist is
4024: select 'Y' from ams_list_import_errors
4025: where import_list_header_id = p_import_list_header_id
4026: and error_type = 'E'
4027: and col1 <> 'This is a duplicate lead.'
4028: and rownum < 2;

Line 4043: ams_list_import_errors errors

4039:
4040: /*
4041: cursor c_rec_failed_in_ams is
4042: select count(*) from ams_imp_source_lines lines,
4043: ams_list_import_errors errors
4044: where lines.import_list_header_id = p_import_list_header_id
4045: and lines.load_status = 'ERROR'
4046: and lines.import_list_header_id = errors.import_list_header_id
4047: and lines.IMPORT_SOURCE_LINE_ID = errors.IMPORT_SOURCE_LINE_ID

Line 4128: delete from ams_list_import_errors where import_list_header_id

4124: p_msg_type => 'DEBUG'
4125: );
4126:
4127: -- Delete all the errors from the errors table which are reloaded.
4128: delete from ams_list_import_errors where import_list_header_id
4129: = p_import_list_header_id and import_source_line_id = 0;
4130: delete from ams_list_import_errors where import_list_header_id
4131: = p_import_list_header_id and import_source_line_id in
4132: (select import_source_line_id from ams_imp_source_lines where

Line 4130: delete from ams_list_import_errors where import_list_header_id

4126:
4127: -- Delete all the errors from the errors table which are reloaded.
4128: delete from ams_list_import_errors where import_list_header_id
4129: = p_import_list_header_id and import_source_line_id = 0;
4130: delete from ams_list_import_errors where import_list_header_id
4131: = p_import_list_header_id and import_source_line_id in
4132: (select import_source_line_id from ams_imp_source_lines where
4133: import_list_header_id = p_import_list_header_id and load_status = G_STATUS_RELOAD);
4134:

Line 4472: delete from ams_list_import_errors where import_list_header_id

4468: );
4469: end if;
4470:
4471: -- Delete all the errors from the errors table which are sucessful.
4472: delete from ams_list_import_errors where import_list_header_id
4473: = p_import_list_header_id and import_source_line_id in
4474: (select import_source_line_id from ams_imp_source_lines where
4475: import_list_header_id = p_import_list_header_id and load_status = G_STATUS_SUCCESS);
4476:

Line 6803: from ams_list_import_errors

6799: AND source_system <> l_source_system;
6800:
6801: cursor c_error_exists is
6802: select 'Y'
6803: from ams_list_import_errors
6804: where import_list_header_id = x_import_source_line_id
6805: and import_source_line_id = x_import_source_line_id
6806: and batch_id = l_batch_id;
6807:

Line 7075: INSERT INTO ams_list_import_errors

7071: LIMIT L_MAX_ROW_COUNT;
7072:
7073:
7074: FORALL i IN 1 .. l_import_source_line_id.count
7075: INSERT INTO ams_list_import_errors
7076: (
7077: LIST_IMPORT_ERROR_ID,
7078: LAST_UPDATED_BY,
7079: LAST_UPDATE_DATE,

Line 7330: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

7326: col238
7327: )
7328: VALUES
7329: (
7330: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
7331: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
7332: SYSDATE, -- LAST_UPDATE_DATE,
7333: SYSDATE, -- CREATION_DATE,
7334: FND_GLOBAL.User_ID, -- CREATED_BY,

Line 7608: update ams_list_import_errors

7604: open c_error_exists;
7605: fetch c_error_exists into l_error_exists;
7606: close c_error_exists;
7607: if l_error_exists = 'Y' then
7608: update ams_list_import_errors
7609: set col1 = 'SOURCE_SYSTEM:'||l_invalid_src_system
7610: where import_list_header_id = x_import_list_header_id
7611: and import_source_line_id = x_import_source_line_id
7612: and batch_id = l_batch_id;

Line 7615: INSERT INTO ams_list_import_errors

7611: and import_source_line_id = x_import_source_line_id
7612: and batch_id = l_batch_id;
7613: end if;
7614: if l_error_exists is null then
7615: INSERT INTO ams_list_import_errors
7616: (
7617: LIST_IMPORT_ERROR_ID,
7618: LAST_UPDATED_BY,
7619: LAST_UPDATE_DATE,

Line 7632: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

7628: col1
7629: )
7630: VALUES
7631: (
7632: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
7633: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
7634: SYSDATE, -- LAST_UPDATE_DATE,
7635: SYSDATE, -- CREATION_DATE,
7636: FND_GLOBAL.User_ID, -- CREATED_BY,

Line 7653: (select import_source_line_id from ams_list_import_errors

7649: UPDATE ams_imp_source_lines
7650: SET load_status = decode(load_status,'DUPLICATE','DUPLICATE','ERROR')
7651: WHERE import_list_header_id = p_import_list_header_id
7652: and import_source_line_id in
7653: (select import_source_line_id from ams_list_import_errors
7654: where import_list_header_id = p_import_list_header_id
7655: and error_type = 'E');
7656:
7657:

Line 7720: from ams_list_import_errors

7716: x_date_format VARCHAR2(50);
7717:
7718: cursor c_error_exists is
7719: select 'Y'
7720: from ams_list_import_errors
7721: where import_list_header_id = p_import_list_header_id
7722: and import_source_line_id = p_import_source_line_id
7723: and batch_id = p_batch_id;
7724:

Line 7945: update ams_list_import_errors

7941: end if;
7942:
7943: if (l_col1 = 'Y' or l_col2 = 'Y' or l_col3 = 'Y' or l_col4 = 'Y' or l_col5 = 'Y' or l_col6 = 'Y') then
7944: if l_error_exist = 'Y' then
7945: update ams_list_import_errors
7946: set col227 = decode(l_col1,'Y',l_col11||l_invalid_date),
7947: col228 = decode(l_col2,'Y',l_col22||l_invalid_date),
7948: -- col229 = decode(l_col3,'Y','LAST_ORDERED_DATE:'||l_invalid_date),
7949: -- col230 = decode(l_col4,'Y','PROGRAM_UPDATE_DATE:'||l_invalid_date),

Line 8017: INSERT INTO ams_list_import_errors

8013: end if;
8014: end if;
8015: if l_error_exist is null then
8016: if (l_col1 = 'Y' or l_col2 = 'Y' or l_col3 = 'Y' or l_col4 = 'Y' or l_col5 = 'Y' or l_col6 = 'Y') then
8017: INSERT INTO ams_list_import_errors
8018: (
8019: LIST_IMPORT_ERROR_ID,
8020: LAST_UPDATED_BY,
8021: LAST_UPDATE_DATE,

Line 8041: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

8037: col236
8038: )
8039: VALUES
8040: (
8041: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
8042: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
8043: SYSDATE, -- LAST_UPDATE_DATE,
8044: SYSDATE, -- CREATION_DATE,
8045: FND_GLOBAL.User_ID, -- CREATED_BY,

Line 8219: INSERT INTO ams_list_import_errors

8215: END IF;
8216:
8217:
8218: FORALL i IN I_imp_source_line_id.FIRST..I_imp_source_line_id.LAST
8219: INSERT INTO ams_list_import_errors
8220: (
8221: LIST_IMPORT_ERROR_ID,
8222: LAST_UPDATED_BY,
8223: LAST_UPDATE_DATE,

Line 8235: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

8231: COL1
8232: )
8233: values
8234: (
8235: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
8236: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
8237: SYSDATE, -- LAST_UPDATE_DATE,
8238: SYSDATE, -- CREATION_DATE,
8239: FND_GLOBAL.User_ID, -- CREATED_BY,

Line 8262: (select import_source_line_id from ams_list_import_errors

8258: UPDATE ams_imp_source_lines
8259: SET load_status = 'ERROR'
8260: WHERE import_list_header_id = p_import_list_header_id
8261: and import_source_line_id in
8262: (select import_source_line_id from ams_list_import_errors
8263: where import_list_header_id = p_import_list_header_id
8264: and error_type = 'E');
8265:
8266:

Line 10635: INSERT INTO ams_list_import_errors

10631: LIMIT L_MAX_ROW_COUNT;
10632: end if;
10633:
10634: FORALL i IN 1 .. l_import_source_line_id.count
10635: INSERT INTO ams_list_import_errors
10636: (
10637: LIST_IMPORT_ERROR_ID,
10638: LAST_UPDATED_BY,
10639: LAST_UPDATE_DATE,

Line 10846: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

10842: col194
10843: )
10844: VALUES
10845: (
10846: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
10847: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
10848: SYSDATE, -- LAST_UPDATE_DATE,
10849: SYSDATE, -- CREATION_DATE,
10850: FND_GLOBAL.User_ID, -- CREATED_BY,

Line 11092: (select import_source_line_id from ams_list_import_errors

11088: UPDATE ams_imp_source_lines
11089: SET load_status = decode(load_status,'DUPLICATE','DUPLICATE','ERROR')
11090: WHERE import_list_header_id = p_import_list_header_id
11091: and import_source_line_id in
11092: (select import_source_line_id from ams_list_import_errors
11093: where import_list_header_id = p_import_list_header_id
11094: and error_type = 'E');
11095:
11096: EXCEPTION

Line 13688: select 'Y' from ams_list_import_errors

13684: SELECT concurrent_program FROM ams_imp_list_import_types
13685: where import_type = 'LEAD';
13686:
13687: cursor c_error_exist is
13688: select 'Y' from ams_list_import_errors
13689: where import_list_header_id = p_import_list_header_id
13690: and error_type = 'E'
13691: and rownum < 2;
13692:

Line 14284: delete from ams_list_import_errors where import_list_header_id

14280: p_msg_data => 'Starting Validation for CUSTOMER data.',
14281: p_msg_type => 'DEBUG'
14282: );
14283: -- Delete all the errors from the errors table which are reloaded.
14284: delete from ams_list_import_errors where import_list_header_id
14285: = p_import_list_header_id and import_source_line_id = 0;
14286: delete from ams_list_import_errors where import_list_header_id
14287: = p_import_list_header_id and import_source_line_id in
14288: (select import_source_line_id from ams_imp_source_lines where

Line 14286: delete from ams_list_import_errors where import_list_header_id

14282: );
14283: -- Delete all the errors from the errors table which are reloaded.
14284: delete from ams_list_import_errors where import_list_header_id
14285: = p_import_list_header_id and import_source_line_id = 0;
14286: delete from ams_list_import_errors where import_list_header_id
14287: = p_import_list_header_id and import_source_line_id in
14288: (select import_source_line_id from ams_imp_source_lines where
14289: import_list_header_id = p_import_list_header_id and load_status = G_STATUS_RELOAD);
14290: if l_file_type = 'XML' then

Line 14484: delete from ams_list_import_errors where import_list_header_id

14480: where import_list_header_id = p_import_list_header_id;
14481: end if;
14482:
14483: -- Delete all the errors from the errors table which are sucessful.
14484: delete from ams_list_import_errors where import_list_header_id
14485: = p_import_list_header_id and import_source_line_id in
14486: (select import_source_line_id from ams_imp_source_lines where
14487: import_list_header_id = p_import_list_header_id and load_status = G_STATUS_SUCCESS);
14488: open c_loaded_records;

Line 14605: delete from ams_list_import_errors where import_list_header_id

14601: p_msg_data => 'Starting Validation for EVENT data.',
14602: p_msg_type => 'DEBUG'
14603: );
14604: -- Delete all the errors from the errors table which are reloaded.
14605: delete from ams_list_import_errors where import_list_header_id
14606: = p_import_list_header_id and import_source_line_id = 0;
14607: delete from ams_list_import_errors where import_list_header_id
14608: = p_import_list_header_id and import_source_line_id in
14609: (select import_source_line_id from ams_imp_source_lines where

Line 14607: delete from ams_list_import_errors where import_list_header_id

14603: );
14604: -- Delete all the errors from the errors table which are reloaded.
14605: delete from ams_list_import_errors where import_list_header_id
14606: = p_import_list_header_id and import_source_line_id = 0;
14607: delete from ams_list_import_errors where import_list_header_id
14608: = p_import_list_header_id and import_source_line_id in
14609: (select import_source_line_id from ams_imp_source_lines where
14610: import_list_header_id = p_import_list_header_id and load_status = G_STATUS_RELOAD);
14611:

Line 14696: delete from ams_list_import_errors where import_list_header_id

14692: status_date = sysdate
14693: where import_list_header_id = p_import_list_header_id;
14694: end if;
14695: -- Delete all the errors from the errors table which are sucessful.
14696: delete from ams_list_import_errors where import_list_header_id
14697: = p_import_list_header_id and import_source_line_id in
14698: (select import_source_line_id from ams_imp_source_lines where
14699: import_list_header_id = p_import_list_header_id and load_status = G_STATUS_SUCCESS);
14700: open c_loaded_records;

Line 15532: INSERT INTO ams_list_import_errors

15528: LIMIT L_MAX_ROW_COUNT;
15529:
15530:
15531: FORALL i IN 1 .. l_import_source_line_id.count
15532: INSERT INTO ams_list_import_errors
15533: (
15534: LIST_IMPORT_ERROR_ID,
15535: LAST_UPDATED_BY,
15536: LAST_UPDATE_DATE,

Line 15684: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

15680: col135
15681: )
15682: VALUES
15683: (
15684: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,
15685: FND_GLOBAL.User_ID, -- LAST_UPDATED_BY,
15686: SYSDATE, -- LAST_UPDATE_DATE,
15687: SYSDATE, -- CREATION_DATE,
15688: FND_GLOBAL.User_ID, -- CREATED_BY,

Line 15840: (select import_source_line_id from ams_list_import_errors

15836: UPDATE ams_imp_source_lines
15837: SET load_status = 'ERROR'
15838: WHERE import_list_header_id = p_import_list_header_id
15839: and import_source_line_id in
15840: (select import_source_line_id from ams_list_import_errors
15841: where import_list_header_id = p_import_list_header_id
15842: and error_type = 'E');
15843:
15844:

Line 20898: select 'Y' from ams_list_import_errors

20894: where import_list_header_id = p_import_list_header_id
20895: and duplicate_flag = 'Y';
20896:
20897: cursor c_error_exist is
20898: select 'Y' from ams_list_import_errors
20899: where import_list_header_id = p_import_list_header_id
20900: and error_type = 'E'
20901: and rownum < 2;
20902:

Line 20977: delete from ams_list_import_errors where import_list_header_id

20973: where import_list_header_id = p_import_list_header_id;
20974: end if;
20975:
20976: -- Delete all the errors from the errors table which are sucessful.
20977: delete from ams_list_import_errors where import_list_header_id
20978: = p_import_list_header_id and import_source_line_id in
20979: (select import_source_line_id from ams_imp_source_lines where
20980: import_list_header_id = p_import_list_header_id and load_status = G_STATUS_SUCCESS);
20981: open c_loaded_records;