DBA Data[Home] [Help]

APPS.AP_PARTYMERGE_GRP dependencies on FND_API

Line 34: x_return_status := FND_API.G_RET_STS_SUCCESS;

30: l_api_name CONSTANT VARCHAR2(30) := 'Veto_PartySiteMerge';
31:
32: BEGIN
33:
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35:
36: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
37: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
38: 'p_Entity_name: '|| p_Entity_name);

Line 84: x_return_status := FND_API.G_RET_STS_ERROR;

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;
87:
88: ------------------------------------------------------------------------

Line 95: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

91: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
92: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
93: END IF;
94:
95: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
96:
97: -- Veto Rule 2
98: -- Checking for unpaid(including partially paid invoices) invoices
99: -- associated with the party_site being merged

Line 116: x_return_status := FND_API.G_RET_STS_ERROR;

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;
119: END IF;
120:

Line 128: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

124: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
125: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
126: END IF;
127:
128: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
129:
130: -- Veto Rule 3
131: -- Checking if the user had not checked the Transfer PO Checkbox on
132: -- the Supplier Merge Form

Line 163: x_return_status := FND_API.G_RET_STS_ERROR;

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;
166: END IF;
167:

Line 175: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

171: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
173: END IF;
174:
175: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
176:
177: -- Veto Rule 4
178: -- A Supplier/Supplier Site is associated with the merged-from
179: -- Party/Party Site but there is no Supplier/Supplier Site

Line 196: x_return_status := FND_API.G_RET_STS_ERROR;

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;
199: END IF;
200:

Line 208: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

204: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
206: END IF;
207:
208: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
209:
210: -- Veto Rule 5
211: -- Payables must confirm that the merged-from Party/Party Site
212: -- and merged-to Party/Party Site are correlated th the same

Line 238: x_return_status := FND_API.G_RET_STS_ERROR;

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;
241: END IF;
242:

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

257: ||', Batch Party Id = '|| to_char(p_Batch_Party_id));
258: FND_MSG_PUB.ADD;
259: END IF;
260:
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262:
263: END Veto_PartySiteMerge;
264:
265: --

Line 290: x_return_status := FND_API.G_RET_STS_SUCCESS;

286: l_debug_info VARCHAR2(2000);
287:
288: BEGIN
289:
290: x_return_status := FND_API.G_RET_STS_SUCCESS;
291:
292: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
293: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
294: 'p_Entity_name: '|| p_Entity_name);

Line 354: x_return_status := FND_API.G_RET_STS_ERROR;

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;
357:
358: ------------------------------------------------------------------------

Line 365: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

361: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
362: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
363: END IF;
364:
365: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
366:
367: -- Veto Rule 2
368: -- Checking for unpaid(including partially paid invoices) invoices
369: -- associated with the party_site being merged

Line 390: x_return_status := FND_API.G_RET_STS_ERROR;

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;
393: END IF;
394:

Line 402: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

398: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
399: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
400: END IF;
401:
402: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
403:
404: -- Veto Rule 3
405: -- Checking if the user had not checked the Transfer PO Checkbox on
406: -- the Supplier Merge Form

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

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;
442: END IF;
443:

Line 451: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

447: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
448: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
449: END IF;
450:
451: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
452:
453: -- Veto Rule 4
454: -- A Supplier/Supplier Site is associated with the merged-from
455: -- Party/Party Site but there is no Supplier/Supplier Site

Line 479: x_return_status := FND_API.G_RET_STS_ERROR;

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;
482: END IF;
483:

Line 491: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

487: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
488: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
489: END IF;
490:
491: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
492:
493: -- Veto Rule 5
494: -- Payables must confirm that the merged-from Party/Party Site
495: -- and merged-to Party/Party Site are correlated with the same

Line 525: x_return_status := FND_API.G_RET_STS_ERROR;

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;
528: END IF;
529:

Line 549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

545: ||', Batch Party Id = '|| to_char(p_Batch_Party_id));
546: FND_MSG_PUB.ADD;
547: END IF;
548:
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550:
551: END Veto_PartyMerge;
552:
553: --

Line 575: x_return_status := FND_API.G_RET_STS_SUCCESS;

571: l_debug_info VARCHAR2(2000);
572:
573: BEGIN
574:
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576:
577: ------------------------------------------------------------------------
578: l_debug_info := 'Updating po_vendor_contacts';
579: ------------------------------------------------------------------------

Line 607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

603: ||', Batch Party Id = '|| to_char(p_Batch_Party_id));
604: FND_MSG_PUB.ADD;
605: END IF;
606:
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
608:
609: END Update_PerPartyid ;
610:
611: --

Line 633: x_return_status := FND_API.G_RET_STS_SUCCESS;

629: l_debug_info VARCHAR2(2000);
630:
631: BEGIN
632:
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: ------------------------------------------------------------------------
636: l_debug_info := 'Updating po_vendor_contacts';
637: ------------------------------------------------------------------------

Line 665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

661: ||', Batch Party Id = '|| to_char(p_Batch_Party_id));
662: FND_MSG_PUB.ADD;
663: END IF;
664:
665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
666:
667: END Update_RelPartyid;
668:
669: --

Line 691: x_return_status := FND_API.G_RET_STS_SUCCESS;

687: l_debug_info VARCHAR2(2000);
688:
689: BEGIN
690:
691: x_return_status := FND_API.G_RET_STS_SUCCESS;
692:
693: ------------------------------------------------------------------------
694: l_debug_info := 'Updating po_vendor_contacts';
695: ------------------------------------------------------------------------

Line 723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

719: ||', Batch Party Id = '|| to_char(p_Batch_Party_id));
720: FND_MSG_PUB.ADD;
721: END IF;
722:
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
724:
725: END Update_PartySiteid ;
726:
727: END AP_PartyMerge_GRP;