eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CHECKLIST_PVT dependencies on FND_MSG_PUB

Line 2496: FND_MSG_PUB.initialize;

2492: END IF;
2493:
2494: -- Initialize message list if requested
2495: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2496: FND_MSG_PUB.initialize;
2497: END IF;
2498:
2499: -- Initialize API status to success
2500: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2552: FND_MSG_PUB.Count_And_Get

2548:
2549: /*** End API body ******************************************************/
2550:
2551: -- Get message count and if count is 1, get message info
2552: FND_MSG_PUB.Count_And_Get
2553: (p_count => x_msg_count,
2554: p_data => x_msg_data);
2555:
2556: EXCEPTION

Line 2560: FND_MSG_PUB.Count_And_Get

2556: EXCEPTION
2557: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2558: ROLLBACK TO create_checklist_hdr;
2559: x_return_status := OKL_API.G_RET_STS_ERROR;
2560: FND_MSG_PUB.Count_And_Get
2561: (p_count => x_msg_count,
2562: p_data => x_msg_data);
2563:
2564: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2567: FND_MSG_PUB.Count_And_Get

2563:
2564: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2565: ROLLBACK TO create_checklist_hdr;
2566: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2567: FND_MSG_PUB.Count_And_Get
2568: (p_count => x_msg_count,
2569: p_data => x_msg_data);
2570:
2571: WHEN OTHERS THEN

Line 2580: FND_MSG_PUB.Count_And_Get

2576: p_token1 => G_SQLCODE_TOKEN,
2577: p_token1_value => SQLCODE,
2578: p_token2 => G_SQLERRM_TOKEN,
2579: p_token2_value => SQLERRM);
2580: FND_MSG_PUB.Count_And_Get
2581: (p_count => x_msg_count,
2582: p_data => x_msg_data);
2583:
2584: end create_checklist_hdr;

Line 2628: FND_MSG_PUB.initialize;

2624: END IF;
2625:
2626: -- Initialize message list if requested
2627: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2628: FND_MSG_PUB.initialize;
2629: END IF;
2630:
2631: -- Initialize API status to success
2632: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2674: FND_MSG_PUB.Count_And_Get

2670:
2671: /*** End API body ******************************************************/
2672:
2673: -- Get message count and if count is 1, get message info
2674: FND_MSG_PUB.Count_And_Get
2675: (p_count => x_msg_count,
2676: p_data => x_msg_data);
2677:
2678: EXCEPTION

Line 2682: FND_MSG_PUB.Count_And_Get

2678: EXCEPTION
2679: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2680: ROLLBACK TO update_checklist_hdr;
2681: x_return_status := OKL_API.G_RET_STS_ERROR;
2682: FND_MSG_PUB.Count_And_Get
2683: (p_count => x_msg_count,
2684: p_data => x_msg_data);
2685:
2686: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2689: FND_MSG_PUB.Count_And_Get

2685:
2686: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2687: ROLLBACK TO update_checklist_hdr;
2688: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2689: FND_MSG_PUB.Count_And_Get
2690: (p_count => x_msg_count,
2691: p_data => x_msg_data);
2692:
2693: WHEN OTHERS THEN

Line 2702: FND_MSG_PUB.Count_And_Get

2698: p_token1 => G_SQLCODE_TOKEN,
2699: p_token1_value => SQLCODE,
2700: p_token2 => G_SQLERRM_TOKEN,
2701: p_token2_value => SQLERRM);
2702: FND_MSG_PUB.Count_And_Get
2703: (p_count => x_msg_count,
2704: p_data => x_msg_data);
2705:
2706: end update_checklist_hdr;

Line 2749: FND_MSG_PUB.initialize;

2745: END IF;
2746:
2747: -- Initialize message list if requested
2748: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2749: FND_MSG_PUB.initialize;
2750: END IF;
2751:
2752: -- Initialize API status to success
2753: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2775: FND_MSG_PUB.Count_And_Get

2771:
2772: /*** End API body ******************************************************/
2773:
2774: -- Get message count and if count is 1, get message info
2775: FND_MSG_PUB.Count_And_Get
2776: (p_count => x_msg_count,
2777: p_data => x_msg_data);
2778:
2779: EXCEPTION

Line 2783: FND_MSG_PUB.Count_And_Get

2779: EXCEPTION
2780: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2781: ROLLBACK TO delete_checklist_hdr;
2782: x_return_status := OKL_API.G_RET_STS_ERROR;
2783: FND_MSG_PUB.Count_And_Get
2784: (p_count => x_msg_count,
2785: p_data => x_msg_data);
2786:
2787: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2790: FND_MSG_PUB.Count_And_Get

2786:
2787: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2788: ROLLBACK TO delete_checklist_hdr;
2789: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2790: FND_MSG_PUB.Count_And_Get
2791: (p_count => x_msg_count,
2792: p_data => x_msg_data);
2793:
2794: WHEN OTHERS THEN

Line 2803: FND_MSG_PUB.Count_And_Get

2799: p_token1 => G_SQLCODE_TOKEN,
2800: p_token1_value => SQLCODE,
2801: p_token2 => G_SQLERRM_TOKEN,
2802: p_token2_value => SQLERRM);
2803: FND_MSG_PUB.Count_And_Get
2804: (p_count => x_msg_count,
2805: p_data => x_msg_data);
2806:
2807: end delete_checklist_hdr;

Line 2851: FND_MSG_PUB.initialize;

2847: END IF;
2848:
2849: -- Initialize message list if requested
2850: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
2851: FND_MSG_PUB.initialize;
2852: END IF;
2853:
2854: -- Initialize API status to success
2855: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2916: FND_MSG_PUB.Count_And_Get

2912:
2913: /*** End API body ******************************************************/
2914:
2915: -- Get message count and if count is 1, get message info
2916: FND_MSG_PUB.Count_And_Get
2917: (p_count => x_msg_count,
2918: p_data => x_msg_data);
2919:
2920: EXCEPTION

Line 2924: FND_MSG_PUB.Count_And_Get

2920: EXCEPTION
2921: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2922: ROLLBACK TO create_checklist_dtl;
2923: x_return_status := OKL_API.G_RET_STS_ERROR;
2924: FND_MSG_PUB.Count_And_Get
2925: (p_count => x_msg_count,
2926: p_data => x_msg_data);
2927:
2928: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2931: FND_MSG_PUB.Count_And_Get

2927:
2928: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2929: ROLLBACK TO create_checklist_dtl;
2930: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2931: FND_MSG_PUB.Count_And_Get
2932: (p_count => x_msg_count,
2933: p_data => x_msg_data);
2934:
2935: WHEN OTHERS THEN

Line 2944: FND_MSG_PUB.Count_And_Get

2940: p_token1 => G_SQLCODE_TOKEN,
2941: p_token1_value => SQLCODE,
2942: p_token2 => G_SQLERRM_TOKEN,
2943: p_token2_value => SQLERRM);
2944: FND_MSG_PUB.Count_And_Get
2945: (p_count => x_msg_count,
2946: p_data => x_msg_data);
2947:
2948: end create_checklist_dtl;

Line 3002: FND_MSG_PUB.initialize;

2998: END IF;
2999:
3000: -- Initialize message list if requested
3001: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3002: FND_MSG_PUB.initialize;
3003: END IF;
3004:
3005: -- Initialize API status to success
3006: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3080: FND_MSG_PUB.Count_And_Get

3076:
3077: /*** End API body ******************************************************/
3078:
3079: -- Get message count and if count is 1, get message info
3080: FND_MSG_PUB.Count_And_Get
3081: (p_count => x_msg_count,
3082: p_data => x_msg_data);
3083:
3084: EXCEPTION

Line 3088: FND_MSG_PUB.Count_And_Get

3084: EXCEPTION
3085: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3086: ROLLBACK TO update_checklist_dtl;
3087: x_return_status := OKL_API.G_RET_STS_ERROR;
3088: FND_MSG_PUB.Count_And_Get
3089: (p_count => x_msg_count,
3090: p_data => x_msg_data);
3091:
3092: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3095: FND_MSG_PUB.Count_And_Get

3091:
3092: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3093: ROLLBACK TO update_checklist_dtl;
3094: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3095: FND_MSG_PUB.Count_And_Get
3096: (p_count => x_msg_count,
3097: p_data => x_msg_data);
3098:
3099: WHEN OTHERS THEN

Line 3108: FND_MSG_PUB.Count_And_Get

3104: p_token1 => G_SQLCODE_TOKEN,
3105: p_token1_value => SQLCODE,
3106: p_token2 => G_SQLERRM_TOKEN,
3107: p_token2_value => SQLERRM);
3108: FND_MSG_PUB.Count_And_Get
3109: (p_count => x_msg_count,
3110: p_data => x_msg_data);
3111:
3112: end update_checklist_dtl;

Line 3155: FND_MSG_PUB.initialize;

3151: END IF;
3152:
3153: -- Initialize message list if requested
3154: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3155: FND_MSG_PUB.initialize;
3156: END IF;
3157:
3158: -- Initialize API status to success
3159: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3181: FND_MSG_PUB.Count_And_Get

3177:
3178: /*** End API body ******************************************************/
3179:
3180: -- Get message count and if count is 1, get message info
3181: FND_MSG_PUB.Count_And_Get
3182: (p_count => x_msg_count,
3183: p_data => x_msg_data);
3184:
3185: EXCEPTION

Line 3189: FND_MSG_PUB.Count_And_Get

3185: EXCEPTION
3186: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3187: ROLLBACK TO delete_checklist_dtl;
3188: x_return_status := OKL_API.G_RET_STS_ERROR;
3189: FND_MSG_PUB.Count_And_Get
3190: (p_count => x_msg_count,
3191: p_data => x_msg_data);
3192:
3193: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3196: FND_MSG_PUB.Count_And_Get

3192:
3193: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3194: ROLLBACK TO delete_checklist_dtl;
3195: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3196: FND_MSG_PUB.Count_And_Get
3197: (p_count => x_msg_count,
3198: p_data => x_msg_data);
3199:
3200: WHEN OTHERS THEN

Line 3209: FND_MSG_PUB.Count_And_Get

3205: p_token1 => G_SQLCODE_TOKEN,
3206: p_token1_value => SQLCODE,
3207: p_token2 => G_SQLERRM_TOKEN,
3208: p_token2_value => SQLERRM);
3209: FND_MSG_PUB.Count_And_Get
3210: (p_count => x_msg_count,
3211: p_data => x_msg_data);
3212:
3213: end delete_checklist_dtl;

Line 3270: FND_MSG_PUB.initialize;

3266: END IF;
3267:
3268: -- Initialize message list if requested
3269: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3270: FND_MSG_PUB.initialize;
3271: END IF;
3272:
3273: -- Initialize API status to success
3274: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3347: FND_MSG_PUB.Count_And_Get

3343:
3344: /*** End API body ******************************************************/
3345:
3346: -- Get message count and if count is 1, get message info
3347: FND_MSG_PUB.Count_And_Get
3348: (p_count => x_msg_count,
3349: p_data => x_msg_data);
3350:
3351: EXCEPTION

Line 3356: FND_MSG_PUB.Count_And_Get

3352: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3353: ROLLBACK TO submit_for_approval_pvt;
3354: x_return_status := OKL_API.G_RET_STS_ERROR;
3355: x_status_code := l_org_status_code;
3356: FND_MSG_PUB.Count_And_Get
3357: (p_count => x_msg_count,
3358: p_data => x_msg_data);
3359:
3360: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3364: FND_MSG_PUB.Count_And_Get

3360: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3361: ROLLBACK TO submit_for_approval_pvt;
3362: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3363: x_status_code := l_org_status_code;
3364: FND_MSG_PUB.Count_And_Get
3365: (p_count => x_msg_count,
3366: p_data => x_msg_data);
3367:
3368: WHEN OTHERS THEN

Line 3378: FND_MSG_PUB.Count_And_Get

3374: p_token1 => G_SQLCODE_TOKEN,
3375: p_token1_value => SQLCODE,
3376: p_token2 => G_SQLERRM_TOKEN,
3377: p_token2_value => SQLERRM);
3378: FND_MSG_PUB.Count_And_Get
3379: (p_count => x_msg_count,
3380: p_data => x_msg_data);
3381:
3382: end submit_for_approval;

Line 3437: FND_MSG_PUB.initialize;

3433: END IF;
3434:
3435: -- Initialize message list if requested
3436: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3437: FND_MSG_PUB.initialize;
3438: END IF;
3439:
3440: -- Initialize API status to success
3441: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3475: FND_MSG_PUB.Count_And_Get

3471:
3472: /*** End API body ******************************************************/
3473:
3474: -- Get message count and if count is 1, get message info
3475: FND_MSG_PUB.Count_And_Get
3476: (p_count => x_msg_count,
3477: p_data => x_msg_data);
3478:
3479: EXCEPTION

Line 3483: FND_MSG_PUB.Count_And_Get

3479: EXCEPTION
3480: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3481: ROLLBACK TO create_checklist_inst_hdr;
3482: x_return_status := OKL_API.G_RET_STS_ERROR;
3483: FND_MSG_PUB.Count_And_Get
3484: (p_count => x_msg_count,
3485: p_data => x_msg_data);
3486:
3487: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3490: FND_MSG_PUB.Count_And_Get

3486:
3487: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3488: ROLLBACK TO create_checklist_inst_hdr;
3489: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3490: FND_MSG_PUB.Count_And_Get
3491: (p_count => x_msg_count,
3492: p_data => x_msg_data);
3493:
3494: WHEN OTHERS THEN

Line 3503: FND_MSG_PUB.Count_And_Get

3499: p_token1 => G_SQLCODE_TOKEN,
3500: p_token1_value => SQLCODE,
3501: p_token2 => G_SQLERRM_TOKEN,
3502: p_token2_value => SQLERRM);
3503: FND_MSG_PUB.Count_And_Get
3504: (p_count => x_msg_count,
3505: p_data => x_msg_data);
3506:
3507: end create_checklist_inst_hdr;

Line 3555: FND_MSG_PUB.initialize;

3551: END IF;
3552:
3553: -- Initialize message list if requested
3554: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3555: FND_MSG_PUB.initialize;
3556: END IF;
3557:
3558: -- Initialize API status to success
3559: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3582: FND_MSG_PUB.Count_And_Get

3578:
3579: /*** End API body ******************************************************/
3580:
3581: -- Get message count and if count is 1, get message info
3582: FND_MSG_PUB.Count_And_Get
3583: (p_count => x_msg_count,
3584: p_data => x_msg_data);
3585:
3586: EXCEPTION

Line 3590: FND_MSG_PUB.Count_And_Get

3586: EXCEPTION
3587: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3588: ROLLBACK TO update_checklist_inst_hdr;
3589: x_return_status := OKL_API.G_RET_STS_ERROR;
3590: FND_MSG_PUB.Count_And_Get
3591: (p_count => x_msg_count,
3592: p_data => x_msg_data);
3593:
3594: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3597: FND_MSG_PUB.Count_And_Get

3593:
3594: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3595: ROLLBACK TO update_checklist_inst_hdr;
3596: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3597: FND_MSG_PUB.Count_And_Get
3598: (p_count => x_msg_count,
3599: p_data => x_msg_data);
3600:
3601: WHEN OTHERS THEN

Line 3610: FND_MSG_PUB.Count_And_Get

3606: p_token1 => G_SQLCODE_TOKEN,
3607: p_token1_value => SQLCODE,
3608: p_token2 => G_SQLERRM_TOKEN,
3609: p_token2_value => SQLERRM);
3610: FND_MSG_PUB.Count_And_Get
3611: (p_count => x_msg_count,
3612: p_data => x_msg_data);
3613:
3614: end update_checklist_inst_hdr;

Line 3657: FND_MSG_PUB.initialize;

3653: END IF;
3654:
3655: -- Initialize message list if requested
3656: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3657: FND_MSG_PUB.initialize;
3658: END IF;
3659:
3660: -- Initialize API status to success
3661: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3683: FND_MSG_PUB.Count_And_Get

3679:
3680: /*** End API body ******************************************************/
3681:
3682: -- Get message count and if count is 1, get message info
3683: FND_MSG_PUB.Count_And_Get
3684: (p_count => x_msg_count,
3685: p_data => x_msg_data);
3686:
3687: EXCEPTION

Line 3691: FND_MSG_PUB.Count_And_Get

3687: EXCEPTION
3688: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3689: ROLLBACK TO delete_checklist_inst_hdr;
3690: x_return_status := OKL_API.G_RET_STS_ERROR;
3691: FND_MSG_PUB.Count_And_Get
3692: (p_count => x_msg_count,
3693: p_data => x_msg_data);
3694:
3695: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3698: FND_MSG_PUB.Count_And_Get

3694:
3695: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3696: ROLLBACK TO delete_checklist_inst_hdr;
3697: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3698: FND_MSG_PUB.Count_And_Get
3699: (p_count => x_msg_count,
3700: p_data => x_msg_data);
3701:
3702: WHEN OTHERS THEN

Line 3711: FND_MSG_PUB.Count_And_Get

3707: p_token1 => G_SQLCODE_TOKEN,
3708: p_token1_value => SQLCODE,
3709: p_token2 => G_SQLERRM_TOKEN,
3710: p_token2_value => SQLERRM);
3711: FND_MSG_PUB.Count_And_Get
3712: (p_count => x_msg_count,
3713: p_data => x_msg_data);
3714:
3715: end delete_checklist_inst_hdr;

Line 3782: FND_MSG_PUB.initialize;

3778: END IF;
3779:
3780: -- Initialize message list if requested
3781: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3782: FND_MSG_PUB.initialize;
3783: END IF;
3784:
3785: -- Initialize API status to success
3786: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3848: FND_MSG_PUB.Count_And_Get

3844:
3845: /*** End API body ******************************************************/
3846:
3847: -- Get message count and if count is 1, get message info
3848: FND_MSG_PUB.Count_And_Get
3849: (p_count => x_msg_count,
3850: p_data => x_msg_data);
3851:
3852: EXCEPTION

Line 3856: FND_MSG_PUB.Count_And_Get

3852: EXCEPTION
3853: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3854: ROLLBACK TO create_checklist_inst_dtl;
3855: x_return_status := OKL_API.G_RET_STS_ERROR;
3856: FND_MSG_PUB.Count_And_Get
3857: (p_count => x_msg_count,
3858: p_data => x_msg_data);
3859:
3860: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3863: FND_MSG_PUB.Count_And_Get

3859:
3860: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3861: ROLLBACK TO create_checklist_inst_dtl;
3862: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3863: FND_MSG_PUB.Count_And_Get
3864: (p_count => x_msg_count,
3865: p_data => x_msg_data);
3866:
3867: WHEN OTHERS THEN

Line 3876: FND_MSG_PUB.Count_And_Get

3872: p_token1 => G_SQLCODE_TOKEN,
3873: p_token1_value => SQLCODE,
3874: p_token2 => G_SQLERRM_TOKEN,
3875: p_token2_value => SQLERRM);
3876: FND_MSG_PUB.Count_And_Get
3877: (p_count => x_msg_count,
3878: p_data => x_msg_data);
3879:
3880: end create_checklist_inst_dtl;

Line 3929: FND_MSG_PUB.initialize;

3925: END IF;
3926:
3927: -- Initialize message list if requested
3928: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
3929: FND_MSG_PUB.initialize;
3930: END IF;
3931:
3932: -- Initialize API status to success
3933: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3955: FND_MSG_PUB.Count_And_Get

3951:
3952: /*** End API body ******************************************************/
3953:
3954: -- Get message count and if count is 1, get message info
3955: FND_MSG_PUB.Count_And_Get
3956: (p_count => x_msg_count,
3957: p_data => x_msg_data);
3958:
3959: EXCEPTION

Line 3963: FND_MSG_PUB.Count_And_Get

3959: EXCEPTION
3960: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3961: ROLLBACK TO update_checklist_inst_dtl;
3962: x_return_status := OKL_API.G_RET_STS_ERROR;
3963: FND_MSG_PUB.Count_And_Get
3964: (p_count => x_msg_count,
3965: p_data => x_msg_data);
3966:
3967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3970: FND_MSG_PUB.Count_And_Get

3966:
3967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3968: ROLLBACK TO update_checklist_inst_dtl;
3969: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3970: FND_MSG_PUB.Count_And_Get
3971: (p_count => x_msg_count,
3972: p_data => x_msg_data);
3973:
3974: WHEN OTHERS THEN

Line 3983: FND_MSG_PUB.Count_And_Get

3979: p_token1 => G_SQLCODE_TOKEN,
3980: p_token1_value => SQLCODE,
3981: p_token2 => G_SQLERRM_TOKEN,
3982: p_token2_value => SQLERRM);
3983: FND_MSG_PUB.Count_And_Get
3984: (p_count => x_msg_count,
3985: p_data => x_msg_data);
3986:
3987: end update_checklist_inst_dtl;

Line 4031: FND_MSG_PUB.initialize;

4027: END IF;
4028:
4029: -- Initialize message list if requested
4030: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
4031: FND_MSG_PUB.initialize;
4032: END IF;
4033:
4034: -- Initialize API status to success
4035: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4057: FND_MSG_PUB.Count_And_Get

4053:
4054: /*** End API body ******************************************************/
4055:
4056: -- Get message count and if count is 1, get message info
4057: FND_MSG_PUB.Count_And_Get
4058: (p_count => x_msg_count,
4059: p_data => x_msg_data);
4060:
4061: EXCEPTION

Line 4065: FND_MSG_PUB.Count_And_Get

4061: EXCEPTION
4062: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4063: ROLLBACK TO delete_checklist_inst_dtl;
4064: x_return_status := OKL_API.G_RET_STS_ERROR;
4065: FND_MSG_PUB.Count_And_Get
4066: (p_count => x_msg_count,
4067: p_data => x_msg_data);
4068:
4069: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 4072: FND_MSG_PUB.Count_And_Get

4068:
4069: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4070: ROLLBACK TO delete_checklist_inst_dtl;
4071: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4072: FND_MSG_PUB.Count_And_Get
4073: (p_count => x_msg_count,
4074: p_data => x_msg_data);
4075:
4076: WHEN OTHERS THEN

Line 4085: FND_MSG_PUB.Count_And_Get

4081: p_token1 => G_SQLCODE_TOKEN,
4082: p_token1_value => SQLCODE,
4083: p_token2 => G_SQLERRM_TOKEN,
4084: p_token2_value => SQLERRM);
4085: FND_MSG_PUB.Count_And_Get
4086: (p_count => x_msg_count,
4087: p_data => x_msg_data);
4088:
4089: end delete_checklist_inst_dtl;

Line 4182: FND_MSG_PUB.initialize;

4178: END IF;
4179:
4180: -- Initialize message list if requested
4181: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
4182: FND_MSG_PUB.initialize;
4183: END IF;
4184:
4185: -- Initialize API status to success
4186: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4293: FND_MSG_PUB.Count_And_Get

4289:
4290: /*** End API body ******************************************************/
4291:
4292: -- Get message count and if count is 1, get message info
4293: FND_MSG_PUB.Count_And_Get
4294: (p_count => x_msg_count,
4295: p_data => x_msg_data);
4296:
4297: EXCEPTION

Line 4301: FND_MSG_PUB.Count_And_Get

4297: EXCEPTION
4298: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4299: ROLLBACK TO chk_eligible_for_approval;
4300: x_return_status := OKL_API.G_RET_STS_ERROR;
4301: FND_MSG_PUB.Count_And_Get
4302: (p_count => x_msg_count,
4303: p_data => x_msg_data);
4304:
4305: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 4308: FND_MSG_PUB.Count_And_Get

4304:
4305: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4306: ROLLBACK TO chk_eligible_for_approval;
4307: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4308: FND_MSG_PUB.Count_And_Get
4309: (p_count => x_msg_count,
4310: p_data => x_msg_data);
4311:
4312: --START: 06-Oct-2005 cklee -- Fixed dupliciated system error message |

Line 4316: FND_MSG_PUB.Count_And_Get

4312: --START: 06-Oct-2005 cklee -- Fixed dupliciated system error message |
4313: WHEN G_EXCEPTION_HALT_VALIDATION THEN
4314: ROLLBACK TO chk_eligible_for_approval;
4315: x_return_status := OKL_API.G_RET_STS_ERROR;
4316: FND_MSG_PUB.Count_And_Get
4317: (p_count => x_msg_count,
4318: p_data => x_msg_data);
4319: --END: 06-Oct-2005 cklee -- Fixed dupliciated system error message |
4320:

Line 4330: FND_MSG_PUB.Count_And_Get

4326: p_token1 => G_SQLCODE_TOKEN,
4327: p_token1_value => SQLCODE,
4328: p_token2 => G_SQLERRM_TOKEN,
4329: p_token2_value => SQLERRM);
4330: FND_MSG_PUB.Count_And_Get
4331: (p_count => x_msg_count,
4332: p_data => x_msg_data);
4333:
4334: end chk_eligible_for_approval;

Line 4400: FND_MSG_PUB.initialize;

4396: END IF;
4397:
4398: -- Initialize message list if requested
4399: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
4400: FND_MSG_PUB.initialize;
4401: END IF;
4402:
4403: -- Initialize API status to success
4404: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4433: FND_MSG_PUB.Count_And_Get

4429:
4430: EXCEPTION
4431: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4432: lp_fund_rst := 'ERROR';
4433: FND_MSG_PUB.Count_And_Get
4434: (p_count => x_msg_count,
4435: p_data => x_msg_data);
4436: lp_msg_data := substr('Application error: ' || x_msg_data, 2000);
4437:

Line 4440: FND_MSG_PUB.Count_And_Get

4436: lp_msg_data := substr('Application error: ' || x_msg_data, 2000);
4437:
4438: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4439: lp_fund_rst := 'ERROR';
4440: FND_MSG_PUB.Count_And_Get
4441: (p_count => x_msg_count,
4442: p_data => x_msg_data);
4443: lp_msg_data := substr('Unexpected application error: ' || x_msg_data, 2000);
4444:

Line 4475: FND_MSG_PUB.Count_And_Get

4471:
4472: /*** End API body ******************************************************/
4473:
4474: -- Get message count and if count is 1, get message info
4475: FND_MSG_PUB.Count_And_Get
4476: (p_count => x_msg_count,
4477: p_data => x_msg_data);
4478:
4479: EXCEPTION

Line 4483: FND_MSG_PUB.Count_And_Get

4479: EXCEPTION
4480: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4481: ROLLBACK TO update_checklist_function;
4482: x_return_status := OKL_API.G_RET_STS_ERROR;
4483: FND_MSG_PUB.Count_And_Get
4484: (p_count => x_msg_count,
4485: p_data => x_msg_data);
4486:
4487: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 4490: FND_MSG_PUB.Count_And_Get

4486:
4487: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4488: ROLLBACK TO update_checklist_function;
4489: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4490: FND_MSG_PUB.Count_And_Get
4491: (p_count => x_msg_count,
4492: p_data => x_msg_data);
4493:
4494: WHEN OTHERS THEN

Line 4504: FND_MSG_PUB.Count_And_Get

4500: p_token1 => G_SQLCODE_TOKEN,
4501: p_token1_value => SQLCODE,
4502: p_token2 => G_SQLERRM_TOKEN,
4503: p_token2_value => SQLERRM);
4504: FND_MSG_PUB.Count_And_Get
4505: (p_count => x_msg_count,
4506: p_data => x_msg_data);
4507:
4508: end update_checklist_function;

Line 4609: FND_MSG_PUB.initialize;

4605: END IF;
4606:
4607: -- Initialize message list if requested
4608: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
4609: FND_MSG_PUB.initialize;
4610: END IF;
4611:
4612: -- Initialize API status to success
4613: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 4698: FND_MSG_PUB.Count_And_Get

4694:
4695: /*** End API body ******************************************************/
4696:
4697: -- Get message count and if count is 1, get message info
4698: FND_MSG_PUB.Count_And_Get
4699: (p_count => x_msg_count,
4700: p_data => x_msg_data);
4701:
4702: EXCEPTION

Line 4706: FND_MSG_PUB.Count_And_Get

4702: EXCEPTION
4703: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4704: ROLLBACK TO create_contract_checklist;
4705: x_return_status := OKL_API.G_RET_STS_ERROR;
4706: FND_MSG_PUB.Count_And_Get
4707: (p_count => x_msg_count,
4708: p_data => x_msg_data);
4709:
4710: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 4713: FND_MSG_PUB.Count_And_Get

4709:
4710: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4711: ROLLBACK TO create_contract_checklist;
4712: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4713: FND_MSG_PUB.Count_And_Get
4714: (p_count => x_msg_count,
4715: p_data => x_msg_data);
4716:
4717: WHEN OTHERS THEN

Line 4726: FND_MSG_PUB.Count_And_Get

4722: p_token1 => G_SQLCODE_TOKEN,
4723: p_token1_value => SQLCODE,
4724: p_token2 => G_SQLERRM_TOKEN,
4725: p_token2_value => SQLERRM);
4726: FND_MSG_PUB.Count_And_Get
4727: (p_count => x_msg_count,
4728: p_data => x_msg_data);
4729:
4730: end create_contract_checklist;