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'
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;
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'
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;
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'
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;
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'
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;
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'
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;
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'
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;
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'
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;
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 '
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;
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'
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;
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 '
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;
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 '
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;
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 '
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;
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 '
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;
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 '
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;
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 '
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;
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'
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;
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 '
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;
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 '
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;
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 '
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;
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 '
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;
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 '
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;
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'
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;
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'
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;
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'
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;
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'
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;
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'
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;
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 '
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;
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 '
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;