DBA Data[Home] [Help]

APPS.IGW_BUDGET_OPERATIONS dependencies on FND_MSG_PUB

Line 144: fnd_msg_pub.initialize;

140: l_msg_data VARCHAR2(200);
141: l_msg_count NUMBER(10);
142:
143: BEGIN
144: fnd_msg_pub.initialize;
145: for rec_budget_periods in c_budget_periods
146: LOOP
147: l_budget_period_id := rec_budget_periods.budget_period_id;
148: for rec_budget_details in c_budget_details

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

597: EXCEPTION
598: when FND_API.G_EXC_ERROR then
599: x_return_status := l_return_status;
600: x_msg_data := l_msg_data;
601: fnd_msg_pub.count_and_get(p_count => x_msg_count,
602: p_data => x_msg_data);
603:
604: when others then
605: x_return_status := 'U';

Line 607: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'RECALCULATE_BUDGET');

603:
604: when others then
605: x_return_status := 'U';
606: x_msg_data := SQLCODE||' '||SQLERRM;
607: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'RECALCULATE_BUDGET');
608: fnd_msg_pub.count_and_get(p_count => x_msg_count,
609: p_data => x_msg_data);
610: end recalculate_budget;
611: */

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

604: when others then
605: x_return_status := 'U';
606: x_msg_data := SQLCODE||' '||SQLERRM;
607: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'RECALCULATE_BUDGET');
608: fnd_msg_pub.count_and_get(p_count => x_msg_count,
609: p_data => x_msg_data);
610: end recalculate_budget;
611: */
612: -----------------------------------------------------------------------------------------------

Line 733: fnd_msg_pub.initialize;

729:
730:
731:
732: BEGIN
733: fnd_msg_pub.initialize;
734:
735: if p_copy_type = 'B' then
736: select max(version_id)+1
737: into l_target_version_id

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

1148: EXCEPTION
1149: when FND_API.G_EXC_ERROR then
1150: x_return_status := l_return_status;
1151: x_msg_data := l_msg_data;
1152: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1153: p_data => x_msg_data);
1154:
1155: when others then
1156: x_return_status := 'U';

Line 1159: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'COPY_BUDGET');

1155: when others then
1156: x_return_status := 'U';
1157: x_msg_data := SQLCODE||' '||SQLERRM;
1158: --dbms_output.put_line(x_msg_data);
1159: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'COPY_BUDGET');
1160: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1161: p_data => x_msg_data);
1162: END copy_budget;
1163: -----------------------------------------------------------------------------------------

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

1156: x_return_status := 'U';
1157: x_msg_data := SQLCODE||' '||SQLERRM;
1158: --dbms_output.put_line(x_msg_data);
1159: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'COPY_BUDGET');
1160: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1161: p_data => x_msg_data);
1162: END copy_budget;
1163: -----------------------------------------------------------------------------------------
1164: Function get_proposal_id RETURN NUMBER is

Line 1330: fnd_msg_pub.initialize;

1326: l_msg_data VARCHAR2(200);
1327: l_msg_count NUMBER(10);
1328:
1329: BEGIN
1330: fnd_msg_pub.initialize;
1331: x_return_status := 'S';
1332:
1333: /* getting needed values if not provided */
1334: if (p_version_id is not null and p_proposal_id is not null) then

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

1886: EXCEPTION
1887: when FND_API.G_EXC_ERROR then
1888: x_return_status := l_return_status;
1889: x_msg_data := l_msg_data;
1890: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1891: p_data => x_msg_data);
1892:
1893: when others then
1894: x_return_status := 'U';

Line 1896: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'RECALCULATE_BUDGET');

1892:
1893: when others then
1894: x_return_status := 'U';
1895: x_msg_data := SQLCODE||' '||SQLERRM;
1896: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'RECALCULATE_BUDGET');
1897: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1898: p_data => x_msg_data);
1899: end recalculate_budget;
1900:

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

1893: when others then
1894: x_return_status := 'U';
1895: x_msg_data := SQLCODE||' '||SQLERRM;
1896: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'RECALCULATE_BUDGET');
1897: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1898: p_data => x_msg_data);
1899: end recalculate_budget;
1900:
1901: