APPS.PA_PWP_NOTIFICATION dependencies on FND_API

Line 418: WHEN FND_API.G_EXC_ERROR THEN

414:
415: log_message('START_AR_NOTIFY_WF: Normal Exit', 3);
416:
417: EXCEPTION
418: WHEN FND_API.G_EXC_ERROR THEN
419: WF_CORE.CONTEXT('PA_PWP_NOTIFICATION ','START_AR_NOTIFY_WF');
420: RAISE;
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: x_err_code := SQLCODE;

Line 421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

417: EXCEPTION
418: WHEN FND_API.G_EXC_ERROR THEN
419: WF_CORE.CONTEXT('PA_PWP_NOTIFICATION ','START_AR_NOTIFY_WF');
420: RAISE;
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422: x_err_code := SQLCODE;
423: WF_CORE.CONTEXT('PA_PWP_NOTIFICATION ','START_AR_NOTIFY_WF');
424: RAISE;
425: WHEN OTHERS THEN

Line 557: PA_PAGE_CONTENTS_PUB.CREATE_PAGE_CONTENTS(p_init_msg_list => fnd_api.g_false

553:
554: x_content_id := 0;
555:
556: log_message('Generate_PWP_Notify_Page: Before Calling CREATE_PAGE_CONTENTS: p_inv_info_rec.ra_id=' || p_inv_info_rec.ra_id || '*', 3);
557: PA_PAGE_CONTENTS_PUB.CREATE_PAGE_CONTENTS(p_init_msg_list => fnd_api.g_false
558: ,p_validate_only => fnd_api.g_false
559: ,p_object_type => 'PA_PWP_AR_NOTIFY'
560: ,p_pk1_value => p_inv_info_rec.ra_id
561: ,p_pk2_value => NULL

Line 558: ,p_validate_only => fnd_api.g_false

554: x_content_id := 0;
555:
556: log_message('Generate_PWP_Notify_Page: Before Calling CREATE_PAGE_CONTENTS: p_inv_info_rec.ra_id=' || p_inv_info_rec.ra_id || '*', 3);
557: PA_PAGE_CONTENTS_PUB.CREATE_PAGE_CONTENTS(p_init_msg_list => fnd_api.g_false
558: ,p_validate_only => fnd_api.g_false
559: ,p_object_type => 'PA_PWP_AR_NOTIFY'
560: ,p_pk1_value => p_inv_info_rec.ra_id
561: ,p_pk2_value => NULL
562: ,x_page_content_id => l_page_content_id

Line 1074: WHEN FND_API.G_EXC_ERROR THEN

1070: resultout := wf_engine.eng_completed||':'||'F';
1071: END IF;
1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: WF_CORE.CONTEXT('PA_PWP_NOTIFICATION','SELECT_PROJECT_MANAGER',itemtype, itemkey, to_char(actid), funcmode);
1076: RAISE;
1077:
1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1074: WHEN FND_API.G_EXC_ERROR THEN
1075: WF_CORE.CONTEXT('PA_PWP_NOTIFICATION','SELECT_PROJECT_MANAGER',itemtype, itemkey, to_char(actid), funcmode);
1076: RAISE;
1077:
1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1079: WF_CORE.CONTEXT('PA_PWP_NOTIFICATION','SELECT_PROJECT_MANAGER',itemtype, itemkey, to_char(actid), funcmode);
1080: RAISE;
1081:
1082: WHEN OTHERS THEN

Line 1149: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1145: ,x_return_status => l_return_status
1146: ,x_msg_count => l_msg_count
1147: ,x_msg_data => l_msg_data);
1148:
1149: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1150: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
1151: dbms_lob.writeappend(document, 255, SUBSTR(SQLERRM, 255));
1152: END IF;
1153: ELSE