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

2478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2479: END IF;
2480: -- Initialize message list if p_init_msg_list is set to TRUE.
2481: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2482: FND_MSG_PUB.initialize;
2483: END IF;
2484: -- Initialize API return status to success
2485: x_return_status := FND_API.G_RET_STS_SUCCESS;
2486: -- API body

Line 2562: FND_MSG_PUB.Count_And_Get

2558: --dbms_output.put_line('committing');
2559: COMMIT WORK;
2560: END IF;
2561: -- Standard call to get message count and if count is 1, get message info.
2562: FND_MSG_PUB.Count_And_Get
2563: ( p_count => x_msg_count ,
2564: p_data => x_msg_data
2565: );
2566: EXCEPTION

Line 2569: FND_MSG_PUB.Count_And_Get

2565: );
2566: EXCEPTION
2567: WHEN FND_API.G_EXC_ERROR THEN
2568: x_return_status := FND_API.G_RET_STS_ERROR ;
2569: FND_MSG_PUB.Count_And_Get
2570: ( p_count => x_msg_count ,
2571: p_data => x_msg_data
2572: );
2573:

Line 2577: FND_MSG_PUB.Count_And_Get

2573:
2574:
2575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2577: FND_MSG_PUB.Count_And_Get
2578: (
2579: p_count => x_msg_count,
2580: p_data => x_msg_data
2581: );

Line 2585: IF FND_MSG_PUB.Check_Msg_Level

2581: );
2582:
2583: WHEN OTHERS THEN
2584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2585: IF FND_MSG_PUB.Check_Msg_Level
2586: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2587: THEN
2588: FND_MSG_PUB.Add_Exc_Msg
2589: ( G_PKG_NAME,

Line 2586: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2582:
2583: WHEN OTHERS THEN
2584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2585: IF FND_MSG_PUB.Check_Msg_Level
2586: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2587: THEN
2588: FND_MSG_PUB.Add_Exc_Msg
2589: ( G_PKG_NAME,
2590: l_api_name||'('||l_stmt_num||')'

Line 2588: FND_MSG_PUB.Add_Exc_Msg

2584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2585: IF FND_MSG_PUB.Check_Msg_Level
2586: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2587: THEN
2588: FND_MSG_PUB.Add_Exc_Msg
2589: ( G_PKG_NAME,
2590: l_api_name||'('||l_stmt_num||')'
2591: );
2592: END IF;

Line 2593: FND_MSG_PUB.Count_And_Get

2589: ( G_PKG_NAME,
2590: l_api_name||'('||l_stmt_num||')'
2591: );
2592: END IF;
2593: FND_MSG_PUB.Count_And_Get
2594: ( p_count => x_msg_count,
2595: p_data => x_msg_data
2596: );
2597:

Line 2658: FND_MSG_PUB.initialize;

2654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2655: END IF;
2656: -- Initialize message list if p_init_msg_list is set to TRUE.
2657: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2658: FND_MSG_PUB.initialize;
2659: END IF;
2660: -- Initialize API return status to success
2661: x_return_status := FND_API.G_RET_STS_SUCCESS;
2662: -- API body

Line 2739: FND_MSG_PUB.Count_And_Get

2735: --dbms_output.put_line('committing');
2736: COMMIT WORK;
2737: END IF;
2738: -- Standard call to get message count and if count is 1, get message info.
2739: FND_MSG_PUB.Count_And_Get
2740: ( p_count => x_msg_count ,
2741: p_data => x_msg_data
2742: );
2743: EXCEPTION

Line 2746: FND_MSG_PUB.Count_And_Get

2742: );
2743: EXCEPTION
2744: WHEN FND_API.G_EXC_ERROR THEN
2745: x_return_status := FND_API.G_RET_STS_ERROR ;
2746: FND_MSG_PUB.Count_And_Get
2747: ( p_count => x_msg_count ,
2748: p_data => x_msg_data
2749: );
2750:

Line 2754: FND_MSG_PUB.Count_And_Get

2750:
2751:
2752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2754: FND_MSG_PUB.Count_And_Get
2755: (
2756: p_count => x_msg_count,
2757: p_data => x_msg_data
2758: );

Line 2762: IF FND_MSG_PUB.Check_Msg_Level

2758: );
2759:
2760: WHEN OTHERS THEN
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2762: IF FND_MSG_PUB.Check_Msg_Level
2763: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2764: THEN
2765: FND_MSG_PUB.Add_Exc_Msg
2766: ( G_PKG_NAME,

Line 2763: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2759:
2760: WHEN OTHERS THEN
2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2762: IF FND_MSG_PUB.Check_Msg_Level
2763: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2764: THEN
2765: FND_MSG_PUB.Add_Exc_Msg
2766: ( G_PKG_NAME,
2767: l_api_name||'('||l_stmt_num||')'

Line 2765: FND_MSG_PUB.Add_Exc_Msg

2761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2762: IF FND_MSG_PUB.Check_Msg_Level
2763: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2764: THEN
2765: FND_MSG_PUB.Add_Exc_Msg
2766: ( G_PKG_NAME,
2767: l_api_name||'('||l_stmt_num||')'
2768: );
2769: END IF;

Line 2770: FND_MSG_PUB.Count_And_Get

2766: ( G_PKG_NAME,
2767: l_api_name||'('||l_stmt_num||')'
2768: );
2769: END IF;
2770: FND_MSG_PUB.Count_And_Get
2771: ( p_count => x_msg_count,
2772: p_data => x_msg_data
2773: );
2774:

Line 2841: FND_MSG_PUB.initialize;

2837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2838: END IF;
2839: -- Initialize message list if p_init_msg_list is set to TRUE.
2840: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2841: FND_MSG_PUB.initialize;
2842: END IF;
2843: -- Initialize API return status to success
2844: x_return_status := FND_API.G_RET_STS_SUCCESS;
2845: -- API body

Line 2906: FND_MSG_PUB.Add_Exc_Msg

2902: l_this_level_min_window := 1; -- Max possible Value is One Day
2903: l_next_level_min_window := 1; -- Max possible Value is One Day
2904: x_right_snap_window := 1; -- Max possible Value is One Day
2905: WHEN OTHERS THEN
2906: FND_MSG_PUB.Add_Exc_Msg
2907: ( G_PKG_NAME,
2908: l_api_name||'('||l_stmt_num||')'
2909: );
2910: END;

Line 2949: FND_MSG_PUB.Add_Exc_Msg

2945: WHEN NO_DATA_FOUND THEN
2946: --dbms_output.put_line('Inside Sibling NO DATA FOUND');
2947: l_min_right_snap_window := l_this_level_min_window;
2948: WHEN OTHERS THEN
2949: FND_MSG_PUB.Add_Exc_Msg
2950: ( G_PKG_NAME,
2951: l_api_name||'('||l_stmt_num||')'
2952: );
2953: END;

Line 3021: FND_MSG_PUB.Count_And_Get

3017: --dbms_output.put_line('committing');
3018: COMMIT WORK;
3019: END IF;
3020: -- Standard call to get message count and if count is 1, get message info.
3021: FND_MSG_PUB.Count_And_Get
3022: ( p_count => x_msg_count ,
3023: p_data => x_msg_data
3024: );
3025: EXCEPTION

Line 3028: FND_MSG_PUB.Count_And_Get

3024: );
3025: EXCEPTION
3026: WHEN FND_API.G_EXC_ERROR THEN
3027: x_return_status := FND_API.G_RET_STS_ERROR ;
3028: FND_MSG_PUB.Count_And_Get
3029: ( p_count => x_msg_count ,
3030: p_data => x_msg_data
3031: );
3032:

Line 3036: FND_MSG_PUB.Count_And_Get

3032:
3033:
3034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3036: FND_MSG_PUB.Count_And_Get
3037: (
3038: p_count => x_msg_count,
3039: p_data => x_msg_data
3040: );

Line 3044: IF FND_MSG_PUB.Check_Msg_Level

3040: );
3041:
3042: WHEN OTHERS THEN
3043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3044: IF FND_MSG_PUB.Check_Msg_Level
3045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3046: THEN
3047: FND_MSG_PUB.Add_Exc_Msg
3048: ( G_PKG_NAME,

Line 3045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3041:
3042: WHEN OTHERS THEN
3043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3044: IF FND_MSG_PUB.Check_Msg_Level
3045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3046: THEN
3047: FND_MSG_PUB.Add_Exc_Msg
3048: ( G_PKG_NAME,
3049: l_api_name||'('||l_stmt_num||')'

Line 3047: FND_MSG_PUB.Add_Exc_Msg

3043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3044: IF FND_MSG_PUB.Check_Msg_Level
3045: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3046: THEN
3047: FND_MSG_PUB.Add_Exc_Msg
3048: ( G_PKG_NAME,
3049: l_api_name||'('||l_stmt_num||')'
3050: );
3051: END IF;

Line 3052: FND_MSG_PUB.Count_And_Get

3048: ( G_PKG_NAME,
3049: l_api_name||'('||l_stmt_num||')'
3050: );
3051: END IF;
3052: FND_MSG_PUB.Count_And_Get
3053: ( p_count => x_msg_count,
3054: p_data => x_msg_data
3055: );
3056:

Line 3124: FND_MSG_PUB.initialize;

3120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3121: END IF;
3122: -- Initialize message list if p_init_msg_list is set to TRUE.
3123: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3124: FND_MSG_PUB.initialize;
3125: END IF;
3126: -- Initialize API return status to success
3127: x_return_status := FND_API.G_RET_STS_SUCCESS;
3128: -- API body

Line 3190: FND_MSG_PUB.Add_Exc_Msg

3186: l_this_level_min_window := 1; -- Max possible Value is One Day
3187: l_next_level_min_window := 1; -- Max possible Value is One Day
3188: x_left_snap_window := 1; -- Max possible Value is One Day
3189: WHEN OTHERS THEN
3190: FND_MSG_PUB.Add_Exc_Msg
3191: ( G_PKG_NAME,
3192: l_api_name||'('||l_stmt_num||')'
3193: );
3194: END;

Line 3232: FND_MSG_PUB.Add_Exc_Msg

3228: WHEN NO_DATA_FOUND THEN
3229: --dbms_output.put_line('Inside Sibling NO DATA FOUND');
3230: l_min_left_snap_window := l_this_level_min_window;
3231: WHEN OTHERS THEN
3232: FND_MSG_PUB.Add_Exc_Msg
3233: ( G_PKG_NAME,
3234: l_api_name||'('||l_stmt_num||')'
3235: );
3236: END;

Line 3302: FND_MSG_PUB.Count_And_Get

3298: --dbms_output.put_line('committing');
3299: COMMIT WORK;
3300: END IF;
3301: -- Standard call to get message count and if count is 1, get message info.
3302: FND_MSG_PUB.Count_And_Get
3303: ( p_count => x_msg_count ,
3304: p_data => x_msg_data
3305: );
3306: EXCEPTION

Line 3309: FND_MSG_PUB.Count_And_Get

3305: );
3306: EXCEPTION
3307: WHEN FND_API.G_EXC_ERROR THEN
3308: x_return_status := FND_API.G_RET_STS_ERROR ;
3309: FND_MSG_PUB.Count_And_Get
3310: ( p_count => x_msg_count ,
3311: p_data => x_msg_data
3312: );
3313:

Line 3317: FND_MSG_PUB.Count_And_Get

3313:
3314:
3315: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3317: FND_MSG_PUB.Count_And_Get
3318: (
3319: p_count => x_msg_count,
3320: p_data => x_msg_data
3321: );

Line 3325: IF FND_MSG_PUB.Check_Msg_Level

3321: );
3322:
3323: WHEN OTHERS THEN
3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3325: IF FND_MSG_PUB.Check_Msg_Level
3326: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3327: THEN
3328: FND_MSG_PUB.Add_Exc_Msg
3329: ( G_PKG_NAME,

Line 3326: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3322:
3323: WHEN OTHERS THEN
3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3325: IF FND_MSG_PUB.Check_Msg_Level
3326: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3327: THEN
3328: FND_MSG_PUB.Add_Exc_Msg
3329: ( G_PKG_NAME,
3330: l_api_name||'('||l_stmt_num||')'

Line 3328: FND_MSG_PUB.Add_Exc_Msg

3324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3325: IF FND_MSG_PUB.Check_Msg_Level
3326: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3327: THEN
3328: FND_MSG_PUB.Add_Exc_Msg
3329: ( G_PKG_NAME,
3330: l_api_name||'('||l_stmt_num||')'
3331: );
3332: END IF;

Line 3333: FND_MSG_PUB.Count_And_Get

3329: ( G_PKG_NAME,
3330: l_api_name||'('||l_stmt_num||')'
3331: );
3332: END IF;
3333: FND_MSG_PUB.Count_And_Get
3334: ( p_count => x_msg_count,
3335: p_data => x_msg_data
3336: );
3337:

Line 3417: FND_MSG_PUB.initialize;

3413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3414: END IF;
3415: -- Initialize message list if p_init_msg_list is set to TRUE.
3416: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3417: FND_MSG_PUB.initialize;
3418: END IF;
3419: -- Initialize API return status to success
3420: x_return_status := FND_API.G_RET_STS_SUCCESS;
3421: -- API body

Line 3552: FND_MSG_PUB.Count_And_Get

3548: --dbms_output.put_line('committing');
3549: COMMIT WORK;
3550: END IF;
3551: -- Standard call to get message count and if count is 1, get message info.
3552: FND_MSG_PUB.Count_And_Get
3553: ( p_count => x_msg_count ,
3554: p_data => x_msg_data
3555: );
3556: EXCEPTION

Line 3559: FND_MSG_PUB.Count_And_Get

3555: );
3556: EXCEPTION
3557: WHEN FND_API.G_EXC_ERROR THEN
3558: x_return_status := FND_API.G_RET_STS_ERROR ;
3559: FND_MSG_PUB.Count_And_Get
3560: ( p_count => x_msg_count ,
3561: p_data => x_msg_data
3562: );
3563:

Line 3568: FND_MSG_PUB.Count_And_Get

3564: RETURN;
3565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3566:
3567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3568: FND_MSG_PUB.Count_And_Get
3569: (
3570: p_count => x_msg_count,
3571: p_data => x_msg_data
3572: );

Line 3577: IF FND_MSG_PUB.Check_Msg_Level

3573:
3574: RETURN;
3575: WHEN OTHERS THEN
3576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3577: IF FND_MSG_PUB.Check_Msg_Level
3578: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3579: THEN
3580: FND_MSG_PUB.Add_Exc_Msg
3581: ( G_PKG_NAME,

Line 3578: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3574: RETURN;
3575: WHEN OTHERS THEN
3576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3577: IF FND_MSG_PUB.Check_Msg_Level
3578: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3579: THEN
3580: FND_MSG_PUB.Add_Exc_Msg
3581: ( G_PKG_NAME,
3582: l_api_name||'('||l_stmt_num||')'

Line 3580: FND_MSG_PUB.Add_Exc_Msg

3576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3577: IF FND_MSG_PUB.Check_Msg_Level
3578: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3579: THEN
3580: FND_MSG_PUB.Add_Exc_Msg
3581: ( G_PKG_NAME,
3582: l_api_name||'('||l_stmt_num||')'
3583: );
3584: END IF;

Line 3585: FND_MSG_PUB.Count_And_Get

3581: ( G_PKG_NAME,
3582: l_api_name||'('||l_stmt_num||')'
3583: );
3584: END IF;
3585: FND_MSG_PUB.Count_And_Get
3586: ( p_count => x_msg_count,
3587: p_data => x_msg_data
3588: );
3589:

Line 3671: FND_MSG_PUB.initialize;

3667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3668: END IF;
3669: -- Initialize message list if p_init_msg_list is set to TRUE.
3670: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3671: FND_MSG_PUB.initialize;
3672: END IF;
3673: -- Initialize API return status to success
3674: x_return_status := FND_API.G_RET_STS_SUCCESS;
3675: -- API body

Line 3807: FND_MSG_PUB.Count_And_Get

3803: --dbms_output.put_line('committing');
3804: COMMIT WORK;
3805: END IF;
3806: -- Standard call to get message count and if count is 1, get message info.
3807: FND_MSG_PUB.Count_And_Get
3808: ( p_count => x_msg_count ,
3809: p_data => x_msg_data
3810: );
3811: EXCEPTION

Line 3814: FND_MSG_PUB.Count_And_Get

3810: );
3811: EXCEPTION
3812: WHEN FND_API.G_EXC_ERROR THEN
3813: x_return_status := FND_API.G_RET_STS_ERROR ;
3814: FND_MSG_PUB.Count_And_Get
3815: ( p_count => x_msg_count ,
3816: p_data => x_msg_data
3817: );
3818:

Line 3823: FND_MSG_PUB.Count_And_Get

3819: RETURN;
3820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3821:
3822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3823: FND_MSG_PUB.Count_And_Get
3824: (
3825: p_count => x_msg_count,
3826: p_data => x_msg_data
3827: );

Line 3832: IF FND_MSG_PUB.Check_Msg_Level

3828:
3829: RETURN;
3830: WHEN OTHERS THEN
3831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3832: IF FND_MSG_PUB.Check_Msg_Level
3833: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3834: THEN
3835: FND_MSG_PUB.Add_Exc_Msg
3836: ( G_PKG_NAME,

Line 3833: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3829: RETURN;
3830: WHEN OTHERS THEN
3831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3832: IF FND_MSG_PUB.Check_Msg_Level
3833: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3834: THEN
3835: FND_MSG_PUB.Add_Exc_Msg
3836: ( G_PKG_NAME,
3837: l_api_name||'('||l_stmt_num||')'

Line 3835: FND_MSG_PUB.Add_Exc_Msg

3831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3832: IF FND_MSG_PUB.Check_Msg_Level
3833: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3834: THEN
3835: FND_MSG_PUB.Add_Exc_Msg
3836: ( G_PKG_NAME,
3837: l_api_name||'('||l_stmt_num||')'
3838: );
3839: END IF;

Line 3840: FND_MSG_PUB.Count_And_Get

3836: ( G_PKG_NAME,
3837: l_api_name||'('||l_stmt_num||')'
3838: );
3839: END IF;
3840: FND_MSG_PUB.Count_And_Get
3841: ( p_count => x_msg_count,
3842: p_data => x_msg_data
3843: );
3844: