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 926: l_request_id := fnd_global.conc_request_id;

922: x_errbuf := '';
923:
924: l_err_loc := 200;
925: -- get the concurrent request Id
926: l_request_id := fnd_global.conc_request_id;
927:
928: l_err_loc := 300;
929: -- update the job status to running
930: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'RUNNING');

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

953: INSERT INTO icx_por_failed_line_messages
954: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
955: program_application_id, program_login_id)
956: VALUES (l_request_id, 'OTHER', 'ICX_CAT_CANNOT_UPDATE_CZS_ERR', l_token_list, 1, l_request_id,
957: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);
958: ELSE
959: l_err_loc := 900;
960: -- update the job status to completed
961: ICX_CAT_SCHEMA_UPLOAD_PVT.update_job_status(l_request_id, 'COMPLETED');

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

985: INSERT INTO icx_por_failed_line_messages
986: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
987: program_application_id, program_login_id)
988: VALUES (l_request_id, 'OTHER', 'ICX_CAT_HIER_UNEXPECTED_ERR', l_token_list, 1, l_request_id,
989: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);
990:
991: COMMIT;
992:
993: END sync_sqes_for_hierarchy_change;

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

1031: INSERT INTO icx_por_failed_line_messages
1032: (job_number, descriptor_key, message_name, token_list, line_number, request_id, program_id,
1033: program_application_id, program_login_id)
1034: VALUES (p_request_id, 'ICX_CAT_CONTENT_ZONES', 'ICX_CAT_CANNOT_UPDATE_ZONES', null, p_line_number, p_request_id,
1035: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);
1036:
1037: l_err_loc := 900;
1038: INSERT INTO icx_por_failed_lines
1039: (job_number, line_number, action, row_type, descriptor_key, descriptor_value,

Line 1042: l_errored_zone_name_list, p_request_id, fnd_global.conc_program_id,

1038: INSERT INTO icx_por_failed_lines
1039: (job_number, line_number, action, row_type, descriptor_key, descriptor_value,
1040: request_id, program_id, program_application_id, program_login_id)
1041: VALUES (p_request_id, p_line_number, p_action, 'RELATIONSHIP', 'ICX_CAT_CONTENT_ZONES',
1042: l_errored_zone_name_list, p_request_id, fnd_global.conc_program_id,
1043: fnd_global.prog_appl_id, fnd_global.conc_login_id);
1044: END IF;
1045:
1046: l_err_loc := 1000;

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

1039: (job_number, line_number, action, row_type, descriptor_key, descriptor_value,
1040: request_id, program_id, program_application_id, program_login_id)
1041: VALUES (p_request_id, p_line_number, p_action, 'RELATIONSHIP', 'ICX_CAT_CONTENT_ZONES',
1042: l_errored_zone_name_list, p_request_id, fnd_global.conc_program_id,
1043: fnd_global.prog_appl_id, fnd_global.conc_login_id);
1044: END IF;
1045:
1046: l_err_loc := 1000;
1047: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN