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

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

Line 3980: OE_MSG_PUB.Add_Exc_Msg

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

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

5767:
5768: EXCEPTION
5769: WHEN OTHERS THEN
5770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5772: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Get_Past_Due_Invoice');
5773: END IF;
5774: RAISE;
5775: END Get_Past_Due_Invoice ;

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

5768: EXCEPTION
5769: WHEN OTHERS THEN
5770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5772: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Get_Past_Due_Invoice');
5773: END IF;
5774: RAISE;
5775: END Get_Past_Due_Invoice ;
5776:

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

11288: CLOSE site_external_exposure_csr;
11289: END IF;
11290: WHEN OTHERS THEN
11291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11293: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, '
11294: Get_order_exposure');
11295: END IF;
11296: IF cust_external_exposure_csr%ISOPEN THEN

Line 11293: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, '

11289: END IF;
11290: WHEN OTHERS THEN
11291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11293: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, '
11294: Get_order_exposure');
11295: END IF;
11296: IF cust_external_exposure_csr%ISOPEN THEN
11297: CLOSE cust_external_exposure_csr;

Line 11669: OE_MSG_PUB.Count_And_Get

11665: THEN
11666: oe_debug_pub.ADD(' EXCEPTION OTHERS IN SEND_NOTIFICATION');
11667: oe_debug_pub.ADD( ' Errm = '|| SUBSTR(sqlerrm,1,200) );
11668: END IF;
11669: OE_MSG_PUB.Count_And_Get
11670: ( p_count => l_msg_count,
11671: p_data => l_msg_data
11672: );
11673: IF G_debug_flag = 'Y'

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

11768: WHEN OTHERS THEN
11769: G_DBG_MSG := SUBSTRB(sqlerrm,1,200);
11770: OE_DEBUG_PUB.ADD('EXCEPTION = '|| SUBSTRB(sqlerrm,1,200));
11771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11772: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11773: OE_MSG_PUB.Add_Exc_Msg
11774: ( G_PKG_NAME
11775: , 'GET_external_trx_amount'
11776: );

Line 11773: OE_MSG_PUB.Add_Exc_Msg

11769: G_DBG_MSG := SUBSTRB(sqlerrm,1,200);
11770: OE_DEBUG_PUB.ADD('EXCEPTION = '|| SUBSTRB(sqlerrm,1,200));
11771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11772: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11773: OE_MSG_PUB.Add_Exc_Msg
11774: ( G_PKG_NAME
11775: , 'GET_external_trx_amount'
11776: );
11777: END IF;

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

12191: RETURN (l_meaning);
12192:
12193: EXCEPTION
12194: When Others Then
12195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12196: THEN
12197: OE_MSG_PUB.Add_Exc_Msg
12198: ( G_PKG_NAME
12199: , 'Get_CC_Lookup_Meaning'

Line 12197: OE_MSG_PUB.Add_Exc_Msg

12193: EXCEPTION
12194: When Others Then
12195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12196: THEN
12197: OE_MSG_PUB.Add_Exc_Msg
12198: ( G_PKG_NAME
12199: , 'Get_CC_Lookup_Meaning'
12200: );
12201: END IF;