DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_UTIL dependencies on OE_MSG_PUB

Line 1068: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1064: RETURN( NVL(l_global_exposure_flag,'N') );
1065:
1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1069: OE_MSG_PUB.Add_Exc_Msg
1070: ( G_PKG_NAME
1071: , 'Get_global_exposure_ruleset'
1072: );

Line 1069: OE_MSG_PUB.Add_Exc_Msg

1065:
1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1069: OE_MSG_PUB.Add_Exc_Msg
1070: ( G_PKG_NAME
1071: , 'Get_global_exposure_ruleset'
1072: );
1073: END IF;

Line 1137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1133: END IF;
1134: RETURN(l_GL_currency);
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1138: OE_MSG_PUB.Add_Exc_Msg
1139: ( G_PKG_NAME
1140: , 'Get_GL_currency'
1141: );

Line 1138: OE_MSG_PUB.Add_Exc_Msg

1134: RETURN(l_GL_currency);
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1138: OE_MSG_PUB.Add_Exc_Msg
1139: ( G_PKG_NAME
1140: , 'Get_GL_currency'
1141: );
1142: END IF;

Line 3978: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3974: THEN
3975: x_credit_rule_id := NULL ;
3976: OE_DEBUG_PUB.ADD('EXCEPTION:No credit check rule found');
3977: WHEN OTHERS THEN
3978: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3979: OE_MSG_PUB.Add_Exc_Msg
3980: ( G_PKG_NAME
3981: , 'Get_Credit_Check_Rule_ID'
3982: );

Line 3979: OE_MSG_PUB.Add_Exc_Msg

3975: x_credit_rule_id := NULL ;
3976: OE_DEBUG_PUB.ADD('EXCEPTION:No credit check rule found');
3977: WHEN OTHERS THEN
3978: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3979: OE_MSG_PUB.Add_Exc_Msg
3980: ( G_PKG_NAME
3981: , 'Get_Credit_Check_Rule_ID'
3982: );
3983: END IF;

Line 5565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5561:
5562: EXCEPTION
5563: WHEN OTHERS THEN
5564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5566: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Get_Past_Due_Invoice');
5567: END IF;
5568: RAISE;
5569: END Get_Past_Due_Invoice ;

Line 5566: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Get_Past_Due_Invoice');

5562: EXCEPTION
5563: WHEN OTHERS THEN
5564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5566: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Get_Past_Due_Invoice');
5567: END IF;
5568: RAISE;
5569: END Get_Past_Due_Invoice ;
5570:

Line 10939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

10935: CLOSE site_external_exposure_csr;
10936: END IF;
10937: WHEN OTHERS THEN
10938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10940: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, '
10941: Get_order_exposure');
10942: END IF;
10943: IF cust_external_exposure_csr%ISOPEN THEN

Line 10940: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, '

10936: END IF;
10937: WHEN OTHERS THEN
10938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10939: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10940: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, '
10941: Get_order_exposure');
10942: END IF;
10943: IF cust_external_exposure_csr%ISOPEN THEN
10944: CLOSE cust_external_exposure_csr;

Line 11310: OE_MSG_PUB.Count_And_Get

11306: THEN
11307: oe_debug_pub.ADD(' EXCEPTION OTHERS IN SEND_NOTIFICATION');
11308: oe_debug_pub.ADD( ' Errm = '|| SUBSTR(sqlerrm,1,200) );
11309: END IF;
11310: OE_MSG_PUB.Count_And_Get
11311: ( p_count => l_msg_count,
11312: p_data => l_msg_data
11313: );
11314: IF G_debug_flag = 'Y'

Line 11413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

11409: WHEN OTHERS THEN
11410: G_DBG_MSG := SUBSTRB(sqlerrm,1,200);
11411: OE_DEBUG_PUB.ADD('EXCEPTION = '|| SUBSTRB(sqlerrm,1,200));
11412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11414: OE_MSG_PUB.Add_Exc_Msg
11415: ( G_PKG_NAME
11416: , 'GET_external_trx_amount'
11417: );

Line 11414: OE_MSG_PUB.Add_Exc_Msg

11410: G_DBG_MSG := SUBSTRB(sqlerrm,1,200);
11411: OE_DEBUG_PUB.ADD('EXCEPTION = '|| SUBSTRB(sqlerrm,1,200));
11412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11414: OE_MSG_PUB.Add_Exc_Msg
11415: ( G_PKG_NAME
11416: , 'GET_external_trx_amount'
11417: );
11418: END IF;

Line 11834: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

11830: RETURN (l_meaning);
11831:
11832: EXCEPTION
11833: When Others Then
11834: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11835: THEN
11836: OE_MSG_PUB.Add_Exc_Msg
11837: ( G_PKG_NAME
11838: , 'Get_CC_Lookup_Meaning'

Line 11836: OE_MSG_PUB.Add_Exc_Msg

11832: EXCEPTION
11833: When Others Then
11834: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11835: THEN
11836: OE_MSG_PUB.Add_Exc_Msg
11837: ( G_PKG_NAME
11838: , 'Get_CC_Lookup_Meaning'
11839: );
11840: END IF;