DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_DEBUG_PKG

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

62: --
63:
64: l_debug_info := 'Inside Delete_Lines_Dists procedure';
65: IF g_debug_flag = 'Y' THEN
66: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
67: END IF;
68:
69:
70: SELECT DISTINCT invoice_id

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

92:
93:
94: l_debug_info := 'End of Delete_Lines_Dists procedure';
95: IF g_debug_flag = 'Y' THEN
96: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
97: END IF;
98:
99: EXCEPTION
100: WHEN OTHERS THEN

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

99: EXCEPTION
100: WHEN OTHERS THEN
101: IF (SQLCODE <> -20001) THEN
102: IF g_debug_flag = 'Y' THEN
103: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,
104: 'CALLING_SEQUENCE', l_curr_calling_sequence);
105: END IF;
106: END IF;
107: APP_EXCEPTION.RAISE_EXCEPTION;

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

131: --
132:
133: l_debug_info := 'Inside Insert_Dist_Line_Info procedure';
134: IF g_debug_flag = 'Y' THEN
135: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
136: END IF;
137:
138:
139: /* Insert the distribution info and line number for each distribution

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

603:
604:
605: l_debug_info := 'End of Insert_Dist_Line_Info procedure';
606: IF g_debug_flag = 'Y' THEN
607: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
608: END IF;
609:
610: /*
611: EXCEPTION

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

611: EXCEPTION
612: WHEN OTHERS THEN
613: IF (SQLCODE <> -20001) THEN
614: IF g_debug_flag = 'Y' THEN
615: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,
616: 'CALLING_SEQUENCE', l_curr_calling_sequence);
617: END IF;
618: END IF;
619: APP_EXCEPTION.RAISE_EXCEPTION;

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

835:
836:
837: l_debug_info := 'End of Insert_Alloc_Info procedure';
838: IF g_debug_flag = 'Y' THEN
839: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
840: END IF;
841:
842: /*
843: EXCEPTION

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

843: EXCEPTION
844: WHEN OTHERS THEN
845: IF (SQLCODE <> -20001) THEN
846: IF g_debug_flag = 'Y' THEN
847: AP_Debug_Pkg.Print('Y','SQLAP','AP_DEBUG','ERROR',SQLERRM,
848: 'CALLING_SEQUENCE', l_curr_calling_sequence);
849: END IF;
850: END IF;
851: APP_EXCEPTION.RAISE_EXCEPTION;

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

874: --
875:
876: l_debug_info := 'Inside Create_Lines procedure';
877: IF g_debug_flag = 'Y' THEN
878: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
879: END IF;
880:
881: l_fnd_return := FND_INSTALLATION.GET(401,401, l_inv_flag, l_industry);
882:

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

888:
889:
890: l_debug_info := 'Creating invoice lines from the distributions table';
891: IF g_debug_flag = 'Y' THEN
892: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
893: END IF;
894:
895:
896: /* The following logic will be used to create an invoice line

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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