DBA Data[Home] [Help]

APPS.ZPB_AC_OPS dependencies on FND_MSG_PUB

Line 2280: FND_MSG_PUB.ADD;

2276:
2277: IF lock_val <> lock_val_in THEN
2278: FND_MESSAGE.SET_NAME('ZPB', 'ZPB_BUS_PROC_LOCKED');
2279: x_msg_data := 'ZPB_BUS_PROC_LOCKED';
2280: FND_MSG_PUB.ADD;
2281: RAISE FND_API.G_EXC_ERROR;
2282: END IF;
2283: END IF;
2284: SELECT *

Line 2324: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

2320: EXCEPTION
2321: WHEN FND_API.G_EXC_ERROR THEN
2322: x_return_status := FND_API.G_RET_STS_ERROR;
2323: editable_ac_id_out := null;
2324: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2325: p_data => msg_data );
2326: IF lock_cursor%ISOPEN THEN
2327: CLOSE lock_cursor;
2328: END IF;

Line 2720: FND_MSG_PUB.initialize;

2716: END IF;
2717:
2718: -- Initialize message list if p_init_msg_list is set to TRUE.
2719: IF FND_API.to_Boolean(p_init_msg_list) THEN
2720: FND_MSG_PUB.initialize;
2721: END IF;
2722:
2723: -- Initialize API return status to success
2724: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2896: FND_MSG_PUB.Count_And_Get(

2892: IF FND_API.To_Boolean( p_commit ) THEN
2893: COMMIT WORK;
2894: END IF;
2895: -- Standard call to get message count and if count is 1, get message info.
2896: FND_MSG_PUB.Count_And_Get(
2897: p_count => x_msg_count,
2898: p_data => x_msg_data
2899: );
2900:

Line 2936: FND_MSG_PUB.Count_And_Get(

2932: x_return_status := FND_API.G_RET_STS_ERROR;
2933: WHEN FND_API.G_EXC_ERROR THEN
2934: ROLLBACK TO create_partial_cycle;
2935: x_return_status := FND_API.G_RET_STS_ERROR;
2936: FND_MSG_PUB.Count_And_Get(
2937: p_count => x_msg_count,
2938: p_data => x_msg_data
2939: );
2940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2943: FND_MSG_PUB.Count_And_Get(

2939: );
2940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2941: ROLLBACK TO create_partial_cycle;
2942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2943: FND_MSG_PUB.Count_And_Get(
2944: p_count => x_msg_count,
2945: p_data => x_msg_data
2946: );
2947: WHEN OTHERS THEN

Line 2951: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2947: WHEN OTHERS THEN
2948: ROLLBACK TO create_partial_cycle;
2949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2950: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2951: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2952: FND_MSG_PUB.Add_Exc_Msg(
2953: G_PKG_NAME,
2954: l_api_name
2955: );

Line 2952: FND_MSG_PUB.Add_Exc_Msg(

2948: ROLLBACK TO create_partial_cycle;
2949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2950: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
2951: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2952: FND_MSG_PUB.Add_Exc_Msg(
2953: G_PKG_NAME,
2954: l_api_name
2955: );
2956: END IF;

Line 2957: FND_MSG_PUB.Count_And_Get(

2953: G_PKG_NAME,
2954: l_api_name
2955: );
2956: END IF;
2957: FND_MSG_PUB.Count_And_Get(
2958: p_count => x_msg_count,
2959: p_data => x_msg_data
2960: );
2961: end create_partial_cycle;

Line 3165: FND_MSG_PUB.initialize;

3161: END IF;
3162:
3163: -- Initialize message list if p_init_msg_list is set to TRUE.
3164: IF FND_API.to_Boolean(p_init_msg_list) THEN
3165: FND_MSG_PUB.initialize;
3166: END IF;
3167:
3168: -- Initialize API return status to success
3169: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3248: FND_MSG_PUB.Count_And_Get(

3244: IF FND_API.To_Boolean( p_commit ) THEN
3245: COMMIT WORK;
3246: END IF;
3247: -- Standard call to get message count and if count is 1, get message info.
3248: FND_MSG_PUB.Count_And_Get(
3249: p_count => x_msg_count,
3250: p_data => x_msg_data
3251: );
3252:

Line 3267: FND_MSG_PUB.Count_And_Get(

3263: x_return_status := FND_API.G_RET_STS_ERROR;
3264: WHEN FND_API.G_EXC_ERROR THEN
3265: ROLLBACK TO create_migrate_inst;
3266: x_return_status := FND_API.G_RET_STS_ERROR;
3267: FND_MSG_PUB.Count_And_Get(
3268: p_count => x_msg_count,
3269: p_data => x_msg_data
3270: );
3271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3274: FND_MSG_PUB.Count_And_Get(

3270: );
3271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3272: ROLLBACK TO create_migrate_inst;
3273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3274: FND_MSG_PUB.Count_And_Get(
3275: p_count => x_msg_count,
3276: p_data => x_msg_data
3277: );
3278: WHEN OTHERS THEN

Line 3282: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3278: WHEN OTHERS THEN
3279: ROLLBACK TO create_migrate_inst;
3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3281: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
3282: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3283: FND_MSG_PUB.Add_Exc_Msg(
3284: G_PKG_NAME,
3285: l_api_name
3286: );

Line 3283: FND_MSG_PUB.Add_Exc_Msg(

3279: ROLLBACK TO create_migrate_inst;
3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3281: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'|| substr(sqlerrm,1,90));
3282: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3283: FND_MSG_PUB.Add_Exc_Msg(
3284: G_PKG_NAME,
3285: l_api_name
3286: );
3287: END IF;

Line 3288: FND_MSG_PUB.Count_And_Get(

3284: G_PKG_NAME,
3285: l_api_name
3286: );
3287: END IF;
3288: FND_MSG_PUB.Count_And_Get(
3289: p_count => x_msg_count,
3290: p_data => x_msg_data
3291: );
3292: end create_migrate_inst;

Line 3393: FND_MSG_PUB.initialize;

3389: END IF;
3390:
3391: -- Initialize message list if p_init_msg_list is set to TRUE.
3392: IF FND_API.to_Boolean(p_init_msg_list) THEN
3393: FND_MSG_PUB.initialize;
3394: END IF;
3395:
3396: -- Initialize API return status to success
3397: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3549: FND_MSG_PUB.Count_And_Get(

3545: THEN
3546: NULL;
3547: ROLLBACK TO Create_Hier_Order;
3548: x_return_status := FND_API.G_RET_STS_ERROR;
3549: FND_MSG_PUB.Count_And_Get(
3550: p_count => x_msg_count,
3551: p_data => x_msg_data
3552: );
3553:

Line 3558: FND_MSG_PUB.Count_And_Get(

3554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3555: THEN
3556: ROLLBACK TO Create_Hier_Order;
3557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3558: FND_MSG_PUB.Count_And_Get(
3559: p_count => x_msg_count,
3560: p_data => x_msg_data
3561: );
3562:

Line 3569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3565: ROLLBACK TO Create_Hier_Order;
3566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3567: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'
3568: || substr(sqlerrm,1,90));
3569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3570: THEN
3571: FND_MSG_PUB.Add_Exc_Msg(
3572: G_PKG_NAME,
3573: l_api_name

Line 3571: FND_MSG_PUB.Add_Exc_Msg(

3567: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'
3568: || substr(sqlerrm,1,90));
3569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3570: THEN
3571: FND_MSG_PUB.Add_Exc_Msg(
3572: G_PKG_NAME,
3573: l_api_name
3574: );
3575: END IF;

Line 3576: FND_MSG_PUB.Count_And_Get(

3572: G_PKG_NAME,
3573: l_api_name
3574: );
3575: END IF;
3576: FND_MSG_PUB.Count_And_Get(
3577: p_count => x_msg_count,
3578: p_data => x_msg_data
3579: );
3580: END Create_Hier_Order;

Line 3616: FND_MSG_PUB.initialize;

3612: END IF;
3613:
3614: -- Initialize message list if p_init_msg_list is set to TRUE.
3615: IF FND_API.to_Boolean(p_init_msg_list) THEN
3616: FND_MSG_PUB.initialize;
3617: END IF;
3618:
3619: -- Initialize API return status to success
3620: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3647: FND_MSG_PUB.Count_And_Get(

3643:
3644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
3645: THEN
3646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3647: FND_MSG_PUB.Count_And_Get(
3648: p_count => x_msg_count,
3649: p_data => x_msg_data
3650: );
3651:

Line 3657: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3653: THEN
3654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3655: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'
3656: || substr(sqlerrm,1,90));
3657: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3658: THEN
3659: FND_MSG_PUB.Add_Exc_Msg(
3660: G_PKG_NAME,
3661: l_api_name

Line 3659: FND_MSG_PUB.Add_Exc_Msg(

3655: zpb_log.write_event(G_PKG_NAME||'.'||l_api_name,to_char(sqlcode) ||':'
3656: || substr(sqlerrm,1,90));
3657: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3658: THEN
3659: FND_MSG_PUB.Add_Exc_Msg(
3660: G_PKG_NAME,
3661: l_api_name
3662: );
3663: END IF;

Line 3664: FND_MSG_PUB.Count_And_Get(

3660: G_PKG_NAME,
3661: l_api_name
3662: );
3663: END IF;
3664: FND_MSG_PUB.Count_And_Get(
3665: p_count => x_msg_count,
3666: p_data => x_msg_data
3667: );
3668: