eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PURGE_TABLES_PVT dependencies on FND_API

Line 773: RAISE FND_API.G_EXC_ERROR;

769: x_return_status := 'F';
770: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables_transactions:exception others: ' || SQLERRM(SQLCODE()) );
771: -- DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
772: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
773: RAISE FND_API.G_EXC_ERROR;
774: END purge_cn_tables_transactions;
775:
776: -- API name : audit_purge_cn_transactions
777: -- Type : private.

Line 1032: RAISE FND_API.G_EXC_ERROR;

1028: x_return_status := 'F';
1029: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:exception others: ' || SQLERRM(SQLCODE()) );
1030: -- DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
1031: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
1032: RAISE FND_API.G_EXC_ERROR;
1033: END audit_purge_cn_transactions;
1034:
1035: -- API name : audit_purge_cn_subledgers
1036: -- Type : Private.

Line 1259: RAISE FND_API.G_EXC_ERROR;

1255: x_return_status := 'F';
1256: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables_subledgers:exception others: ' || SQLERRM(SQLCODE()) );
1257: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
1258: -- DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
1259: RAISE FND_API.G_EXC_ERROR;
1260: END purge_cn_tables_subledgers;
1261:
1262: -- API name : audit_purge_cn_subledgers
1263: -- Type : Private.

Line 1471: RAISE FND_API.G_EXC_ERROR;

1467: x_return_status := 'F';
1468: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:exception others: ' || SQLERRM(SQLCODE()) );
1469: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
1470: -- DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
1471: RAISE FND_API.G_EXC_ERROR;
1472: END audit_purge_cn_subledgers;
1473:
1474: -- API name : purge_cn_tables_refrences
1475: -- Type : private.

Line 1617: RAISE FND_API.G_EXC_ERROR;

1613: x_return_status := 'F';
1614: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables_transactions:exception others: ' || SQLERRM(SQLCODE()) );
1615: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
1616: -- DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
1617: RAISE FND_API.G_EXC_ERROR;
1618: END purge_cn_tables_refrences;
1619:
1620: -- API name : purge_cn_tables_refrences
1621: -- Type : private.

Line 1778: RAISE FND_API.G_EXC_ERROR;

1774: x_return_status := 'F';
1775: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_refrences:exception others: ' || SQLERRM(SQLCODE()) );
1776: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
1777: -- DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
1778: RAISE FND_API.G_EXC_ERROR;
1779: END audit_purge_cn_refrences;
1780:
1781: -- API name : purge_cn_tables_processing
1782: -- Type : private.

Line 1891: RAISE FND_API.G_EXC_ERROR;

1887: x_return_status := 'F';
1888: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables_transactions:exception others: ' || SQLERRM(SQLCODE()) );
1889: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
1890: -- DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
1891: RAISE FND_API.G_EXC_ERROR;
1892: END purge_cn_tables_processing;
1893:
1894: -- API name : purge_cn_tables_processing
1895: -- Type : private.

Line 1985: RAISE FND_API.G_EXC_ERROR;

1981: x_return_status := 'F';
1982: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_processing:exception others: ' || SQLERRM(SQLCODE()) );
1983: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
1984: -- DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
1985: RAISE FND_API.G_EXC_ERROR;
1986: END audit_purge_cn_processing;
1987:
1988:
1989: -- API name : archive_cn_tables_transactions

Line 2323: RAISE FND_API.G_EXC_ERROR;

2319: x_return_status := 'F';
2320: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:exception others: ' || SQLERRM(SQLCODE()) );
2321: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
2322: --DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
2323: RAISE FND_API.G_EXC_ERROR;
2324: END archive_cn_tables_transactions;
2325:
2326: -- API name : archive_cn_tables_subledgers
2327: -- Type : private.

Line 2591: RAISE FND_API.G_EXC_ERROR;

2587: x_return_status := 'F';
2588: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:exception others: ' || SQLERRM(SQLCODE()) );
2589: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
2590: --DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
2591: RAISE FND_API.G_EXC_ERROR;
2592: END archive_cn_tables_subledgers;
2593:
2594: -- API name : archive_cn_tables_references
2595: -- Type : private.

Line 2788: RAISE FND_API.G_EXC_ERROR;

2784: x_return_status := 'F';
2785: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_references:exception others: ' || SQLERRM(SQLCODE()) );
2786: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
2787: -- DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
2788: RAISE FND_API.G_EXC_ERROR;
2789: END archive_cn_tables_references;
2790:
2791: -- API name : archive_cn_tables_processing
2792: -- Type : private.

Line 2862: RAISE FND_API.G_EXC_ERROR;

2858: x_return_status := 'F';
2859: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_processing:exception others: ' || SQLERRM(SQLCODE()) );
2860: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
2861: --DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
2862: RAISE FND_API.G_EXC_ERROR;
2863: END archive_cn_tables_processing;
2864:
2865: -- API name : archive_cn_tables
2866: -- Type : private.

Line 2913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2909: x_return_status => x_return_status );
2910: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables after archive_cn_tables_transactions x_return_status ' || x_return_status);
2911: IF(x_return_status <> 'S') THEN
2912: ROLLBACK;
2913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2914: END IF;
2915:
2916: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables before archive_cn_tables_references ');
2917: archive_cn_tables_references ( p_start_period_id => p_start_period_id,

Line 2930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2926: x_return_status => x_return_status );
2927: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables after archive_cn_tables_references x_return_status ' || x_return_status);
2928: IF(x_return_status <> 'S') THEN
2929: ROLLBACK;
2930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2931: END IF;
2932:
2933: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables before archive_cn_tables_subledgers ');
2934: archive_cn_tables_subledgers ( p_start_period_id => p_start_period_id,

Line 2947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2943: x_return_status => x_return_status );
2944: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables after archive_cn_tables_subledgers x_return_status ' || x_return_status);
2945: IF(x_return_status <> 'S') THEN
2946: ROLLBACK;
2947: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2948: END IF;
2949:
2950: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables before archive_cn_tables_processing ');
2951: archive_cn_tables_processing ( p_start_period_id => p_start_period_id,

Line 2964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2960: x_return_status => x_return_status );
2961: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables after archive_cn_tables_processing x_return_status ' || x_return_status);
2962: IF(x_return_status <> 'S') THEN
2963: ROLLBACK;
2964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2965: END IF;
2966:
2967:
2968: INSERT

Line 3004: RAISE FND_API.G_EXC_ERROR;

3000: x_return_status := 'F';
3001: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables:exception others: ' || SQLERRM(SQLCODE()) );
3002: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
3003: --DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
3004: RAISE FND_API.G_EXC_ERROR;
3005: END archive_cn_tables;
3006:
3007: -- API name : purge_cn_tables
3008: -- Type : private.

Line 3059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3055: x_return_status => x_return_status);
3056: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables: after purge_cn_tables_transactions x_return_status : ' || x_return_status);
3057: IF(x_return_status <> 'S') THEN
3058: ROLLBACK;
3059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3060: END IF;
3061:
3062: purge_cn_tables_refrences ( p_start_period_id => p_start_period_id,
3063: p_end_period_id => p_end_period_id,

Line 3077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3073: x_return_status => x_return_status);
3074: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables: after purge_cn_tables_refrences x_return_status : ' || x_return_status);
3075: IF(x_return_status <> 'S') THEN
3076: ROLLBACK;
3077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3078: END IF;
3079:
3080: purge_cn_tables_subledgers ( p_start_period_id => p_start_period_id,
3081: p_end_period_id => p_end_period_id,

Line 3095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3091: x_return_status => x_return_status);
3092: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables: after purge_cn_tables_subledgers x_return_status : ' || x_return_status);
3093: IF(x_return_status <> 'S') THEN
3094: ROLLBACK;
3095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3096: END IF;
3097:
3098: purge_cn_tables_processing ( p_start_period_id => p_start_period_id,
3099: p_end_period_id => p_end_period_id,

Line 3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3109: x_return_status => x_return_status);
3110: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables: after purge_cn_tables_refrences x_return_status : ' || x_return_status);
3111: IF(x_return_status <> 'S') THEN
3112: ROLLBACK;
3113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3114: END IF;
3115:
3116: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables: x_return_status : ' || x_return_status);
3117:

Line 3132: RAISE FND_API.G_EXC_ERROR;

3128: 'CN_PURGE_TABLES_PVT.purge_cn_tables:exception others: ' || SQLERRM(SQLCODE())
3129: )
3130: ;
3131: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
3132: RAISE FND_API.G_EXC_ERROR;
3133: --DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
3134: END purge_cn_tables;
3135:
3136: -- API name : purge_cn_tables

Line 3193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3189: x_return_status => x_return_status);
3190: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_tables: after purge_cn_tables_transactions x_return_status : ' || x_return_status);
3191: IF(x_return_status <> 'S') THEN
3192: ROLLBACK;
3193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3194: END IF;
3195:
3196: audit_purge_cn_refrences ( p_start_period_id => p_start_period_id,
3197: p_end_period_id => p_end_period_id,

Line 3211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3207: x_return_status => x_return_status);
3208: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_tables: after purge_cn_tables_refrences x_return_status : ' || x_return_status);
3209: IF(x_return_status <> 'S') THEN
3210: ROLLBACK;
3211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3212: END IF;
3213:
3214: audit_purge_cn_subledgers ( p_start_period_id => p_start_period_id,
3215: p_end_period_id => p_end_period_id,

Line 3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3225: x_return_status => x_return_status);
3226: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_tables: after purge_cn_tables_refrences x_return_status : ' || x_return_status);
3227: IF(x_return_status <> 'S') THEN
3228: ROLLBACK;
3229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3230: END IF;
3231:
3232: audit_purge_cn_processing ( p_start_period_id => p_start_period_id,
3233: p_end_period_id => p_end_period_id,

Line 3247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3243: x_return_status => x_return_status);
3244: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_tables: after purge_cn_tables_refrences x_return_status : ' || x_return_status);
3245: IF(x_return_status <> 'S') THEN
3246: ROLLBACK;
3247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3248: END IF;
3249:
3250: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_tables: x_return_status : ' || x_return_status);
3251:

Line 3291: RAISE FND_API.G_EXC_ERROR;

3287: 'CN_PURGE_TABLES_PVT.audit_purge_cn_tables:exception others: ' || SQLERRM(SQLCODE())
3288: )
3289: ;
3290: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
3291: RAISE FND_API.G_EXC_ERROR;
3292: --DBMS_OUTPUT.put_line('[ ' || SQLERRM(SQLCODE()) || ' ]');
3293: END audit_purge_cn_tables;
3294:
3295: -- API name : archive_purge_cn_tables

Line 3372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3368: debugmsg('CN_PURGE_TABLES_PVT.archive_purge_cn_tables: x_msg_data: ' || x_msg_data);
3369: debugmsg('CN_PURGE_TABLES_PVT.archive_purge_cn_tables: x_return_status: ' || x_return_status);
3370:
3371: IF(x_return_status <> 'S') THEN
3372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3373: END IF;
3374:
3375: EXCEPTION
3376: WHEN OTHERS THEN

Line 3383: RAISE FND_API.G_EXC_ERROR;

3379: debugmsg('CN_PURGE_TABLES_PVT.archive_purge_cn_tables:exception others: ' || SQLERRM(SQLCODE()) );
3380: x_msg_data := x_msg_data || ' : ' || SQLERRM(SQLCODE());
3381: retcode := 2;
3382: errbuf := 'Unexpected Error : ' || SQLERRM(SQLCODE());
3383: RAISE FND_API.G_EXC_ERROR;
3384: END archive_purge_cn_tables;
3385:
3386: END CN_PURGE_TABLES_PVT;