DBA Data[Home] [Help]

APPS.PRP_PARTY_MERGE_PVT dependencies on ARP_MESSAGE

Line 67: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || '()+');

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:

Line 114: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

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;

Line 115: arp_message.set_token('TABLE_NAME', 'PRP_PROPOSALS', FALSE);

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;

Line 122: arp_message.set_name('AR', 'AR_UPDATING_TABLE');

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

Line 123: arp_message.set_token('TABLE_NAME','PRP_PROPOSALS', FALSE);

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),

Line 144: arp_message.set_name('AR', 'AR_ROWS_UPDATED');

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:

Line 145: arp_message.set_token('NUM_ROWS', to_char(l_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:
149: END IF;

Line 152: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || '()-');

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

Line 157: arp_message.set_line

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

Line 216: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || '()+');

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:

Line 263: arp_message.set_name('AR', 'AR_LOCKING_TABLE');

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;

Line 264: arp_message.set_token('TABLE_NAME', 'PRP_EMAIL_RECIPIENTS', FALSE);

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;

Line 271: arp_message.set_name('AR', 'AR_UPDATING_TABLE');

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

Line 272: arp_message.set_token('TABLE_NAME','PRP_EMAIL_RECIPIENTS', FALSE);

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,

Line 290: arp_message.set_name('AR', 'AR_ROWS_UPDATED');

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:

Line 291: arp_message.set_token('NUM_ROWS', to_char(l_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:
295: END IF;

Line 298: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || '()-');

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

Line 303: arp_message.set_line

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