eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PARTYMERGE_GRP dependencies on FND_MESSAGE

Line 81: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO_FAIL');

77:
78:
79: IF l_vndrsites_not_merged > 0 THEN
80:
81: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO_FAIL');
82: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);
83: fnd_msg_pub.ADD;
84: x_return_status := FND_API.G_RET_STS_ERROR;
85:

Line 82: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);

78:
79: IF l_vndrsites_not_merged > 0 THEN
80:
81: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO_FAIL');
82: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);
83: fnd_msg_pub.ADD;
84: x_return_status := FND_API.G_RET_STS_ERROR;
85:
86: END IF;

Line 113: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO_FAIL');

109: AND nvl(ai.payment_status_flag,'N') <> 'Y';
110:
111: IF l_unpaid_invoices > 0 THEN
112:
113: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO_FAIL');
114: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);
115: fnd_msg_pub.ADD;
116: x_return_status := FND_API.G_RET_STS_ERROR;
117:

Line 114: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);

110:
111: IF l_unpaid_invoices > 0 THEN
112:
113: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO_FAIL');
114: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);
115: fnd_msg_pub.ADD;
116: x_return_status := FND_API.G_RET_STS_ERROR;
117:
118: END IF;

Line 160: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO_FAIL');

156: AND nvl(adv.process, 'N') = 'I';
157:
158: IF l_po_unchecked_sites > 0 THEN
159:
160: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO_FAIL');
161: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);
162: fnd_msg_pub.ADD;
163: x_return_status := FND_API.G_RET_STS_ERROR;
164:

Line 161: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);

157:
158: IF l_po_unchecked_sites > 0 THEN
159:
160: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO_FAIL');
161: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);
162: fnd_msg_pub.ADD;
163: x_return_status := FND_API.G_RET_STS_ERROR;
164:
165: END IF;

Line 193: fnd_message.set_name('SQLAP','AP_PARTY_SUPP_MISS_VETO_FAIL');

189: where pav1.party_site_id = p_to_fk_id);
190:
191: IF l_no_mergedto_site > 0 THEN
192:
193: fnd_message.set_name('SQLAP','AP_PARTY_SUPP_MISS_VETO_FAIL');
194: fnd_message.set_token('PARTY_SITE_ID', p_to_fk_id);
195: fnd_msg_pub.ADD;
196: x_return_status := FND_API.G_RET_STS_ERROR;
197:

Line 194: fnd_message.set_token('PARTY_SITE_ID', p_to_fk_id);

190:
191: IF l_no_mergedto_site > 0 THEN
192:
193: fnd_message.set_name('SQLAP','AP_PARTY_SUPP_MISS_VETO_FAIL');
194: fnd_message.set_token('PARTY_SITE_ID', p_to_fk_id);
195: fnd_msg_pub.ADD;
196: x_return_status := FND_API.G_RET_STS_ERROR;
197:
198: END IF;

Line 235: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO5_FAIL');

231: and pav1.party_site_id = p_to_fk_id);
232:
233: IF l_mismatch_merge_sites > 0 THEN
234:
235: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO5_FAIL');
236: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);
237: fnd_msg_pub.ADD;
238: x_return_status := FND_API.G_RET_STS_ERROR;
239:

Line 236: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);

232:
233: IF l_mismatch_merge_sites > 0 THEN
234:
235: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO5_FAIL');
236: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);
237: fnd_msg_pub.ADD;
238: x_return_status := FND_API.G_RET_STS_ERROR;
239:
240: END IF;

Line 246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

242:
243: EXCEPTION
244: WHEN OTHERS THEN
245: IF (SQLCODE <> -20001) THEN
246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
248: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
249: FND_MESSAGE.SET_TOKEN('PARAMETERS',
250: 'Entity Name = '|| p_Entity_name

Line 247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

243: EXCEPTION
244: WHEN OTHERS THEN
245: IF (SQLCODE <> -20001) THEN
246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
248: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
249: FND_MESSAGE.SET_TOKEN('PARAMETERS',
250: 'Entity Name = '|| p_Entity_name
251: ||', From Id = '|| to_char(p_from_id )

Line 248: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

244: WHEN OTHERS THEN
245: IF (SQLCODE <> -20001) THEN
246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
248: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
249: FND_MESSAGE.SET_TOKEN('PARAMETERS',
250: 'Entity Name = '|| p_Entity_name
251: ||', From Id = '|| to_char(p_from_id )
252: ||', To Id = '|| to_char(p_to_id )

Line 249: FND_MESSAGE.SET_TOKEN('PARAMETERS',

245: IF (SQLCODE <> -20001) THEN
246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
248: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
249: FND_MESSAGE.SET_TOKEN('PARAMETERS',
250: 'Entity Name = '|| p_Entity_name
251: ||', From Id = '|| to_char(p_from_id )
252: ||', To Id = '|| to_char(p_to_id )
253: ||', From Foreign Key = '|| to_char(p_From_FK_id)

Line 351: fnd_message.set_name('SQLAP','PARTY_VETO_FAIL');

347: AND nvl(adv.process_flag, 'N') <> 'Y';
348:
349: IF l_vndrsites_not_merged > 0 THEN
350:
351: fnd_message.set_name('SQLAP','PARTY_VETO_FAIL');
352: fnd_message.set_token('PARTY_ID', p_from_fk_id);
353: fnd_msg_pub.ADD;
354: x_return_status := FND_API.G_RET_STS_ERROR;
355:

Line 352: fnd_message.set_token('PARTY_ID', p_from_fk_id);

348:
349: IF l_vndrsites_not_merged > 0 THEN
350:
351: fnd_message.set_name('SQLAP','PARTY_VETO_FAIL');
352: fnd_message.set_token('PARTY_ID', p_from_fk_id);
353: fnd_msg_pub.ADD;
354: x_return_status := FND_API.G_RET_STS_ERROR;
355:
356: END IF;

Line 387: fnd_message.set_name('SQLAP','AP_PARTY_VETO_FAIL');

383: AND nvl(ai.payment_status_flag,'N') <> 'Y';
384:
385: IF l_unpaid_invoices > 0 THEN
386:
387: fnd_message.set_name('SQLAP','AP_PARTY_VETO_FAIL');
388: fnd_message.set_token('PARTY_ID', p_from_fk_id);
389: fnd_msg_pub.ADD;
390: x_return_status := FND_API.G_RET_STS_ERROR;
391:

Line 388: fnd_message.set_token('PARTY_ID', p_from_fk_id);

384:
385: IF l_unpaid_invoices > 0 THEN
386:
387: fnd_message.set_name('SQLAP','AP_PARTY_VETO_FAIL');
388: fnd_message.set_token('PARTY_ID', p_from_fk_id);
389: fnd_msg_pub.ADD;
390: x_return_status := FND_API.G_RET_STS_ERROR;
391:
392: END IF;

Line 436: fnd_message.set_name('SQLAP','AP_PARTY_VETO_FAIL');

432: and nvl(adv.process, 'N') = 'I';
433:
434: IF l_po_unchecked_sites > 0 THEN
435:
436: fnd_message.set_name('SQLAP','AP_PARTY_VETO_FAIL');
437: fnd_message.set_token('PARTY_ID', p_from_fk_id);
438: fnd_msg_pub.ADD;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:

Line 437: fnd_message.set_token('PARTY_ID', p_from_fk_id);

433:
434: IF l_po_unchecked_sites > 0 THEN
435:
436: fnd_message.set_name('SQLAP','AP_PARTY_VETO_FAIL');
437: fnd_message.set_token('PARTY_ID', p_from_fk_id);
438: fnd_msg_pub.ADD;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
441: END IF;

Line 476: fnd_message.set_name('SQLAP','AP_PARTY_SUPP_MISS_VETO_FAIL');

472: and pov1.vendor_id = pvs1.vendor_id);
473:
474: IF l_no_mergedto_site > 0 THEN
475:
476: fnd_message.set_name('SQLAP','AP_PARTY_SUPP_MISS_VETO_FAIL');
477: fnd_message.set_token('PARTY_ID', p_to_fk_id);
478: fnd_msg_pub.ADD;
479: x_return_status := FND_API.G_RET_STS_ERROR;
480:

Line 477: fnd_message.set_token('PARTY_ID', p_to_fk_id);

473:
474: IF l_no_mergedto_site > 0 THEN
475:
476: fnd_message.set_name('SQLAP','AP_PARTY_SUPP_MISS_VETO_FAIL');
477: fnd_message.set_token('PARTY_ID', p_to_fk_id);
478: fnd_msg_pub.ADD;
479: x_return_status := FND_API.G_RET_STS_ERROR;
480:
481: END IF;

Line 522: fnd_message.set_name('SQLAP','AP_PARTY_VETO5_FAIL');

518: and aps1.party_id = p_to_fk_id);
519:
520: IF l_mismatch_merge_sites > 0 THEN
521:
522: fnd_message.set_name('SQLAP','AP_PARTY_VETO5_FAIL');
523: fnd_message.set_token('PARTY_ID', p_from_id);
524: fnd_msg_pub.ADD;
525: x_return_status := FND_API.G_RET_STS_ERROR;
526:

Line 523: fnd_message.set_token('PARTY_ID', p_from_id);

519:
520: IF l_mismatch_merge_sites > 0 THEN
521:
522: fnd_message.set_name('SQLAP','AP_PARTY_VETO5_FAIL');
523: fnd_message.set_token('PARTY_ID', p_from_id);
524: fnd_msg_pub.ADD;
525: x_return_status := FND_API.G_RET_STS_ERROR;
526:
527: END IF;

Line 534: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

530: EXCEPTION
531: WHEN OTHERS THEN
532:
533: IF (SQLCODE <> -20001) THEN
534: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
535: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
536: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
537: FND_MESSAGE.SET_TOKEN('PARAMETERS',
538: 'Entity Name = '|| p_Entity_name

Line 535: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

531: WHEN OTHERS THEN
532:
533: IF (SQLCODE <> -20001) THEN
534: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
535: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
536: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
537: FND_MESSAGE.SET_TOKEN('PARAMETERS',
538: 'Entity Name = '|| p_Entity_name
539: ||', From Id = '|| to_char(p_from_id )

Line 536: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

532:
533: IF (SQLCODE <> -20001) THEN
534: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
535: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
536: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
537: FND_MESSAGE.SET_TOKEN('PARAMETERS',
538: 'Entity Name = '|| p_Entity_name
539: ||', From Id = '|| to_char(p_from_id )
540: ||', To Id = '|| to_char(p_to_id )

Line 537: FND_MESSAGE.SET_TOKEN('PARAMETERS',

533: IF (SQLCODE <> -20001) THEN
534: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
535: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
536: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
537: FND_MESSAGE.SET_TOKEN('PARAMETERS',
538: 'Entity Name = '|| p_Entity_name
539: ||', From Id = '|| to_char(p_from_id )
540: ||', To Id = '|| to_char(p_to_id )
541: ||', From Foreign Key = '|| to_char(p_From_FK_id)

Line 592: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

588:
589: EXCEPTION
590: WHEN OTHERS THEN
591: IF (SQLCODE <> -20001) THEN
592: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
593: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
594: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
595: FND_MESSAGE.SET_TOKEN('PARAMETERS',
596: 'Entity Name = '|| p_Entity_name

Line 593: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

589: EXCEPTION
590: WHEN OTHERS THEN
591: IF (SQLCODE <> -20001) THEN
592: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
593: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
594: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
595: FND_MESSAGE.SET_TOKEN('PARAMETERS',
596: 'Entity Name = '|| p_Entity_name
597: ||', From Id = '|| to_char(p_from_id )

Line 594: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

590: WHEN OTHERS THEN
591: IF (SQLCODE <> -20001) THEN
592: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
593: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
594: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
595: FND_MESSAGE.SET_TOKEN('PARAMETERS',
596: 'Entity Name = '|| p_Entity_name
597: ||', From Id = '|| to_char(p_from_id )
598: ||', To Id = '|| to_char(p_to_id )

Line 595: FND_MESSAGE.SET_TOKEN('PARAMETERS',

591: IF (SQLCODE <> -20001) THEN
592: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
593: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
594: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
595: FND_MESSAGE.SET_TOKEN('PARAMETERS',
596: 'Entity Name = '|| p_Entity_name
597: ||', From Id = '|| to_char(p_from_id )
598: ||', To Id = '|| to_char(p_to_id )
599: ||', From Foreign Key = '|| to_char(p_From_FK_id)

Line 650: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: IF (SQLCODE <> -20001) THEN
650: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
651: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
652: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
653: FND_MESSAGE.SET_TOKEN('PARAMETERS',
654: 'Entity Name = '|| p_Entity_name

Line 651: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

647: EXCEPTION
648: WHEN OTHERS THEN
649: IF (SQLCODE <> -20001) THEN
650: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
651: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
652: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
653: FND_MESSAGE.SET_TOKEN('PARAMETERS',
654: 'Entity Name = '|| p_Entity_name
655: ||', From Id = '|| to_char(p_from_id )

Line 652: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

648: WHEN OTHERS THEN
649: IF (SQLCODE <> -20001) THEN
650: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
651: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
652: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
653: FND_MESSAGE.SET_TOKEN('PARAMETERS',
654: 'Entity Name = '|| p_Entity_name
655: ||', From Id = '|| to_char(p_from_id )
656: ||', To Id = '|| to_char(p_to_id )

Line 653: FND_MESSAGE.SET_TOKEN('PARAMETERS',

649: IF (SQLCODE <> -20001) THEN
650: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
651: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
652: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
653: FND_MESSAGE.SET_TOKEN('PARAMETERS',
654: 'Entity Name = '|| p_Entity_name
655: ||', From Id = '|| to_char(p_from_id )
656: ||', To Id = '|| to_char(p_to_id )
657: ||', From Foreign Key = '|| to_char(p_From_FK_id)

Line 708: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

704:
705: EXCEPTION
706: WHEN OTHERS THEN
707: IF (SQLCODE <> -20001) THEN
708: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
709: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
710: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
711: FND_MESSAGE.SET_TOKEN('PARAMETERS',
712: 'Entity Name = '|| p_Entity_name

Line 709: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

705: EXCEPTION
706: WHEN OTHERS THEN
707: IF (SQLCODE <> -20001) THEN
708: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
709: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
710: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
711: FND_MESSAGE.SET_TOKEN('PARAMETERS',
712: 'Entity Name = '|| p_Entity_name
713: ||', From Id = '|| to_char(p_from_id )

Line 710: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);

706: WHEN OTHERS THEN
707: IF (SQLCODE <> -20001) THEN
708: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
709: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
710: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
711: FND_MESSAGE.SET_TOKEN('PARAMETERS',
712: 'Entity Name = '|| p_Entity_name
713: ||', From Id = '|| to_char(p_from_id )
714: ||', To Id = '|| to_char(p_to_id )

Line 711: FND_MESSAGE.SET_TOKEN('PARAMETERS',

707: IF (SQLCODE <> -20001) THEN
708: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
709: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
710: -- FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
711: FND_MESSAGE.SET_TOKEN('PARAMETERS',
712: 'Entity Name = '|| p_Entity_name
713: ||', From Id = '|| to_char(p_from_id )
714: ||', To Id = '|| to_char(p_to_id )
715: ||', From Foreign Key = '|| to_char(p_From_FK_id)