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.AMS_LISTIMPORT_PVT dependencies on AMS_LIST_IMPORT_ERRORS

Line 3062: select 'Y' from ams_list_import_errors

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

Line 3114: delete from ams_list_import_errors where import_list_header_id

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

Line 3116: delete from ams_list_import_errors where import_list_header_id

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

Line 3246: delete from ams_list_import_errors where import_list_header_id

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

Line 3248: delete from ams_list_import_errors where import_list_header_id

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

Line 3382: delete from ams_list_import_errors where import_list_header_id

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

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

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

Line 4025: select 'Y' from ams_list_import_errors

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

Line 4044: ams_list_import_errors errors

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

Line 4129: delete from ams_list_import_errors where import_list_header_id

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

Line 4131: delete from ams_list_import_errors where import_list_header_id

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

Line 4473: delete from ams_list_import_errors where import_list_header_id

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

Line 6804: from ams_list_import_errors

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

Line 7076: INSERT INTO ams_list_import_errors

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

Line 7331: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

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

Line 7609: update ams_list_import_errors

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

Line 7616: INSERT INTO ams_list_import_errors

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

Line 7633: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

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

Line 7654: (select import_source_line_id from ams_list_import_errors

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

Line 7721: from ams_list_import_errors

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

Line 7946: update ams_list_import_errors

7942: end if;
7943:
7944: 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
7945: if l_error_exist = 'Y' then
7946: update ams_list_import_errors
7947: set col227 = decode(l_col1,'Y',l_col11||l_invalid_date),
7948: col228 = decode(l_col2,'Y',l_col22||l_invalid_date),
7949: -- col229 = decode(l_col3,'Y','LAST_ORDERED_DATE:'||l_invalid_date),
7950: -- col230 = decode(l_col4,'Y','PROGRAM_UPDATE_DATE:'||l_invalid_date),

Line 8018: INSERT INTO ams_list_import_errors

8014: end if;
8015: end if;
8016: if l_error_exist is null then
8017: 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
8018: INSERT INTO ams_list_import_errors
8019: (
8020: LIST_IMPORT_ERROR_ID,
8021: LAST_UPDATED_BY,
8022: LAST_UPDATE_DATE,

Line 8042: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

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

Line 8220: INSERT INTO ams_list_import_errors

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

Line 8236: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

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

Line 8263: (select import_source_line_id from ams_list_import_errors

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

Line 10636: INSERT INTO ams_list_import_errors

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

Line 10847: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

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

Line 11093: (select import_source_line_id from ams_list_import_errors

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

Line 13689: select 'Y' from ams_list_import_errors

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

Line 14285: delete from ams_list_import_errors where import_list_header_id

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

Line 14287: delete from ams_list_import_errors where import_list_header_id

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

Line 14485: delete from ams_list_import_errors where import_list_header_id

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

Line 14606: delete from ams_list_import_errors where import_list_header_id

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

Line 14608: delete from ams_list_import_errors where import_list_header_id

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

Line 14697: delete from ams_list_import_errors where import_list_header_id

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

Line 15533: INSERT INTO ams_list_import_errors

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

Line 15685: ams_list_import_errors_s.nextval, -- LIST_IMPORT_ERROR_ID,

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

Line 15841: (select import_source_line_id from ams_list_import_errors

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

Line 20899: select 'Y' from ams_list_import_errors

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

Line 20978: delete from ams_list_import_errors where import_list_header_id

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