DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_PVT dependencies on FND_MSG_PUB

Line 62: FND_MSG_PUB.initialize;

58:
59: BEGIN
60:
61: IF p_init_msg_list = G_TRUE THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:
65: IF p_quote_id IS NULL THEN
66: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 944: FND_MSG_PUB.initialize;

940: SAVEPOINT l_program_name;
941: END IF;
942:
943: IF p_init_msg_list = G_TRUE THEN
944: FND_MSG_PUB.initialize;
945: END IF;
946:
947: l_lease_qte_rec := p_lease_qte_rec;
948:

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

1030: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1031:
1032: IF p_transaction_control = G_TRUE THEN
1033: ROLLBACK TO l_program_name;
1034: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1035: END IF;
1036:
1037: x_return_status := G_RET_STS_ERROR;
1038:

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

1039: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1040:
1041: IF p_transaction_control = G_TRUE THEN
1042: ROLLBACK TO l_program_name;
1043: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1044: END IF;
1045:
1046: x_return_status := G_RET_STS_UNEXP_ERROR;
1047:

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

1057: p_token3_value => sqlerrm);
1058:
1059: IF p_transaction_control = G_TRUE THEN
1060: ROLLBACK TO l_program_name;
1061: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1062: END IF;
1063:
1064: x_return_status := G_RET_STS_UNEXP_ERROR;
1065:

Line 1121: FND_MSG_PUB.initialize;

1117: SAVEPOINT l_program_name;
1118: END IF;
1119:
1120: IF p_init_msg_list = G_TRUE THEN
1121: FND_MSG_PUB.initialize;
1122: END IF;
1123:
1124: IF ((p_lease_qte_rec.parent_object_code IS NULL OR
1125: p_lease_qte_rec.parent_object_code = OKL_API.G_MISS_CHAR) OR

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

1347: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1348:
1349: IF p_transaction_control = G_TRUE THEN
1350: ROLLBACK TO l_program_name;
1351: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1352: END IF;
1353:
1354: x_return_status := G_RET_STS_ERROR;
1355:

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

1356: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1357:
1358: IF p_transaction_control = G_TRUE THEN
1359: ROLLBACK TO l_program_name;
1360: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1361: END IF;
1362:
1363: x_return_status := G_RET_STS_UNEXP_ERROR;
1364:

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

1374: p_token3_value => sqlerrm);
1375:
1376: IF p_transaction_control = G_TRUE THEN
1377: ROLLBACK TO l_program_name;
1378: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1379: END IF;
1380:
1381: x_return_status := G_RET_STS_UNEXP_ERROR;
1382:

Line 1975: FND_MSG_PUB.initialize;

1971: SAVEPOINT l_program_name;
1972: END IF;
1973:
1974: IF p_init_msg_list = G_TRUE THEN
1975: FND_MSG_PUB.initialize;
1976: END IF;
1977:
1978: l_lease_qte_rec := p_lease_qte_rec;
1979:

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

2128: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2129:
2130: IF p_transaction_control = G_TRUE THEN
2131: ROLLBACK TO l_program_name;
2132: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2133: END IF;
2134:
2135: x_return_status := G_RET_STS_ERROR;
2136:

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

2137: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2138:
2139: IF p_transaction_control = G_TRUE THEN
2140: ROLLBACK TO l_program_name;
2141: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2142: END IF;
2143:
2144: x_return_status := G_RET_STS_UNEXP_ERROR;
2145:

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

2155: p_token3_value => sqlerrm);
2156:
2157: IF p_transaction_control = G_TRUE THEN
2158: ROLLBACK TO l_program_name;
2159: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2160: END IF;
2161:
2162: x_return_status := G_RET_STS_UNEXP_ERROR;
2163:

Line 2188: FND_MSG_PUB.initialize;

2184: SAVEPOINT l_program_name;
2185: END IF;
2186:
2187: IF p_init_msg_list = G_TRUE THEN
2188: FND_MSG_PUB.initialize;
2189: END IF;
2190:
2191: get_quote_rec ( p_quote_id => p_quote_id,
2192: x_quote_rec => l_quote_rec,

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

2228: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2229:
2230: IF p_transaction_control = G_TRUE THEN
2231: ROLLBACK TO l_program_name;
2232: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2233: END IF;
2234:
2235: x_return_status := G_RET_STS_ERROR;
2236:

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

2237: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2238:
2239: IF p_transaction_control = G_TRUE THEN
2240: ROLLBACK TO l_program_name;
2241: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2242: END IF;
2243:
2244: x_return_status := G_RET_STS_UNEXP_ERROR;
2245:

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

2255: p_token3_value => sqlerrm);
2256:
2257: IF p_transaction_control = G_TRUE THEN
2258: ROLLBACK TO l_program_name;
2259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2260: END IF;
2261:
2262: x_return_status := G_RET_STS_UNEXP_ERROR;
2263:

Line 2358: FND_MSG_PUB.initialize;

2354: SAVEPOINT l_program_name;
2355: END IF;
2356:
2357: IF p_init_msg_list = G_TRUE THEN
2358: FND_MSG_PUB.initialize;
2359: END IF;
2360:
2361: IF p_lease_qte_tbl.COUNT > 0 THEN
2362:

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

2406: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2407:
2408: IF p_transaction_control = G_TRUE THEN
2409: ROLLBACK TO l_program_name;
2410: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2411: END IF;
2412:
2413: x_return_status := G_RET_STS_ERROR;
2414:

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

2415: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2416:
2417: IF p_transaction_control = G_TRUE THEN
2418: ROLLBACK TO l_program_name;
2419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2420: END IF;
2421:
2422: x_return_status := G_RET_STS_UNEXP_ERROR;
2423:

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

2433: p_token3_value => sqlerrm);
2434:
2435: IF p_transaction_control = G_TRUE THEN
2436: ROLLBACK TO l_program_name;
2437: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2438: END IF;
2439:
2440: x_return_status := G_RET_STS_UNEXP_ERROR;
2441:

Line 2485: FND_MSG_PUB.initialize;

2481: SAVEPOINT l_program_name;
2482: END IF;
2483:
2484: IF p_init_msg_list = G_TRUE THEN
2485: FND_MSG_PUB.initialize;
2486: END IF;
2487:
2488: get_quote_rec ( p_quote_id => p_quote_id,
2489: x_quote_rec => l_lease_qte_rec,

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

2564: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2565:
2566: IF p_transaction_control = G_TRUE THEN
2567: ROLLBACK TO l_program_name;
2568: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2569: END IF;
2570:
2571: x_return_status := G_RET_STS_ERROR;
2572:

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

2573: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2574:
2575: IF p_transaction_control = G_TRUE THEN
2576: ROLLBACK TO l_program_name;
2577: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2578: END IF;
2579:
2580: x_return_status := G_RET_STS_UNEXP_ERROR;
2581:

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

2591: p_token3_value => sqlerrm);
2592:
2593: IF p_transaction_control = G_TRUE THEN
2594: ROLLBACK TO l_program_name;
2595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2596: END IF;
2597:
2598: x_return_status := G_RET_STS_UNEXP_ERROR;
2599:

Line 2637: FND_MSG_PUB.initialize;

2633: SAVEPOINT l_program_name;
2634: END IF;
2635:
2636: IF p_init_msg_list = G_TRUE THEN
2637: FND_MSG_PUB.initialize;
2638: END IF;
2639:
2640: get_quote_rec ( p_quote_id => p_quote_id,
2641: x_quote_rec => l_lease_qte_rec,

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

2712: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2713:
2714: IF p_transaction_control = G_TRUE THEN
2715: ROLLBACK TO l_program_name;
2716: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2717: END IF;
2718:
2719: x_return_status := G_RET_STS_ERROR;
2720:

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

2721: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2722:
2723: IF p_transaction_control = G_TRUE THEN
2724: ROLLBACK TO l_program_name;
2725: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2726: END IF;
2727:
2728: x_return_status := G_RET_STS_UNEXP_ERROR;
2729:

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

2739: p_token3_value => sqlerrm);
2740:
2741: IF p_transaction_control = G_TRUE THEN
2742: ROLLBACK TO l_program_name;
2743: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2744: END IF;
2745:
2746: x_return_status := G_RET_STS_UNEXP_ERROR;
2747:

Line 2781: FND_MSG_PUB.initialize;

2777: SAVEPOINT l_program_name;
2778: END IF;
2779:
2780: IF p_init_msg_list = G_TRUE THEN
2781: FND_MSG_PUB.initialize;
2782: END IF;
2783:
2784: -- Copy Quotes
2785: FOR l_get_quotes IN c_get_quotes LOOP

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

2827: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2828:
2829: IF p_transaction_control = G_TRUE THEN
2830: ROLLBACK TO l_program_name;
2831: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2832: END IF;
2833:
2834: x_return_status := G_RET_STS_ERROR;
2835:

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

2836: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2837:
2838: IF p_transaction_control = G_TRUE THEN
2839: ROLLBACK TO l_program_name;
2840: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2841: END IF;
2842:
2843: x_return_status := G_RET_STS_UNEXP_ERROR;
2844:

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

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

Line 2969: FND_MSG_PUB.initialize;

2965: SAVEPOINT l_program_name;
2966: END IF;
2967:
2968: IF p_init_msg_list = G_TRUE THEN
2969: FND_MSG_PUB.initialize;
2970: END IF;
2971:
2972: get_quote_rec ( p_quote_id => p_quote_id,
2973: x_quote_rec => l_lease_qte_rec,

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

3023: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3024:
3025: IF p_transaction_control = G_TRUE THEN
3026: ROLLBACK TO l_program_name;
3027: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3028: END IF;
3029:
3030: x_return_status := G_RET_STS_ERROR;
3031:

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

3032: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
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:

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

3050: p_token3_value => sqlerrm);
3051:
3052: IF p_transaction_control = G_TRUE THEN
3053: ROLLBACK TO l_program_name;
3054: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3055: END IF;
3056:
3057: x_return_status := G_RET_STS_UNEXP_ERROR;
3058:

Line 3304: FND_MSG_PUB.initialize;

3300: SAVEPOINT l_program_name;
3301: END IF;
3302:
3303: IF p_init_msg_list = G_TRUE THEN
3304: FND_MSG_PUB.initialize;
3305: END IF;
3306:
3307: --Get Lease Quote Rec
3308: get_quote_rec( p_quote_id => p_quote_id

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

3502: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3503:
3504: IF p_transaction_control = G_TRUE THEN
3505: ROLLBACK TO l_program_name;
3506: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3507: END IF;
3508:
3509: x_return_status := G_RET_STS_ERROR;
3510:

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

3511: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3512:
3513: IF p_transaction_control = G_TRUE THEN
3514: ROLLBACK TO l_program_name;
3515: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3516: END IF;
3517:
3518: x_return_status := G_RET_STS_UNEXP_ERROR;
3519:

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

3529: p_token3_value => sqlerrm);
3530:
3531: IF p_transaction_control = G_TRUE THEN
3532: ROLLBACK TO l_program_name;
3533: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3534: END IF;
3535:
3536: x_return_status := G_RET_STS_UNEXP_ERROR;
3537:

Line 3664: FND_MSG_PUB.initialize;

3660: SAVEPOINT l_program_name;
3661: END IF;
3662:
3663: IF p_init_msg_list = G_TRUE THEN
3664: FND_MSG_PUB.initialize;
3665: END IF;
3666:
3667: IF p_quote_id IS NULL THEN
3668: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

3874:
3875: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3876: IF p_transaction_control = G_TRUE THEN
3877: ROLLBACK TO l_program_name;
3878: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3879: END IF;
3880: x_return_status := G_RET_STS_ERROR;
3881:
3882: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

3881:
3882: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3883: IF p_transaction_control = G_TRUE THEN
3884: ROLLBACK TO l_program_name;
3885: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3886: END IF;
3887: x_return_status := G_RET_STS_UNEXP_ERROR;
3888:
3889: WHEN OTHERS THEN

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

3897: p_token3_value => sqlerrm);
3898:
3899: IF p_transaction_control = G_TRUE THEN
3900: ROLLBACK TO l_program_name;
3901: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3902: END IF;
3903: x_return_status := G_RET_STS_UNEXP_ERROR;
3904:
3905: END calculate_sales_tax;