DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_DEBUG_PKG

Line 45: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

41: --
42:
43: l_debug_info := 'Inside Delete_Lines_Dists procedure';
44: IF g_debug_flag = 'Y' THEN
45: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
46: END IF;
47:
48:
49: SELECT DISTINCT invoice_id

Line 75: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

71:
72:
73: l_debug_info := 'End of Delete_Lines_Dists procedure';
74: IF g_debug_flag = 'Y' THEN
75: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
76: END IF;
77:
78: EXCEPTION
79: WHEN OTHERS THEN

Line 82: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,

78: EXCEPTION
79: WHEN OTHERS THEN
80: IF (SQLCODE <> -20001) THEN
81: IF g_debug_flag = 'Y' THEN
82: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,
83: 'CALLING_SEQUENCE', l_curr_calling_sequence);
84: END IF;
85: END IF;
86: APP_EXCEPTION.RAISE_EXCEPTION;

Line 114: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

110: --
111:
112: l_debug_info := 'Inside Insert_Dist_Line_Info procedure';
113: IF g_debug_flag = 'Y' THEN
114: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
115: END IF;
116:
117:
118: /* Insert the distribution info and line number for each distribution

Line 586: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

582:
583:
584: l_debug_info := 'End of Insert_Dist_Line_Info procedure';
585: IF g_debug_flag = 'Y' THEN
586: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
587: END IF;
588:
589: /*
590: EXCEPTION

Line 594: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,

590: EXCEPTION
591: WHEN OTHERS THEN
592: IF (SQLCODE <> -20001) THEN
593: IF g_debug_flag = 'Y' THEN
594: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,
595: 'CALLING_SEQUENCE', l_curr_calling_sequence);
596: END IF;
597: END IF;
598: APP_EXCEPTION.RAISE_EXCEPTION;

Line 818: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

814:
815:
816: l_debug_info := 'End of Insert_Alloc_Info procedure';
817: IF g_debug_flag = 'Y' THEN
818: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
819: END IF;
820:
821: /*
822: EXCEPTION

Line 826: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,

822: EXCEPTION
823: WHEN OTHERS THEN
824: IF (SQLCODE <> -20001) THEN
825: IF g_debug_flag = 'Y' THEN
826: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,
827: 'CALLING_SEQUENCE', l_curr_calling_sequence);
828: END IF;
829: END IF;
830: APP_EXCEPTION.RAISE_EXCEPTION;

Line 857: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

853: --
854:
855: l_debug_info := 'Inside Create_Lines procedure';
856: IF g_debug_flag = 'Y' THEN
857: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
858: END IF;
859:
860: l_fnd_return := FND_INSTALLATION.GET(401,401, l_inv_flag, l_industry);
861:

Line 871: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

867:
868:
869: l_debug_info := 'Creating invoice lines from the distributions table';
870: IF g_debug_flag = 'Y' THEN
871: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
872: END IF;
873:
874:
875: /* The following logic will be used to create an invoice line

Line 1388: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

1384:
1385:
1386: l_debug_info := 'End of Create_Lines procedure';
1387: IF g_debug_flag = 'Y' THEN
1388: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
1389: END IF;
1390: /*
1391: EXCEPTION
1392: WHEN OTHERS THEN

Line 1395: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,

1391: EXCEPTION
1392: WHEN OTHERS THEN
1393: IF (SQLCODE <> -20001) THEN
1394: IF g_debug_flag = 'Y' THEN
1395: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,
1396: 'CALLING_SEQUENCE', l_curr_calling_sequence);
1397: END IF;
1398: END IF;
1399: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1419: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

1415: || p_calling_sequence;
1416:
1417: l_debug_info := 'Inside Transform_Distributions procedure';
1418: IF g_debug_flag = 'Y' THEN
1419: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
1420: END IF;
1421:
1422:
1423: l_debug_info := 'Creating ITEM, PREPAY, AWT, ERV and IPV type of distributions';

Line 1425: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

1421:
1422:
1423: l_debug_info := 'Creating ITEM, PREPAY, AWT, ERV and IPV type of distributions';
1424: IF g_debug_flag = 'Y' THEN
1425: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
1426: END IF;
1427:
1428:
1429: /* This insert statement will insert all the ITEM, PREPAY

Line 1826: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

1822:
1823:
1824: l_debug_info := 'Creating TAX, TIPV and TERV type of distributions';
1825: IF g_debug_flag = 'Y' THEN
1826: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
1827: END IF;
1828:
1829:
1830: /* This insert statement will insert TAX, TIPV and TERV type of distributions

Line 2268: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

2264:
2265:
2266: l_debug_info := 'End of Transform_Distributions procedure';
2267: IF g_debug_flag = 'Y' THEN
2268: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2269: END IF;
2270:
2271:
2272: /*

Line 2277: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,

2273: EXCEPTION
2274: WHEN OTHERS THEN
2275: IF (SQLCODE <> -20001) THEN
2276: IF g_debug_flag = 'Y' THEN
2277: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,
2278: 'CALLING_SEQUENCE', l_curr_calling_sequence);
2279: END IF;
2280: END IF;
2281: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2303: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

2299: || p_calling_sequence;
2300:
2301: l_debug_info := 'Inside Populate_Lines procedure';
2302: IF g_debug_flag = 'Y' THEN
2303: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2304: END IF;
2305:
2306:
2307: l_debug_info := 'Calling procedure delete_lines_dists';

Line 2309: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

2305:
2306:
2307: l_debug_info := 'Calling procedure delete_lines_dists';
2308: IF g_debug_flag = 'Y' THEN
2309: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2310: END IF;
2311:
2312: Delete_Lines_Dists(l_curr_calling_sequence);
2313:

Line 2320: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

2316: VALUES (linetype(i));
2317:
2318: l_debug_info := 'Calling procedure insert_dist_line_info';
2319: IF g_debug_flag = 'Y' THEN
2320: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2321: END IF;
2322:
2323: Insert_Dist_Line_Info(l_curr_calling_sequence);
2324:

Line 2328: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

2324:
2325:
2326: l_debug_info := 'Calling procedure insert_alloc_info';
2327: IF g_debug_flag = 'Y' THEN
2328: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2329: END IF;
2330:
2331: Insert_Alloc_Info(l_curr_calling_sequence);
2332:

Line 2336: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

2332:
2333:
2334: l_debug_info := 'Calling Create_Lines procedure';
2335: IF g_debug_flag = 'Y' THEN
2336: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2337: END IF;
2338:
2339: Create_Lines (l_curr_calling_sequence);
2340:

Line 2344: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

2340:
2341:
2342: l_debug_info := 'Calling Transform_Distributions procedure';
2343: IF g_debug_flag = 'Y' THEN
2344: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2345: END IF;
2346:
2347: Transform_Distributions (l_curr_calling_sequence);
2348:

Line 2351: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

2347: Transform_Distributions (l_curr_calling_sequence);
2348:
2349: l_debug_info := 'End of Populate_Lines procedure';
2350: IF g_debug_flag = 'Y' THEN
2351: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2352: END IF;
2353:
2354:
2355: /*

Line 2360: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,

2356: EXCEPTION
2357: WHEN OTHERS THEN
2358: IF (SQLCODE <> -20001) THEN
2359: IF g_debug_flag = 'Y' THEN
2360: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,
2361: 'CALLING_SEQUENCE', l_curr_calling_sequence);
2362: END IF;
2363: END IF;
2364: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2392: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

2388:
2389:
2390: l_debug_info := 'Inside Transaction_Upgrade_Sync procedure';
2391: IF g_debug_flag = 'Y' THEN
2392: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2393: END IF;
2394:
2395: IF (FND_INSTALLATION.GET_APP_INFO('SQLAP', l_status, l_industry, l_table_owner)) THEN
2396: NULL;

Line 2438: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);

2434:
2435:
2436: l_debug_info := 'Calling procedure Populate_Lines';
2437: IF g_debug_flag = 'Y' THEN
2438: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2439: END IF;
2440:
2441:
2442: POPULATE_LINES(l_curr_calling_sequence);

Line 2461: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,

2457: EXCEPTION
2458: WHEN OTHERS THEN
2459: IF (SQLCODE <> -20001) THEN
2460: IF g_debug_flag = 'Y' THEN
2461: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,
2462: 'CALLING_SEQUENCE', l_curr_calling_sequence);
2463: END IF;
2464: END IF;
2465: APP_EXCEPTION.RAISE_EXCEPTION;