DBA Data[Home] [Help]

APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on FND_NEW_MESSAGES

Line 395: l_c_token_val fnd_new_messages.message_text%TYPE;

391: AND NVL(end_dt,SYSDATE) >= SYSDATE
392: AND grading_schema_type = 'ASSESSMENT_ITEM';
393:
394: l_c_var VARCHAR2(1);
395: l_c_token_val fnd_new_messages.message_text%TYPE;
396:
397: BEGIN
398:
399: IF (p_unitass_item_rec.midterm_mandatory_type_code IS NOT NULL) AND (p_unitass_item_rec.midterm_mandatory_type_code NOT IN ('MANDATORY', 'MANDATORY_PASS','OPTIONAL')) THEN

Line 696: l_c_msg_name fnd_new_messages.message_name%TYPE;

692:
693: DECLARE
694: FUNCTION get_msg_from_stack(l_n_msg_count NUMBER) RETURN VARCHAR2 AS
695: l_c_msg VARCHAR2(3000);
696: l_c_msg_name fnd_new_messages.message_name%TYPE;
697: l_appl_name VARCHAR2(30);
698: BEGIN
699: l_c_msg := FND_MSG_PUB.GET(p_msg_index => l_n_msg_count, p_encoded => 'T');
700: FND_MESSAGE.SET_ENCODED (l_c_msg);

Line 1145: l_message_name fnd_new_messages.message_name%TYPE;

1141: SELECT uoo_id
1142: FROM igs_ps_uso_clas_meet
1143: WHERE class_meet_group_id = cp_class_meet_group_id;
1144:
1145: l_message_name fnd_new_messages.message_name%TYPE;
1146: l_request_id igs_ps_sch_hdr_int.request_id%TYPE;
1147:
1148: BEGIN
1149:

Line 1310: l_c_msg_name fnd_new_messages.message_name%TYPE;

1306:
1307: DECLARE
1308: FUNCTION get_msg_from_stack(l_n_msg_count NUMBER) RETURN VARCHAR2 AS
1309: l_c_msg VARCHAR2(3000);
1310: l_c_msg_name fnd_new_messages.message_name%TYPE;
1311: l_appl_name VARCHAR2(30);
1312: BEGIN
1313: l_c_msg := FND_MSG_PUB.GET(p_msg_index => l_n_msg_count, p_encoded => 'T');
1314: FND_MESSAGE.SET_ENCODED (l_c_msg);

Line 1706: l_message_name fnd_new_messages.message_name%TYPE;

1702: SELECT uoo_id
1703: FROM igs_ps_usec_x_grpmem
1704: WHERE usec_x_listed_group_id = cp_usec_x_listed_group_id;
1705:
1706: l_message_name fnd_new_messages.message_name%TYPE;
1707: l_request_id igs_ps_sch_hdr_int.request_id%TYPE;
1708:
1709: BEGIN
1710: