APPS.IGS_EN_LGCY_PRC dependencies on IGS_EN_LGCY_ERR_INT

Line 154: DELETE FROM igs_en_lgcy_err_int

150: This procedure deletes the error message
151: records for the particualr interface table corresponding
152: to the p_int_table_code and p_int_table_id
153: */
154: DELETE FROM igs_en_lgcy_err_int
155: WHERE int_table_id = p_int_table_id
156: AND int_table_code = p_int_table_code;
157: END;
158: -------------------------------------------------------------------------------

Line 307: INSERT INTO igs_en_lgcy_err_int

303: l_request_id := get_request_id;
304: l_program_application_id := get_program_application_id;
305: l_program_id := get_program_id;
306: l_program_update_date := get_program_update_date;
307: INSERT INTO igs_en_lgcy_err_int
308: (
309: err_message_id,
310: int_table_code,
311: int_table_id,

Line 410: l_err_msg_id igs_en_lgcy_err_int.err_message_id%TYPE;

406: l_appl_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;
407: l_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
408: l_msg_number FND_NEW_MESSAGES.MESSAGE_NUMBER%TYPE;
409: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
410: l_err_msg_id igs_en_lgcy_err_int.err_message_id%TYPE;
411: l_app VARCHAR2(10);
412: BEGIN
413:
414: l_msg_count := p_msg_count;

Line 418: SELECT igs_en_lgcy_err_int_s.NEXTVAL INTO l_err_msg_id FROM DUAL;

414: l_msg_count := p_msg_count;
415: l_msg_data := p_msg_data;
416:
417: IF l_msg_count =1 THEN
418: SELECT igs_en_lgcy_err_int_s.NEXTVAL INTO l_err_msg_id FROM DUAL;
419: FND_MESSAGE.SET_ENCODED(l_msg_data);
420: l_msg_text := FND_MESSAGE.GET;
421:
422: l_msg_number := NULL;

Line 439: SELECT igs_en_lgcy_err_int_s.NEXTVAL INTO l_err_msg_id FROM DUAL;

435: );
436: ELSIF l_msg_count > 1 THEN
437: FOR l_index IN 1..NVL(l_msg_count,0)
438: LOOP
439: SELECT igs_en_lgcy_err_int_s.NEXTVAL INTO l_err_msg_id FROM DUAL;
440: FND_MSG_PUB.GET(FND_MSG_PUB.G_FIRST,
441: FND_API.G_TRUE,
442: l_enc_msg,
443: l_msg_index);