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 2117: FND_MSG_PUB.initialize;

2113: SAVEPOINT l_program_name;
2114: END IF;
2115:
2116: IF p_init_msg_list = G_TRUE THEN
2117: FND_MSG_PUB.initialize;
2118: END IF;
2119:
2120: l_asset_adj_tbl := p_asset_adj_tbl;
2121:

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

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

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

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

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

2353: p_token3_value => sqlerrm);
2354:
2355: IF p_transaction_control = G_TRUE THEN
2356: ROLLBACK TO l_program_name;
2357: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2358: END IF;
2359:
2360: x_return_status := G_RET_STS_UNEXP_ERROR;
2361: END;

Line 2397: FND_MSG_PUB.initialize;

2393: SAVEPOINT l_program_name;
2394: END IF;
2395:
2396: IF p_init_msg_list = G_TRUE THEN
2397: FND_MSG_PUB.initialize;
2398: END IF;
2399:
2400: l_asset_adj_tbl := p_asset_adj_tbl;
2401:

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

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

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

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

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

2704: p_token3_value => sqlerrm);
2705:
2706: IF p_transaction_control = G_TRUE THEN
2707: ROLLBACK TO l_program_name;
2708: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2709: END IF;
2710:
2711: x_return_status := G_RET_STS_UNEXP_ERROR;
2712: END;

Line 2757: FND_MSG_PUB.initialize;

2753: SAVEPOINT l_program_name;
2754: END IF;
2755:
2756: IF p_init_msg_list = G_TRUE THEN
2757: FND_MSG_PUB.initialize;
2758: END IF;
2759: --Bug # 5142940 ssdeshpa start
2760: --Fix Bug # 4894844 Start
2761: IF p_adjustment_type = 'SUBSIDY' THEN

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

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

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

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

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

2871: p_token3_value => sqlerrm);
2872:
2873: IF p_transaction_control = G_TRUE THEN
2874: ROLLBACK TO l_program_name;
2875: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2876: END IF;
2877:
2878: x_return_status := G_RET_STS_UNEXP_ERROR;
2879: END;

Line 2941: FND_MSG_PUB.initialize;

2937: SAVEPOINT l_program_name;
2938: END IF;
2939:
2940: IF p_init_msg_list = G_TRUE THEN
2941: FND_MSG_PUB.initialize;
2942: END IF;
2943:
2944: FOR l_get_cashflow_object_info IN c_get_cashflow_object_info(p_src_id => p_source_id) LOOP
2945: l_cashflow_object_id := l_get_cashflow_object_info.id;

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

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

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

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

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

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

Line 3364: FND_MSG_PUB.initialize;

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

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

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

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

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

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

3576: p_token3_value => sqlerrm);
3577:
3578: IF p_transaction_control = G_TRUE THEN
3579: ROLLBACK TO l_program_name;
3580: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3581: END IF;
3582:
3583: x_return_status := G_RET_STS_UNEXP_ERROR;
3584:

Line 3625: FND_MSG_PUB.initialize;

3621: SAVEPOINT l_program_name;
3622: END IF;
3623:
3624: IF p_init_msg_list = G_TRUE THEN
3625: FND_MSG_PUB.initialize;
3626: END IF;
3627:
3628: l_asset_rec := p_asset_rec;
3629: l_asset_comp_tbl := p_component_tbl;

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

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

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

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

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

3802: p_token3_value => sqlerrm);
3803:
3804: IF p_transaction_control = G_TRUE THEN
3805: ROLLBACK TO l_program_name;
3806: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3807: END IF;
3808:
3809: x_return_status := G_RET_STS_UNEXP_ERROR;
3810:

Line 3852: FND_MSG_PUB.initialize;

3848: SAVEPOINT l_program_name;
3849: END IF;
3850:
3851: IF p_init_msg_list = G_TRUE THEN
3852: FND_MSG_PUB.initialize;
3853: END IF;
3854:
3855: l_asset_rec := p_asset_rec;
3856: l_asset_comp_tbl := p_component_tbl;

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

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

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

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

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

4016: p_token3_value => sqlerrm);
4017:
4018: IF p_transaction_control = G_TRUE THEN
4019: ROLLBACK TO l_program_name;
4020: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4021: END IF;
4022:
4023: x_return_status := G_RET_STS_UNEXP_ERROR;
4024:

Line 4073: FND_MSG_PUB.initialize;

4069: SAVEPOINT l_program_name;
4070: END IF;
4071:
4072: IF p_init_msg_list = G_TRUE THEN
4073: FND_MSG_PUB.initialize;
4074: END IF;
4075:
4076: l_asset_id := p_asset_id;
4077:

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

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

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

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

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

4188: p_token3_value => sqlerrm);
4189:
4190: IF p_transaction_control = G_TRUE THEN
4191: ROLLBACK TO l_program_name;
4192: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4193: END IF;
4194:
4195: x_return_status := G_RET_STS_UNEXP_ERROR;
4196:

Line 4251: FND_MSG_PUB.initialize;

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

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

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

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

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

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

4570: p_token3_value => sqlerrm);
4571:
4572: IF p_transaction_control = G_TRUE THEN
4573: ROLLBACK TO l_program_name;
4574: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4575: END IF;
4576:
4577: x_return_status := G_RET_STS_UNEXP_ERROR;
4578:

Line 4627: FND_MSG_PUB.initialize;

4623: SAVEPOINT l_program_name;
4624: END IF;
4625:
4626: IF p_init_msg_list = G_TRUE THEN
4627: FND_MSG_PUB.initialize;
4628: END IF;
4629:
4630: l_asset_tbl := p_asset_tbl;
4631: l_asset_comp_tbl := p_component_tbl;

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

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

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

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

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

4800: p_token3_value => sqlerrm);
4801:
4802: IF p_transaction_control = G_TRUE THEN
4803: ROLLBACK TO l_program_name;
4804: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4805: END IF;
4806:
4807: END create_assets_with_adjustments;
4808: