APPS.PA_FP_PJI_INTG_PKG dependencies on FND_API

Line 414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

753: IF NOT l_rep_act_quantity_tab.EXISTS(i)
754: THEN
755: l_rep_act_quantity_tab.EXTEND;
756: l_rep_act_quantity_tab(i) := NULL;
757: ELSIF l_rep_act_quantity_tab(i) = fnd_api.g_miss_num
758: THEN
759: l_rep_act_quantity_tab(i) := NULL;
760: END IF;
761:

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

762: IF NOT l_rep_txn_act_raw_cost_tab.EXISTS(i)
763: THEN
764: l_rep_txn_act_raw_cost_tab.EXTEND;
765: l_rep_txn_act_raw_cost_tab(i) := NULL;
766: ELSIF l_rep_txn_act_raw_cost_tab(i) = fnd_api.g_miss_num
767: THEN
768: l_rep_txn_act_raw_cost_tab(i) := NULL;
769: END IF;
770:

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

771: IF NOT l_rep_txn_act_burd_cost_tab.EXISTS(i)
772: THEN
773: l_rep_txn_act_burd_cost_tab.EXTEND;
774: l_rep_txn_act_burd_cost_tab(i) := NULL;
775: ELSIF l_rep_txn_act_burd_cost_tab(i) = fnd_api.g_miss_num
776: THEN
777: l_rep_txn_act_burd_cost_tab(i) := NULL;
778: END IF;
779:

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

780: IF NOT l_rep_txn_act_rev_tab.EXISTS(i)
781: THEN
782: l_rep_txn_act_rev_tab.EXTEND;
783: l_rep_txn_act_rev_tab(i) := NULL;
784: ELSIF l_rep_txn_act_rev_tab(i) = fnd_api.g_miss_num
785: THEN
786: l_rep_txn_act_rev_tab(i) := NULL;
787: END IF;
788:

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

789: IF NOT l_rep_prj_act_raw_cost_tab.EXISTS(i)
790: THEN
791: l_rep_prj_act_raw_cost_tab.EXTEND;
792: l_rep_prj_act_raw_cost_tab(i) := NULL;
793: ELSIF l_rep_prj_act_raw_cost_tab(i) = fnd_api.g_miss_num
794: THEN
795: l_rep_prj_act_raw_cost_tab(i) := NULL;
796: END IF;
797: IF NOT l_rep_prj_act_burd_cost_tab.EXISTS(i)

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

797: IF NOT l_rep_prj_act_burd_cost_tab.EXISTS(i)
798: THEN
799: l_rep_prj_act_burd_cost_tab.EXTEND;
800: l_rep_prj_act_burd_cost_tab(i) := NULL;
801: ELSIF l_rep_prj_act_burd_cost_tab(i) = fnd_api.g_miss_num
802: THEN
803: l_rep_prj_act_burd_cost_tab(i) := NULL;
804: END IF;
805: IF NOT l_rep_prj_act_rev_tab.EXISTS(i)

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

805: IF NOT l_rep_prj_act_rev_tab.EXISTS(i)
806: THEN
807: l_rep_prj_act_rev_tab.EXTEND;
808: l_rep_prj_act_rev_tab(i) := NULL;
809: ELSIF l_rep_prj_act_rev_tab(i) = fnd_api.g_miss_num
810: THEN
811: l_rep_prj_act_rev_tab(i) := NULL;
812: END IF;
813: IF NOT l_rep_pf_act_raw_cost_tab.EXISTS(i)

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

813: IF NOT l_rep_pf_act_raw_cost_tab.EXISTS(i)
814: THEN
815: l_rep_pf_act_raw_cost_tab.EXTEND;
816: l_rep_pf_act_raw_cost_tab(i) := NULL;
817: ELSIF l_rep_pf_act_raw_cost_tab(i) = fnd_api.g_miss_num
818: THEN
819: l_rep_pf_act_raw_cost_tab(i) := NULL;
820: END IF;
821: IF NOT l_rep_pf_act_burd_cost_tab.EXISTS(i)

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

821: IF NOT l_rep_pf_act_burd_cost_tab.EXISTS(i)
822: THEN
823: l_rep_pf_act_burd_cost_tab.EXTEND;
824: l_rep_pf_act_burd_cost_tab(i) := NULL;
825: ELSIF l_rep_pf_act_burd_cost_tab(i) = fnd_api.g_miss_num
826: THEN
827: l_rep_pf_act_burd_cost_tab(i) := NULL;
828: END IF;
829: IF NOT l_rep_pf_act_rev_tab.EXISTS(i)

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

829: IF NOT l_rep_pf_act_rev_tab.EXISTS(i)
830: THEN
831: l_rep_pf_act_rev_tab.EXTEND;
832: l_rep_pf_act_rev_tab(i) := NULL;
833: ELSIF l_rep_pf_act_rev_tab(i) = fnd_api.g_miss_num
834: THEN
835: l_rep_pf_act_rev_tab(i) := NULL;
836: END IF;
837:

Line 1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1241: End If;
1242: -- Bug 4621171: Removed RAISE statement.
1243:
1244: WHEN OTHERS THEN
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: x_msg_data := SQLCODE||SQLERRM;
1247: x_msg_count := 1;
1248: fnd_msg_pub.add_exc_msg
1249: ( p_pkg_name => 'PA_FP_PJI_INTG_PKG'