DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_PUB dependencies on FND_MSG_PUB

Line 81: fnd_msg_pub.initialize;

77: end if;
78: pa_debug.init_err_stack('Create_project_party_pub');
79:
80: if FND_API.to_boolean(nvl(p_init_msg_list,FND_API.G_TRUE)) then
81: fnd_msg_pub.initialize;
82: end if;
83:
84: ------dbms_output.put_line('After initializing the stack');
85:

Line 249: fnd_msg_pub.add;

245: ;
246:
247: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
248: fnd_message.set_name('PA',l_error_message_code);
249: fnd_msg_pub.add;
250: end if;
251:
252: --dbms_output.put_line('Check5 role_id='||l_project_role_id||', resource_source_id='||l_resource_source_id);
253: -- dbms_output.put_line('Return Status '||x_return_status);

Line 286: fnd_msg_pub.count_and_get(p_count => x_msg_count,

282: else
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: end if;
285:
286: fnd_msg_pub.count_and_get(p_count => x_msg_count,
287: p_data => x_msg_data);
288: --dbms_output.put_line('Check7');
289: IF x_msg_count = 1 THEN
290: --dbms_output.put_line('Check8');

Line 307: fnd_msg_pub.add();

303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
305: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
306: fnd_message.set_token('PROCEDURE_NAME','CREATE_PROJECT_PARTY');
307: fnd_msg_pub.add();
308: fnd_msg_pub.count_and_get(p_count => x_msg_count,
309: p_data => x_msg_data);
310: raise;
311:

Line 308: fnd_msg_pub.count_and_get(p_count => x_msg_count,

304: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
305: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
306: fnd_message.set_token('PROCEDURE_NAME','CREATE_PROJECT_PARTY');
307: fnd_msg_pub.add();
308: fnd_msg_pub.count_and_get(p_count => x_msg_count,
309: p_data => x_msg_data);
310: raise;
311:
312: WHEN OTHERS THEN

Line 315: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',

311:
312: WHEN OTHERS THEN
313: rollback to create_project_party;
314: x_return_status := fnd_api.g_ret_sts_error;
315: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
316: p_procedure_name => pa_debug.G_err_stack,
317: p_error_text => SUBSTRB(SQLERRM,1,240));
318: raise;
319:

Line 394: fnd_msg_pub.initialize;

390: pa_debug.debug('Update_project_party: Initializing message stack.');
391: end if;
392:
393: if FND_API.to_boolean(nvl(p_init_msg_list,FND_API.G_TRUE)) then
394: fnd_msg_pub.initialize;
395: end if;
396:
397: ------dbms_output.put_line('After initializing the stack');
398:

Line 459: fnd_msg_pub.add;

455: ,x_error_message_code => l_error_message_code);
456:
457: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
458: fnd_message.set_name('PA',l_error_message_code);
459: fnd_msg_pub.add;
460: end if;
461:
462: if l_project_role_id <> -999 and l_resource_source_id <> -999 and x_return_status = FND_API.G_RET_STS_SUCCESS then
463: PA_PROJECT_PARTIES_PVT.UPDATE_PROJECT_PARTY( p_commit => p_commit,

Line 495: fnd_msg_pub.count_and_get(p_count => x_msg_count,

491: else
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: end if;
494:
495: fnd_msg_pub.count_and_get(p_count => x_msg_count,
496: p_data => x_msg_data);
497:
498: IF x_msg_count = 1 THEN
499: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

Line 514: fnd_msg_pub.add();

510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
512: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
513: fnd_message.set_token('PROCEDURE_NAME','UPDATE_PROJECT_PARTY');
514: fnd_msg_pub.add();
515: fnd_msg_pub.count_and_get(p_count => x_msg_count,
516: p_data => x_msg_data);
517: raise;
518:

Line 515: fnd_msg_pub.count_and_get(p_count => x_msg_count,

511: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
512: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
513: fnd_message.set_token('PROCEDURE_NAME','UPDATE_PROJECT_PARTY');
514: fnd_msg_pub.add();
515: fnd_msg_pub.count_and_get(p_count => x_msg_count,
516: p_data => x_msg_data);
517: raise;
518:
519:

Line 523: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',

519:
520: WHEN OTHERS THEN
521: rollback to update_project_party;
522: x_return_status := fnd_api.g_ret_sts_error;
523: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
524: p_procedure_name => pa_debug.g_err_stack,
525: p_error_text => SUBSTRB(SQLERRM,1,240));
526: raise;
527:

Line 587: fnd_msg_pub.initialize;

583: pa_debug.debug('Delete_project_party: Initializing message stack.');
584: end if;
585:
586: if FND_API.to_boolean(nvl(p_init_msg_list,fnd_api.G_TRUE)) then
587: fnd_msg_pub.initialize;
588: end if;
589:
590: ------dbms_output.put_line('After initializing the stack');
591:

Line 600: fnd_msg_pub.add();

596: fetch task_cnt_crsr into l_task_cnt;
597: if l_task_cnt > 0
598: then
599: FND_MESSAGE.Set_Name('PA', 'PA_PARTY_PROGR_TASK');
600: fnd_msg_pub.add();
601: fnd_msg_pub.count_and_get(p_count => x_msg_count,
602: p_data => x_msg_data);
603: x_return_status := FND_API.G_RET_STS_ERROR;
604:

Line 601: fnd_msg_pub.count_and_get(p_count => x_msg_count,

597: if l_task_cnt > 0
598: then
599: FND_MESSAGE.Set_Name('PA', 'PA_PARTY_PROGR_TASK');
600: fnd_msg_pub.add();
601: fnd_msg_pub.count_and_get(p_count => x_msg_count,
602: p_data => x_msg_data);
603: x_return_status := FND_API.G_RET_STS_ERROR;
604:
605: else

Line 641: fnd_msg_pub.count_and_get(p_count => x_msg_count,

637: x_msg_count => x_msg_count,
638: x_msg_data => x_msg_data);
639: end if;
640:
641: fnd_msg_pub.count_and_get(p_count => x_msg_count,
642: p_data => x_msg_data);
643:
644: IF x_msg_count = 1 THEN
645: pa_interface_utils_pub.get_messages ( p_encoded => FND_API.G_TRUE

Line 662: fnd_msg_pub.add();

658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
660: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
661: fnd_message.set_token('PROCEDURE_NAME','DELETE_PROJECT_PARTY');
662: fnd_msg_pub.add();
663: fnd_msg_pub.count_and_get(p_count => x_msg_count,
664: p_data => x_msg_data);
665: raise;
666:

Line 663: fnd_msg_pub.count_and_get(p_count => x_msg_count,

659: fnd_message.set_name('PA','PA_UNEXPECTED_ERROR');
660: fnd_message.set_token('PKG_NAME','PA_PROJECT_PARTIES_PUB');
661: fnd_message.set_token('PROCEDURE_NAME','DELETE_PROJECT_PARTY');
662: fnd_msg_pub.add();
663: fnd_msg_pub.count_and_get(p_count => x_msg_count,
664: p_data => x_msg_data);
665: raise;
666:
667: WHEN NO_DATA_FOUND THEN

Line 690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',

686: FND_MESSAGE.Set_token('TASK',NULL);
687: x_msg_data := FND_MESSAGE.get;
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: else
690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
691: p_procedure_name => pa_debug.g_err_stack,
692: p_error_text => SUBSTRB(SQLERRM,1,240));
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: end if;

Line 931: x_msg_count := Fnd_Msg_Pub.count_msg;

927: x_assignment_id := null;
928: x_wf_type := null;
929: x_wf_item_type := null;
930: x_wf_process := null;
931: x_msg_count := Fnd_Msg_Pub.count_msg;
932:
933:
934: IF x_msg_count = 1 AND x_msg_data IS NULL
935: THEN

Line 960: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',

956: x_wf_process := null;
957: x_msg_count := 1;
958: x_msg_data := SUBSTRB(SQLERRM,1,240);
959:
960: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJECT_PARTIES_PUB',
961: p_procedure_name => 'CREATE_PROJECT_PARTY_WRP',
962: p_error_text => x_msg_data);
963:
964: END CREATE_PROJECT_PARTY_WRP;