APPS.IGS_PS_GEN_008 dependencies on FND_NEW_MESSAGES

Line 1581: l_message_name fnd_new_messages.message_name%TYPE;

1577: SELECT max(gs.version_number) maxm
1578: FROM igs_as_grd_schema gs
1579: WHERE gs.grading_schema_cd = cp_grad_schema_cd;
1580:
1581: l_message_name fnd_new_messages.message_name%TYPE;
1582: v_latest_gs_ver cur_latest_gs_ver%ROWTYPE;
1583: l_unit_ass_item_id igs_as_unitass_item_all.unit_ass_item_id%TYPE;
1584:
1585: BEGIN

Line 2217: l_message_name fnd_new_messages.message_name%TYPE;

2213: FROM igs_as_grd_schema
2214: WHERE grading_schema_cd = p_grading_schema_cd;
2215: l_appr_grd_sch igs_as_appr_grd_sch%ROWTYPE;
2216: l_max_ver_grd_sch igs_as_grd_schema.version_number%TYPE;
2217: l_message_name fnd_new_messages.message_name%TYPE;
2218: l_rowid VARCHAR(30);
2219:
2220: BEGIN
2221: FOR l_appr_grd_sch IN c_appr_grd_sch

Line 2634: l_message_name fnd_new_messages.message_text%TYPE;

2630: SELECT owner_org_unit_cd
2631: FROM igs_ps_unit_ofr_opt
2632: WHERE uoo_id = cp_uoo_id;
2633: lcur_org_unit cur_org_unit%rowtype;
2634: l_message_name fnd_new_messages.message_text%TYPE;
2635: BEGIN
2636: --l_message_name should contain error messasges from tbh while insertion, if any other error is occured
2637: --that is fetched by using sqlerrm and stored in l_message_name
2638: l_message_name:=fnd_message.get;