63:
64: BEGIN
65:
66: -- Log message
67: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || '()+');
68:
69: -- Initialize API return status to success
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
110:
111: IF p_parent_entity_name = 'HZ_PARTIES' THEN
112:
113: -- Log message
114: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
115: arp_message.set_token('TABLE_NAME', 'PRP_PROPOSALS', FALSE);
116:
117: -- Lock table
118: OPEN C1;
111: IF p_parent_entity_name = 'HZ_PARTIES' THEN
112:
113: -- Log message
114: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
115: arp_message.set_token('TABLE_NAME', 'PRP_PROPOSALS', FALSE);
116:
117: -- Lock table
118: OPEN C1;
119: CLOSE C1;
118: OPEN C1;
119: CLOSE C1;
120:
121: -- Log message
122: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
123: arp_message.set_token('TABLE_NAME','PRP_PROPOSALS', FALSE);
124:
125: -- Update table
126: UPDATE prp_proposals SET
119: CLOSE C1;
120:
121: -- Log message
122: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
123: arp_message.set_token('TABLE_NAME','PRP_PROPOSALS', FALSE);
124:
125: -- Update table
126: UPDATE prp_proposals SET
127: party_id = DECODE(party_id, p_from_fk_id, p_to_fk_id, party_id),
140: -- Get the row count
141: l_count := sql%rowcount;
142:
143: -- Log message
144: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
145: arp_message.set_token('NUM_ROWS', to_char(l_count));
146:
147: END IF;
148:
141: l_count := sql%rowcount;
142:
143: -- Log message
144: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
145: arp_message.set_token('NUM_ROWS', to_char(l_count));
146:
147: END IF;
148:
149: END IF;
148:
149: END IF;
150:
151: -- Log message
152: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || '()-');
153:
154: EXCEPTION
155:
156: WHEN OTHERS THEN
153:
154: EXCEPTION
155:
156: WHEN OTHERS THEN
157: arp_message.set_line
158: (
159: G_PKG_NAME || '.' || l_api_name || '():'
160: || 'sqlerrm=' || SQLERRM || ','
161: || 'sqlcode=' || SQLCODE
212:
213: BEGIN
214:
215: -- Log message
216: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || '()+');
217:
218: -- Initialize API return status to success
219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220:
259:
260: IF p_parent_entity_name = 'HZ_PARTIES' THEN
261:
262: -- Log message
263: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
264: arp_message.set_token('TABLE_NAME', 'PRP_EMAIL_RECIPIENTS', FALSE);
265:
266: -- Lock table
267: OPEN C1;
260: IF p_parent_entity_name = 'HZ_PARTIES' THEN
261:
262: -- Log message
263: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
264: arp_message.set_token('TABLE_NAME', 'PRP_EMAIL_RECIPIENTS', FALSE);
265:
266: -- Lock table
267: OPEN C1;
268: CLOSE C1;
267: OPEN C1;
268: CLOSE C1;
269:
270: -- Log message
271: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
272: arp_message.set_token('TABLE_NAME','PRP_EMAIL_RECIPIENTS', FALSE);
273:
274: -- Update table
275: UPDATE prp_email_recipients SET
268: CLOSE C1;
269:
270: -- Log message
271: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
272: arp_message.set_token('TABLE_NAME','PRP_EMAIL_RECIPIENTS', FALSE);
273:
274: -- Update table
275: UPDATE prp_email_recipients SET
276: party_id = p_to_fk_id,
286: -- Get the row count
287: l_count := sql%rowcount;
288:
289: -- Log message
290: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
291: arp_message.set_token('NUM_ROWS', to_char(l_count));
292:
293: END IF;
294:
287: l_count := sql%rowcount;
288:
289: -- Log message
290: arp_message.set_name('AR', 'AR_ROWS_UPDATED');
291: arp_message.set_token('NUM_ROWS', to_char(l_count));
292:
293: END IF;
294:
295: END IF;
294:
295: END IF;
296:
297: -- Log message
298: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || '()-');
299:
300: EXCEPTION
301:
302: WHEN OTHERS THEN
299:
300: EXCEPTION
301:
302: WHEN OTHERS THEN
303: arp_message.set_line
304: (
305: G_PKG_NAME || '.' || l_api_name || '():'
306: || 'sqlerrm=' || SQLERRM || ','
307: || 'sqlcode=' || SQLCODE