APPS.CTO_ORDER_PURGE dependencies on CTO_ORDER_PURGE

Line 1: PACKAGE BODY CTO_ORDER_PURGE as

1: PACKAGE BODY CTO_ORDER_PURGE as
2: /* $Header: CTOPURGB.pls 120.1 2005/06/06 10:05:49 appldev $ */
3: /*
4: *=========================================================================*
5: | |

Line 12: | CTO ORDER PURGE package body |

8: | |
9: *=========================================================================*
10: | |
11: | NAME |
12: | CTO ORDER PURGE package body |
13: | |
14: | DESCRIPTION |
15: | PL/SQL package body containing the deletion routine for |
16: | purging the data in CTO tables which were inserted during |

Line 103: oe_debug_pub.add('cto_purge_tables: ' || 'Entering CTO_ORDER_PURGE.cto_purge_tables :

99:
100: BEGIN
101:
102: IF PG_DEBUG <> 0 THEN
103: oe_debug_pub.add('cto_purge_tables: ' || 'Entering CTO_ORDER_PURGE.cto_purge_tables :
104: header_id=> '||to_char(p_header_id),1);
105: END IF;
106:
107: --to check if rows exists for header_id in cto tables

Line 213: oe_debug_pub.add('cto_purge_tables: ' || 'Exiting CTO_ORDER_PURGE.cto_purge_tables :

209: --end bugfix#3763753
210:
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
212: IF PG_DEBUG <> 0 THEN
213: oe_debug_pub.add('cto_purge_tables: ' || 'Exiting CTO_ORDER_PURGE.cto_purge_tables :
214: with '||x_return_status,1);
215: END IF;
216:
217:

Line 225: oe_debug_pub.add('cto_purge_tables: ' || 'Exiting CTO_ORDER_PURGE.cto_purge_tables : with '

221: x_error_msg := 'ORDPUR:bom cto tables'||substr(sqlerrm,1,200);
222: IF PG_DEBUG <> 0 THEN
223: oe_debug_pub.add('cto_purge_tables: ' || sqlerrm,1);
224:
225: oe_debug_pub.add('cto_purge_tables: ' || 'Exiting CTO_ORDER_PURGE.cto_purge_tables : with '
226: ||x_return_status,1);
227: END IF;
228:
229:

Line 232: END CTO_ORDER_PURGE;

228:
229:
230:
231: END cto_purge_tables ;
232: END CTO_ORDER_PURGE;
233: