DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_UTIL dependencies on FND_MSG_PUB

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

150: return(NVL(l_exists,'N')) ;
151:
152: EXCEPTION
153: WHEN OTHERS THEN
154: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
155: THEN
156: FND_MSG_PUB.Add_Exc_Msg
157: ( G_PKG_NAME
158: , 'Check_drawee_exists'

Line 156: FND_MSG_PUB.Add_Exc_Msg

152: EXCEPTION
153: WHEN OTHERS THEN
154: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
155: THEN
156: FND_MSG_PUB.Add_Exc_Msg
157: ( G_PKG_NAME
158: , 'Check_drawee_exists'
159: );
160: END IF;

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

215: return ( l_site_use_id );
216:
217: EXCEPTION
218: WHEN OTHERS THEN
219: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
220: THEN
221: FND_MSG_PUB.Add_Exc_Msg
222: ( G_PKG_NAME
223: , 'get_drawee_site_use_id'

Line 221: FND_MSG_PUB.Add_Exc_Msg

217: EXCEPTION
218: WHEN OTHERS THEN
219: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
220: THEN
221: FND_MSG_PUB.Add_Exc_Msg
222: ( G_PKG_NAME
223: , 'get_drawee_site_use_id'
224: );
225: END IF;

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

455: END IF;
456:
457: EXCEPTION
458: WHEN OTHERS THEN
459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
460: THEN
461: FND_MSG_PUB.Add_Exc_Msg
462: ( G_PKG_NAME
463: , 'GET_hierarchy_party_limit'

Line 461: FND_MSG_PUB.Add_Exc_Msg

457: EXCEPTION
458: WHEN OTHERS THEN
459: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
460: THEN
461: FND_MSG_PUB.Add_Exc_Msg
462: ( G_PKG_NAME
463: , 'GET_hierarchy_party_limit'
464: );
465: END IF;

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

540: END IF;
541:
542: EXCEPTION
543: WHEN OTHERS THEN
544: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
545: THEN
546: FND_MSG_PUB.Add_Exc_Msg
547: ( G_PKG_NAME
548: , 'GET_single_party_limit'

Line 546: FND_MSG_PUB.Add_Exc_Msg

542: EXCEPTION
543: WHEN OTHERS THEN
544: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
545: THEN
546: FND_MSG_PUB.Add_Exc_Msg
547: ( G_PKG_NAME
548: , 'GET_single_party_limit'
549: );
550: END IF;

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

703: END IF;
704:
705: EXCEPTION
706: WHEN OTHERS THEN
707: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
708: THEN
709: FND_MSG_PUB.Add_Exc_Msg
710: ( G_PKG_NAME
711: , 'GET_multi_party_limit'

Line 709: FND_MSG_PUB.Add_Exc_Msg

705: EXCEPTION
706: WHEN OTHERS THEN
707: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
708: THEN
709: FND_MSG_PUB.Add_Exc_Msg
710: ( G_PKG_NAME
711: , 'GET_multi_party_limit'
712: );
713: END IF;

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

861: END IF;
862:
863: EXCEPTION
864: WHEN OTHERS THEN
865: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
866: THEN
867: FND_MSG_PUB.Add_Exc_Msg
868: ( G_PKG_NAME
869: , 'GET_party_limit'

Line 867: FND_MSG_PUB.Add_Exc_Msg

863: EXCEPTION
864: WHEN OTHERS THEN
865: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
866: THEN
867: FND_MSG_PUB.Add_Exc_Msg
868: ( G_PKG_NAME
869: , 'GET_party_limit'
870: );
871: END IF;

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

1008:
1009:
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1013: THEN
1014: FND_MSG_PUB.Add_Exc_Msg
1015: ( G_PKG_NAME
1016: , 'Get_global_exposure_flag'

Line 1014: FND_MSG_PUB.Add_Exc_Msg

1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1013: THEN
1014: FND_MSG_PUB.Add_Exc_Msg
1015: ( G_PKG_NAME
1016: , 'Get_global_exposure_flag'
1017: );
1018: END IF;

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

1185: EXCEPTION
1186: WHEN OTHERS THEN
1187: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1188:
1189: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1190: THEN
1191: FND_MSG_PUB.Add_Exc_Msg
1192: ( G_PKG_NAME
1193: , ' GET_category_set_id '

Line 1191: FND_MSG_PUB.Add_Exc_Msg

1187: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1188:
1189: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1190: THEN
1191: FND_MSG_PUB.Add_Exc_Msg
1192: ( G_PKG_NAME
1193: , ' GET_category_set_id '
1194: );
1195: END IF;

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

1256:
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1261: THEN
1262: FND_MSG_PUB.Add_Exc_Msg
1263: ( G_PKG_NAME
1264: , ' GET_Credit_check_Flag'

Line 1262: FND_MSG_PUB.Add_Exc_Msg

1258: WHEN OTHERS THEN
1259: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1261: THEN
1262: FND_MSG_PUB.Add_Exc_Msg
1263: ( G_PKG_NAME
1264: , ' GET_Credit_check_Flag'
1265: );
1266: END IF;

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

1348:
1349: EXCEPTION
1350: WHEN OTHERS THEN
1351: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1353: THEN
1354: FND_MSG_PUB.Add_Exc_Msg
1355: ( G_PKG_NAME
1356: , ' GET_Single_Customer_Limit '

Line 1354: FND_MSG_PUB.Add_Exc_Msg

1350: WHEN OTHERS THEN
1351: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1353: THEN
1354: FND_MSG_PUB.Add_Exc_Msg
1355: ( G_PKG_NAME
1356: , ' GET_Single_Customer_Limit '
1357: );
1358: END IF;

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

1446:
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1451: THEN
1452: FND_MSG_PUB.Add_Exc_Msg
1453: ( G_PKG_NAME
1454: , ' GET_Single_Site_Limit '

Line 1452: FND_MSG_PUB.Add_Exc_Msg

1448: WHEN OTHERS THEN
1449: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1451: THEN
1452: FND_MSG_PUB.Add_Exc_Msg
1453: ( G_PKG_NAME
1454: , ' GET_Single_Site_Limit '
1455: );
1456: END IF;

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

1636:
1637: EXCEPTION
1638: WHEN OTHERS THEN
1639: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1640: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1641: THEN
1642: FND_MSG_PUB.Add_Exc_Msg
1643: ( G_PKG_NAME
1644: , ' GET_multi_customer_Limit '

Line 1642: FND_MSG_PUB.Add_Exc_Msg

1638: WHEN OTHERS THEN
1639: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1640: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1641: THEN
1642: FND_MSG_PUB.Add_Exc_Msg
1643: ( G_PKG_NAME
1644: , ' GET_multi_customer_Limit '
1645: );
1646: END IF;

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

1801:
1802: EXCEPTION
1803: WHEN OTHERS THEN
1804: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1806: THEN
1807: FND_MSG_PUB.Add_Exc_Msg
1808: ( G_PKG_NAME
1809: , ' GET_multi_site_Limit '

Line 1807: FND_MSG_PUB.Add_Exc_Msg

1803: WHEN OTHERS THEN
1804: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1806: THEN
1807: FND_MSG_PUB.Add_Exc_Msg
1808: ( G_PKG_NAME
1809: , ' GET_multi_site_Limit '
1810: );
1811: END IF;

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

1893:
1894: EXCEPTION
1895: WHEN OTHERS THEN
1896: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1897: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1898: THEN
1899: FND_MSG_PUB.Add_Exc_Msg
1900: ( G_PKG_NAME
1901: , ' GET_single_default_Limit '

Line 1899: FND_MSG_PUB.Add_Exc_Msg

1895: WHEN OTHERS THEN
1896: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
1897: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1898: THEN
1899: FND_MSG_PUB.Add_Exc_Msg
1900: ( G_PKG_NAME
1901: , ' GET_single_default_Limit '
1902: );
1903: END IF;

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

2081:
2082: EXCEPTION
2083: WHEN OTHERS THEN
2084: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
2085: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2086: THEN
2087: FND_MSG_PUB.Add_Exc_Msg
2088: ( G_PKG_NAME
2089: , ' GET_multi_default_Limit '

Line 2087: FND_MSG_PUB.Add_Exc_Msg

2083: WHEN OTHERS THEN
2084: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
2085: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2086: THEN
2087: FND_MSG_PUB.Add_Exc_Msg
2088: ( G_PKG_NAME
2089: , ' GET_multi_default_Limit '
2090: );
2091: END IF;

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

2158:
2159: EXCEPTION
2160: WHEN OTHERS THEN
2161: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
2162: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2163: THEN
2164: FND_MSG_PUB.Add_Exc_Msg
2165: ( G_PKG_NAME
2166: , ' GET_single_Item_Limit'

Line 2164: FND_MSG_PUB.Add_Exc_Msg

2160: WHEN OTHERS THEN
2161: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
2162: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2163: THEN
2164: FND_MSG_PUB.Add_Exc_Msg
2165: ( G_PKG_NAME
2166: , ' GET_single_Item_Limit'
2167: );
2168: END IF;

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

2289: EXCEPTION
2290: WHEN OTHERS THEN
2291: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
2292:
2293: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2294: THEN
2295: FND_MSG_PUB.Add_Exc_Msg
2296: ( G_PKG_NAME
2297: , ' GET_multi_Item_Limit '

Line 2295: FND_MSG_PUB.Add_Exc_Msg

2291: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
2292:
2293: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2294: THEN
2295: FND_MSG_PUB.Add_Exc_Msg
2296: ( G_PKG_NAME
2297: , ' GET_multi_Item_Limit '
2298: );
2299: END IF;

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

2335: EXCEPTION
2336: WHEN OTHERS THEN
2337: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
2338:
2339: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2340: THEN
2341: FND_MSG_PUB.Add_Exc_Msg
2342: ( G_PKG_NAME
2343: , 'check_category '

Line 2341: FND_MSG_PUB.Add_Exc_Msg

2337: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
2338:
2339: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2340: THEN
2341: FND_MSG_PUB.Add_Exc_Msg
2342: ( G_PKG_NAME
2343: , 'check_category '
2344: );
2345: END IF;

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

2695: EXCEPTION
2696: WHEN OTHERS THEN
2697: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
2698:
2699: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2700: THEN
2701: FND_MSG_PUB.Add_Exc_Msg
2702: ( G_PKG_NAME
2703: , ' GET_Item_Limit '

Line 2701: FND_MSG_PUB.Add_Exc_Msg

2697: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
2698:
2699: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2700: THEN
2701: FND_MSG_PUB.Add_Exc_Msg
2702: ( G_PKG_NAME
2703: , ' GET_Item_Limit '
2704: );
2705: END IF;

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

2914: EXCEPTION
2915: WHEN OTHERS THEN
2916: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
2917:
2918: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2919: THEN
2920: FND_MSG_PUB.Add_Exc_Msg
2921: ( G_PKG_NAME
2922: , ' Get_Multi_Limit '

Line 2920: FND_MSG_PUB.Add_Exc_Msg

2916: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
2917:
2918: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2919: THEN
2920: FND_MSG_PUB.Add_Exc_Msg
2921: ( G_PKG_NAME
2922: , ' Get_Multi_Limit '
2923: );
2924: END IF;

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

3008: EXCEPTION
3009: WHEN OTHERS THEN
3010: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
3011:
3012: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3013: THEN
3014: FND_MSG_PUB.Add_Exc_Msg
3015: ( G_PKG_NAME
3016: , ' Get_SIngle_Limit '

Line 3014: FND_MSG_PUB.Add_Exc_Msg

3010: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
3011:
3012: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3013: THEN
3014: FND_MSG_PUB.Add_Exc_Msg
3015: ( G_PKG_NAME
3016: , ' Get_SIngle_Limit '
3017: );
3018: END IF;

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

3759: EXCEPTION
3760: WHEN OTHERS THEN
3761: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
3762:
3763: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3764: THEN
3765: FND_MSG_PUB.Add_Exc_Msg
3766: ( G_PKG_NAME
3767: , 'get_usages'

Line 3765: FND_MSG_PUB.Add_Exc_Msg

3761: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
3762:
3763: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3764: THEN
3765: FND_MSG_PUB.Add_Exc_Msg
3766: ( G_PKG_NAME
3767: , 'get_usages'
3768: );
3769: END IF;

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

3830: EXCEPTION
3831: WHEN OTHERS THEN
3832: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
3833:
3834: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3835: THEN
3836: FND_MSG_PUB.Add_Exc_Msg
3837: ( G_PKG_NAME
3838: , 'GET_System_parameters'

Line 3836: FND_MSG_PUB.Add_Exc_Msg

3832: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
3833:
3834: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3835: THEN
3836: FND_MSG_PUB.Add_Exc_Msg
3837: ( G_PKG_NAME
3838: , 'GET_System_parameters'
3839: );
3840: END IF;

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

4072: EXCEPTION
4073: WHEN OTHERS THEN
4074: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
4075:
4076: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4077: THEN
4078: FND_MSG_PUB.Add_Exc_Msg
4079: ( G_PKG_NAME
4080: , 'GET_credit_check_level'

Line 4078: FND_MSG_PUB.Add_Exc_Msg

4074: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
4075:
4076: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4077: THEN
4078: FND_MSG_PUB.Add_Exc_Msg
4079: ( G_PKG_NAME
4080: , 'GET_credit_check_level'
4081: );
4082: END IF;

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

4276: EXCEPTION
4277: WHEN OTHERS THEN
4278: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
4279:
4280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4281: THEN
4282: FND_MSG_PUB.Add_Exc_Msg
4283: ( G_PKG_NAME
4284: , 'GET_credit_check_rule'

Line 4282: FND_MSG_PUB.Add_Exc_Msg

4278: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
4279:
4280: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4281: THEN
4282: FND_MSG_PUB.Add_Exc_Msg
4283: ( G_PKG_NAME
4284: , 'GET_credit_check_rule'
4285: );
4286: END IF;

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

5464: OE_DEBUG_PUB.ADD('EXCEPTION = '||
5465: SUBSTR(sqlerrm,1,200) );
5466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5467:
5468: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5469: THEN
5470: FND_MSG_PUB.Add_Exc_Msg
5471: ( G_PKG_NAME
5472: , 'GET_transaction_amount'

Line 5470: FND_MSG_PUB.Add_Exc_Msg

5466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5467:
5468: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5469: THEN
5470: FND_MSG_PUB.Add_Exc_Msg
5471: ( G_PKG_NAME
5472: , 'GET_transaction_amount'
5473: );
5474: END IF;

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

11866:
11867: EXCEPTION
11868: WHEN OTHERS THEN
11869: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
11870: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11871: THEN
11872: FND_MSG_PUB.Add_Exc_Msg
11873: ( G_PKG_NAME
11874: , ' GET_default_Limit '

Line 11872: FND_MSG_PUB.Add_Exc_Msg

11868: WHEN OTHERS THEN
11869: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
11870: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11871: THEN
11872: FND_MSG_PUB.Add_Exc_Msg
11873: ( G_PKG_NAME
11874: , ' GET_default_Limit '
11875: );
11876: END IF;

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

12155: EXCEPTION
12156: WHEN OTHERS THEN
12157: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
12158:
12159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12160: THEN
12161: FND_MSG_PUB.Add_Exc_Msg
12162: ( G_PKG_NAME
12163: , ' get_limit_info '

Line 12161: FND_MSG_PUB.Add_Exc_Msg

12157: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
12158:
12159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12160: THEN
12161: FND_MSG_PUB.Add_Exc_Msg
12162: ( G_PKG_NAME
12163: , ' get_limit_info '
12164: );
12165: END IF;