DBA Data[Home] [Help]

APPS.AS_RTTAP_ACCOUNT dependencies on WF_EVENT

Line 63: FUNCTION CREATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

59: END IF;
60:
61: END PROCESS_RTTAP_ACCOUNT;
62:
63: FUNCTION CREATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
64: p_return_status VARCHAR2(1);
65: BEGIN
66: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
67: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 74: WF_EVENT.setErrorInfo(p_event, 'ERROR');

70: RETURN 'SUCCESS';
71: EXCEPTION
72: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
73: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_ORGANIZATION_POST', p_event.getEventName(), p_subscription_guid);
74: WF_EVENT.setErrorInfo(p_event, 'ERROR');
75: RETURN 'ERROR';
76: WHEN OTHERS THEN
77: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_ORGANIZATION_POST', p_event.getEventName(), p_subscription_guid);
78: WF_EVENT.setErrorInfo(p_event, 'ERROR');

Line 78: WF_EVENT.setErrorInfo(p_event, 'ERROR');

74: WF_EVENT.setErrorInfo(p_event, 'ERROR');
75: RETURN 'ERROR';
76: WHEN OTHERS THEN
77: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_ORGANIZATION_POST', p_event.getEventName(), p_subscription_guid);
78: WF_EVENT.setErrorInfo(p_event, 'ERROR');
79: RETURN 'ERROR';
80: END CREATE_ORGANIZATION_POST;
81:
82: FUNCTION UPDATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

Line 82: FUNCTION UPDATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

78: WF_EVENT.setErrorInfo(p_event, 'ERROR');
79: RETURN 'ERROR';
80: END CREATE_ORGANIZATION_POST;
81:
82: FUNCTION UPDATE_ORGANIZATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
83: p_return_status VARCHAR2(1);
84: BEGIN
85: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
86: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 93: WF_EVENT.setErrorInfo(p_event, 'ERROR');

89: RETURN 'SUCCESS';
90: EXCEPTION
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
92: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_ORGANIZATION_POST', p_event.getEventName(), p_subscription_guid);
93: WF_EVENT.setErrorInfo(p_event, 'ERROR');
94: RETURN 'ERROR';
95: WHEN OTHERS THEN
96: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_ORGANIZATION_POST', p_event.getEventName(), p_subscription_guid);
97: WF_EVENT.setErrorInfo(p_event, 'ERROR');

Line 97: WF_EVENT.setErrorInfo(p_event, 'ERROR');

93: WF_EVENT.setErrorInfo(p_event, 'ERROR');
94: RETURN 'ERROR';
95: WHEN OTHERS THEN
96: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_ORGANIZATION_POST', p_event.getEventName(), p_subscription_guid);
97: WF_EVENT.setErrorInfo(p_event, 'ERROR');
98: RETURN 'ERROR';
99: END;
100:
101: FUNCTION CREATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

Line 101: FUNCTION CREATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

97: WF_EVENT.setErrorInfo(p_event, 'ERROR');
98: RETURN 'ERROR';
99: END;
100:
101: FUNCTION CREATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
102: p_return_status VARCHAR2(1);
103: BEGIN
104: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
105: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 112: WF_EVENT.setErrorInfo(p_event, 'ERROR');

108: RETURN 'SUCCESS';
109: EXCEPTION
110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
111: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_PERSON_POST', p_event.getEventName(), p_subscription_guid);
112: WF_EVENT.setErrorInfo(p_event, 'ERROR');
113: RETURN 'ERROR';
114: WHEN OTHERS THEN
115: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_PERSON_POST', p_event.getEventName(), p_subscription_guid);
116: WF_EVENT.setErrorInfo(p_event, 'ERROR');

Line 116: WF_EVENT.setErrorInfo(p_event, 'ERROR');

112: WF_EVENT.setErrorInfo(p_event, 'ERROR');
113: RETURN 'ERROR';
114: WHEN OTHERS THEN
115: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_PERSON_POST', p_event.getEventName(), p_subscription_guid);
116: WF_EVENT.setErrorInfo(p_event, 'ERROR');
117: RETURN 'ERROR';
118: END;
119:
120:

Line 121: FUNCTION UPDATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

117: RETURN 'ERROR';
118: END;
119:
120:
121: FUNCTION UPDATE_PERSON_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
122: p_return_status VARCHAR2(1);
123: BEGIN
124: PROCESS_RTTAP_ACCOUNT(p_event.GetValueForParameter('PARTY_ID'),p_return_status);
125: IF p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 132: WF_EVENT.setErrorInfo(p_event, 'ERROR');

128: RETURN 'SUCCESS';
129: EXCEPTION
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_PERSON_POST', p_event.getEventName(), p_subscription_guid);
132: WF_EVENT.setErrorInfo(p_event, 'ERROR');
133: RETURN 'ERROR';
134: WHEN OTHERS THEN
135: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_PERSON_POST', p_event.getEventName(), p_subscription_guid);
136: WF_EVENT.setErrorInfo(p_event, 'ERROR');

Line 136: WF_EVENT.setErrorInfo(p_event, 'ERROR');

132: WF_EVENT.setErrorInfo(p_event, 'ERROR');
133: RETURN 'ERROR';
134: WHEN OTHERS THEN
135: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_PERSON_POST', p_event.getEventName(), p_subscription_guid);
136: WF_EVENT.setErrorInfo(p_event, 'ERROR');
137: RETURN 'ERROR';
138:
139: END;
140:

Line 141: FUNCTION CREATE_PARTY_SITE_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

137: RETURN 'ERROR';
138:
139: END;
140:
141: FUNCTION CREATE_PARTY_SITE_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
142: CURSOR c1 IS
143: SELECT party_id
144: FROM HZ_PARTY_SITES
145: WHERE party_site_id = p_event.GetValueForParameter('PARTY_SITE_ID');

Line 160: WF_EVENT.setErrorInfo(p_event, 'ERROR');

156: RETURN 'SUCCESS';
157: EXCEPTION
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_PARTY_SITE_POST', p_event.getEventName(), p_subscription_guid);
160: WF_EVENT.setErrorInfo(p_event, 'ERROR');
161: RETURN 'ERROR';
162: WHEN OTHERS THEN
163: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_PARTY_SITE_POST', p_event.getEventName(), p_subscription_guid);
164: WF_EVENT.setErrorInfo(p_event, 'ERROR');

Line 164: WF_EVENT.setErrorInfo(p_event, 'ERROR');

160: WF_EVENT.setErrorInfo(p_event, 'ERROR');
161: RETURN 'ERROR';
162: WHEN OTHERS THEN
163: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_PARTY_SITE_POST', p_event.getEventName(), p_subscription_guid);
164: WF_EVENT.setErrorInfo(p_event, 'ERROR');
165: RETURN 'ERROR';
166:
167: END;
168:

Line 169: FUNCTION UPDATE_PARTY_SITE_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

165: RETURN 'ERROR';
166:
167: END;
168:
169: FUNCTION UPDATE_PARTY_SITE_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
170: CURSOR c1 IS
171: SELECT party_id
172: FROM HZ_PARTY_SITES
173: WHERE party_site_id = p_event.GetValueForParameter('PARTY_SITE_ID');

Line 188: WF_EVENT.setErrorInfo(p_event, 'ERROR');

184: RETURN 'SUCCESS';
185: EXCEPTION
186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
187: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_PARTY_SITE_POST', p_event.getEventName(), p_subscription_guid);
188: WF_EVENT.setErrorInfo(p_event, 'ERROR');
189: RETURN 'ERROR';
190: WHEN OTHERS THEN
191: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_PARTY_SITE_POST', p_event.getEventName(), p_subscription_guid);
192: WF_EVENT.setErrorInfo(p_event, 'ERROR');

Line 192: WF_EVENT.setErrorInfo(p_event, 'ERROR');

188: WF_EVENT.setErrorInfo(p_event, 'ERROR');
189: RETURN 'ERROR';
190: WHEN OTHERS THEN
191: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_PARTY_SITE_POST', p_event.getEventName(), p_subscription_guid);
192: WF_EVENT.setErrorInfo(p_event, 'ERROR');
193: RETURN 'ERROR';
194:
195: END;
196:

Line 198: FUNCTION CREATE_CONTACT_POINT_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

194:
195: END;
196:
197:
198: FUNCTION CREATE_CONTACT_POINT_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
199: CURSOR c1 IS
200: SELECT owner_table_name,owner_table_id
201: FROM hz_contact_points
202: WHERE contact_point_id = p_event.GetValueForParameter('CONTACT_POINT_ID')

Line 239: WF_EVENT.setErrorInfo(p_event, 'ERROR');

235: RETURN 'SUCCESS';
236: EXCEPTION
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_CONTACT_POINT_POST', p_event.getEventName(), p_subscription_guid);
239: WF_EVENT.setErrorInfo(p_event, 'ERROR');
240: RETURN 'ERROR';
241: WHEN OTHERS THEN
242: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_CONTACT_POINT_POST', p_event.getEventName(), p_subscription_guid);
243: WF_EVENT.setErrorInfo(p_event, 'ERROR');

Line 243: WF_EVENT.setErrorInfo(p_event, 'ERROR');

239: WF_EVENT.setErrorInfo(p_event, 'ERROR');
240: RETURN 'ERROR';
241: WHEN OTHERS THEN
242: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'CREATE_CONTACT_POINT_POST', p_event.getEventName(), p_subscription_guid);
243: WF_EVENT.setErrorInfo(p_event, 'ERROR');
244: RETURN 'ERROR';
245:
246: END CREATE_CONTACT_POINT_POST;
247:

Line 248: FUNCTION UPDATE_CONTACT_POINT_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

244: RETURN 'ERROR';
245:
246: END CREATE_CONTACT_POINT_POST;
247:
248: FUNCTION UPDATE_CONTACT_POINT_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
249: CURSOR C1 IS
250: SELECT owner_table_name,owner_table_id
251: FROM hz_contact_points
252: WHERE contact_point_id = p_event.GetValueForParameter('CONTACT_POINT_ID')

Line 289: WF_EVENT.setErrorInfo(p_event, 'ERROR');

285: RETURN 'SUCCESS';
286: EXCEPTION
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_CONTACT_POINT_POST', p_event.getEventName(), p_subscription_guid);
289: WF_EVENT.setErrorInfo(p_event, 'ERROR');
290: RETURN 'ERROR';
291: WHEN OTHERS THEN
292: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_CONTACT_POINT_POST', p_event.getEventName(), p_subscription_guid);
293: WF_EVENT.setErrorInfo(p_event, 'ERROR');

Line 293: WF_EVENT.setErrorInfo(p_event, 'ERROR');

289: WF_EVENT.setErrorInfo(p_event, 'ERROR');
290: RETURN 'ERROR';
291: WHEN OTHERS THEN
292: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_CONTACT_POINT_POST', p_event.getEventName(), p_subscription_guid);
293: WF_EVENT.setErrorInfo(p_event, 'ERROR');
294: RETURN 'ERROR';
295:
296: END UPDATE_CONTACT_POINT_POST;
297:

Line 298: FUNCTION UPDATE_LOCATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS

294: RETURN 'ERROR';
295:
296: END UPDATE_CONTACT_POINT_POST;
297:
298: FUNCTION UPDATE_LOCATION_POST ( p_subscription_guid IN RAW, p_event IN OUT NOCOPY wf_event_t ) RETURN VARCHAR2 IS
299:
300: CURSOR C2 IS
301: SELECT DISTINCT party_id
302: FROM AS_PARTY_ADDRESSES_V

Line 316: WF_EVENT.setErrorInfo(p_event, 'ERROR');

312: RETURN 'SUCCESS';
313: EXCEPTION
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_LOCATION_POST', p_event.getEventName(), p_subscription_guid);
316: WF_EVENT.setErrorInfo(p_event, 'ERROR');
317: RETURN 'ERROR';
318: WHEN OTHERS THEN
319: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_LOCATION_POST', p_event.getEventName(), p_subscription_guid);
320: WF_EVENT.setErrorInfo(p_event, 'ERROR');

Line 320: WF_EVENT.setErrorInfo(p_event, 'ERROR');

316: WF_EVENT.setErrorInfo(p_event, 'ERROR');
317: RETURN 'ERROR';
318: WHEN OTHERS THEN
319: WF_CORE.CONTEXT('AS_RTTAP_ACCOUNT', 'UPDATE_LOCATION_POST', p_event.getEventName(), p_subscription_guid);
320: WF_EVENT.setErrorInfo(p_event, 'ERROR');
321: RETURN 'ERROR';
322: END UPDATE_LOCATION_POST;
323:
324: PROCEDURE RTTAP_WRAPPER(