[Home] [Help]
209:
210:
211: BEGIN
212: l_return_status := fnd_api.g_ret_sts_success;
213: -- Standard start of API savepoint
214: SAVEPOINT Get_ReceivingUnitPrice_GRP;
215:
216: l_stmt_num := 0;
217:
219: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE,G_LOG_HEAD || '.'||l_api_name||'.begin'
220: ,'Get_ReceivingUnitPrice <<');
221: END IF;
222:
223: -- Standard call to check for call compatibility
224: IF NOT FND_API.Compatible_API_Call (
225: l_api_version,
226: p_api_version,
227: l_api_name,
660: END IF; -- l_po_org_id <> l_rcv_org_id
661: ELSE
662: -- Transaction was done after Patchset J and it relates to global procurement
663: -- RAE.unit_price can be used.
664: -- A sum is necessary here since in the case of a standard receipt,
665: -- you could have multiple events - one for each distribution. */
666: -- Added organization check so adjust events in global procurement
667: -- scenarios would get excluded.
668:
822: ,l_api_message);
823: END IF;
824:
825:
826: --- Standard check of p_commit
827: IF FND_API.to_Boolean(p_commit) THEN
828: COMMIT WORK;
829: END IF;
830:
828: COMMIT WORK;
829: END IF;
830:
831:
832: -- Standard Call to get message count and if count = 1, get message info
833: FND_MSG_PUB.Count_And_Get (
834: p_count => x_msg_count,
835: p_data => x_msg_data );
836:
921: BEGIN
922: -- Establish API Savepoint
923: SAVEPOINT Validate_PO_Purge;
924:
925: -- Standard call to check for call compatibility
926: l_stmt_num := 10;
927: IF NOT FND_API.Compatible_API_Call ( l_api_version,
928: p_api_version,
929: l_api_name,
952: EXIT WHEN l_index = p_purge_in_rec.entity_ids.LAST;
953: l_index := p_purge_in_rec.entity_ids.NEXT(l_index);
954: END LOOP;
955:
956: --- Standard check of p_commit
957: IF FND_API.to_Boolean(p_commit) THEN
958: COMMIT WORK;
959: END IF;
960:
1018: BEGIN
1019: -- Establish API Savepoint
1020: SAVEPOINT Purge;
1021:
1022: -- Standard call to check for call compatibility
1023: l_stmt_num := 10;
1024: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1025: p_api_version,
1026: l_api_name,
1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: RAISE DELETE_FAILED;
1059: END;
1060: --- Standard check of p_commit
1061: IF FND_API.to_Boolean(p_commit) THEN
1062: COMMIT WORK;
1063: END IF;
1064: