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

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

Line 2700: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 2919: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 3013: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 3764: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 3835: FND_MSG_PUB.Add_Exc_Msg

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

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

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

Line 4077: FND_MSG_PUB.Add_Exc_Msg

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

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

4266: EXCEPTION
4267: WHEN OTHERS THEN
4268: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
4269:
4270: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4271: THEN
4272: FND_MSG_PUB.Add_Exc_Msg
4273: ( G_PKG_NAME
4274: , 'GET_credit_check_rule'

Line 4272: FND_MSG_PUB.Add_Exc_Msg

4268: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
4269:
4270: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4271: THEN
4272: FND_MSG_PUB.Add_Exc_Msg
4273: ( G_PKG_NAME
4274: , 'GET_credit_check_rule'
4275: );
4276: END IF;

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

5258: OE_DEBUG_PUB.ADD('EXCEPTION = '||
5259: SUBSTR(sqlerrm,1,200) );
5260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5261:
5262: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5263: THEN
5264: FND_MSG_PUB.Add_Exc_Msg
5265: ( G_PKG_NAME
5266: , 'GET_transaction_amount'

Line 5264: FND_MSG_PUB.Add_Exc_Msg

5260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5261:
5262: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5263: THEN
5264: FND_MSG_PUB.Add_Exc_Msg
5265: ( G_PKG_NAME
5266: , 'GET_transaction_amount'
5267: );
5268: END IF;

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

11507:
11508: EXCEPTION
11509: WHEN OTHERS THEN
11510: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
11511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11512: THEN
11513: FND_MSG_PUB.Add_Exc_Msg
11514: ( G_PKG_NAME
11515: , ' GET_default_Limit '

Line 11513: FND_MSG_PUB.Add_Exc_Msg

11509: WHEN OTHERS THEN
11510: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
11511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11512: THEN
11513: FND_MSG_PUB.Add_Exc_Msg
11514: ( G_PKG_NAME
11515: , ' GET_default_Limit '
11516: );
11517: END IF;

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

11794: EXCEPTION
11795: WHEN OTHERS THEN
11796: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
11797:
11798: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11799: THEN
11800: FND_MSG_PUB.Add_Exc_Msg
11801: ( G_PKG_NAME
11802: , ' get_limit_info '

Line 11800: FND_MSG_PUB.Add_Exc_Msg

11796: G_DBG_MSG := SUBSTR(sqlerrm,1,200);
11797:
11798: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11799: THEN
11800: FND_MSG_PUB.Add_Exc_Msg
11801: ( G_PKG_NAME
11802: , ' get_limit_info '
11803: );
11804: END IF;