DBA Data[Home] [Help]

APPS.IGW_OVERHEAD_CAL dependencies on FND_MSG_PUB

Line 82: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'GET_FISCAL_YEAR');

78: EXCEPTION
79: when others then
80: x_return_status := 'U';
81: x_msg_data := SQLCODE||' '||SQLERRM;
82: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'GET_FISCAL_YEAR');
83: END;
84:
85:
86: PROCEDURE get_rate ( p_proposal_id NUMBER

Line 184: fnd_msg_pub.add;

180: fnd_message.set_token('LOCATION_CODE', l_location);
181: fnd_message.set_token('FISCAL_YEAR', p_fiscal_year);
182: fnd_message.set_token('RATE_CLASS', l_rate_class);
183: fnd_message.set_token('RATE_TYPE', l_rate_type);
184: fnd_msg_pub.add;
185: */
186:
187: when others then
188: x_return_status := 'U';

Line 190: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'GET_RATE');

186:
187: when others then
188: x_return_status := 'U';
189: x_msg_data := SQLCODE||' '||SQLERRM;
190: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'GET_RATE');
191: END get_rate;
192:
193: ---------------------------------------------------------------------
194: FUNCTION get_applicable_rate (

Line 259: fnd_msg_pub.initialize;

255: l_return_status VARCHAR2(1);
256: l_msg_data VARCHAR2(200);
257:
258: BEGIN
259: fnd_msg_pub.initialize;
260: l_no_of_days := (p_budget_end_date - p_budget_start_date) +1 ;
261: get_date_details(p_budget_start_date
262: ,l_start_fiscal_year
263: ,l_start_f_start_date

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

338: EXCEPTION
339: when FND_API.G_EXC_ERROR then
340: x_return_status := l_return_status;
341: x_msg_data := l_msg_data;
342: fnd_msg_pub.count_and_get(p_count => x_msg_count,
343: p_data => x_msg_data);
344: when others then
345: x_return_status := 'U';
346: x_msg_data := SQLCODE||' '||SQLERRM;

Line 347: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_OH');

343: p_data => x_msg_data);
344: when others then
345: x_return_status := 'U';
346: x_msg_data := SQLCODE||' '||SQLERRM;
347: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_OH');
348: fnd_msg_pub.count_and_get(p_count => x_msg_count,
349: p_data => x_msg_data);
350: END calc_oh;
351:

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

344: when others then
345: x_return_status := 'U';
346: x_msg_data := SQLCODE||' '||SQLERRM;
347: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_OH');
348: fnd_msg_pub.count_and_get(p_count => x_msg_count,
349: p_data => x_msg_data);
350: END calc_oh;
351:
352:

Line 394: fnd_msg_pub.initialize;

390: l_return_status VARCHAR2(1);
391: l_msg_data VARCHAR2(200);
392:
393: BEGIN
394: fnd_msg_pub.initialize;
395: l_no_of_days := (p_budget_end_date - p_budget_start_date) +1 ;
396: get_date_details(p_budget_start_date
397: ,l_start_fiscal_year
398: ,l_start_f_start_date

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

510: EXCEPTION
511: when FND_API.G_EXC_ERROR then
512: x_return_status := l_return_status;
513: x_msg_data := l_msg_data;
514: fnd_msg_pub.count_and_get(p_count => x_msg_count,
515: p_data => x_msg_data);
516: when others then
517: x_return_status := 'U';
518: x_msg_data := SQLCODE||' '||SQLERRM;

Line 519: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_OH_EB');

515: p_data => x_msg_data);
516: when others then
517: x_return_status := 'U';
518: x_msg_data := SQLCODE||' '||SQLERRM;
519: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_OH_EB');
520: fnd_msg_pub.count_and_get(p_count => x_msg_count,
521: p_data => x_msg_data);
522: END calc_oh_eb;
523:

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

516: when others then
517: x_return_status := 'U';
518: x_msg_data := SQLCODE||' '||SQLERRM;
519: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_OH_EB');
520: fnd_msg_pub.count_and_get(p_count => x_msg_count,
521: p_data => x_msg_data);
522: END calc_oh_eb;
523:
524: /* Inflation is calculated based on each fiscal year. If

Line 565: fnd_msg_pub.initialize;

561: l_inflated_rate_ov NUMBER(5,2);
562: l_return_status VARCHAR2(1);
563: l_msg_data VARCHAR2(200);
564: BEGIN
565: fnd_msg_pub.initialize;
566: l_base_amount := p_base_amount;
567: l_no_of_days := (p_budget_end_date - p_budget_start_date) +1 ;
568: get_date_details(p_budget_start_date
569: ,l_start_fiscal_year

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

647: EXCEPTION
648: when FND_API.G_EXC_ERROR then
649: x_return_status := l_return_status;
650: x_msg_data := l_msg_data;
651: fnd_msg_pub.count_and_get(p_count => x_msg_count,
652: p_data => x_msg_data);
653: when others then
654: x_return_status := 'U';
655: x_msg_data := SQLCODE||' '||SQLERRM;

Line 656: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_INFLATION');

652: p_data => x_msg_data);
653: when others then
654: x_return_status := 'U';
655: x_msg_data := SQLCODE||' '||SQLERRM;
656: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_INFLATION');
657: fnd_msg_pub.count_and_get(p_count => x_msg_count,
658: p_data => x_msg_data);
659: END calc_inflation;
660:

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

653: when others then
654: x_return_status := 'U';
655: x_msg_data := SQLCODE||' '||SQLERRM;
656: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_INFLATION');
657: fnd_msg_pub.count_and_get(p_count => x_msg_count,
658: p_data => x_msg_data);
659: END calc_inflation;
660:
661:

Line 700: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_SAL_BETWEEN_MONTHS');

696: EXCEPTION
697: when others then
698: x_return_status := 'U';
699: x_msg_data := SQLCODE||' '||SQLERRM;
700: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_SAL_BETWEEN_MONTHS');
701: END calc_sal_between_months;
702:
703:
704: PROCEDURE calc_salary(p_proposal_id NUMBER

Line 762: fnd_msg_pub.initialize;

758: and ir.location_code = p_location_code
759: and (ir.start_date > p_line_start_date and ir.start_date <= p_line_end_date);
760:
761: BEGIN
762: fnd_msg_pub.initialize;
763: if p_appointment_type = '12' then
764: l_base_amount := p_base_amount;
765: elsif p_appointment_type = '11' then
766: l_base_amount := p_base_amount * 12/11;

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

1032: EXCEPTION
1033: when FND_API.G_EXC_ERROR then
1034: x_return_status := l_return_status;
1035: x_msg_data := l_msg_data;
1036: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1037: p_data => x_msg_data);
1038: when others then
1039: x_return_status := 'U';
1040: x_msg_data := SQLCODE||' '||SQLERRM;

Line 1041: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_INFLATION');

1037: p_data => x_msg_data);
1038: when others then
1039: x_return_status := 'U';
1040: x_msg_data := SQLCODE||' '||SQLERRM;
1041: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_INFLATION');
1042: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1043: p_data => x_msg_data);
1044: END calc_salary;
1045:

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

1038: when others then
1039: x_return_status := 'U';
1040: x_msg_data := SQLCODE||' '||SQLERRM;
1041: fnd_msg_pub.add_exc_msg(G_PKG_NAME, 'CALC_INFLATION');
1042: fnd_msg_pub.count_and_get(p_count => x_msg_count,
1043: p_data => x_msg_data);
1044: END calc_salary;
1045:
1046: