DBA Data[Home] [Help]

APPS.EAM_WO_NETWORK_DEFAULT_PVT dependencies on FND_MSG_PUB

Line 144: FND_MSG_PUB.initialize;

140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142: -- Initialize message list if p_init_msg_list is set to TRUE.
143: IF FND_API.to_Boolean( p_init_msg_list ) THEN
144: FND_MSG_PUB.initialize;
145: END IF;
146: -- Initialize API return status to success
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148: -- API body

Line 2509: FND_MSG_PUB.initialize;

2505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2506: END IF;
2507: -- Initialize message list if p_init_msg_list is set to TRUE.
2508: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2509: FND_MSG_PUB.initialize;
2510: END IF;
2511: -- Initialize API return status to success
2512: x_return_status := FND_API.G_RET_STS_SUCCESS;
2513: -- API body

Line 2589: FND_MSG_PUB.Count_And_Get

2585: --dbms_output.put_line('committing');
2586: COMMIT WORK;
2587: END IF;
2588: -- Standard call to get message count and if count is 1, get message info.
2589: FND_MSG_PUB.Count_And_Get
2590: ( p_count => x_msg_count ,
2591: p_data => x_msg_data
2592: );
2593: EXCEPTION

Line 2596: FND_MSG_PUB.Count_And_Get

2592: );
2593: EXCEPTION
2594: WHEN FND_API.G_EXC_ERROR THEN
2595: x_return_status := FND_API.G_RET_STS_ERROR ;
2596: FND_MSG_PUB.Count_And_Get
2597: ( p_count => x_msg_count ,
2598: p_data => x_msg_data
2599: );
2600:

Line 2604: FND_MSG_PUB.Count_And_Get

2600:
2601:
2602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2604: FND_MSG_PUB.Count_And_Get
2605: (
2606: p_count => x_msg_count,
2607: p_data => x_msg_data
2608: );

Line 2612: IF FND_MSG_PUB.Check_Msg_Level

2608: );
2609:
2610: WHEN OTHERS THEN
2611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2612: IF FND_MSG_PUB.Check_Msg_Level
2613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2614: THEN
2615: FND_MSG_PUB.Add_Exc_Msg
2616: ( G_PKG_NAME,

Line 2613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2609:
2610: WHEN OTHERS THEN
2611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2612: IF FND_MSG_PUB.Check_Msg_Level
2613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2614: THEN
2615: FND_MSG_PUB.Add_Exc_Msg
2616: ( G_PKG_NAME,
2617: l_api_name||'('||l_stmt_num||')'

Line 2615: FND_MSG_PUB.Add_Exc_Msg

2611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2612: IF FND_MSG_PUB.Check_Msg_Level
2613: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2614: THEN
2615: FND_MSG_PUB.Add_Exc_Msg
2616: ( G_PKG_NAME,
2617: l_api_name||'('||l_stmt_num||')'
2618: );
2619: END IF;

Line 2620: FND_MSG_PUB.Count_And_Get

2616: ( G_PKG_NAME,
2617: l_api_name||'('||l_stmt_num||')'
2618: );
2619: END IF;
2620: FND_MSG_PUB.Count_And_Get
2621: ( p_count => x_msg_count,
2622: p_data => x_msg_data
2623: );
2624:

Line 2685: FND_MSG_PUB.initialize;

2681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2682: END IF;
2683: -- Initialize message list if p_init_msg_list is set to TRUE.
2684: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2685: FND_MSG_PUB.initialize;
2686: END IF;
2687: -- Initialize API return status to success
2688: x_return_status := FND_API.G_RET_STS_SUCCESS;
2689: -- API body

Line 2766: FND_MSG_PUB.Count_And_Get

2762: --dbms_output.put_line('committing');
2763: COMMIT WORK;
2764: END IF;
2765: -- Standard call to get message count and if count is 1, get message info.
2766: FND_MSG_PUB.Count_And_Get
2767: ( p_count => x_msg_count ,
2768: p_data => x_msg_data
2769: );
2770: EXCEPTION

Line 2773: FND_MSG_PUB.Count_And_Get

2769: );
2770: EXCEPTION
2771: WHEN FND_API.G_EXC_ERROR THEN
2772: x_return_status := FND_API.G_RET_STS_ERROR ;
2773: FND_MSG_PUB.Count_And_Get
2774: ( p_count => x_msg_count ,
2775: p_data => x_msg_data
2776: );
2777:

Line 2781: FND_MSG_PUB.Count_And_Get

2777:
2778:
2779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2781: FND_MSG_PUB.Count_And_Get
2782: (
2783: p_count => x_msg_count,
2784: p_data => x_msg_data
2785: );

Line 2789: IF FND_MSG_PUB.Check_Msg_Level

2785: );
2786:
2787: WHEN OTHERS THEN
2788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2789: IF FND_MSG_PUB.Check_Msg_Level
2790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2791: THEN
2792: FND_MSG_PUB.Add_Exc_Msg
2793: ( G_PKG_NAME,

Line 2790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2786:
2787: WHEN OTHERS THEN
2788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2789: IF FND_MSG_PUB.Check_Msg_Level
2790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2791: THEN
2792: FND_MSG_PUB.Add_Exc_Msg
2793: ( G_PKG_NAME,
2794: l_api_name||'('||l_stmt_num||')'

Line 2792: FND_MSG_PUB.Add_Exc_Msg

2788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2789: IF FND_MSG_PUB.Check_Msg_Level
2790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2791: THEN
2792: FND_MSG_PUB.Add_Exc_Msg
2793: ( G_PKG_NAME,
2794: l_api_name||'('||l_stmt_num||')'
2795: );
2796: END IF;

Line 2797: FND_MSG_PUB.Count_And_Get

2793: ( G_PKG_NAME,
2794: l_api_name||'('||l_stmt_num||')'
2795: );
2796: END IF;
2797: FND_MSG_PUB.Count_And_Get
2798: ( p_count => x_msg_count,
2799: p_data => x_msg_data
2800: );
2801:

Line 2868: FND_MSG_PUB.initialize;

2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2865: END IF;
2866: -- Initialize message list if p_init_msg_list is set to TRUE.
2867: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2868: FND_MSG_PUB.initialize;
2869: END IF;
2870: -- Initialize API return status to success
2871: x_return_status := FND_API.G_RET_STS_SUCCESS;
2872: -- API body

Line 2933: FND_MSG_PUB.Add_Exc_Msg

2929: l_this_level_min_window := 1; -- Max possible Value is One Day
2930: l_next_level_min_window := 1; -- Max possible Value is One Day
2931: x_right_snap_window := 1; -- Max possible Value is One Day
2932: WHEN OTHERS THEN
2933: FND_MSG_PUB.Add_Exc_Msg
2934: ( G_PKG_NAME,
2935: l_api_name||'('||l_stmt_num||')'
2936: );
2937: END;

Line 2976: FND_MSG_PUB.Add_Exc_Msg

2972: WHEN NO_DATA_FOUND THEN
2973: --dbms_output.put_line('Inside Sibling NO DATA FOUND');
2974: l_min_right_snap_window := l_this_level_min_window;
2975: WHEN OTHERS THEN
2976: FND_MSG_PUB.Add_Exc_Msg
2977: ( G_PKG_NAME,
2978: l_api_name||'('||l_stmt_num||')'
2979: );
2980: END;

Line 3048: FND_MSG_PUB.Count_And_Get

3044: --dbms_output.put_line('committing');
3045: COMMIT WORK;
3046: END IF;
3047: -- Standard call to get message count and if count is 1, get message info.
3048: FND_MSG_PUB.Count_And_Get
3049: ( p_count => x_msg_count ,
3050: p_data => x_msg_data
3051: );
3052: EXCEPTION

Line 3055: FND_MSG_PUB.Count_And_Get

3051: );
3052: EXCEPTION
3053: WHEN FND_API.G_EXC_ERROR THEN
3054: x_return_status := FND_API.G_RET_STS_ERROR ;
3055: FND_MSG_PUB.Count_And_Get
3056: ( p_count => x_msg_count ,
3057: p_data => x_msg_data
3058: );
3059:

Line 3063: FND_MSG_PUB.Count_And_Get

3059:
3060:
3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3063: FND_MSG_PUB.Count_And_Get
3064: (
3065: p_count => x_msg_count,
3066: p_data => x_msg_data
3067: );

Line 3071: IF FND_MSG_PUB.Check_Msg_Level

3067: );
3068:
3069: WHEN OTHERS THEN
3070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3071: IF FND_MSG_PUB.Check_Msg_Level
3072: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3073: THEN
3074: FND_MSG_PUB.Add_Exc_Msg
3075: ( G_PKG_NAME,

Line 3072: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3068:
3069: WHEN OTHERS THEN
3070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3071: IF FND_MSG_PUB.Check_Msg_Level
3072: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3073: THEN
3074: FND_MSG_PUB.Add_Exc_Msg
3075: ( G_PKG_NAME,
3076: l_api_name||'('||l_stmt_num||')'

Line 3074: FND_MSG_PUB.Add_Exc_Msg

3070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3071: IF FND_MSG_PUB.Check_Msg_Level
3072: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3073: THEN
3074: FND_MSG_PUB.Add_Exc_Msg
3075: ( G_PKG_NAME,
3076: l_api_name||'('||l_stmt_num||')'
3077: );
3078: END IF;

Line 3079: FND_MSG_PUB.Count_And_Get

3075: ( G_PKG_NAME,
3076: l_api_name||'('||l_stmt_num||')'
3077: );
3078: END IF;
3079: FND_MSG_PUB.Count_And_Get
3080: ( p_count => x_msg_count,
3081: p_data => x_msg_data
3082: );
3083:

Line 3151: FND_MSG_PUB.initialize;

3147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3148: END IF;
3149: -- Initialize message list if p_init_msg_list is set to TRUE.
3150: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3151: FND_MSG_PUB.initialize;
3152: END IF;
3153: -- Initialize API return status to success
3154: x_return_status := FND_API.G_RET_STS_SUCCESS;
3155: -- API body

Line 3217: FND_MSG_PUB.Add_Exc_Msg

3213: l_this_level_min_window := 1; -- Max possible Value is One Day
3214: l_next_level_min_window := 1; -- Max possible Value is One Day
3215: x_left_snap_window := 1; -- Max possible Value is One Day
3216: WHEN OTHERS THEN
3217: FND_MSG_PUB.Add_Exc_Msg
3218: ( G_PKG_NAME,
3219: l_api_name||'('||l_stmt_num||')'
3220: );
3221: END;

Line 3259: FND_MSG_PUB.Add_Exc_Msg

3255: WHEN NO_DATA_FOUND THEN
3256: --dbms_output.put_line('Inside Sibling NO DATA FOUND');
3257: l_min_left_snap_window := l_this_level_min_window;
3258: WHEN OTHERS THEN
3259: FND_MSG_PUB.Add_Exc_Msg
3260: ( G_PKG_NAME,
3261: l_api_name||'('||l_stmt_num||')'
3262: );
3263: END;

Line 3329: FND_MSG_PUB.Count_And_Get

3325: --dbms_output.put_line('committing');
3326: COMMIT WORK;
3327: END IF;
3328: -- Standard call to get message count and if count is 1, get message info.
3329: FND_MSG_PUB.Count_And_Get
3330: ( p_count => x_msg_count ,
3331: p_data => x_msg_data
3332: );
3333: EXCEPTION

Line 3336: FND_MSG_PUB.Count_And_Get

3332: );
3333: EXCEPTION
3334: WHEN FND_API.G_EXC_ERROR THEN
3335: x_return_status := FND_API.G_RET_STS_ERROR ;
3336: FND_MSG_PUB.Count_And_Get
3337: ( p_count => x_msg_count ,
3338: p_data => x_msg_data
3339: );
3340:

Line 3344: FND_MSG_PUB.Count_And_Get

3340:
3341:
3342: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3344: FND_MSG_PUB.Count_And_Get
3345: (
3346: p_count => x_msg_count,
3347: p_data => x_msg_data
3348: );

Line 3352: IF FND_MSG_PUB.Check_Msg_Level

3348: );
3349:
3350: WHEN OTHERS THEN
3351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3352: IF FND_MSG_PUB.Check_Msg_Level
3353: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3354: THEN
3355: FND_MSG_PUB.Add_Exc_Msg
3356: ( G_PKG_NAME,

Line 3353: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3349:
3350: WHEN OTHERS THEN
3351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3352: IF FND_MSG_PUB.Check_Msg_Level
3353: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3354: THEN
3355: FND_MSG_PUB.Add_Exc_Msg
3356: ( G_PKG_NAME,
3357: l_api_name||'('||l_stmt_num||')'

Line 3355: FND_MSG_PUB.Add_Exc_Msg

3351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3352: IF FND_MSG_PUB.Check_Msg_Level
3353: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3354: THEN
3355: FND_MSG_PUB.Add_Exc_Msg
3356: ( G_PKG_NAME,
3357: l_api_name||'('||l_stmt_num||')'
3358: );
3359: END IF;

Line 3360: FND_MSG_PUB.Count_And_Get

3356: ( G_PKG_NAME,
3357: l_api_name||'('||l_stmt_num||')'
3358: );
3359: END IF;
3360: FND_MSG_PUB.Count_And_Get
3361: ( p_count => x_msg_count,
3362: p_data => x_msg_data
3363: );
3364:

Line 3444: FND_MSG_PUB.initialize;

3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3441: END IF;
3442: -- Initialize message list if p_init_msg_list is set to TRUE.
3443: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3444: FND_MSG_PUB.initialize;
3445: END IF;
3446: -- Initialize API return status to success
3447: x_return_status := FND_API.G_RET_STS_SUCCESS;
3448: -- API body

Line 3579: FND_MSG_PUB.Count_And_Get

3575: --dbms_output.put_line('committing');
3576: COMMIT WORK;
3577: END IF;
3578: -- Standard call to get message count and if count is 1, get message info.
3579: FND_MSG_PUB.Count_And_Get
3580: ( p_count => x_msg_count ,
3581: p_data => x_msg_data
3582: );
3583: EXCEPTION

Line 3586: FND_MSG_PUB.Count_And_Get

3582: );
3583: EXCEPTION
3584: WHEN FND_API.G_EXC_ERROR THEN
3585: x_return_status := FND_API.G_RET_STS_ERROR ;
3586: FND_MSG_PUB.Count_And_Get
3587: ( p_count => x_msg_count ,
3588: p_data => x_msg_data
3589: );
3590:

Line 3595: FND_MSG_PUB.Count_And_Get

3591: RETURN;
3592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3593:
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3595: FND_MSG_PUB.Count_And_Get
3596: (
3597: p_count => x_msg_count,
3598: p_data => x_msg_data
3599: );

Line 3604: IF FND_MSG_PUB.Check_Msg_Level

3600:
3601: RETURN;
3602: WHEN OTHERS THEN
3603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3604: IF FND_MSG_PUB.Check_Msg_Level
3605: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3606: THEN
3607: FND_MSG_PUB.Add_Exc_Msg
3608: ( G_PKG_NAME,

Line 3605: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3601: RETURN;
3602: WHEN OTHERS THEN
3603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3604: IF FND_MSG_PUB.Check_Msg_Level
3605: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3606: THEN
3607: FND_MSG_PUB.Add_Exc_Msg
3608: ( G_PKG_NAME,
3609: l_api_name||'('||l_stmt_num||')'

Line 3607: FND_MSG_PUB.Add_Exc_Msg

3603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3604: IF FND_MSG_PUB.Check_Msg_Level
3605: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3606: THEN
3607: FND_MSG_PUB.Add_Exc_Msg
3608: ( G_PKG_NAME,
3609: l_api_name||'('||l_stmt_num||')'
3610: );
3611: END IF;

Line 3612: FND_MSG_PUB.Count_And_Get

3608: ( G_PKG_NAME,
3609: l_api_name||'('||l_stmt_num||')'
3610: );
3611: END IF;
3612: FND_MSG_PUB.Count_And_Get
3613: ( p_count => x_msg_count,
3614: p_data => x_msg_data
3615: );
3616:

Line 3698: FND_MSG_PUB.initialize;

3694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3695: END IF;
3696: -- Initialize message list if p_init_msg_list is set to TRUE.
3697: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3698: FND_MSG_PUB.initialize;
3699: END IF;
3700: -- Initialize API return status to success
3701: x_return_status := FND_API.G_RET_STS_SUCCESS;
3702: -- API body

Line 3834: FND_MSG_PUB.Count_And_Get

3830: --dbms_output.put_line('committing');
3831: COMMIT WORK;
3832: END IF;
3833: -- Standard call to get message count and if count is 1, get message info.
3834: FND_MSG_PUB.Count_And_Get
3835: ( p_count => x_msg_count ,
3836: p_data => x_msg_data
3837: );
3838: EXCEPTION

Line 3841: FND_MSG_PUB.Count_And_Get

3837: );
3838: EXCEPTION
3839: WHEN FND_API.G_EXC_ERROR THEN
3840: x_return_status := FND_API.G_RET_STS_ERROR ;
3841: FND_MSG_PUB.Count_And_Get
3842: ( p_count => x_msg_count ,
3843: p_data => x_msg_data
3844: );
3845:

Line 3850: FND_MSG_PUB.Count_And_Get

3846: RETURN;
3847: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3848:
3849: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3850: FND_MSG_PUB.Count_And_Get
3851: (
3852: p_count => x_msg_count,
3853: p_data => x_msg_data
3854: );

Line 3859: IF FND_MSG_PUB.Check_Msg_Level

3855:
3856: RETURN;
3857: WHEN OTHERS THEN
3858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3859: IF FND_MSG_PUB.Check_Msg_Level
3860: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3861: THEN
3862: FND_MSG_PUB.Add_Exc_Msg
3863: ( G_PKG_NAME,

Line 3860: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3856: RETURN;
3857: WHEN OTHERS THEN
3858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3859: IF FND_MSG_PUB.Check_Msg_Level
3860: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3861: THEN
3862: FND_MSG_PUB.Add_Exc_Msg
3863: ( G_PKG_NAME,
3864: l_api_name||'('||l_stmt_num||')'

Line 3862: FND_MSG_PUB.Add_Exc_Msg

3858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3859: IF FND_MSG_PUB.Check_Msg_Level
3860: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3861: THEN
3862: FND_MSG_PUB.Add_Exc_Msg
3863: ( G_PKG_NAME,
3864: l_api_name||'('||l_stmt_num||')'
3865: );
3866: END IF;

Line 3867: FND_MSG_PUB.Count_And_Get

3863: ( G_PKG_NAME,
3864: l_api_name||'('||l_stmt_num||')'
3865: );
3866: END IF;
3867: FND_MSG_PUB.Count_And_Get
3868: ( p_count => x_msg_count,
3869: p_data => x_msg_data
3870: );
3871: