DBA Data[Home] [Help]

APPS.POR_RCV_ORD_SV dependencies on ERROR_STACK

Line 364: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');

360: mo_global.set_policy_context(p_access_mode => 'S',
361: p_org_id => x_user_org_id);
362: end if;
363:
364: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');
365: return 1;
366: end groupPoTransaction;
367:
368:

Line 556: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');

552: mo_global.set_policy_context(p_access_mode => 'S',
553: p_org_id => x_user_org_id);
554: end if;
555:
556: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');
557: return 1;
558:
559: end groupInternalTransaction;
560:

Line 796: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');

792:
793:
794: if (x_caller = 'WP4' OR x_caller = 'WP4_CONFIRM') then
795: l_err_message := substr(SQLERRM,12,512);
796: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');
797: APP_EXCEPTION.RAISE_EXCEPTION;
798: end if;
799:
800: end INSERT_RCV_TXN_INTERFACE_IR;

Line 1208: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');

1204: when others THEN
1205: if (x_caller = 'WP4' OR x_caller = 'WP4_CONFIRM') then
1206: l_err_message := substr(SQLERRM,12,512);
1207: asn_debug.put_line(l_err_message);
1208: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');
1209: APP_EXCEPTION.RAISE_EXCEPTION;
1210: end if;
1211:
1212:

Line 1321: ERROR_STACK.PUSHMESSAGE(x_message,'ICX');

1317: end if;
1318: if (x_caller = 'WP4' OR x_caller ='WP4_CONFIRM') then
1319: x_message := fnd_message.get;
1320: if (x_message = '') THEN
1321: ERROR_STACK.PUSHMESSAGE(x_message,'ICX');
1322: asn_debug.put_line(x_message);
1323: ELSE
1324: ERROR_STACK.PUSHMESSAGE(substr(SQLERRM,12,512),'ICX');
1325: asn_debug.put_line(substr(SQLERRM,12,512));

Line 1324: ERROR_STACK.PUSHMESSAGE(substr(SQLERRM,12,512),'ICX');

1320: if (x_message = '') THEN
1321: ERROR_STACK.PUSHMESSAGE(x_message,'ICX');
1322: asn_debug.put_line(x_message);
1323: ELSE
1324: ERROR_STACK.PUSHMESSAGE(substr(SQLERRM,12,512),'ICX');
1325: asn_debug.put_line(substr(SQLERRM,12,512));
1326: END IF;
1327: end if;
1328: return 97;

Line 1638: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');

1634: exception
1635: when others then
1636:
1637: if (x_caller = 'WP4' OR x_caller ='WP4_CONFIRM') THEN
1638: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');
1639: APP_EXCEPTION.RAISE_EXCEPTION;
1640: end if;
1641: return FALSE;
1642:

Line 1761: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');

1757: htp.teletype(x_output_message);
1758: htp.nl;
1759: ELSE
1760: asn_debug.put_line('return 1, msg=' || x_output_message);
1761: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');
1762: end if;
1763: end if;
1764: delete_rows := TRUE;
1765: elsif rc = 2 then

Line 1780: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');

1776: fnd_message.set_token('REASON', x_str);
1777:
1778:
1779: x_output_message := fnd_message.get;
1780: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');
1781: asn_debug.put_line('return 2, msg=' || x_output_message);
1782: end if;
1783: delete_rows := TRUE;
1784: elsif (rc = 3 or (outcome IN ('WARNING', 'ERROR'))) then

Line 1816: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');

1812: IF (r_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;
1813: IF (r_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;
1814: IF (r_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;
1815:
1816: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');
1817: asn_debug.put_line('return 3 or error, msg=' || x_output_message);
1818: /* for this error case, we change the rc
1819: so that the error case will properly passed to middle tier.
1820: set to 4 to distinguish from 3

Line 1828: ERROR_STACK.PUSHMESSAGE(x_output_message,'ICX');

1824: elsif rc=3 then
1825: fnd_message.clear;
1826: fnd_message.set_name('ICX','ICX_POR_RCV_TXN_MGR_DOWN_ERROR');
1827: x_output_message := fnd_message.get;
1828: ERROR_STACK.PUSHMESSAGE(x_output_message,'ICX');
1829: end if;
1830:
1831: END IF;
1832:

Line 1916: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512), 'ICX');

1912: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1913: mo_global.set_policy_context(p_access_mode => 'S',
1914: p_org_id => x_user_org_id);
1915: end if;
1916: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512), 'ICX');
1917: return 95;
1918: END;
1919:
1920: END if;

Line 1936: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512), 'ICX');

1932: p_org_id => x_user_org_id);
1933: end if;
1934: x_progress := 'call txn processor exception' || substr(SQLERRM,12,512);
1935: asn_debug.put_line(x_progress);
1936: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512), 'ICX');
1937: return 94;
1938:
1939: end call_txn_processor;
1940:

Line 2044: error_stack.pushmessage( substr(SQLERRM,12,512),'ICX');

2040: when no_data_found then
2041: return false;
2042: when others then
2043: if (x_caller = 'WP4'OR x_caller ='WP4_CONFIRM') then
2044: error_stack.pushmessage( substr(SQLERRM,12,512),'ICX');
2045: app_exception.raise_exception;
2046: else
2047: return FALSE;
2048: end if;