241: ---------------------------------------------------------------------
242: EXCEPTION
243: WHEN OTHERS THEN
244: IF (SQLCODE <> -20001) THEN
245: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
246: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
247: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
248: END IF;
249:
242: EXCEPTION
243: WHEN OTHERS THEN
244: IF (SQLCODE <> -20001) THEN
245: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
246: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
247: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
248: END IF;
249:
250: ROLLBACK;
243: WHEN OTHERS THEN
244: IF (SQLCODE <> -20001) THEN
245: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
246: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
247: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
248: END IF;
249:
250: ROLLBACK;
251:
412: -----------------------------------------------------------------------
413: l_debug_info := 'Wrong p_accounting_mode ='||p_accounting_mode;
414: trace(G_LEVEL_EXCEPTION, l_procedure_name, l_debug_info);
415: -----------------------------------------------------------------------
416: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
417: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
418: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
419: l_curr_calling_sequence);
420: FND_MESSAGE.SET_TOKEN('PARAMETERS',
413: l_debug_info := 'Wrong p_accounting_mode ='||p_accounting_mode;
414: trace(G_LEVEL_EXCEPTION, l_procedure_name, l_debug_info);
415: -----------------------------------------------------------------------
416: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
417: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
418: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
419: l_curr_calling_sequence);
420: FND_MESSAGE.SET_TOKEN('PARAMETERS',
421: 'p_process_category = '||p_process_category
414: trace(G_LEVEL_EXCEPTION, l_procedure_name, l_debug_info);
415: -----------------------------------------------------------------------
416: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
417: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
418: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
419: l_curr_calling_sequence);
420: FND_MESSAGE.SET_TOKEN('PARAMETERS',
421: 'p_process_category = '||p_process_category
422: || 'p_accounting_mode = '||p_accounting_mode);
416: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
417: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
418: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
419: l_curr_calling_sequence);
420: FND_MESSAGE.SET_TOKEN('PARAMETERS',
421: 'p_process_category = '||p_process_category
422: || 'p_accounting_mode = '||p_accounting_mode);
423: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
424:
419: l_curr_calling_sequence);
420: FND_MESSAGE.SET_TOKEN('PARAMETERS',
421: 'p_process_category = '||p_process_category
422: || 'p_accounting_mode = '||p_accounting_mode);
423: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
424:
425: app_exception.raise_exception();
426:
427: END CASE; -- p_accounting_mode
434:
435: WHEN OTHERS THEN
436:
437: IF (SQLCODE <> -20001) THEN
438: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
439: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
440: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
441: l_curr_calling_sequence);
442: FND_MESSAGE.SET_TOKEN('PARAMETERS',
435: WHEN OTHERS THEN
436:
437: IF (SQLCODE <> -20001) THEN
438: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
439: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
440: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
441: l_curr_calling_sequence);
442: FND_MESSAGE.SET_TOKEN('PARAMETERS',
443: 'p_application_id=' || p_application_id || ' ' ||
436:
437: IF (SQLCODE <> -20001) THEN
438: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
439: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
440: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
441: l_curr_calling_sequence);
442: FND_MESSAGE.SET_TOKEN('PARAMETERS',
443: 'p_application_id=' || p_application_id || ' ' ||
444: 'p_ledger_id=' || p_ledger_id || ' ' ||
438: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
439: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
440: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
441: l_curr_calling_sequence);
442: FND_MESSAGE.SET_TOKEN('PARAMETERS',
443: 'p_application_id=' || p_application_id || ' ' ||
444: 'p_ledger_id=' || p_ledger_id || ' ' ||
445: 'p_process_category=' || p_process_category || ' ' ||
446: 'p_end_date=' || p_end_date || ' ' ||
452: 'p_security_id_char_1=' || p_security_id_char_1 || ' ' ||
453: 'p_security_id_char_2=' || p_security_id_char_2 || ' ' ||
454: 'p_security_id_char_3=' || p_security_id_char_3 || ' ' ||
455: 'p_report_request_id=' || p_report_request_id);
456: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
457: END IF;
458:
459: app_exception.raise_exception();
460:
1568: l_tax_dist_id_final_list.DELETE;
1569:
1570: IF ( l_return_status_service <> FND_API.G_RET_STS_SUCCESS ) THEN
1571:
1572: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1573: FND_MESSAGE.SET_TOKEN('ERROR','calling etax api fails');
1574: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1576: app_exception.raise_exception();
1569:
1570: IF ( l_return_status_service <> FND_API.G_RET_STS_SUCCESS ) THEN
1571:
1572: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1573: FND_MESSAGE.SET_TOKEN('ERROR','calling etax api fails');
1574: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1576: app_exception.raise_exception();
1577:
1570: IF ( l_return_status_service <> FND_API.G_RET_STS_SUCCESS ) THEN
1571:
1572: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1573: FND_MESSAGE.SET_TOKEN('ERROR','calling etax api fails');
1574: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1576: app_exception.raise_exception();
1577:
1578: END IF;
1571:
1572: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1573: FND_MESSAGE.SET_TOKEN('ERROR','calling etax api fails');
1574: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1575: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1576: app_exception.raise_exception();
1577:
1578: END IF;
1579:
1706: ---------------------------------------------------------------------
1707: l_debug_info := 'Others: p_accounting_mode = '|| p_accounting_mode;
1708: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1709: ---------------------------------------------------------------------
1710: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1711: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
1712: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1713: l_curr_calling_sequence);
1714: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1707: l_debug_info := 'Others: p_accounting_mode = '|| p_accounting_mode;
1708: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1709: ---------------------------------------------------------------------
1710: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1711: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
1712: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1713: l_curr_calling_sequence);
1714: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1715: 'p_accounting_mode = '||p_accounting_mode);
1708: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1709: ---------------------------------------------------------------------
1710: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1711: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
1712: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1713: l_curr_calling_sequence);
1714: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1715: 'p_accounting_mode = '||p_accounting_mode);
1716: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1710: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1711: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
1712: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1713: l_curr_calling_sequence);
1714: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1715: 'p_accounting_mode = '||p_accounting_mode);
1716: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1717:
1718: app_exception.raise_exception();
1712: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1713: l_curr_calling_sequence);
1714: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1715: 'p_accounting_mode = '||p_accounting_mode);
1716: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1717:
1718: app_exception.raise_exception();
1719:
1720: END CASE; -- p_accounting_mode
1779: -- */
1780:
1781:
1782: IF (SQLCODE <> -20001) THEN
1783: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1784: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1785: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1786: l_curr_calling_sequence);
1787: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1780:
1781:
1782: IF (SQLCODE <> -20001) THEN
1783: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1784: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1785: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1786: l_curr_calling_sequence);
1787: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1788: 'p_application_id = '|| p_application_id ||' '||
1781:
1782: IF (SQLCODE <> -20001) THEN
1783: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1784: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1785: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1786: l_curr_calling_sequence);
1787: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1788: 'p_application_id = '|| p_application_id ||' '||
1789: 'p_accounting_mode = '|| p_accounting_mode);
1783: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1784: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1785: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1786: l_curr_calling_sequence);
1787: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1788: 'p_application_id = '|| p_application_id ||' '||
1789: 'p_accounting_mode = '|| p_accounting_mode);
1790: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1791: END IF;
1786: l_curr_calling_sequence);
1787: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1788: 'p_application_id = '|| p_application_id ||' '||
1789: 'p_accounting_mode = '|| p_accounting_mode);
1790: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1791: END IF;
1792:
1793: app_exception.raise_exception();
1794:
1917:
1918: END IF;
1919:
1920: IF (SQLCODE <> -20001) THEN
1921: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1922: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1923: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1924: l_curr_calling_sequence);
1925: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1918: END IF;
1919:
1920: IF (SQLCODE <> -20001) THEN
1921: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1922: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1923: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1924: l_curr_calling_sequence);
1925: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1926: 'p_application_id = '|| p_application_id ||' '||
1919:
1920: IF (SQLCODE <> -20001) THEN
1921: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1922: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1923: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1924: l_curr_calling_sequence);
1925: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1926: 'p_application_id = '|| p_application_id ||' '||
1927: 'p_accounting_mode = '|| p_accounting_mode);
1921: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1922: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1923: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1924: l_curr_calling_sequence);
1925: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1926: 'p_application_id = '|| p_application_id ||' '||
1927: 'p_accounting_mode = '|| p_accounting_mode);
1928: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1929: END IF;
1924: l_curr_calling_sequence);
1925: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1926: 'p_application_id = '|| p_application_id ||' '||
1927: 'p_accounting_mode = '|| p_accounting_mode);
1928: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1929: END IF;
1930:
1931: app_exception.raise_exception();
1932:
2281: -----------------------------------------------------------------------
2282: NULL;
2283:
2284: ELSE -- different value for p_accounting_mode
2285: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2286: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
2287: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2288: l_curr_calling_sequence);
2289: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2282: NULL;
2283:
2284: ELSE -- different value for p_accounting_mode
2285: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2286: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
2287: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2288: l_curr_calling_sequence);
2289: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2290: 'p_accounting_mode = '|| p_accounting_mode);
2283:
2284: ELSE -- different value for p_accounting_mode
2285: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2286: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
2287: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2288: l_curr_calling_sequence);
2289: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2290: 'p_accounting_mode = '|| p_accounting_mode);
2291: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2285: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2286: FND_MESSAGE.SET_TOKEN('ERROR','Wrong p_accounting_mode');
2287: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2288: l_curr_calling_sequence);
2289: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2290: 'p_accounting_mode = '|| p_accounting_mode);
2291: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2292:
2293: app_exception.raise_exception();
2287: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2288: l_curr_calling_sequence);
2289: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2290: 'p_accounting_mode = '|| p_accounting_mode);
2291: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2292:
2293: app_exception.raise_exception();
2294:
2295: END CASE; -- p_accounting_mode
2313:
2314: END IF;
2315:
2316: IF (SQLCODE <> -20001) THEN
2317: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2318: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2319: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2320: l_curr_calling_sequence);
2321: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2314: END IF;
2315:
2316: IF (SQLCODE <> -20001) THEN
2317: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2318: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2319: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2320: l_curr_calling_sequence);
2321: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2322: 'p_application_id=' || p_application_id || ' ' ||
2315:
2316: IF (SQLCODE <> -20001) THEN
2317: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2318: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2319: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2320: l_curr_calling_sequence);
2321: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2322: 'p_application_id=' || p_application_id || ' ' ||
2323: 'p_ledger_id=' || p_ledger_id || ' ' ||
2317: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2318: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2319: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2320: l_curr_calling_sequence);
2321: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2322: 'p_application_id=' || p_application_id || ' ' ||
2323: 'p_ledger_id=' || p_ledger_id || ' ' ||
2324: 'p_process_category=' || p_process_category || ' ' ||
2325: 'p_end_date=' || p_end_date || ' ' ||
2331: 'p_security_id_char_1=' || p_security_id_char_1 || ' ' ||
2332: 'p_security_id_char_2=' || p_security_id_char_2 || ' ' ||
2333: 'p_security_id_char_3=' || p_security_id_char_3 || ' ' ||
2334: 'p_report_request_id=' || p_report_request_id);
2335: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2336: END IF;
2337:
2338: app_exception.raise_exception();
2339: