DBA Data[Home] [Help]

APPS.CTO_UTILITY_PK dependencies on FND_MSG_PUB

Line 90: | to call the fnd_msg_pub.count_and_get and

86: | changed completely. The FND_MESSAGE.SET_NAME
87: | needs to be called twice in all the error handling
88: | exception. And there should be one add for OE and
89: | one add for FND. IN the exception block we need
90: | to call the fnd_msg_pub.count_and_get and
91: | oe_msg_pub.count_and_get.
92: |
93: |
94: | Modified on 13-NOV-2001 By Renga Kannan

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

411: IF PG_DEBUG <> 0 THEN
412: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::others::'||lStmtNumber||sqlerrm,1);
413: END IF;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
416: FND_MSG_PUB.Add_Exc_Msg
417: (G_PKG_NAME
418: ,'populate_src_orgs'
419: );

Line 416: FND_MSG_PUB.Add_Exc_Msg

412: oe_debug_pub.add('populate_plan_level: ' || 'Populate_Src_Orgs::others::'||lStmtNumber||sqlerrm,1);
413: END IF;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
416: FND_MSG_PUB.Add_Exc_Msg
417: (G_PKG_NAME
418: ,'populate_src_orgs'
419: );
420: END IF;

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

1558: IF PG_DEBUG <> 0 THEN
1559: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::others::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1560: END IF;
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1562: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1563: FND_MSG_PUB.Add_Exc_Msg
1564: (G_PKG_NAME
1565: ,'Get_All_Item_Orgs'
1566: );

Line 1563: FND_MSG_PUB.Add_Exc_Msg

1559: oe_debug_pub.add('populate_plan_level: ' || 'Get_All_item_orgs::others::'||to_char(lStmtNumber)||'::'||sqlerrm,1);
1560: END IF;
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1562: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1563: FND_MSG_PUB.Add_Exc_Msg
1564: (G_PKG_NAME
1565: ,'Get_All_Item_Orgs'
1566: );
1567: END IF;

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

2074: IF PG_DEBUG <> 0 THEN
2075: oe_debug_pub.add('populate_plan_level: ' || 'Create_Src_Rules::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
2076: END IF;
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2078: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2079: FND_MSG_PUB.Add_Exc_Msg
2080: (G_PKG_NAME
2081: ,'Create_Sourcing_Rules'
2082: );

Line 2079: FND_MSG_PUB.Add_Exc_Msg

2075: oe_debug_pub.add('populate_plan_level: ' || 'Create_Src_Rules::others::'||to_char(lStmtNum)||'::'||sqlerrm,1);
2076: END IF;
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2078: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2079: FND_MSG_PUB.Add_Exc_Msg
2080: (G_PKG_NAME
2081: ,'Create_Sourcing_Rules'
2082: );
2083: END IF;

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

2935: IF PG_DEBUG <> 0 THEN
2936: oe_debug_pub.add('populate_bcol: ' || 'populate_Bcol::others::'|| v_step ||'::'||sqlerrm , 1 );
2937: END IF;
2938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2939: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2940: FND_MSG_PUB.Add_Exc_Msg
2941: (G_PKG_NAME
2942: ,'populate_bcol'
2943: );

Line 2940: FND_MSG_PUB.Add_Exc_Msg

2936: oe_debug_pub.add('populate_bcol: ' || 'populate_Bcol::others::'|| v_step ||'::'||sqlerrm , 1 );
2937: END IF;
2938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2939: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2940: FND_MSG_PUB.Add_Exc_Msg
2941: (G_PKG_NAME
2942: ,'populate_bcol'
2943: );
2944: END IF;

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

3699: oe_debug_pub.add('get_model_sourcing_org: ' || 'GET_MODEL_SOURCING_ORG::others::'||to_char(l_stmt_num)||'::'||sqlerrm,1);
3700: END IF;
3701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3702:
3703: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3704: FND_MSG_PUB.Add_Exc_Msg(
3705: G_PKG_NAME
3706: , 'GET_MODEL_SOURCING_ORG'
3707: );

Line 3704: FND_MSG_PUB.Add_Exc_Msg(

3700: END IF;
3701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3702:
3703: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3704: FND_MSG_PUB.Add_Exc_Msg(
3705: G_PKG_NAME
3706: , 'GET_MODEL_SOURCING_ORG'
3707: );
3708: END IF;

Line 4629: if fnd_msg_pub.check_msg_level

4625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4626: IF PG_DEBUG <> 0 THEN
4627: oe_debug_pub.add ('chk_all_rsv_details: ' || 'unexpected error in called program chk_all_rsv_details'|| l_stmt||sqlerrm , 1);
4628: END IF;
4629: if fnd_msg_pub.check_msg_level
4630: (fnd_msg_pub.g_msg_lvl_unexp_error)
4631: then
4632: fnd_msg_pub.Add_Exc_msg
4633: ( 'CTO_WORKFLOW',

Line 4630: (fnd_msg_pub.g_msg_lvl_unexp_error)

4626: IF PG_DEBUG <> 0 THEN
4627: oe_debug_pub.add ('chk_all_rsv_details: ' || 'unexpected error in called program chk_all_rsv_details'|| l_stmt||sqlerrm , 1);
4628: END IF;
4629: if fnd_msg_pub.check_msg_level
4630: (fnd_msg_pub.g_msg_lvl_unexp_error)
4631: then
4632: fnd_msg_pub.Add_Exc_msg
4633: ( 'CTO_WORKFLOW',
4634: 'chk_all_rsv_details'

Line 4632: fnd_msg_pub.Add_Exc_msg

4628: END IF;
4629: if fnd_msg_pub.check_msg_level
4630: (fnd_msg_pub.g_msg_lvl_unexp_error)
4631: then
4632: fnd_msg_pub.Add_Exc_msg
4633: ( 'CTO_WORKFLOW',
4634: 'chk_all_rsv_details'
4635: );
4636: end if;

Line 6202: l_msg_data := substr(fnd_msg_pub.get(

6198: FOR l_index IN 1..P_MSG_COUNT LOOP
6199: -- Fixed bug 5639511
6200: -- Added substr function to avoid buffer overflow error
6201:
6202: l_msg_data := substr(fnd_msg_pub.get(
6203: p_msg_index => l_index,
6204: p_encoded => FND_API.G_FALSE),1,2000);
6205:
6206: oe_debug_pub.add('CTO_UTILITY_PK.notify_expected_error: '||substr(l_msg_data,1,250));