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 417: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

Line 418: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 1565: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 2081: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 2942: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 3706: FND_MSG_PUB.Add_Exc_Msg(

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

Line 4653: if fnd_msg_pub.check_msg_level

4649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4650: IF PG_DEBUG <> 0 THEN
4651: oe_debug_pub.add ('chk_all_rsv_details: ' || 'unexpected error in called program chk_all_rsv_details'|| l_stmt||sqlerrm , 1);
4652: END IF;
4653: if fnd_msg_pub.check_msg_level
4654: (fnd_msg_pub.g_msg_lvl_unexp_error)
4655: then
4656: fnd_msg_pub.Add_Exc_msg
4657: ( 'CTO_WORKFLOW',

Line 4654: (fnd_msg_pub.g_msg_lvl_unexp_error)

4650: IF PG_DEBUG <> 0 THEN
4651: oe_debug_pub.add ('chk_all_rsv_details: ' || 'unexpected error in called program chk_all_rsv_details'|| l_stmt||sqlerrm , 1);
4652: END IF;
4653: if fnd_msg_pub.check_msg_level
4654: (fnd_msg_pub.g_msg_lvl_unexp_error)
4655: then
4656: fnd_msg_pub.Add_Exc_msg
4657: ( 'CTO_WORKFLOW',
4658: 'chk_all_rsv_details'

Line 4656: fnd_msg_pub.Add_Exc_msg

4652: END IF;
4653: if fnd_msg_pub.check_msg_level
4654: (fnd_msg_pub.g_msg_lvl_unexp_error)
4655: then
4656: fnd_msg_pub.Add_Exc_msg
4657: ( 'CTO_WORKFLOW',
4658: 'chk_all_rsv_details'
4659: );
4660: end if;

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

6222: FOR l_index IN 1..P_MSG_COUNT LOOP
6223: -- Fixed bug 5639511
6224: -- Added substr function to avoid buffer overflow error
6225:
6226: l_msg_data := substr(fnd_msg_pub.get(
6227: p_msg_index => l_index,
6228: p_encoded => FND_API.G_FALSE),1,2000);
6229:
6230: oe_debug_pub.add('CTO_UTILITY_PK.notify_expected_error: '||substr(l_msg_data,1,250));