210: ---------------------------------------------------------------------
211: EXCEPTION
212: WHEN OTHERS THEN
213: IF (SQLCODE <> -20001) THEN
214: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
215: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
216: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
217: END IF;
218:
211: EXCEPTION
212: WHEN OTHERS THEN
213: IF (SQLCODE <> -20001) THEN
214: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
215: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
216: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
217: END IF;
218:
219: ROLLBACK;
212: WHEN OTHERS THEN
213: IF (SQLCODE <> -20001) THEN
214: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
215: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
216: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
217: END IF;
218:
219: ROLLBACK;
220:
382: -----------------------------------------------------------------------
383: l_debug_info := 'Wrong p_accounting_mode ='||p_accounting_mode;
384: trace(G_LEVEL_EXCEPTION, l_procedure_name, l_debug_info);
385: -----------------------------------------------------------------------
386: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
387: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
388: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
389: l_curr_calling_sequence);
390: FND_MESSAGE.SET_TOKEN('PARAMETERS',
383: l_debug_info := 'Wrong p_accounting_mode ='||p_accounting_mode;
384: trace(G_LEVEL_EXCEPTION, l_procedure_name, l_debug_info);
385: -----------------------------------------------------------------------
386: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
387: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
388: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
389: l_curr_calling_sequence);
390: FND_MESSAGE.SET_TOKEN('PARAMETERS',
391: 'p_process_category = '||p_process_category
384: trace(G_LEVEL_EXCEPTION, l_procedure_name, l_debug_info);
385: -----------------------------------------------------------------------
386: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
387: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
388: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
389: l_curr_calling_sequence);
390: FND_MESSAGE.SET_TOKEN('PARAMETERS',
391: 'p_process_category = '||p_process_category
392: || 'p_accounting_mode = '||p_accounting_mode);
386: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
387: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
388: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
389: l_curr_calling_sequence);
390: FND_MESSAGE.SET_TOKEN('PARAMETERS',
391: 'p_process_category = '||p_process_category
392: || 'p_accounting_mode = '||p_accounting_mode);
393: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
394:
389: l_curr_calling_sequence);
390: FND_MESSAGE.SET_TOKEN('PARAMETERS',
391: 'p_process_category = '||p_process_category
392: || 'p_accounting_mode = '||p_accounting_mode);
393: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
394:
395: app_exception.raise_exception();
396:
397: END CASE; -- p_accounting_mode
404:
405: WHEN OTHERS THEN
406:
407: IF (SQLCODE <> -20001) THEN
408: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
409: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
410: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
411: l_curr_calling_sequence);
412: FND_MESSAGE.SET_TOKEN('PARAMETERS',
405: WHEN OTHERS THEN
406:
407: IF (SQLCODE <> -20001) THEN
408: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
409: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
410: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
411: l_curr_calling_sequence);
412: FND_MESSAGE.SET_TOKEN('PARAMETERS',
413: 'p_application_id=' || p_application_id || ' ' ||
406:
407: IF (SQLCODE <> -20001) THEN
408: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
409: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
410: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
411: l_curr_calling_sequence);
412: FND_MESSAGE.SET_TOKEN('PARAMETERS',
413: 'p_application_id=' || p_application_id || ' ' ||
414: 'p_ledger_id=' || p_ledger_id || ' ' ||
408: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
409: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
410: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
411: l_curr_calling_sequence);
412: FND_MESSAGE.SET_TOKEN('PARAMETERS',
413: 'p_application_id=' || p_application_id || ' ' ||
414: 'p_ledger_id=' || p_ledger_id || ' ' ||
415: 'p_process_category=' || p_process_category || ' ' ||
416: 'p_end_date=' || p_end_date || ' ' ||
422: 'p_security_id_char_1=' || p_security_id_char_1 || ' ' ||
423: 'p_security_id_char_2=' || p_security_id_char_2 || ' ' ||
424: 'p_security_id_char_3=' || p_security_id_char_3 || ' ' ||
425: 'p_report_request_id=' || p_report_request_id);
426: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
427: END IF;
428:
429: app_exception.raise_exception();
430:
1350: l_tax_dist_id_final_list.DELETE;
1351:
1352: IF ( l_return_status_service <> FND_API.G_RET_STS_SUCCESS ) THEN
1353:
1354: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1355: FND_MESSAGE.SET_TOKEN('ERROR','calling etax api fails');
1356: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1357: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1358: app_exception.raise_exception();
1351:
1352: IF ( l_return_status_service <> FND_API.G_RET_STS_SUCCESS ) THEN
1353:
1354: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1355: FND_MESSAGE.SET_TOKEN('ERROR','calling etax api fails');
1356: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1357: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1358: app_exception.raise_exception();
1359:
1352: IF ( l_return_status_service <> FND_API.G_RET_STS_SUCCESS ) THEN
1353:
1354: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1355: FND_MESSAGE.SET_TOKEN('ERROR','calling etax api fails');
1356: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1357: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1358: app_exception.raise_exception();
1359:
1360: END IF;
1353:
1354: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1355: FND_MESSAGE.SET_TOKEN('ERROR','calling etax api fails');
1356: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1357: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1358: app_exception.raise_exception();
1359:
1360: END IF;
1361:
1442: ---------------------------------------------------------------------
1443: l_debug_info := 'Others: p_accounting_mode = '|| p_accounting_mode;
1444: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1445: ---------------------------------------------------------------------
1446: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1447: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
1448: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1449: l_curr_calling_sequence);
1450: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1443: l_debug_info := 'Others: p_accounting_mode = '|| p_accounting_mode;
1444: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1445: ---------------------------------------------------------------------
1446: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1447: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
1448: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1449: l_curr_calling_sequence);
1450: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1451: 'p_accounting_mode = '||p_accounting_mode);
1444: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1445: ---------------------------------------------------------------------
1446: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1447: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
1448: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1449: l_curr_calling_sequence);
1450: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1451: 'p_accounting_mode = '||p_accounting_mode);
1452: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1446: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1447: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
1448: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1449: l_curr_calling_sequence);
1450: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1451: 'p_accounting_mode = '||p_accounting_mode);
1452: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1453:
1454: app_exception.raise_exception();
1448: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1449: l_curr_calling_sequence);
1450: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1451: 'p_accounting_mode = '||p_accounting_mode);
1452: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1453:
1454: app_exception.raise_exception();
1455:
1456: END CASE; -- p_accounting_mode
1504: -- */
1505:
1506:
1507: IF (SQLCODE <> -20001) THEN
1508: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1509: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1510: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1511: l_curr_calling_sequence);
1512: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1505:
1506:
1507: IF (SQLCODE <> -20001) THEN
1508: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1509: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1510: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1511: l_curr_calling_sequence);
1512: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1513: 'p_application_id = '|| p_application_id ||' '||
1506:
1507: IF (SQLCODE <> -20001) THEN
1508: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1509: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1510: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1511: l_curr_calling_sequence);
1512: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1513: 'p_application_id = '|| p_application_id ||' '||
1514: 'p_accounting_mode = '|| p_accounting_mode);
1508: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1509: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1510: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1511: l_curr_calling_sequence);
1512: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1513: 'p_application_id = '|| p_application_id ||' '||
1514: 'p_accounting_mode = '|| p_accounting_mode);
1515: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1516: END IF;
1511: l_curr_calling_sequence);
1512: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1513: 'p_application_id = '|| p_application_id ||' '||
1514: 'p_accounting_mode = '|| p_accounting_mode);
1515: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1516: END IF;
1517:
1518: app_exception.raise_exception();
1519:
1639:
1640: END IF;
1641:
1642: IF (SQLCODE <> -20001) THEN
1643: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1644: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1645: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1646: l_curr_calling_sequence);
1647: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1640: END IF;
1641:
1642: IF (SQLCODE <> -20001) THEN
1643: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1644: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1645: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1646: l_curr_calling_sequence);
1647: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1648: 'p_application_id = '|| p_application_id ||' '||
1641:
1642: IF (SQLCODE <> -20001) THEN
1643: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1644: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1645: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1646: l_curr_calling_sequence);
1647: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1648: 'p_application_id = '|| p_application_id ||' '||
1649: 'p_accounting_mode = '|| p_accounting_mode);
1643: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1644: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1645: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1646: l_curr_calling_sequence);
1647: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1648: 'p_application_id = '|| p_application_id ||' '||
1649: 'p_accounting_mode = '|| p_accounting_mode);
1650: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1651: END IF;
1646: l_curr_calling_sequence);
1647: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1648: 'p_application_id = '|| p_application_id ||' '||
1649: 'p_accounting_mode = '|| p_accounting_mode);
1650: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1651: END IF;
1652:
1653: app_exception.raise_exception();
1654:
1944: -----------------------------------------------------------------------
1945: NULL;
1946:
1947: ELSE -- different value for p_accounting_mode
1948: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1949: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
1950: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1951: l_curr_calling_sequence);
1952: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1945: NULL;
1946:
1947: ELSE -- different value for p_accounting_mode
1948: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1949: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
1950: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1951: l_curr_calling_sequence);
1952: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1953: 'p_accounting_mode = '|| p_accounting_mode);
1946:
1947: ELSE -- different value for p_accounting_mode
1948: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1949: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
1950: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1951: l_curr_calling_sequence);
1952: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1953: 'p_accounting_mode = '|| p_accounting_mode);
1954: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1948: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1949: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
1950: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1951: l_curr_calling_sequence);
1952: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1953: 'p_accounting_mode = '|| p_accounting_mode);
1954: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1955:
1956: app_exception.raise_exception();
1950: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1951: l_curr_calling_sequence);
1952: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1953: 'p_accounting_mode = '|| p_accounting_mode);
1954: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1955:
1956: app_exception.raise_exception();
1957:
1958: END CASE; -- p_accounting_mode
1975:
1976: END IF;
1977:
1978: IF (SQLCODE <> -20001) THEN
1979: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1980: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1982: l_curr_calling_sequence);
1983: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1976: END IF;
1977:
1978: IF (SQLCODE <> -20001) THEN
1979: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1980: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1982: l_curr_calling_sequence);
1983: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1984: 'p_application_id=' || p_application_id || ' ' ||
1977:
1978: IF (SQLCODE <> -20001) THEN
1979: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1980: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1982: l_curr_calling_sequence);
1983: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1984: 'p_application_id=' || p_application_id || ' ' ||
1985: 'p_ledger_id=' || p_ledger_id || ' ' ||
1979: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1980: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1981: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1982: l_curr_calling_sequence);
1983: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1984: 'p_application_id=' || p_application_id || ' ' ||
1985: 'p_ledger_id=' || p_ledger_id || ' ' ||
1986: 'p_process_category=' || p_process_category || ' ' ||
1987: 'p_end_date=' || p_end_date || ' ' ||
1993: 'p_security_id_char_1=' || p_security_id_char_1 || ' ' ||
1994: 'p_security_id_char_2=' || p_security_id_char_2 || ' ' ||
1995: 'p_security_id_char_3=' || p_security_id_char_3 || ' ' ||
1996: 'p_report_request_id=' || p_report_request_id);
1997: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1998: END IF;
1999:
2000: app_exception.raise_exception();
2001: