DBA Data[Home] [Help]

APPS.AR_ADJUSTAPI_PUB dependencies on ARP_UTIL

Line 22: | arp_util.disable_debug |

18: | |
19: | SCOPE - PRIVATE |
20: | |
21: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
22: | arp_util.disable_debug |
23: | arp_util.enable_debug |
24: | fnd_api.compatible_api_call |
25: | fnd_api.g_exc_unexpected_error |
26: | fnd_api.g_ret_sts_error |

Line 23: | arp_util.enable_debug |

19: | SCOPE - PRIVATE |
20: | |
21: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
22: | arp_util.disable_debug |
23: | arp_util.enable_debug |
24: | fnd_api.compatible_api_call |
25: | fnd_api.g_exc_unexpected_error |
26: | fnd_api.g_ret_sts_error |
27: | fnd_api.g_ret_sts_error |

Line 72: arp_util.debug('Validate_Adj_Insert()+' , G_MSG_HIGH);

68: l_ps_rec ar_payment_schedules%rowtype;
69: BEGIN
70:
71: IF PG_DEBUG in ('Y', 'C') THEN
72: arp_util.debug('Validate_Adj_Insert()+' , G_MSG_HIGH);
73: END IF;
74:
75: /*-------------------------------------------------+
76: | 1. Validate type |

Line 216: arp_util.debug('Validate_Adj_Insert()-' , G_MSG_HIGH);

212: p_validation_status
213: );
214:
215: IF PG_DEBUG in ('Y', 'C') THEN
216: arp_util.debug('Validate_Adj_Insert()-' , G_MSG_HIGH);
217: END IF;
218: RETURN;
219:
220: EXCEPTION

Line 224: arp_util.debug('EXCEPTION: Validate_Adj_Insert() ', G_MSG_UERROR);

220: EXCEPTION
221:
222: WHEN OTHERS THEN
223: IF PG_DEBUG in ('Y', 'C') THEN
224: arp_util.debug('EXCEPTION: Validate_Adj_Insert() ', G_MSG_UERROR);
225: END IF;
226: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Adj_Insert');
227: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;
228: RETURN;

Line 273: arp_util.debug('Set_Remaining_Attributes()+' , G_MSG_HIGH);

269:
270: BEGIN
271:
272: IF PG_DEBUG in ('Y', 'C') THEN
273: arp_util.debug('Set_Remaining_Attributes()+' , G_MSG_HIGH);
274: END IF;
275:
276: /*-----------------------------------------------+
277: | Set the status to success |

Line 298: arp_util.debug('Set_Remaining_Attributes()-' , G_MSG_HIGH);

294: p_adj_rec.subsequent_trx_id := NULL ;
295:
296:
297: IF PG_DEBUG in ('Y', 'C') THEN
298: arp_util.debug('Set_Remaining_Attributes()-' , G_MSG_HIGH);
299: END IF;
300:
301: RETURN ;
302:

Line 307: arp_util.debug('EXCEPTION: Set_Remaining_Attributes() ', G_MSG_UERROR);

303: EXCEPTION
304:
305: WHEN OTHERS THEN
306: IF PG_DEBUG in ('Y', 'C') THEN
307: arp_util.debug('EXCEPTION: Set_Remaining_Attributes() ', G_MSG_UERROR);
308: END IF;
309: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Set_Remaining_Attributes');
310: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311: RETURN;

Line 359: arp_util.debug('Validate_Adj_modify()+' , G_MSG_HIGH);

355:
356: BEGIN
357:
358: IF PG_DEBUG in ('Y', 'C') THEN
359: arp_util.debug('Validate_Adj_modify()+' , G_MSG_HIGH);
360: END IF;
361:
362: /*----------------------------------------------+
363: | Validate Old Adjustment status. Cannot modify |

Line 513: arp_util.debug('Validate_Adj_modify()-' , G_MSG_HIGH);

509: p_adj_rec.gl_date := l_temp_adj_rec.gl_date ;
510: END IF ;
511:
512: IF PG_DEBUG in ('Y', 'C') THEN
513: arp_util.debug('Validate_Adj_modify()-' , G_MSG_HIGH);
514: END IF;
515:
516: EXCEPTION
517:

Line 520: arp_util.debug('EXCEPTION: Validate_Adj_Modify() ', G_MSG_UERROR);

516: EXCEPTION
517:
518: WHEN OTHERS THEN
519: IF PG_DEBUG in ('Y', 'C') THEN
520: arp_util.debug('EXCEPTION: Validate_Adj_Modify() ', G_MSG_UERROR);
521: END IF;
522: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Adj_Modify');
523: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;
524: RETURN;

Line 574: arp_util.debug('Validate_Adj_Reverse()+' , G_MSG_HIGH);

570:
571: BEGIN
572:
573: IF PG_DEBUG in ('Y', 'C') THEN
574: arp_util.debug('Validate_Adj_Reverse()+' , G_MSG_HIGH);
575: END IF;
576:
577: /*----------------------------------------------+
578: | Validate Old Adjustment status. Cannot reverse|

Line 654: arp_util.debug('Validate_Adj_Reverse()-' , G_MSG_HIGH);

650: p_reversal_gl_date := trunc(p_reversal_gl_date);
651: p_reversal_date := trunc(p_reversal_date);
652:
653: IF PG_DEBUG in ('Y', 'C') THEN
654: arp_util.debug('Validate_Adj_Reverse()-' , G_MSG_HIGH);
655: END IF;
656:
657: EXCEPTION
658:

Line 661: arp_util.debug('EXCEPTION: Validate_Adj_Reverse() ', G_MSG_UERROR);

657: EXCEPTION
658:
659: WHEN OTHERS THEN
660: IF PG_DEBUG in ('Y', 'C') THEN
661: arp_util.debug('EXCEPTION: Validate_Adj_Reverse() ', G_MSG_UERROR);
662: END IF;
663: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Adj_Reverse');
664: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;
665: RETURN;

Line 716: arp_util.debug('Validate_Adj_Approve()+' , G_MSG_HIGH);

712:
713: BEGIN
714:
715: IF PG_DEBUG in ('Y', 'C') THEN
716: arp_util.debug('Validate_Adj_Approve()+' , G_MSG_HIGH);
717: END IF;
718:
719: /*-----------------------------------------------+
720: | Validate Old Adjustment status. Cannot approve|

Line 882: arp_util.debug('Validate_Adj_Approve ()-' , G_MSG_HIGH);

878: p_adj_rec.gl_date := l_temp_adj_rec.gl_date ;
879: END IF ;
880:
881: IF PG_DEBUG in ('Y', 'C') THEN
882: arp_util.debug('Validate_Adj_Approve ()-' , G_MSG_HIGH);
883: END IF;
884:
885: EXCEPTION
886:

Line 889: arp_util.debug('EXCEPTION: Validate_Adj_Approve() ', G_MSG_UERROR);

885: EXCEPTION
886:
887: WHEN OTHERS THEN
888: IF PG_DEBUG in ('Y', 'C') THEN
889: arp_util.debug('EXCEPTION: Validate_Adj_Approve() ', G_MSG_UERROR);
890: END IF;
891: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,'Validate_Adj_Approve');
892: p_validation_status := FND_API.G_RET_STS_UNEXP_ERROR ;
893: RETURN;

Line 908: | arp_util.disable_debug |

904: | |
905: | SCOPE - PUBLIC |
906: | |
907: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
908: | arp_util.disable_debug |
909: | arp_util.enable_debug |
910: | fnd_api.compatible_api_call |
911: | fnd_api.g_exc_unexpected_error |
912: | fnd_api.g_ret_sts_error |

Line 909: | arp_util.enable_debug |

905: | SCOPE - PUBLIC |
906: | |
907: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
908: | arp_util.disable_debug |
909: | arp_util.enable_debug |
910: | fnd_api.compatible_api_call |
911: | fnd_api.g_exc_unexpected_error |
912: | fnd_api.g_ret_sts_error |
913: | fnd_api.g_ret_sts_error |

Line 1008: arp_util.debug('Compatility error occurred.', G_MSG_ERROR);

1004: p_count => p_msg_count,
1005: p_data => p_msg_data
1006: );
1007: IF PG_DEBUG in ('Y', 'C') THEN
1008: arp_util.debug('Compatility error occurred.', G_MSG_ERROR);
1009: END IF;
1010:
1011: RETURN ;
1012: END IF;

Line 1031: arp_util.enable_debug;

1027: +------------------------------------------------------------*/
1028:
1029: IF ( FND_MSG_PUB.Check_Msg_Level( G_MSG_LOW) )
1030: THEN
1031: arp_util.enable_debug;
1032: ELSE
1033: arp_util.disable_debug;
1034: END IF;
1035:

Line 1033: arp_util.disable_debug;

1029: IF ( FND_MSG_PUB.Check_Msg_Level( G_MSG_LOW) )
1030: THEN
1031: arp_util.enable_debug;
1032: ELSE
1033: arp_util.disable_debug;
1034: END IF;
1035:
1036: IF PG_DEBUG in ('Y', 'C') THEN
1037: arp_util.debug('Insert_Adjustment()+ ', G_MSG_HIGH);

Line 1037: arp_util.debug('Insert_Adjustment()+ ', G_MSG_HIGH);

1033: arp_util.disable_debug;
1034: END IF;
1035:
1036: IF PG_DEBUG in ('Y', 'C') THEN
1037: arp_util.debug('Insert_Adjustment()+ ', G_MSG_HIGH);
1038: END IF;
1039:
1040: /*-----------------------------------------+
1041: | Initialize return status to SUCCESS |

Line 1134: arp_util.debug('Create_Adjustment: ' ||

1130: p_data => p_msg_data
1131: );
1132:
1133: IF PG_DEBUG in ('Y', 'C') THEN
1134: arp_util.debug('Create_Adjustment: ' ||
1135: 'Validation error(s) occurred. Rolling back '||
1136: 'and setting status to ERROR', G_MSG_ERROR);
1137: END IF;
1138:

Line 1175: arp_util.debug('Create_Adjustment: ' ||

1171: p_data => p_msg_data
1172: );
1173:
1174: IF PG_DEBUG in ('Y', 'C') THEN
1175: arp_util.debug('Create_Adjustment: ' ||
1176: 'Validation error(s) occurred. Rolling back '||
1177: 'and setting status to ERROR', G_MSG_ERROR);
1178: END IF;
1179:

Line 1217: arp_util.debug('Create_Adjustment: ' ||

1213: p_data => p_msg_data
1214: );
1215:
1216: IF PG_DEBUG in ('Y', 'C') THEN
1217: arp_util.debug('Create_Adjustment: ' ||
1218: 'Error in Insert Entity handler. Rolling back ' ||
1219: 'and setting status to ERROR', G_MSG_ERROR);
1220: END IF;
1221:

Line 1251: arp_util.debug('Create_Adjustment: ' || 'committing', G_MSG_HIGH);

1247:
1248: IF FND_API.To_Boolean( p_commit_flag )
1249: THEN
1250: IF PG_DEBUG in ('Y', 'C') THEN
1251: arp_util.debug('Create_Adjustment: ' || 'committing', G_MSG_HIGH);
1252: END IF;
1253: Commit;
1254: END IF;
1255:

Line 1257: arp_util.debug('Create_Adjustment()- ', G_MSG_HIGH);

1253: Commit;
1254: END IF;
1255:
1256: IF PG_DEBUG in ('Y', 'C') THEN
1257: arp_util.debug('Create_Adjustment()- ', G_MSG_HIGH);
1258: END IF;
1259:
1260: select TO_CHAR( (hsecs - G_START_TIME) / 100)
1261: into l_hsec

Line 1265: arp_util.debug('Create_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds', G_MSG_LOW);

1261: into l_hsec
1262: from v$timer;
1263:
1264: IF PG_DEBUG in ('Y', 'C') THEN
1265: arp_util.debug('Create_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds', G_MSG_LOW);
1266: END IF;
1267:
1268:
1269: EXCEPTION

Line 1273: arp_util.debug(SQLCODE, G_MSG_ERROR);

1269: EXCEPTION
1270: WHEN FND_API.G_EXC_ERROR THEN
1271:
1272: IF PG_DEBUG in ('Y', 'C') THEN
1273: arp_util.debug(SQLCODE, G_MSG_ERROR);
1274: arp_util.debug(SQLERRM, G_MSG_ERROR);
1275: END IF;
1276:
1277: ROLLBACK TO AR_ADJUSTAPI_PUB;

Line 1274: arp_util.debug(SQLERRM, G_MSG_ERROR);

1270: WHEN FND_API.G_EXC_ERROR THEN
1271:
1272: IF PG_DEBUG in ('Y', 'C') THEN
1273: arp_util.debug(SQLCODE, G_MSG_ERROR);
1274: arp_util.debug(SQLERRM, G_MSG_ERROR);
1275: END IF;
1276:
1277: ROLLBACK TO AR_ADJUSTAPI_PUB;
1278: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 1287: arp_util.debug(SQLERRM, G_MSG_ERROR);

1283:
1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1285:
1286: IF PG_DEBUG in ('Y', 'C') THEN
1287: arp_util.debug(SQLERRM, G_MSG_ERROR);
1288: END IF;
1289: ROLLBACK TO AR_ADJUSTAPI_PUB ;
1290: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1291: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 1309: arp_util.debug('Create_Adjustment: ' ||

1305: THEN
1306: p_return_status := FND_API.G_RET_STS_ERROR ;
1307: ROLLBACK TO AR_ADJUSTAPI_PUB;
1308: IF PG_DEBUG in ('Y', 'C') THEN
1309: arp_util.debug('Create_Adjustment: ' ||
1310: 'Completion validation error(s) occurred. ' ||
1311: 'Rolling back and setting status to ERROR',
1312: G_MSG_ERROR);
1313: END IF;

Line 1324: arp_util.disable_debug;

1320: ELSE
1321: NULL;
1322: END IF;
1323:
1324: arp_util.disable_debug;
1325:
1326: END Create_Adjustment;
1327:
1328:

Line 1339: | arp_util.disable_debug |

1335: | |
1336: | SCOPE - PUBLIC |
1337: | |
1338: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1339: | arp_util.disable_debug |
1340: | arp_util.enable_debug |
1341: | fnd_api.compatible_api_call |
1342: | fnd_api.g_exc_unexpected_error |
1343: | fnd_api.g_ret_sts_error |

Line 1340: | arp_util.enable_debug |

1336: | SCOPE - PUBLIC |
1337: | |
1338: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1339: | arp_util.disable_debug |
1340: | arp_util.enable_debug |
1341: | fnd_api.compatible_api_call |
1342: | fnd_api.g_exc_unexpected_error |
1343: | fnd_api.g_ret_sts_error |
1344: | fnd_api.g_ret_sts_error |

Line 1434: arp_util.debug('Modify_Adjustment: ' || 'Compatility error occurred.', G_MSG_ERROR);

1430: p_count => p_msg_count,
1431: p_data => p_msg_data
1432: );
1433: IF PG_DEBUG in ('Y', 'C') THEN
1434: arp_util.debug('Modify_Adjustment: ' || 'Compatility error occurred.', G_MSG_ERROR);
1435: END IF;
1436:
1437: RETURN ;
1438: END IF;

Line 1457: arp_util.enable_debug;

1453: +------------------------------------------------------------*/
1454:
1455: IF ( FND_MSG_PUB.Check_Msg_Level( G_MSG_LOW ) )
1456: THEN
1457: arp_util.enable_debug;
1458: ELSE
1459: arp_util.disable_debug;
1460: END IF;
1461:

Line 1459: arp_util.disable_debug;

1455: IF ( FND_MSG_PUB.Check_Msg_Level( G_MSG_LOW ) )
1456: THEN
1457: arp_util.enable_debug;
1458: ELSE
1459: arp_util.disable_debug;
1460: END IF;
1461:
1462:
1463: IF PG_DEBUG in ('Y', 'C') THEN

Line 1464: arp_util.debug('Modify_Adjustment()+ ', G_MSG_HIGH);

1460: END IF;
1461:
1462:
1463: IF PG_DEBUG in ('Y', 'C') THEN
1464: arp_util.debug('Modify_Adjustment()+ ', G_MSG_HIGH);
1465: END IF;
1466:
1467: /*-----------------------------------------+
1468: | Initialize return status to SUCCESS |

Line 1593: arp_util.debug('Modify_Adjustment: ' ||

1589: p_data => p_msg_data
1590: );
1591:
1592: IF PG_DEBUG in ('Y', 'C') THEN
1593: arp_util.debug('Modify_Adjustment: ' ||
1594: 'Validation error(s) occurred. Rolling back ' ||
1595: 'and setting status to ERROR', G_MSG_ERROR);
1596: END IF;
1597:

Line 1635: arp_util.debug('Modify_Adjustment: ' ||

1631: p_count => p_msg_count,
1632: p_data => p_msg_data
1633: );
1634: IF PG_DEBUG in ('Y', 'C') THEN
1635: arp_util.debug('Modify_Adjustment: ' ||
1636: 'Error in Insert Entity handler. Rolling back '||
1637: 'and setting status to ERROR', G_MSG_ERROR);
1638: END IF;
1639:

Line 1665: arp_util.debug('Modify_Adjustment: ' || 'committing', G_MSG_HIGH);

1661:
1662: IF FND_API.To_Boolean( p_commit_flag )
1663: THEN
1664: IF PG_DEBUG in ('Y', 'C') THEN
1665: arp_util.debug('Modify_Adjustment: ' || 'committing', G_MSG_HIGH);
1666: END IF;
1667: Commit;
1668: END IF;
1669:

Line 1671: arp_util.debug('Modify_Adjustment()- ', G_MSG_HIGH);

1667: Commit;
1668: END IF;
1669:
1670: IF PG_DEBUG in ('Y', 'C') THEN
1671: arp_util.debug('Modify_Adjustment()- ', G_MSG_HIGH);
1672: END IF;
1673:
1674: select TO_CHAR( (hsecs - G_START_TIME) / 100)
1675: into l_hsec

Line 1679: arp_util.debug('Modify_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds', G_MSG_LOW);

1675: into l_hsec
1676: from v$timer;
1677:
1678: IF PG_DEBUG in ('Y', 'C') THEN
1679: arp_util.debug('Modify_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds', G_MSG_LOW);
1680: END IF;
1681:
1682:
1683: EXCEPTION

Line 1687: arp_util.debug('Modify_Adjustment: ' || SQLCODE, G_MSG_ERROR);

1683: EXCEPTION
1684: WHEN FND_API.G_EXC_ERROR THEN
1685:
1686: IF PG_DEBUG in ('Y', 'C') THEN
1687: arp_util.debug('Modify_Adjustment: ' || SQLCODE, G_MSG_ERROR);
1688: arp_util.debug('Modify_Adjustment: ' || SQLERRM, G_MSG_ERROR);
1689: END IF;
1690:
1691: ROLLBACK TO AR_ADJUSTAPI_PUB;

Line 1688: arp_util.debug('Modify_Adjustment: ' || SQLERRM, G_MSG_ERROR);

1684: WHEN FND_API.G_EXC_ERROR THEN
1685:
1686: IF PG_DEBUG in ('Y', 'C') THEN
1687: arp_util.debug('Modify_Adjustment: ' || SQLCODE, G_MSG_ERROR);
1688: arp_util.debug('Modify_Adjustment: ' || SQLERRM, G_MSG_ERROR);
1689: END IF;
1690:
1691: ROLLBACK TO AR_ADJUSTAPI_PUB;
1692: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 1701: arp_util.debug('Modify_Adjustment: ' || SQLERRM, G_MSG_ERROR);

1697:
1698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1699:
1700: IF PG_DEBUG in ('Y', 'C') THEN
1701: arp_util.debug('Modify_Adjustment: ' || SQLERRM, G_MSG_ERROR);
1702: END IF;
1703: ROLLBACK TO AR_ADJUSTAPI_PUB ;
1704: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1705: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 1723: arp_util.debug('Modify_Adjustment: ' ||

1719: THEN
1720: p_return_status := FND_API.G_RET_STS_ERROR ;
1721: ROLLBACK TO AR_ADJUSTAPI_PUB;
1722: IF PG_DEBUG in ('Y', 'C') THEN
1723: arp_util.debug('Modify_Adjustment: ' ||
1724: 'Completion validation error(s) occurred. ' ||
1725: 'Rolling back and setting status to ERROR',
1726: G_MSG_ERROR);
1727: END IF;

Line 1737: arp_util.disable_debug;

1733: ELSE
1734: NULL;
1735: END IF;
1736:
1737: arp_util.disable_debug;
1738:
1739: END Modify_Adjustment;
1740:
1741:

Line 1752: | arp_util.disable_debug |

1748: | |
1749: | SCOPE - PUBLIC |
1750: | |
1751: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1752: | arp_util.disable_debug |
1753: | arp_util.enable_debug |
1754: | fnd_api.compatible_api_call |
1755: | fnd_api.g_exc_unexpected_error |
1756: | fnd_api.g_ret_sts_error |

Line 1753: | arp_util.enable_debug |

1749: | SCOPE - PUBLIC |
1750: | |
1751: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
1752: | arp_util.disable_debug |
1753: | arp_util.enable_debug |
1754: | fnd_api.compatible_api_call |
1755: | fnd_api.g_exc_unexpected_error |
1756: | fnd_api.g_ret_sts_error |
1757: | fnd_api.g_ret_sts_error |

Line 1849: arp_util.debug('Reverse_Adjustment: ' || 'Compatility error occurred.', G_MSG_ERROR);

1845: p_count => p_msg_count,
1846: p_data => p_msg_data
1847: );
1848: IF PG_DEBUG in ('Y', 'C') THEN
1849: arp_util.debug('Reverse_Adjustment: ' || 'Compatility error occurred.', G_MSG_ERROR);
1850: END IF;
1851:
1852: RETURN ;
1853: END IF;

Line 1872: arp_util.enable_debug;

1868: +------------------------------------------------------------*/
1869:
1870: IF ( FND_MSG_PUB.Check_Msg_Level( G_MSG_LOW ) )
1871: THEN
1872: arp_util.enable_debug;
1873: ELSE
1874: arp_util.disable_debug;
1875: END IF;
1876:

Line 1874: arp_util.disable_debug;

1870: IF ( FND_MSG_PUB.Check_Msg_Level( G_MSG_LOW ) )
1871: THEN
1872: arp_util.enable_debug;
1873: ELSE
1874: arp_util.disable_debug;
1875: END IF;
1876:
1877:
1878: IF PG_DEBUG in ('Y', 'C') THEN

Line 1879: arp_util.debug('Reverse_Adjustment()+ ', G_MSG_HIGH);

1875: END IF;
1876:
1877:
1878: IF PG_DEBUG in ('Y', 'C') THEN
1879: arp_util.debug('Reverse_Adjustment()+ ', G_MSG_HIGH);
1880: END IF;
1881:
1882: /*-----------------------------------------+
1883: | Initialize return status to SUCCESS |

Line 2010: arp_util.debug('Reverse_Adjustment: ' ||

2006: p_data => p_msg_data
2007: );
2008:
2009: IF PG_DEBUG in ('Y', 'C') THEN
2010: arp_util.debug('Reverse_Adjustment: ' ||
2011: 'Validation error(s) occurred. Rolling back '||
2012: 'and setting status to ERROR', G_MSG_ERROR);
2013: END IF;
2014:

Line 2053: arp_util.debug('Reverse_Adjustment: ' ||

2049: p_data => p_msg_data
2050: );
2051:
2052: IF PG_DEBUG in ('Y', 'C') THEN
2053: arp_util.debug('Reverse_Adjustment: ' ||
2054: 'Error in Insert Entity handler. Rolling back '||
2055: 'and setting status to ERROR', G_MSG_ERROR);
2056: END IF;
2057:

Line 2084: arp_util.debug('Reverse_Adjustment: ' || 'committing', G_MSG_HIGH);

2080:
2081: IF FND_API.To_Boolean( p_commit_flag )
2082: THEN
2083: IF PG_DEBUG in ('Y', 'C') THEN
2084: arp_util.debug('Reverse_Adjustment: ' || 'committing', G_MSG_HIGH);
2085: END IF;
2086: Commit;
2087: END IF;
2088:

Line 2090: arp_util.debug('Reverse_Adjustment()- ', G_MSG_HIGH);

2086: Commit;
2087: END IF;
2088:
2089: IF PG_DEBUG in ('Y', 'C') THEN
2090: arp_util.debug('Reverse_Adjustment()- ', G_MSG_HIGH);
2091: END IF;
2092:
2093: select TO_CHAR( (hsecs - G_START_TIME) / 100)
2094: into l_hsec

Line 2098: arp_util.debug('Reverse_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds', G_MSG_LOW);

2094: into l_hsec
2095: from v$timer;
2096:
2097: IF PG_DEBUG in ('Y', 'C') THEN
2098: arp_util.debug('Reverse_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds', G_MSG_LOW);
2099: END IF;
2100:
2101:
2102: EXCEPTION

Line 2106: arp_util.debug('Reverse_Adjustment: ' || SQLCODE, G_MSG_ERROR);

2102: EXCEPTION
2103: WHEN FND_API.G_EXC_ERROR THEN
2104:
2105: IF PG_DEBUG in ('Y', 'C') THEN
2106: arp_util.debug('Reverse_Adjustment: ' || SQLCODE, G_MSG_ERROR);
2107: arp_util.debug('Reverse_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2108: END IF;
2109:
2110: ROLLBACK TO AR_ADJUSTAPI_PUB;

Line 2107: arp_util.debug('Reverse_Adjustment: ' || SQLERRM, G_MSG_ERROR);

2103: WHEN FND_API.G_EXC_ERROR THEN
2104:
2105: IF PG_DEBUG in ('Y', 'C') THEN
2106: arp_util.debug('Reverse_Adjustment: ' || SQLCODE, G_MSG_ERROR);
2107: arp_util.debug('Reverse_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2108: END IF;
2109:
2110: ROLLBACK TO AR_ADJUSTAPI_PUB;
2111: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 2120: arp_util.debug('Reverse_Adjustment: ' || SQLERRM, G_MSG_ERROR);

2116:
2117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2118:
2119: IF PG_DEBUG in ('Y', 'C') THEN
2120: arp_util.debug('Reverse_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2121: END IF;
2122: ROLLBACK TO AR_ADJUSTAPI_PUB ;
2123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2124: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 2142: arp_util.debug('Reverse_Adjustment: ' ||

2138: THEN
2139: p_return_status := FND_API.G_RET_STS_ERROR ;
2140: ROLLBACK TO AR_ADJUSTAPI_PUB;
2141: IF PG_DEBUG in ('Y', 'C') THEN
2142: arp_util.debug('Reverse_Adjustment: ' ||
2143: 'Completion validation error(s) occurred. ' ||
2144: 'Rolling back and setting status to ERROR',
2145: G_MSG_ERROR);
2146: END IF;

Line 2157: arp_util.disable_debug;

2153: ELSE
2154: NULL;
2155: END IF;
2156:
2157: arp_util.disable_debug;
2158:
2159: END Reverse_Adjustment;
2160:
2161:

Line 2172: | arp_util.disable_debug |

2168: | |
2169: | SCOPE - PUBLIC |
2170: | |
2171: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2172: | arp_util.disable_debug |
2173: | arp_util.enable_debug |
2174: | fnd_api.compatible_api_call |
2175: | fnd_api.g_exc_unexpected_error |
2176: | fnd_api.g_ret_sts_error |

Line 2173: | arp_util.enable_debug |

2169: | SCOPE - PUBLIC |
2170: | |
2171: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2172: | arp_util.disable_debug |
2173: | arp_util.enable_debug |
2174: | fnd_api.compatible_api_call |
2175: | fnd_api.g_exc_unexpected_error |
2176: | fnd_api.g_ret_sts_error |
2177: | fnd_api.g_ret_sts_error |

Line 2268: arp_util.debug('Approve_Adjustment: ' || 'Compatility error occurred.', G_MSG_ERROR);

2264: p_count => p_msg_count,
2265: p_data => p_msg_data
2266: );
2267: IF PG_DEBUG in ('Y', 'C') THEN
2268: arp_util.debug('Approve_Adjustment: ' || 'Compatility error occurred.', G_MSG_ERROR);
2269: END IF;
2270:
2271: RETURN ;
2272: END IF;

Line 2291: arp_util.enable_debug;

2287: +------------------------------------------------------------*/
2288:
2289: IF ( FND_MSG_PUB.Check_Msg_Level( G_MSG_LOW ) )
2290: THEN
2291: arp_util.enable_debug;
2292: ELSE
2293: arp_util.disable_debug;
2294: END IF;
2295:

Line 2293: arp_util.disable_debug;

2289: IF ( FND_MSG_PUB.Check_Msg_Level( G_MSG_LOW ) )
2290: THEN
2291: arp_util.enable_debug;
2292: ELSE
2293: arp_util.disable_debug;
2294: END IF;
2295:
2296:
2297: IF PG_DEBUG in ('Y', 'C') THEN

Line 2298: arp_util.debug('Approve_Adjustment()+ ', G_MSG_HIGH);

2294: END IF;
2295:
2296:
2297: IF PG_DEBUG in ('Y', 'C') THEN
2298: arp_util.debug('Approve_Adjustment()+ ', G_MSG_HIGH);
2299: END IF;
2300:
2301: /*-----------------------------------------+
2302: | Initialize return status to SUCCESS |

Line 2428: arp_util.debug('Approve_Adjustment: ' ||

2424: p_data => p_msg_data
2425: );
2426:
2427: IF PG_DEBUG in ('Y', 'C') THEN
2428: arp_util.debug('Approve_Adjustment: ' ||
2429: 'Validation error(s) occurred. Rolling back ' ||
2430: 'and setting status to ERROR', G_MSG_ERROR);
2431: END IF;
2432:

Line 2472: arp_util.debug('Approve_Adjustment: ' ||

2468: p_data => p_msg_data
2469: );
2470:
2471: IF PG_DEBUG in ('Y', 'C') THEN
2472: arp_util.debug('Approve_Adjustment: ' ||
2473: 'Error in Insert Entity handler. Rolling back ' ||
2474: 'and setting status to ERROR', G_MSG_ERROR);
2475: END IF;
2476:

Line 2503: arp_util.debug('Approve_Adjustment: ' || 'committing', G_MSG_HIGH);

2499:
2500: IF FND_API.To_Boolean( p_commit_flag )
2501: THEN
2502: IF PG_DEBUG in ('Y', 'C') THEN
2503: arp_util.debug('Approve_Adjustment: ' || 'committing', G_MSG_HIGH);
2504: END IF;
2505: Commit;
2506: END IF;
2507:

Line 2509: arp_util.debug('Approve_Adjustment()- ', G_MSG_HIGH);

2505: Commit;
2506: END IF;
2507:
2508: IF PG_DEBUG in ('Y', 'C') THEN
2509: arp_util.debug('Approve_Adjustment()- ', G_MSG_HIGH);
2510: END IF;
2511:
2512: select TO_CHAR( (hsecs - G_START_TIME) / 100)
2513: into l_hsec

Line 2517: arp_util.debug('Approve_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds', G_MSG_LOW);

2513: into l_hsec
2514: from v$timer;
2515:
2516: IF PG_DEBUG in ('Y', 'C') THEN
2517: arp_util.debug('Approve_Adjustment: ' || 'Elapsed Time : '||l_hsec||' seconds', G_MSG_LOW);
2518: END IF;
2519:
2520:
2521: EXCEPTION

Line 2525: arp_util.debug('Approve_Adjustment: ' || SQLCODE, G_MSG_ERROR);

2521: EXCEPTION
2522: WHEN FND_API.G_EXC_ERROR THEN
2523:
2524: IF PG_DEBUG in ('Y', 'C') THEN
2525: arp_util.debug('Approve_Adjustment: ' || SQLCODE, G_MSG_ERROR);
2526: arp_util.debug('Approve_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2527: END IF;
2528:
2529: ROLLBACK TO AR_ADJUSTAPI_PUB;

Line 2526: arp_util.debug('Approve_Adjustment: ' || SQLERRM, G_MSG_ERROR);

2522: WHEN FND_API.G_EXC_ERROR THEN
2523:
2524: IF PG_DEBUG in ('Y', 'C') THEN
2525: arp_util.debug('Approve_Adjustment: ' || SQLCODE, G_MSG_ERROR);
2526: arp_util.debug('Approve_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2527: END IF;
2528:
2529: ROLLBACK TO AR_ADJUSTAPI_PUB;
2530: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 2539: arp_util.debug('Approve_Adjustment: ' || SQLERRM, G_MSG_ERROR);

2535:
2536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2537:
2538: IF PG_DEBUG in ('Y', 'C') THEN
2539: arp_util.debug('Approve_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2540: END IF;
2541: ROLLBACK TO AR_ADJUSTAPI_PUB ;
2542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2543: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 2561: arp_util.debug('Approve_Adjustment: ' ||

2557: THEN
2558: p_return_status := FND_API.G_RET_STS_ERROR ;
2559: ROLLBACK TO AR_ADJUSTAPI_PUB;
2560: IF PG_DEBUG in ('Y', 'C') THEN
2561: arp_util.debug('Approve_Adjustment: ' ||
2562: 'Completion validation error(s) occurred. ' ||
2563: 'Rolling back and setting status to ERROR',
2564: G_MSG_ERROR);
2565: END IF;

Line 2576: arp_util.disable_debug;

2572: ELSE
2573: NULL;
2574: END IF;
2575:
2576: arp_util.disable_debug;
2577:
2578: END Approve_Adjustment;
2579:
2580: