86: )
87:
88: IS
89: L_proc_name VARCHAR2(30) := 'Validate_Trans_Type';
90: l_msg_name fnd_new_messages.message_name%type;
91: l_msg_text fnd_new_messages.message_text%type;
92: l_sysdate DATE := SYSDATE;
93:
94: BEGIN
87:
88: IS
89: L_proc_name VARCHAR2(30) := 'Validate_Trans_Type';
90: l_msg_name fnd_new_messages.message_name%type;
91: l_msg_text fnd_new_messages.message_text%type;
92: l_sysdate DATE := SYSDATE;
93:
94: BEGIN
95: write_debug (l_proc_name, 'Start of '||l_proc_name);
433: )
434:
435: IS
436: L_proc_name VARCHAR2(30) := 'Validate_Entity_Cols';
437: l_msg_name fnd_new_messages.message_name%type;
438: l_msg_text fnd_new_messages.message_text%type;
439: l_sysdate DATE := SYSDATE;
440:
441: BEGIN
434:
435: IS
436: L_proc_name VARCHAR2(30) := 'Validate_Entity_Cols';
437: l_msg_name fnd_new_messages.message_name%type;
438: l_msg_text fnd_new_messages.message_text%type;
439: l_sysdate DATE := SYSDATE;
440:
441: BEGIN
442: write_debug (l_proc_name, 'Start of '||l_proc_name);
968: )
969:
970: IS
971: l_proc_name varchar2(30) := 'Validate_Name_ID_Cols';
972: l_msg_name fnd_new_messages.message_name%type;
973: l_msg_text fnd_new_messages.message_text%type;
974: l_msg_name2 fnd_new_messages.message_name%type;
975: l_msg_text2 fnd_new_messages.message_text%type;
976: l_msg_name3 fnd_new_messages.message_name%type;
969:
970: IS
971: l_proc_name varchar2(30) := 'Validate_Name_ID_Cols';
972: l_msg_name fnd_new_messages.message_name%type;
973: l_msg_text fnd_new_messages.message_text%type;
974: l_msg_name2 fnd_new_messages.message_name%type;
975: l_msg_text2 fnd_new_messages.message_text%type;
976: l_msg_name3 fnd_new_messages.message_name%type;
977: l_msg_text3 fnd_new_messages.message_text%type;
970: IS
971: l_proc_name varchar2(30) := 'Validate_Name_ID_Cols';
972: l_msg_name fnd_new_messages.message_name%type;
973: l_msg_text fnd_new_messages.message_text%type;
974: l_msg_name2 fnd_new_messages.message_name%type;
975: l_msg_text2 fnd_new_messages.message_text%type;
976: l_msg_name3 fnd_new_messages.message_name%type;
977: l_msg_text3 fnd_new_messages.message_text%type;
978: l_msg_name4 fnd_new_messages.message_name%type;
971: l_proc_name varchar2(30) := 'Validate_Name_ID_Cols';
972: l_msg_name fnd_new_messages.message_name%type;
973: l_msg_text fnd_new_messages.message_text%type;
974: l_msg_name2 fnd_new_messages.message_name%type;
975: l_msg_text2 fnd_new_messages.message_text%type;
976: l_msg_name3 fnd_new_messages.message_name%type;
977: l_msg_text3 fnd_new_messages.message_text%type;
978: l_msg_name4 fnd_new_messages.message_name%type;
979: l_msg_text4 fnd_new_messages.message_text%type;
972: l_msg_name fnd_new_messages.message_name%type;
973: l_msg_text fnd_new_messages.message_text%type;
974: l_msg_name2 fnd_new_messages.message_name%type;
975: l_msg_text2 fnd_new_messages.message_text%type;
976: l_msg_name3 fnd_new_messages.message_name%type;
977: l_msg_text3 fnd_new_messages.message_text%type;
978: l_msg_name4 fnd_new_messages.message_name%type;
979: l_msg_text4 fnd_new_messages.message_text%type;
980: l_msg_name5 fnd_new_messages.message_name%type;
973: l_msg_text fnd_new_messages.message_text%type;
974: l_msg_name2 fnd_new_messages.message_name%type;
975: l_msg_text2 fnd_new_messages.message_text%type;
976: l_msg_name3 fnd_new_messages.message_name%type;
977: l_msg_text3 fnd_new_messages.message_text%type;
978: l_msg_name4 fnd_new_messages.message_name%type;
979: l_msg_text4 fnd_new_messages.message_text%type;
980: l_msg_name5 fnd_new_messages.message_name%type;
981: l_msg_text5 fnd_new_messages.message_text%type;
974: l_msg_name2 fnd_new_messages.message_name%type;
975: l_msg_text2 fnd_new_messages.message_text%type;
976: l_msg_name3 fnd_new_messages.message_name%type;
977: l_msg_text3 fnd_new_messages.message_text%type;
978: l_msg_name4 fnd_new_messages.message_name%type;
979: l_msg_text4 fnd_new_messages.message_text%type;
980: l_msg_name5 fnd_new_messages.message_name%type;
981: l_msg_text5 fnd_new_messages.message_text%type;
982:
975: l_msg_text2 fnd_new_messages.message_text%type;
976: l_msg_name3 fnd_new_messages.message_name%type;
977: l_msg_text3 fnd_new_messages.message_text%type;
978: l_msg_name4 fnd_new_messages.message_name%type;
979: l_msg_text4 fnd_new_messages.message_text%type;
980: l_msg_name5 fnd_new_messages.message_name%type;
981: l_msg_text5 fnd_new_messages.message_text%type;
982:
983:
976: l_msg_name3 fnd_new_messages.message_name%type;
977: l_msg_text3 fnd_new_messages.message_text%type;
978: l_msg_name4 fnd_new_messages.message_name%type;
979: l_msg_text4 fnd_new_messages.message_text%type;
980: l_msg_name5 fnd_new_messages.message_name%type;
981: l_msg_text5 fnd_new_messages.message_text%type;
982:
983:
984: l_sysdate DATE := SYSDATE;
977: l_msg_text3 fnd_new_messages.message_text%type;
978: l_msg_name4 fnd_new_messages.message_name%type;
979: l_msg_text4 fnd_new_messages.message_text%type;
980: l_msg_name5 fnd_new_messages.message_name%type;
981: l_msg_text5 fnd_new_messages.message_text%type;
982:
983:
984: l_sysdate DATE := SYSDATE;
985: l_item_data_level VARCHAR2(50) := 'ITEM_LEVEL';
5425: )
5426: IS
5427:
5428: l_proc_name VARCHAR2(30) := 'Create_Draft_Version';
5429: l_msg_name fnd_new_messages.message_name%TYPE := null;
5430: l_msg_text fnd_new_messages.message_text%TYPE := null;
5431: l_obj_name VARCHAR2(30) := 'EGO_ITEM_CATALOG_CATEGORY';
5432: l_sysdate DATE;
5433: l_party_id ego_user_v.party_id%type;
5426: IS
5427:
5428: l_proc_name VARCHAR2(30) := 'Create_Draft_Version';
5429: l_msg_name fnd_new_messages.message_name%TYPE := null;
5430: l_msg_text fnd_new_messages.message_text%TYPE := null;
5431: l_obj_name VARCHAR2(30) := 'EGO_ITEM_CATALOG_CATEGORY';
5432: l_sysdate DATE;
5433: l_party_id ego_user_v.party_id%type;
5434: