DBA Data[Home] [Help]

APPS.IGW_REPORT_PROCESSING dependencies on FND_API

Line 75: raise FND_API.G_EXC_ERROR;

71: when no_data_found then
72: fnd_message.set_name('IGW', 'IGW_NO_FINAL_BUDGET_VERSION');
73: fnd_msg_pub.add;
74: RETURN NULL;
75: raise FND_API.G_EXC_ERROR;
76: when others then
77: RETURN NULL;
78: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'GET_FINAL_VERSION');
79: End get_final_version;

Line 151: raise FND_API.G_EXC_ERROR;

147: BEGIN
148: fnd_msg_pub.initialize;
149: l_version_id := get_final_version(p_proposal_id);
150: if l_version_id is null then
151: raise FND_API.G_EXC_ERROR;
152: end if;
153:
154: --deleting previously precessed data
155: delete from igw_report_budg_justification

Line 253: when FND_API.G_EXC_ERROR then

249: ,fnd_global.login_id);
250: */
251: x_return_status := 'S';
252: EXCEPTION
253: when FND_API.G_EXC_ERROR then
254: x_return_status := 'E';
255: --x_msg_data := l_msg_data;
256: --x_msg_data := fnd_msg_pub.get(p_msg_index=>1, p_encoded=>'TRUE');
257: --dbms_output.put_line('x_msg_data right after EXCEPTION is '||x_msg_data);

Line 321: when FND_API.G_EXC_ERROR then

317:
318: x_return_status := 'S';
319:
320: EXCEPTION
321: when FND_API.G_EXC_ERROR then
322: x_return_status := 'E';
323: --dbms_output.put_line('x_msg_data right after EXCEPTION is '||x_msg_data);
324: --fnd_msg_pub.count_and_get(p_count => x_msg_count,
325: --p_data => x_msg_data);

Line 442: raise FND_API.G_EXC_ERROR;

438: ,l_fiscal_end_date
439: ,l_return_status
440: ,l_msg_data);
441: if l_return_status <> 'S' then
442: raise FND_API.G_EXC_ERROR;
443: end if;
444: if l_fiscal_end_date < rec_no_of_periods.end_date then
445: l_fiscal_year := null;
446: end if;

Line 517: when FND_API.G_EXC_ERROR then

513: end;
514:
515: x_return_status := 'S';
516: EXCEPTION
517: when FND_API.G_EXC_ERROR then
518: x_return_status := l_return_status;
519: x_msg_data := l_msg_data;
520: fnd_msg_pub.count_and_get(p_count => x_msg_count,
521: p_data => x_msg_data);

Line 596: raise FND_API.G_EXC_ERROR;

592: BEGIN
593: fnd_msg_pub.initialize;
594: l_version_id := get_final_version(p_proposal_id);
595: if l_version_id is null then
596: raise FND_API.G_EXC_ERROR;
597: end if;
598:
599: G_START_PERIOD := 1;
600: G_PROPOSAL_ID := p_proposal_id;

Line 891: when FND_API.G_EXC_ERROR then

887: */
888:
889: x_return_status := 'S';
890: EXCEPTION
891: when FND_API.G_EXC_ERROR then
892: x_return_status := l_return_status;
893: x_msg_data := l_msg_data;
894: fnd_msg_pub.count_and_get(p_count => x_msg_count,
895: p_data => x_msg_data);

Line 947: raise FND_API.G_EXC_ERROR;

943: BEGIN
944: fnd_msg_pub.initialize;
945: l_version_id := get_final_version(p_proposal_id);
946: if l_version_id is null then
947: raise FND_API.G_EXC_ERROR;
948: end if;
949:
950: G_START_PERIOD := 1;
951: G_PROPOSAL_ID := p_proposal_id;

Line 997: when FND_API.G_EXC_ERROR then

993: --end if;
994: END LOOP; --rec_budget_category_code
995:
996: EXCEPTION
997: when FND_API.G_EXC_ERROR then
998: x_return_status := l_return_status;
999: x_msg_data := l_msg_data;
1000: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1001: p_data => x_msg_data);