DBA Data[Home] [Help]

APPS.ICX_CAT_SQE_PVT dependencies on FND_GLOBAL

Line 100: VALUES (x_sqe_sequence, fnd_global.user_id, sysdate, fnd_global.user_id,

96: IF (x_sqe_sequence IS NOT NULL) THEN
97: l_err_loc := 850;
98: INSERT INTO icx_cat_deleted_sqes (sqe_sequence, created_by, creation_date,
99: last_updated_by, last_update_date, last_update_login)
100: VALUES (x_sqe_sequence, fnd_global.user_id, sysdate, fnd_global.user_id,
101: sysdate, fnd_global.login_id);
102:
103: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: l_log_string := 'Inserted old sqe sequence into deleted sqes. Old sqe sequence: ' || x_sqe_sequence;

Line 101: sysdate, fnd_global.login_id);

97: l_err_loc := 850;
98: INSERT INTO icx_cat_deleted_sqes (sqe_sequence, created_by, creation_date,
99: last_updated_by, last_update_date, last_update_login)
100: VALUES (x_sqe_sequence, fnd_global.user_id, sysdate, fnd_global.user_id,
101: sysdate, fnd_global.login_id);
102:
103: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
104: l_log_string := 'Inserted old sqe sequence into deleted sqes. Old sqe sequence: ' || x_sqe_sequence;
105: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 937: l_request_id := fnd_global.conc_request_id;

933: x_errbuf := '';
934:
935: l_err_loc := 200;
936: -- get the concurrent request Id
937: l_request_id := fnd_global.conc_request_id;
938:
939: l_err_loc := 300;
940: -- update the job status to running
941: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'RUNNING');

Line 968: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

964: INSERT INTO icx_por_failed_line_messages
965: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
966: program_application_id, program_login_id)
967: VALUES (l_request_id, 'OTHER', 'ICX_CAT_CANNOT_UPDATE_CZS_ERR', l_token_list, 1, l_request_id,
968: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);
969: ELSE
970: l_err_loc := 900;
971: -- update the job status to completed
972: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'COMPLETED');

Line 1000: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

996: INSERT INTO icx_por_failed_line_messages
997: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
998: program_application_id, program_login_id)
999: VALUES (l_request_id, 'OTHER', 'ICX_CAT_HIER_UNEXPECTED_ERR', l_token_list, 1, l_request_id,
1000: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);
1001:
1002: COMMIT;
1003:
1004: END sync_sqes_for_hierarchy_change;

Line 1046: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

1042: INSERT INTO icx_por_failed_line_messages
1043: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
1044: program_application_id, program_login_id)
1045: VALUES (p_request_id, 'ICX_CAT_CONTENT_ZONES', 'ICX_CAT_CANNOT_UPDATE_ZONES', null, p_line_number, p_request_id,
1046: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);
1047:
1048: l_err_loc := 900;
1049: INSERT INTO icx_por_failed_lines
1050: (job_number, line_number, action, row_type, descriptor_key, descriptor_value,

Line 1053: l_errored_zone_name_list, p_request_id, fnd_global.conc_program_id,

1049: INSERT INTO icx_por_failed_lines
1050: (job_number, line_number, action, row_type, descriptor_key, descriptor_value,
1051: request_id, program_id, program_application_id, program_login_id)
1052: VALUES (p_request_id, p_line_number, p_action, 'RELATIONSHIP', 'ICX_CAT_CONTENT_ZONES',
1053: l_errored_zone_name_list, p_request_id, fnd_global.conc_program_id,
1054: fnd_global.prog_appl_id, fnd_global.conc_login_id);
1055: END IF;
1056:
1057: l_err_loc := 1000;

Line 1054: fnd_global.prog_appl_id, fnd_global.conc_login_id);

1050: (job_number, line_number, action, row_type, descriptor_key, descriptor_value,
1051: request_id, program_id, program_application_id, program_login_id)
1052: VALUES (p_request_id, p_line_number, p_action, 'RELATIONSHIP', 'ICX_CAT_CONTENT_ZONES',
1053: l_errored_zone_name_list, p_request_id, fnd_global.conc_program_id,
1054: fnd_global.prog_appl_id, fnd_global.conc_login_id);
1055: END IF;
1056:
1057: l_err_loc := 1000;
1058: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN