DBA Data[Home] [Help]

APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on FND_MSG_PUB

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

453: l_error_log := substr(l_error_log,1,3800);
454: end if;
455:
456: if(api_return_status = 'E') then
457: for i in 1 .. fnd_msg_pub.count_msg Loop
458: l_error_log := l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
459: end loop;
460:
461: log_message := log_message || l_error_log;

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

454: end if;
455:
456: if(api_return_status = 'E') then
457: for i in 1 .. fnd_msg_pub.count_msg Loop
458: l_error_log := l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
459: end loop;
460:
461: log_message := log_message || l_error_log;
462:

Line 476: fnd_msg_pub.Delete_Msg;

472: ,p_return_status => api_return_status
473: );
474: end if;
475:
476: fnd_msg_pub.Delete_Msg;
477:
478: -- to be changed once the error_log column is added
479: --update per_personal_scorecards
480: --set error_log = l_error_log

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

511: resultout :='COMPLETE:FAIL';
512: elsif ( api_return_status = 'S' or api_return_status = 'W') then
513:
514: if( api_return_status = 'W' ) then
515: for i in 1 .. fnd_msg_pub.count_msg Loop
516: log_message := log_message || l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
517: end loop;
518:
519: fnd_msg_pub.Delete_Msg;

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

512: elsif ( api_return_status = 'S' or api_return_status = 'W') then
513:
514: if( api_return_status = 'W' ) then
515: for i in 1 .. fnd_msg_pub.count_msg Loop
516: log_message := log_message || l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
517: end loop;
518:
519: fnd_msg_pub.Delete_Msg;
520:

Line 519: fnd_msg_pub.Delete_Msg;

515: for i in 1 .. fnd_msg_pub.count_msg Loop
516: log_message := log_message || l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
517: end loop;
518:
519: fnd_msg_pub.Delete_Msg;
520:
521: --update per_personal_scorecards
522: --set error_log = l_error_log
523: --where scorecard_id = next_score_card;

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

543: hr_transaction_swi.delete_transaction(score_card_txn_id,hr_Api.g_false_num);
544:
545: exception when others then
546:
547: for i in 1 .. fnd_msg_pub.count_msg Loop
548: l_error_log := l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
549: end loop;
550:
551: temp := wf_engine.getitemattrtext(itemtype,itemkey,'SC_ERROR', true);

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

544:
545: exception when others then
546:
547: for i in 1 .. fnd_msg_pub.count_msg Loop
548: l_error_log := l_error_log || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
549: end loop;
550:
551: temp := wf_engine.getitemattrtext(itemtype,itemkey,'SC_ERROR', true);
552: wf_engine.setitemattrtext(itemtype,itemkey,'SC_ERROR', temp || l_error_log);