DBA Data[Home] [Help]

APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on FND_MSG_PUB

Line 851: for i in 1 .. fnd_msg_pub.count_msg Loop

847: l_error_log := substr(l_error_log,1,3800);
848: end if;
849:
850: if(api_return_status = 'E') then
851: for i in 1 .. fnd_msg_pub.count_msg Loop
852: l_error_log := l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
853: end loop;
854:
855: log_message := log_message || l_error_log;

Line 852: l_error_log := l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');

848: end if;
849:
850: if(api_return_status = 'E') then
851: for i in 1 .. fnd_msg_pub.count_msg Loop
852: l_error_log := l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
853: end loop;
854:
855: log_message := log_message || l_error_log;
856:

Line 870: fnd_msg_pub.Delete_Msg;

866: ,p_return_status => api_return_status
867: );
868: end if;
869:
870: fnd_msg_pub.Delete_Msg;
871:
872: -- to be changed once the error_log column is added
873: --update per_personal_scorecards
874: --set error_log = l_error_log

Line 909: for i in 1 .. fnd_msg_pub.count_msg Loop

905: resultout :='COMPLETE:FAIL';
906: elsif ( api_return_status = 'S' or api_return_status = 'W') then
907:
908: if( api_return_status = 'W' ) then
909: for i in 1 .. fnd_msg_pub.count_msg Loop
910: log_message := log_message || l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
911: end loop;
912:
913: fnd_msg_pub.Delete_Msg;

Line 910: log_message := log_message || l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');

906: elsif ( api_return_status = 'S' or api_return_status = 'W') then
907:
908: if( api_return_status = 'W' ) then
909: for i in 1 .. fnd_msg_pub.count_msg Loop
910: log_message := log_message || l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
911: end loop;
912:
913: fnd_msg_pub.Delete_Msg;
914:

Line 913: fnd_msg_pub.Delete_Msg;

909: for i in 1 .. fnd_msg_pub.count_msg Loop
910: log_message := log_message || l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
911: end loop;
912:
913: fnd_msg_pub.Delete_Msg;
914:
915: --update per_personal_scorecards
916: --set error_log = l_error_log
917: --where scorecard_id = next_score_card;

Line 950: for i in 1 .. fnd_msg_pub.count_msg Loop

946: hr_transaction_swi.delete_transaction(score_card_txn_id,hr_Api.g_false_num);
947:
948: exception when others then
949:
950: for i in 1 .. fnd_msg_pub.count_msg Loop
951: l_error_log := l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
952: end loop;
953:
954: temp := wf_engine.getitemattrtext(itemtype,itemkey,'SC_ERROR', true);

Line 951: l_error_log := l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');

947:
948: exception when others then
949:
950: for i in 1 .. fnd_msg_pub.count_msg Loop
951: l_error_log := l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
952: end loop;
953:
954: temp := wf_engine.getitemattrtext(itemtype,itemkey,'SC_ERROR', true);
955: wf_engine.setitemattrtext(itemtype,itemkey,'SC_ERROR', temp || l_error_log);