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 242: x_return_status := FND_API.G_RET_STS_ERROR;

238:
239: fnd_message.set_name('SQLAP','AP_PARTYSITE_VETO5_FAIL');
240: fnd_message.set_token('PARTY_SITE_ID', p_from_fk_id);
241: fnd_msg_pub.ADD;
242: x_return_status := FND_API.G_RET_STS_ERROR;
243:
244: END IF;
245: END IF;
246:

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261: ||', Batch Party Id = '|| to_char(p_Batch_Party_id));
262: FND_MSG_PUB.ADD;
263: END IF;
264:
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266:
267: END Veto_PartySiteMerge;
268:
269: --

Line 294: x_return_status := FND_API.G_RET_STS_SUCCESS;

290: l_debug_info VARCHAR2(2000);
291:
292: BEGIN
293:
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
298: 'p_Entity_name: '|| p_Entity_name);

Line 358: x_return_status := FND_API.G_RET_STS_ERROR;

354:
355: fnd_message.set_name('SQLAP','PARTY_VETO_FAIL');
356: fnd_message.set_token('PARTY_ID', p_from_fk_id);
357: fnd_msg_pub.ADD;
358: x_return_status := FND_API.G_RET_STS_ERROR;
359:
360: END IF;
361:
362: ------------------------------------------------------------------------

Line 369: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

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

Line 394: x_return_status := FND_API.G_RET_STS_ERROR;

390:
391: fnd_message.set_name('SQLAP','AP_PARTY_VETO_FAIL');
392: fnd_message.set_token('PARTY_ID', p_from_fk_id);
393: fnd_msg_pub.ADD;
394: x_return_status := FND_API.G_RET_STS_ERROR;
395:
396: END IF;
397: END IF;
398:

Line 406: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

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

Line 443: x_return_status := FND_API.G_RET_STS_ERROR;

439:
440: fnd_message.set_name('SQLAP','AP_PARTY_VETO_FAIL');
441: fnd_message.set_token('PARTY_ID', p_from_fk_id);
442: fnd_msg_pub.ADD;
443: x_return_status := FND_API.G_RET_STS_ERROR;
444:
445: END IF;
446: END IF;
447:

Line 455: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

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

Line 483: x_return_status := FND_API.G_RET_STS_ERROR;

479:
480: fnd_message.set_name('SQLAP','AP_PARTY_SUPP_MISS_VETO_FAIL');
481: fnd_message.set_token('PARTY_ID', p_to_fk_id);
482: fnd_msg_pub.ADD;
483: x_return_status := FND_API.G_RET_STS_ERROR;
484:
485: END IF;
486: END IF;
487:

Line 495: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN

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

Line 533: x_return_status := FND_API.G_RET_STS_ERROR;

529:
530: fnd_message.set_name('SQLAP','AP_PARTY_VETO5_FAIL');
531: fnd_message.set_token('PARTY_ID', p_from_id);
532: fnd_msg_pub.ADD;
533: x_return_status := FND_API.G_RET_STS_ERROR;
534:
535: END IF;
536: END IF;
537:

Line 557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

553: ||', Batch Party Id = '|| to_char(p_Batch_Party_id));
554: FND_MSG_PUB.ADD;
555: END IF;
556:
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558:
559: END Veto_PartyMerge;
560:
561: --

Line 583: x_return_status := FND_API.G_RET_STS_SUCCESS;

579: l_debug_info VARCHAR2(2000);
580:
581: BEGIN
582:
583: x_return_status := FND_API.G_RET_STS_SUCCESS;
584:
585: ------------------------------------------------------------------------
586: l_debug_info := 'Updating po_vendor_contacts';
587: ------------------------------------------------------------------------

Line 615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

611: ||', Batch Party Id = '|| to_char(p_Batch_Party_id));
612: FND_MSG_PUB.ADD;
613: END IF;
614:
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
616:
617: END Update_PerPartyid ;
618:
619: --

Line 641: x_return_status := FND_API.G_RET_STS_SUCCESS;

637: l_debug_info VARCHAR2(2000);
638:
639: BEGIN
640:
641: x_return_status := FND_API.G_RET_STS_SUCCESS;
642:
643: ------------------------------------------------------------------------
644: l_debug_info := 'Updating po_vendor_contacts';
645: ------------------------------------------------------------------------

Line 673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

669: ||', Batch Party Id = '|| to_char(p_Batch_Party_id));
670: FND_MSG_PUB.ADD;
671: END IF;
672:
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
674:
675: END Update_RelPartyid;
676:
677: --

Line 699: x_return_status := FND_API.G_RET_STS_SUCCESS;

695: l_debug_info VARCHAR2(2000);
696:
697: BEGIN
698:
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: ------------------------------------------------------------------------
702: l_debug_info := 'Updating po_vendor_contacts';
703: ------------------------------------------------------------------------

Line 731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

727: ||', Batch Party Id = '|| to_char(p_Batch_Party_id));
728: FND_MSG_PUB.ADD;
729: END IF;
730:
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
732:
733: END Update_PartySiteid ;
734:
735: /*bug12389663*/

Line 754: x_return_status := FND_API.G_RET_STS_SUCCESS;

750: l_debug_info VARCHAR2(2000);
751:
752: BEGIN
753:
754: x_return_status := FND_API.G_RET_STS_SUCCESS;
755:
756: ------------------------------------------------------------------------
757: l_debug_info := 'Updating po_vendor_contacts';
758: ------------------------------------------------------------------------

Line 785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

781: ||', Batch Party Id = '|| to_char(p_Batch_Party_id));
782: FND_MSG_PUB.ADD;
783: END IF;
784:
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
786:
787: END Update_RelationshipId ;
788:
789: /*bug12389663*/

Line 808: x_return_status := FND_API.G_RET_STS_SUCCESS;

804: l_debug_info VARCHAR2(2000);
805:
806: BEGIN
807:
808: x_return_status := FND_API.G_RET_STS_SUCCESS;
809:
810: ------------------------------------------------------------------------
811: l_debug_info := 'Updating po_vendor_contacts';
812: ------------------------------------------------------------------------

Line 839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

835: ||', Batch Party Id = '|| to_char(p_Batch_Party_id));
836: FND_MSG_PUB.ADD;
837: END IF;
838:
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
840:
841: END Update_OrgContactId ;
842:
843: