DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_ASSET_PVT dependencies on FND_MSG_PUB

Line 504: FND_MSG_PUB.initialize;

500: SAVEPOINT l_program_name;
501: END IF;
502:
503: IF p_init_msg_list = G_TRUE THEN
504: FND_MSG_PUB.initialize;
505: END IF;
506:
507: l_asset_adj_tbl := p_asset_adj_tbl;
508:

Line 2113: FND_MSG_PUB.initialize;

2109: SAVEPOINT l_program_name;
2110: END IF;
2111:
2112: IF p_init_msg_list = G_TRUE THEN
2113: FND_MSG_PUB.initialize;
2114: END IF;
2115:
2116: l_asset_adj_tbl := p_asset_adj_tbl;
2117:

Line 2326: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2322: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2323:
2324: IF p_transaction_control = G_TRUE THEN
2325: ROLLBACK TO l_program_name;
2326: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2327: END IF;
2328:
2329: x_return_status := G_RET_STS_ERROR;
2330:

Line 2335: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2331: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2332:
2333: IF p_transaction_control = G_TRUE THEN
2334: ROLLBACK TO l_program_name;
2335: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2336: END IF;
2337:
2338: x_return_status := G_RET_STS_UNEXP_ERROR;
2339:

Line 2353: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2349: p_token3_value => sqlerrm);
2350:
2351: IF p_transaction_control = G_TRUE THEN
2352: ROLLBACK TO l_program_name;
2353: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2354: END IF;
2355:
2356: x_return_status := G_RET_STS_UNEXP_ERROR;
2357: END;

Line 2393: FND_MSG_PUB.initialize;

2389: SAVEPOINT l_program_name;
2390: END IF;
2391:
2392: IF p_init_msg_list = G_TRUE THEN
2393: FND_MSG_PUB.initialize;
2394: END IF;
2395:
2396: l_asset_adj_tbl := p_asset_adj_tbl;
2397:

Line 2677: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2673: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2674:
2675: IF p_transaction_control = G_TRUE THEN
2676: ROLLBACK TO l_program_name;
2677: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2678: END IF;
2679:
2680: x_return_status := G_RET_STS_ERROR;
2681:

Line 2686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2682: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2683:
2684: IF p_transaction_control = G_TRUE THEN
2685: ROLLBACK TO l_program_name;
2686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2687: END IF;
2688:
2689: x_return_status := G_RET_STS_UNEXP_ERROR;
2690:

Line 2704: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2700: p_token3_value => sqlerrm);
2701:
2702: IF p_transaction_control = G_TRUE THEN
2703: ROLLBACK TO l_program_name;
2704: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2705: END IF;
2706:
2707: x_return_status := G_RET_STS_UNEXP_ERROR;
2708: END;

Line 2753: FND_MSG_PUB.initialize;

2749: SAVEPOINT l_program_name;
2750: END IF;
2751:
2752: IF p_init_msg_list = G_TRUE THEN
2753: FND_MSG_PUB.initialize;
2754: END IF;
2755: --Bug # 5142940 ssdeshpa start
2756: --Fix Bug # 4894844 Start
2757: IF p_adjustment_type = 'SUBSIDY' THEN

Line 2844: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2840: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2841:
2842: IF p_transaction_control = G_TRUE THEN
2843: ROLLBACK TO l_program_name;
2844: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2845: END IF;
2846:
2847: x_return_status := G_RET_STS_ERROR;
2848:

Line 2853: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2849: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2850:
2851: IF p_transaction_control = G_TRUE THEN
2852: ROLLBACK TO l_program_name;
2853: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2854: END IF;
2855:
2856: x_return_status := G_RET_STS_UNEXP_ERROR;
2857:

Line 2871: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2867: p_token3_value => sqlerrm);
2868:
2869: IF p_transaction_control = G_TRUE THEN
2870: ROLLBACK TO l_program_name;
2871: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2872: END IF;
2873:
2874: x_return_status := G_RET_STS_UNEXP_ERROR;
2875: END;

Line 2937: FND_MSG_PUB.initialize;

2933: SAVEPOINT l_program_name;
2934: END IF;
2935:
2936: IF p_init_msg_list = G_TRUE THEN
2937: FND_MSG_PUB.initialize;
2938: END IF;
2939:
2940: FOR l_get_cashflow_object_info IN c_get_cashflow_object_info(p_src_id => p_source_id) LOOP
2941: l_cashflow_object_id := l_get_cashflow_object_info.id;

Line 3009: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3005: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3006:
3007: IF p_transaction_control = G_TRUE THEN
3008: ROLLBACK TO l_program_name;
3009: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3010: END IF;
3011:
3012: x_return_status := G_RET_STS_ERROR;
3013:

Line 3018: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3014: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3015:
3016: IF p_transaction_control = G_TRUE THEN
3017: ROLLBACK TO l_program_name;
3018: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3019: END IF;
3020:
3021: x_return_status := G_RET_STS_UNEXP_ERROR;
3022:

Line 3036: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3032: p_token3_value => sqlerrm);
3033:
3034: IF p_transaction_control = G_TRUE THEN
3035: ROLLBACK TO l_program_name;
3036: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3037: END IF;
3038:
3039: x_return_status := G_RET_STS_UNEXP_ERROR;
3040: END duplicate_asset_cashflows;

Line 3360: FND_MSG_PUB.initialize;

3356: SAVEPOINT l_program_name;
3357: END IF;
3358:
3359: IF p_init_msg_list = G_TRUE THEN
3360: FND_MSG_PUB.initialize;
3361: END IF;
3362:
3363: -- Validation to check if the product and expected start date for source
3364: -- and target contracts are equal, if not cash flows are not copied.

Line 3549: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3545: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3546:
3547: IF p_transaction_control = G_TRUE THEN
3548: ROLLBACK TO l_program_name;
3549: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3550: END IF;
3551:
3552: x_return_status := G_RET_STS_ERROR;
3553:

Line 3558: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3554: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3555:
3556: IF p_transaction_control = G_TRUE THEN
3557: ROLLBACK TO l_program_name;
3558: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3559: END IF;
3560:
3561: x_return_status := G_RET_STS_UNEXP_ERROR;
3562:

Line 3576: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3572: p_token3_value => sqlerrm);
3573:
3574: IF p_transaction_control = G_TRUE THEN
3575: ROLLBACK TO l_program_name;
3576: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3577: END IF;
3578:
3579: x_return_status := G_RET_STS_UNEXP_ERROR;
3580:

Line 3621: FND_MSG_PUB.initialize;

3617: SAVEPOINT l_program_name;
3618: END IF;
3619:
3620: IF p_init_msg_list = G_TRUE THEN
3621: FND_MSG_PUB.initialize;
3622: END IF;
3623:
3624: l_asset_rec := p_asset_rec;
3625: l_asset_comp_tbl := p_component_tbl;

Line 3775: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3771: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3772:
3773: IF p_transaction_control = G_TRUE THEN
3774: ROLLBACK TO l_program_name;
3775: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3776: END IF;
3777:
3778: x_return_status := G_RET_STS_ERROR;
3779:

Line 3784: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3780: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3781:
3782: IF p_transaction_control = G_TRUE THEN
3783: ROLLBACK TO l_program_name;
3784: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3785: END IF;
3786:
3787: x_return_status := G_RET_STS_UNEXP_ERROR;
3788:

Line 3802: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3798: p_token3_value => sqlerrm);
3799:
3800: IF p_transaction_control = G_TRUE THEN
3801: ROLLBACK TO l_program_name;
3802: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3803: END IF;
3804:
3805: x_return_status := G_RET_STS_UNEXP_ERROR;
3806:

Line 3848: FND_MSG_PUB.initialize;

3844: SAVEPOINT l_program_name;
3845: END IF;
3846:
3847: IF p_init_msg_list = G_TRUE THEN
3848: FND_MSG_PUB.initialize;
3849: END IF;
3850:
3851: l_asset_rec := p_asset_rec;
3852: l_asset_comp_tbl := p_component_tbl;

Line 3989: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3985: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3986:
3987: IF p_transaction_control = G_TRUE THEN
3988: ROLLBACK TO l_program_name;
3989: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3990: END IF;
3991:
3992: x_return_status := G_RET_STS_ERROR;
3993:

Line 3998: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3994: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3995:
3996: IF p_transaction_control = G_TRUE THEN
3997: ROLLBACK TO l_program_name;
3998: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3999: END IF;
4000:
4001: x_return_status := G_RET_STS_UNEXP_ERROR;
4002:

Line 4016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4012: p_token3_value => sqlerrm);
4013:
4014: IF p_transaction_control = G_TRUE THEN
4015: ROLLBACK TO l_program_name;
4016: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4017: END IF;
4018:
4019: x_return_status := G_RET_STS_UNEXP_ERROR;
4020:

Line 4069: FND_MSG_PUB.initialize;

4065: SAVEPOINT l_program_name;
4066: END IF;
4067:
4068: IF p_init_msg_list = G_TRUE THEN
4069: FND_MSG_PUB.initialize;
4070: END IF;
4071:
4072: l_asset_id := p_asset_id;
4073:

Line 4161: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4157: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4158:
4159: IF p_transaction_control = G_TRUE THEN
4160: ROLLBACK TO l_program_name;
4161: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4162: END IF;
4163:
4164: x_return_status := G_RET_STS_ERROR;
4165:

Line 4170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4166: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4167:
4168: IF p_transaction_control = G_TRUE THEN
4169: ROLLBACK TO l_program_name;
4170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4171: END IF;
4172:
4173: x_return_status := G_RET_STS_UNEXP_ERROR;
4174:

Line 4188: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4184: p_token3_value => sqlerrm);
4185:
4186: IF p_transaction_control = G_TRUE THEN
4187: ROLLBACK TO l_program_name;
4188: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4189: END IF;
4190:
4191: x_return_status := G_RET_STS_UNEXP_ERROR;
4192:

Line 4247: FND_MSG_PUB.initialize;

4243: SAVEPOINT l_program_name;
4244: END IF;
4245:
4246: IF p_init_msg_list = G_TRUE THEN
4247: FND_MSG_PUB.initialize;
4248: END IF;
4249:
4250: -- Check if the asset is modified through process other than asset ui
4251: IF (p_asset_rec.parent_object_code IS NULL OR

Line 4543: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4539: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4540:
4541: IF p_transaction_control = G_TRUE THEN
4542: ROLLBACK TO l_program_name;
4543: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4544: END IF;
4545:
4546: x_return_status := G_RET_STS_ERROR;
4547:

Line 4552: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4548: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4549:
4550: IF p_transaction_control = G_TRUE THEN
4551: ROLLBACK TO l_program_name;
4552: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4553: END IF;
4554:
4555: x_return_status := G_RET_STS_UNEXP_ERROR;
4556:

Line 4570: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4566: p_token3_value => sqlerrm);
4567:
4568: IF p_transaction_control = G_TRUE THEN
4569: ROLLBACK TO l_program_name;
4570: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4571: END IF;
4572:
4573: x_return_status := G_RET_STS_UNEXP_ERROR;
4574:

Line 4623: FND_MSG_PUB.initialize;

4619: SAVEPOINT l_program_name;
4620: END IF;
4621:
4622: IF p_init_msg_list = G_TRUE THEN
4623: FND_MSG_PUB.initialize;
4624: END IF;
4625:
4626: l_asset_tbl := p_asset_tbl;
4627: l_asset_comp_tbl := p_component_tbl;

Line 4773: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4769: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4770:
4771: IF p_transaction_control = G_TRUE THEN
4772: ROLLBACK TO l_program_name;
4773: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4774: END IF;
4775:
4776: x_return_status := G_RET_STS_ERROR;
4777:

Line 4782: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4778: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4779:
4780: IF p_transaction_control = G_TRUE THEN
4781: ROLLBACK TO l_program_name;
4782: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4783: END IF;
4784:
4785: x_return_status := G_RET_STS_UNEXP_ERROR;
4786:

Line 4800: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4796: p_token3_value => sqlerrm);
4797:
4798: IF p_transaction_control = G_TRUE THEN
4799: ROLLBACK TO l_program_name;
4800: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4801: END IF;
4802:
4803: END create_assets_with_adjustments;
4804: