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

930: SAVEPOINT l_program_name;
931: END IF;
932:
933: IF p_init_msg_list = G_TRUE THEN
934: FND_MSG_PUB.initialize;
935: END IF;
936:
937: l_lease_qte_rec := p_lease_qte_rec;
938:

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

1020: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1021:
1022: IF p_transaction_control = G_TRUE THEN
1023: ROLLBACK TO l_program_name;
1024: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1025: END IF;
1026:
1027: x_return_status := G_RET_STS_ERROR;
1028:

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

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

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

1047: p_token3_value => sqlerrm);
1048:
1049: IF p_transaction_control = G_TRUE THEN
1050: ROLLBACK TO l_program_name;
1051: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1052: END IF;
1053:
1054: x_return_status := G_RET_STS_UNEXP_ERROR;
1055:

Line 1104: FND_MSG_PUB.initialize;

1100: SAVEPOINT l_program_name;
1101: END IF;
1102:
1103: IF p_init_msg_list = G_TRUE THEN
1104: FND_MSG_PUB.initialize;
1105: END IF;
1106:
1107: IF ((p_lease_qte_rec.parent_object_code IS NULL OR
1108: p_lease_qte_rec.parent_object_code = OKL_API.G_MISS_CHAR) OR

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

1321: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1322:
1323: IF p_transaction_control = G_TRUE THEN
1324: ROLLBACK TO l_program_name;
1325: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1326: END IF;
1327:
1328: x_return_status := G_RET_STS_ERROR;
1329:

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

1330: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1331:
1332: IF p_transaction_control = G_TRUE THEN
1333: ROLLBACK TO l_program_name;
1334: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1335: END IF;
1336:
1337: x_return_status := G_RET_STS_UNEXP_ERROR;
1338:

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

1348: p_token3_value => sqlerrm);
1349:
1350: IF p_transaction_control = G_TRUE THEN
1351: ROLLBACK TO l_program_name;
1352: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1353: END IF;
1354:
1355: x_return_status := G_RET_STS_UNEXP_ERROR;
1356:

Line 1919: FND_MSG_PUB.initialize;

1915: SAVEPOINT l_program_name;
1916: END IF;
1917:
1918: IF p_init_msg_list = G_TRUE THEN
1919: FND_MSG_PUB.initialize;
1920: END IF;
1921:
1922: l_lease_qte_rec := p_lease_qte_rec;
1923:

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

2072: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2073:
2074: IF p_transaction_control = G_TRUE THEN
2075: ROLLBACK TO l_program_name;
2076: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2077: END IF;
2078:
2079: x_return_status := G_RET_STS_ERROR;
2080:

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

2081: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2082:
2083: IF p_transaction_control = G_TRUE THEN
2084: ROLLBACK TO l_program_name;
2085: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2086: END IF;
2087:
2088: x_return_status := G_RET_STS_UNEXP_ERROR;
2089:

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

2099: p_token3_value => sqlerrm);
2100:
2101: IF p_transaction_control = G_TRUE THEN
2102: ROLLBACK TO l_program_name;
2103: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2104: END IF;
2105:
2106: x_return_status := G_RET_STS_UNEXP_ERROR;
2107:

Line 2132: FND_MSG_PUB.initialize;

2128: SAVEPOINT l_program_name;
2129: END IF;
2130:
2131: IF p_init_msg_list = G_TRUE THEN
2132: FND_MSG_PUB.initialize;
2133: END IF;
2134:
2135: get_quote_rec ( p_quote_id => p_quote_id,
2136: x_quote_rec => l_quote_rec,

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

2172: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2173:
2174: IF p_transaction_control = G_TRUE THEN
2175: ROLLBACK TO l_program_name;
2176: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2177: END IF;
2178:
2179: x_return_status := G_RET_STS_ERROR;
2180:

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

2181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2182:
2183: IF p_transaction_control = G_TRUE THEN
2184: ROLLBACK TO l_program_name;
2185: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2186: END IF;
2187:
2188: x_return_status := G_RET_STS_UNEXP_ERROR;
2189:

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

2199: p_token3_value => sqlerrm);
2200:
2201: IF p_transaction_control = G_TRUE THEN
2202: ROLLBACK TO l_program_name;
2203: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2204: END IF;
2205:
2206: x_return_status := G_RET_STS_UNEXP_ERROR;
2207:

Line 2302: FND_MSG_PUB.initialize;

2298: SAVEPOINT l_program_name;
2299: END IF;
2300:
2301: IF p_init_msg_list = G_TRUE THEN
2302: FND_MSG_PUB.initialize;
2303: END IF;
2304:
2305: IF p_lease_qte_tbl.COUNT > 0 THEN
2306:

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

2350: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2351:
2352: IF p_transaction_control = G_TRUE THEN
2353: ROLLBACK TO l_program_name;
2354: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2355: END IF;
2356:
2357: x_return_status := G_RET_STS_ERROR;
2358:

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

2359: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2360:
2361: IF p_transaction_control = G_TRUE THEN
2362: ROLLBACK TO l_program_name;
2363: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2364: END IF;
2365:
2366: x_return_status := G_RET_STS_UNEXP_ERROR;
2367:

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

2377: p_token3_value => sqlerrm);
2378:
2379: IF p_transaction_control = G_TRUE THEN
2380: ROLLBACK TO l_program_name;
2381: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2382: END IF;
2383:
2384: x_return_status := G_RET_STS_UNEXP_ERROR;
2385:

Line 2412: FND_MSG_PUB.initialize;

2408: SAVEPOINT l_program_name;
2409: END IF;
2410:
2411: IF p_init_msg_list = G_TRUE THEN
2412: FND_MSG_PUB.initialize;
2413: END IF;
2414:
2415: get_quote_rec ( p_quote_id => p_quote_id,
2416: x_quote_rec => l_lease_qte_rec,

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

2465: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2466:
2467: IF p_transaction_control = G_TRUE THEN
2468: ROLLBACK TO l_program_name;
2469: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2470: END IF;
2471:
2472: x_return_status := G_RET_STS_ERROR;
2473:

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

2474: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2475:
2476: IF p_transaction_control = G_TRUE THEN
2477: ROLLBACK TO l_program_name;
2478: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2479: END IF;
2480:
2481: x_return_status := G_RET_STS_UNEXP_ERROR;
2482:

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

2492: p_token3_value => sqlerrm);
2493:
2494: IF p_transaction_control = G_TRUE THEN
2495: ROLLBACK TO l_program_name;
2496: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2497: END IF;
2498:
2499: x_return_status := G_RET_STS_UNEXP_ERROR;
2500:

Line 2538: FND_MSG_PUB.initialize;

2534: SAVEPOINT l_program_name;
2535: END IF;
2536:
2537: IF p_init_msg_list = G_TRUE THEN
2538: FND_MSG_PUB.initialize;
2539: END IF;
2540:
2541: get_quote_rec ( p_quote_id => p_quote_id,
2542: x_quote_rec => l_lease_qte_rec,

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

2612: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2613:
2614: IF p_transaction_control = G_TRUE THEN
2615: ROLLBACK TO l_program_name;
2616: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2617: END IF;
2618:
2619: x_return_status := G_RET_STS_ERROR;
2620:

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

2621: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2622:
2623: IF p_transaction_control = G_TRUE THEN
2624: ROLLBACK TO l_program_name;
2625: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2626: END IF;
2627:
2628: x_return_status := G_RET_STS_UNEXP_ERROR;
2629:

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

2639: p_token3_value => sqlerrm);
2640:
2641: IF p_transaction_control = G_TRUE THEN
2642: ROLLBACK TO l_program_name;
2643: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2644: END IF;
2645:
2646: x_return_status := G_RET_STS_UNEXP_ERROR;
2647:

Line 2681: FND_MSG_PUB.initialize;

2677: SAVEPOINT l_program_name;
2678: END IF;
2679:
2680: IF p_init_msg_list = G_TRUE THEN
2681: FND_MSG_PUB.initialize;
2682: END IF;
2683:
2684: -- Copy Quotes
2685: FOR l_get_quotes IN c_get_quotes LOOP

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

2727: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2728:
2729: IF p_transaction_control = G_TRUE THEN
2730: ROLLBACK TO l_program_name;
2731: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2732: END IF;
2733:
2734: x_return_status := G_RET_STS_ERROR;
2735:

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

2736: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2737:
2738: IF p_transaction_control = G_TRUE THEN
2739: ROLLBACK TO l_program_name;
2740: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2741: END IF;
2742:
2743: x_return_status := G_RET_STS_UNEXP_ERROR;
2744:

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

2754: p_token3_value => sqlerrm);
2755:
2756: IF p_transaction_control = G_TRUE THEN
2757: ROLLBACK TO l_program_name;
2758: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2759: END IF;
2760:
2761: x_return_status := G_RET_STS_UNEXP_ERROR;
2762:

Line 2869: FND_MSG_PUB.initialize;

2865: SAVEPOINT l_program_name;
2866: END IF;
2867:
2868: IF p_init_msg_list = G_TRUE THEN
2869: FND_MSG_PUB.initialize;
2870: END IF;
2871:
2872: get_quote_rec ( p_quote_id => p_quote_id,
2873: x_quote_rec => l_lease_qte_rec,

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

2923: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2924:
2925: IF p_transaction_control = G_TRUE THEN
2926: ROLLBACK TO l_program_name;
2927: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2928: END IF;
2929:
2930: x_return_status := G_RET_STS_ERROR;
2931:

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

2932: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2933:
2934: IF p_transaction_control = G_TRUE THEN
2935: ROLLBACK TO l_program_name;
2936: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2937: END IF;
2938:
2939: x_return_status := G_RET_STS_UNEXP_ERROR;
2940:

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

2950: p_token3_value => sqlerrm);
2951:
2952: IF p_transaction_control = G_TRUE THEN
2953: ROLLBACK TO l_program_name;
2954: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2955: END IF;
2956:
2957: x_return_status := G_RET_STS_UNEXP_ERROR;
2958:

Line 3204: FND_MSG_PUB.initialize;

3200: SAVEPOINT l_program_name;
3201: END IF;
3202:
3203: IF p_init_msg_list = G_TRUE THEN
3204: FND_MSG_PUB.initialize;
3205: END IF;
3206:
3207: --Get Lease Quote Rec
3208: get_quote_rec( p_quote_id => p_quote_id

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

3402: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3403:
3404: IF p_transaction_control = G_TRUE THEN
3405: ROLLBACK TO l_program_name;
3406: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3407: END IF;
3408:
3409: x_return_status := G_RET_STS_ERROR;
3410:

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

3411: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3412:
3413: IF p_transaction_control = G_TRUE THEN
3414: ROLLBACK TO l_program_name;
3415: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3416: END IF;
3417:
3418: x_return_status := G_RET_STS_UNEXP_ERROR;
3419:

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

3429: p_token3_value => sqlerrm);
3430:
3431: IF p_transaction_control = G_TRUE THEN
3432: ROLLBACK TO l_program_name;
3433: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3434: END IF;
3435:
3436: x_return_status := G_RET_STS_UNEXP_ERROR;
3437:

Line 3563: FND_MSG_PUB.initialize;

3559: SAVEPOINT l_program_name;
3560: END IF;
3561:
3562: IF p_init_msg_list = G_TRUE THEN
3563: FND_MSG_PUB.initialize;
3564: END IF;
3565:
3566: IF p_quote_id IS NULL THEN
3567: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

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

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

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

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

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