APPS.PA_FP_PJI_INTG_PKG dependencies on FND_API

Line 411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

407: End If;
408: RAISE;
409:
410: WHEN OTHERS THEN
411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
412: x_msg_data := SQLCODE||SQLERRM;
413: x_msg_count := 1;
414: fnd_msg_pub.add_exc_msg
415: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'

Line 524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

520: x_msg_count := 1;
521: x_msg_data := 'Invalid params passed to update_reporting_lines_frombl';
522: print_msg(l_stage||x_msg_data,'Y');
523: WHEN OTHERS THEN
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: x_msg_data := SQLCODE||SQLERRM;
526: x_msg_count := 1;
527: fnd_msg_pub.add_exc_msg
528: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'

Line 752: ELSIF l_rep_act_quantity_tab(i) = fnd_api.g_miss_num

748: IF NOT l_rep_act_quantity_tab.EXISTS(i)
749: THEN
750: l_rep_act_quantity_tab.EXTEND;
751: l_rep_act_quantity_tab(i) := NULL;
752: ELSIF l_rep_act_quantity_tab(i) = fnd_api.g_miss_num
753: THEN
754: l_rep_act_quantity_tab(i) := NULL;
755: END IF;
756:

Line 761: ELSIF l_rep_txn_act_raw_cost_tab(i) = fnd_api.g_miss_num

757: IF NOT l_rep_txn_act_raw_cost_tab.EXISTS(i)
758: THEN
759: l_rep_txn_act_raw_cost_tab.EXTEND;
760: l_rep_txn_act_raw_cost_tab(i) := NULL;
761: ELSIF l_rep_txn_act_raw_cost_tab(i) = fnd_api.g_miss_num
762: THEN
763: l_rep_txn_act_raw_cost_tab(i) := NULL;
764: END IF;
765:

Line 770: ELSIF l_rep_txn_act_burd_cost_tab(i) = fnd_api.g_miss_num

766: IF NOT l_rep_txn_act_burd_cost_tab.EXISTS(i)
767: THEN
768: l_rep_txn_act_burd_cost_tab.EXTEND;
769: l_rep_txn_act_burd_cost_tab(i) := NULL;
770: ELSIF l_rep_txn_act_burd_cost_tab(i) = fnd_api.g_miss_num
771: THEN
772: l_rep_txn_act_burd_cost_tab(i) := NULL;
773: END IF;
774:

Line 779: ELSIF l_rep_txn_act_rev_tab(i) = fnd_api.g_miss_num

775: IF NOT l_rep_txn_act_rev_tab.EXISTS(i)
776: THEN
777: l_rep_txn_act_rev_tab.EXTEND;
778: l_rep_txn_act_rev_tab(i) := NULL;
779: ELSIF l_rep_txn_act_rev_tab(i) = fnd_api.g_miss_num
780: THEN
781: l_rep_txn_act_rev_tab(i) := NULL;
782: END IF;
783:

Line 788: ELSIF l_rep_prj_act_raw_cost_tab(i) = fnd_api.g_miss_num

784: IF NOT l_rep_prj_act_raw_cost_tab.EXISTS(i)
785: THEN
786: l_rep_prj_act_raw_cost_tab.EXTEND;
787: l_rep_prj_act_raw_cost_tab(i) := NULL;
788: ELSIF l_rep_prj_act_raw_cost_tab(i) = fnd_api.g_miss_num
789: THEN
790: l_rep_prj_act_raw_cost_tab(i) := NULL;
791: END IF;
792: IF NOT l_rep_prj_act_burd_cost_tab.EXISTS(i)

Line 796: ELSIF l_rep_prj_act_burd_cost_tab(i) = fnd_api.g_miss_num

792: IF NOT l_rep_prj_act_burd_cost_tab.EXISTS(i)
793: THEN
794: l_rep_prj_act_burd_cost_tab.EXTEND;
795: l_rep_prj_act_burd_cost_tab(i) := NULL;
796: ELSIF l_rep_prj_act_burd_cost_tab(i) = fnd_api.g_miss_num
797: THEN
798: l_rep_prj_act_burd_cost_tab(i) := NULL;
799: END IF;
800: IF NOT l_rep_prj_act_rev_tab.EXISTS(i)

Line 804: ELSIF l_rep_prj_act_rev_tab(i) = fnd_api.g_miss_num

800: IF NOT l_rep_prj_act_rev_tab.EXISTS(i)
801: THEN
802: l_rep_prj_act_rev_tab.EXTEND;
803: l_rep_prj_act_rev_tab(i) := NULL;
804: ELSIF l_rep_prj_act_rev_tab(i) = fnd_api.g_miss_num
805: THEN
806: l_rep_prj_act_rev_tab(i) := NULL;
807: END IF;
808: IF NOT l_rep_pf_act_raw_cost_tab.EXISTS(i)

Line 812: ELSIF l_rep_pf_act_raw_cost_tab(i) = fnd_api.g_miss_num

808: IF NOT l_rep_pf_act_raw_cost_tab.EXISTS(i)
809: THEN
810: l_rep_pf_act_raw_cost_tab.EXTEND;
811: l_rep_pf_act_raw_cost_tab(i) := NULL;
812: ELSIF l_rep_pf_act_raw_cost_tab(i) = fnd_api.g_miss_num
813: THEN
814: l_rep_pf_act_raw_cost_tab(i) := NULL;
815: END IF;
816: IF NOT l_rep_pf_act_burd_cost_tab.EXISTS(i)

Line 820: ELSIF l_rep_pf_act_burd_cost_tab(i) = fnd_api.g_miss_num

816: IF NOT l_rep_pf_act_burd_cost_tab.EXISTS(i)
817: THEN
818: l_rep_pf_act_burd_cost_tab.EXTEND;
819: l_rep_pf_act_burd_cost_tab(i) := NULL;
820: ELSIF l_rep_pf_act_burd_cost_tab(i) = fnd_api.g_miss_num
821: THEN
822: l_rep_pf_act_burd_cost_tab(i) := NULL;
823: END IF;
824: IF NOT l_rep_pf_act_rev_tab.EXISTS(i)

Line 828: ELSIF l_rep_pf_act_rev_tab(i) = fnd_api.g_miss_num

824: IF NOT l_rep_pf_act_rev_tab.EXISTS(i)
825: THEN
826: l_rep_pf_act_rev_tab.EXTEND;
827: l_rep_pf_act_rev_tab(i) := NULL;
828: ELSIF l_rep_pf_act_rev_tab(i) = fnd_api.g_miss_num
829: THEN
830: l_rep_pf_act_rev_tab(i) := NULL;
831: END IF;
832:

Line 1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1229: End If;
1230: -- Bug 4621171: Removed RAISE statement.
1231:
1232: WHEN OTHERS THEN
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: x_msg_data := SQLCODE||SQLERRM;
1235: x_msg_count := 1;
1236: fnd_msg_pub.add_exc_msg
1237: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'