190: --changes for ICD number formatting issue
191: icx_numeric varchar2(20);
192:
193: begin
194: fnd_msg_pub.initialize;
195: l_object_version_number := P_OBJECT_VERSION_NUMBER;
196: l_validate := false;
197: if p_validate = 1 then
198: l_validate := true;
430: exception
431:
432: when app_exception.application_exception then
433: if(p_validate = 1) then
434: fnd_msg_pub.add;
435: /*
436: fnd_message.parse_encoded(fnd_message.get_encoded,l_app_name,l_msg_name);
437: if('HR_34927_ELE_ENTRY_VSET_INVLD'= l_msg_name) then
438: fnd_message.set_name('PER', 'HR_34927_ELE_ENTRY_VSET_INVLD');
435: /*
436: fnd_message.parse_encoded(fnd_message.get_encoded,l_app_name,l_msg_name);
437: if('HR_34927_ELE_ENTRY_VSET_INVLD'= l_msg_name) then
438: fnd_message.set_name('PER', 'HR_34927_ELE_ENTRY_VSET_INVLD');
439: fnd_msg_pub.add;
440: else
441: fnd_message.set_name(l_app_name, l_msg_name);
442: fnd_msg_pub.add;
443: end if;
438: fnd_message.set_name('PER', 'HR_34927_ELE_ENTRY_VSET_INVLD');
439: fnd_msg_pub.add;
440: else
441: fnd_message.set_name(l_app_name, l_msg_name);
442: fnd_msg_pub.add;
443: end if;
444: */
445: else
446: raise;
584: l_app_name varchar2(50);
585: l_msg_name varchar2(30);
586:
587: begin
588: fnd_msg_pub.initialize;
589: l_validate := false;
590: if p_validate = 1 then
591: l_validate := true;
592: end if;
849:
850: when app_exception.application_exception then
851: rollback to create_entry;
852: if(p_validate = 1) then
853: fnd_msg_pub.add;
854: /*
855: -- this is when we look for the multiple entries allowed exception
856: fnd_message.parse_encoded(fnd_message.get_encoded,l_app_name,l_msg_name);
857: if('HR_7455_PLK_ELE_ENTRY_EXISTS'= l_msg_name) then
855: -- this is when we look for the multiple entries allowed exception
856: fnd_message.parse_encoded(fnd_message.get_encoded,l_app_name,l_msg_name);
857: if('HR_7455_PLK_ELE_ENTRY_EXISTS'= l_msg_name) then
858: fnd_message.set_name('BEN', 'BEN_ICD_ELE_EXISTS');
859: fnd_msg_pub.add;
860: elsif('HR_34927_ELE_ENTRY_VSET_INVLD'= l_msg_name) then
861: fnd_message.set_name('PER', 'HR_34927_ELE_ENTRY_VSET_INVLD');
862: fnd_msg_pub.add;
863: else
858: fnd_message.set_name('BEN', 'BEN_ICD_ELE_EXISTS');
859: fnd_msg_pub.add;
860: elsif('HR_34927_ELE_ENTRY_VSET_INVLD'= l_msg_name) then
861: fnd_message.set_name('PER', 'HR_34927_ELE_ENTRY_VSET_INVLD');
862: fnd_msg_pub.add;
863: else
864: fnd_message.set_name(l_app_name, l_msg_name);
865: fnd_msg_pub.add;
866: end if;
861: fnd_message.set_name('PER', 'HR_34927_ELE_ENTRY_VSET_INVLD');
862: fnd_msg_pub.add;
863: else
864: fnd_message.set_name(l_app_name, l_msg_name);
865: fnd_msg_pub.add;
866: end if;
867: */
868: else
869: -- this is when its being called from the final process api after approval
894: l_app_name varchar2(50);
895: l_msg_name varchar2(30);
896:
897: begin
898: fnd_msg_pub.initialize;
899: l_object_version_number := p_object_version_number;
900: l_validate := false;
901: if p_validate = 1 then
902: l_validate := true;
916: exception
917:
918: when app_exception.application_exception then
919: if(p_validate = 1) then
920: fnd_msg_pub.add;
921: /*
922: fnd_message.parse_encoded(fnd_message.get_encoded,l_app_name,l_msg_name);
923: if('HR_33000_ENTRY_CANT_PURGE'= l_msg_name) then
924: fnd_message.set_name('PER', 'HR_33000_ENTRY_CANT_PURGE');
921: /*
922: fnd_message.parse_encoded(fnd_message.get_encoded,l_app_name,l_msg_name);
923: if('HR_33000_ENTRY_CANT_PURGE'= l_msg_name) then
924: fnd_message.set_name('PER', 'HR_33000_ENTRY_CANT_PURGE');
925: fnd_msg_pub.add;
926: else
927: fnd_message.set_name(l_app_name, l_msg_name);
928: fnd_msg_pub.add;
929: end if;
924: fnd_message.set_name('PER', 'HR_33000_ENTRY_CANT_PURGE');
925: fnd_msg_pub.add;
926: else
927: fnd_message.set_name(l_app_name, l_msg_name);
928: fnd_msg_pub.add;
929: end if;
930: */
931: else
932: raise;