[Home] [Help]
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:
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:
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;
1197: when others THEN
1198: if (x_caller = 'WP4' OR x_caller = 'WP4_CONFIRM') then
1199: l_err_message := substr(SQLERRM,12,512);
1200: asn_debug.put_line(l_err_message);
1201: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');
1202: APP_EXCEPTION.RAISE_EXCEPTION;
1203: end if;
1204:
1205:
1310: end if;
1311: if (x_caller = 'WP4' OR x_caller ='WP4_CONFIRM') then
1312: x_message := fnd_message.get;
1313: if (x_message = '') THEN
1314: ERROR_STACK.PUSHMESSAGE(x_message,'ICX');
1315: asn_debug.put_line(x_message);
1316: ELSE
1317: ERROR_STACK.PUSHMESSAGE(substr(SQLERRM,12,512),'ICX');
1318: asn_debug.put_line(substr(SQLERRM,12,512));
1313: if (x_message = '') THEN
1314: ERROR_STACK.PUSHMESSAGE(x_message,'ICX');
1315: asn_debug.put_line(x_message);
1316: ELSE
1317: ERROR_STACK.PUSHMESSAGE(substr(SQLERRM,12,512),'ICX');
1318: asn_debug.put_line(substr(SQLERRM,12,512));
1319: END IF;
1320: end if;
1321: return 97;
1627: exception
1628: when others then
1629:
1630: if (x_caller = 'WP4' OR x_caller ='WP4_CONFIRM') THEN
1631: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512),'ICX');
1632: APP_EXCEPTION.RAISE_EXCEPTION;
1633: end if;
1634: return FALSE;
1635:
1749: htp.teletype(x_output_message);
1750: htp.nl;
1751: ELSE
1752: asn_debug.put_line('return 1, msg=' || x_output_message);
1753: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');
1754: end if;
1755: end if;
1756: delete_rows := TRUE;
1757: elsif rc = 2 then
1768: fnd_message.set_token('REASON', x_str);
1769:
1770:
1771: x_output_message := fnd_message.get;
1772: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');
1773: asn_debug.put_line('return 2, msg=' || x_output_message);
1774: end if;
1775: delete_rows := TRUE;
1776: elsif (rc = 3 or (outcome IN ('WARNING', 'ERROR'))) then
1804: IF (r_val18 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val18; END IF;
1805: IF (r_val19 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val19; END IF;
1806: IF (r_val20 IS NOT NULL) THEN x_output_message := x_output_message || fnd_global.local_chr(10) || r_val20; END IF;
1807:
1808: ERROR_STACK.PUSHMESSAGE( x_output_message, 'ICX');
1809: asn_debug.put_line('return 3 or error, msg=' || x_output_message);
1810: /* for this error case, we change the rc
1811: so that the error case will properly passed to middle tier.
1812: set to 4 to distinguish from 3
1899: if (MO_GLOBAL.get_current_org_id <> x_user_org_id) then
1900: mo_global.set_policy_context(p_access_mode => 'S',
1901: p_org_id => x_user_org_id);
1902: end if;
1903: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512), 'ICX');
1904: return 95;
1905: END;
1906:
1907: END if;
1919: p_org_id => x_user_org_id);
1920: end if;
1921: x_progress := 'call txn processor exception' || substr(SQLERRM,12,512);
1922: asn_debug.put_line(x_progress);
1923: ERROR_STACK.PUSHMESSAGE( substr(SQLERRM,12,512), 'ICX');
1924: return 94;
1925:
1926: end call_txn_processor;
1927:
2026: when no_data_found then
2027: return false;
2028: when others then
2029: if (x_caller = 'WP4'OR x_caller ='WP4_CONFIRM') then
2030: error_stack.pushmessage( substr(SQLERRM,12,512),'ICX');
2031: app_exception.raise_exception;
2032: else
2033: return FALSE;
2034: end if;