74: if P_STATUS is null then
75: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
76: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
77: END IF;
78: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
79: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
80: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
81: FND_MSG_PUB.Add;
82: RAISE FND_API.G_EXC_ERROR;
75: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
76: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
77: END IF;
78: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
79: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
80: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
81: FND_MSG_PUB.Add;
82: RAISE FND_API.G_EXC_ERROR;
83: end if;
76: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
77: END IF;
78: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
79: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
80: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
81: FND_MSG_PUB.Add;
82: RAISE FND_API.G_EXC_ERROR;
83: end if;
84:
91: if P_PROMISE_TBL.count = 0 then
92: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
93: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
94: END IF;
95: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
96: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
97: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
98: FND_MSG_PUB.Add;
99: RAISE FND_API.G_EXC_ERROR;
92: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
93: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
94: END IF;
95: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
96: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
97: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
98: FND_MSG_PUB.Add;
99: RAISE FND_API.G_EXC_ERROR;
100: end if;
93: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
94: END IF;
95: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
96: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
97: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
98: FND_MSG_PUB.Add;
99: RAISE FND_API.G_EXC_ERROR;
100: end if;
101:
108: if P_DAYS is not null and P_DAYS < 0 then
109: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
110: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
111: END IF;
112: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
113: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
114: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
115: FND_MSG_PUB.Add;
116: RAISE FND_API.G_EXC_ERROR;
109: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
110: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
111: END IF;
112: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
113: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
114: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
115: FND_MSG_PUB.Add;
116: RAISE FND_API.G_EXC_ERROR;
117: end if;
110: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
111: END IF;
112: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
113: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
114: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
115: FND_MSG_PUB.Add;
116: RAISE FND_API.G_EXC_ERROR;
117: end if;
118:
292: if P_PROMISE_ID is null then
293: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
294: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Error! P_PROMISE_ID is null');
295: END IF;
296: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
297: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
298: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PROMISE_ID');
299: FND_MSG_PUB.Add;
300: RAISE FND_API.G_EXC_ERROR;
293: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
294: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Error! P_PROMISE_ID is null');
295: END IF;
296: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
297: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
298: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PROMISE_ID');
299: FND_MSG_PUB.Add;
300: RAISE FND_API.G_EXC_ERROR;
301: end if;
294: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Error! P_PROMISE_ID is null');
295: END IF;
296: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
297: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
298: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_PROMISE_ID');
299: FND_MSG_PUB.Add;
300: RAISE FND_API.G_EXC_ERROR;
301: end if;
302:
303: if P_STATUS is null then
304: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
305: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Error! P_STATUS is null');
306: END IF;
307: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
308: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
309: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_STATUS');
310: FND_MSG_PUB.Add;
311: RAISE FND_API.G_EXC_ERROR;
304: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
305: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Error! P_STATUS is null');
306: END IF;
307: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
308: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
309: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_STATUS');
310: FND_MSG_PUB.Add;
311: RAISE FND_API.G_EXC_ERROR;
312: end if;
305: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Error! P_STATUS is null');
306: END IF;
307: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
308: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
309: FND_MESSAGE.SET_TOKEN('API_PARAMETER', 'P_STATUS');
310: FND_MSG_PUB.Add;
311: RAISE FND_API.G_EXC_ERROR;
312: end if;
313:
462: iex_debug_pub.LogMessage(G_PKG_NAME || '.SEND_FFM: request_id ' || l_request_id);
463: iex_debug_pub.LogMessage(G_PKG_NAME || '.SEND_FFM: Return status ' || l_return_status);
464: END IF;
465: IF l_return_status <> 'S' then
466: FND_MESSAGE.SET_NAME('IEX', 'IEX_FULFILLMENT_ERROR');
467: FND_MSG_PUB.Add;
468: end if;
469: end if;
470: end if;
620: then
621: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
622: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
623: END IF;
624: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
625: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
626: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
627: FND_MSG_PUB.Add;
628: RAISE FND_API.G_EXC_ERROR;
621: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
622: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
623: END IF;
624: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
625: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
626: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
627: FND_MSG_PUB.Add;
628: RAISE FND_API.G_EXC_ERROR;
629: end if;
622: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
623: END IF;
624: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
625: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
626: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
627: FND_MSG_PUB.Add;
628: RAISE FND_API.G_EXC_ERROR;
629: end if;
630:
637: if P_PROMISE_REC.PROMISE_AMOUNT is null or P_PROMISE_REC.PROMISE_AMOUNT <= 0 then
638: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
639: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
640: END IF;
641: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
642: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
643: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
644: FND_MSG_PUB.Add;
645: RAISE FND_API.G_EXC_ERROR;
638: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
639: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
640: END IF;
641: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
642: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
643: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
644: FND_MSG_PUB.Add;
645: RAISE FND_API.G_EXC_ERROR;
646: end if;
639: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
640: END IF;
641: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
642: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
643: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
644: FND_MSG_PUB.Add;
645: RAISE FND_API.G_EXC_ERROR;
646: end if;
647:
654: if P_PROMISE_REC.PROMISE_DATE is null or trunc(P_PROMISE_REC.PROMISE_DATE) < trunc(sysdate) then
655: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
656: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
657: END IF;
658: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
659: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
660: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
661: FND_MSG_PUB.Add;
662: RAISE FND_API.G_EXC_ERROR;
655: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
656: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
657: END IF;
658: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
659: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
660: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
661: FND_MSG_PUB.Add;
662: RAISE FND_API.G_EXC_ERROR;
663: end if;
656: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
657: END IF;
658: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
659: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
660: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
661: FND_MSG_PUB.Add;
662: RAISE FND_API.G_EXC_ERROR;
663: end if;
664:
671: if P_PROMISE_REC.CURRENCY_CODE is null then
672: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
673: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
674: END IF;
675: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
676: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
677: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
678: FND_MSG_PUB.Add;
679: RAISE FND_API.G_EXC_ERROR;
672: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
673: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
674: END IF;
675: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
676: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
677: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
678: FND_MSG_PUB.Add;
679: RAISE FND_API.G_EXC_ERROR;
680: end if;
673: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
674: END IF;
675: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
676: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
677: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
678: FND_MSG_PUB.Add;
679: RAISE FND_API.G_EXC_ERROR;
680: end if;
681:
688: if P_PROMISE_REC.TAKEN_BY_RESOURCE_ID is null then
689: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
690: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
691: END IF;
692: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
693: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
694: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
695: FND_MSG_PUB.Add;
696: RAISE FND_API.G_EXC_ERROR;
689: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
690: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
691: END IF;
692: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
693: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
694: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
695: FND_MSG_PUB.Add;
696: RAISE FND_API.G_EXC_ERROR;
697: end if;
690: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
691: END IF;
692: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
693: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
694: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
695: FND_MSG_PUB.Add;
696: RAISE FND_API.G_EXC_ERROR;
697: end if;
698:
727: if l_cursor%rowcount = 0 or l_result_varchar is null then
728: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
729: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation: wrong payment method');
730: END IF;
731: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
732: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
733: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
734: FND_MSG_PUB.Add;
735: RAISE FND_API.G_EXC_ERROR;
728: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
729: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation: wrong payment method');
730: END IF;
731: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
732: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
733: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
734: FND_MSG_PUB.Add;
735: RAISE FND_API.G_EXC_ERROR;
736: end if;
729: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation: wrong payment method');
730: END IF;
731: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
732: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
733: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
734: FND_MSG_PUB.Add;
735: RAISE FND_API.G_EXC_ERROR;
736: end if;
737: else
749: if P_PROMISE_REC.CUST_ACCOUNT_ID is null then
750: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
751: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
752: END IF;
753: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
754: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
755: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
756: FND_MSG_PUB.Add;
757: RAISE FND_API.G_EXC_ERROR;
750: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
751: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
752: END IF;
753: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
754: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
755: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
756: FND_MSG_PUB.Add;
757: RAISE FND_API.G_EXC_ERROR;
758: end if;
751: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
752: END IF;
753: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
754: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
755: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
756: FND_MSG_PUB.Add;
757: RAISE FND_API.G_EXC_ERROR;
758: end if;
759:
782: if l_cursor%rowcount = 0 or l_result_num > 0 then
783: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
784: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
785: END IF;
786: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
787: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
788: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
789: FND_MSG_PUB.Add;
790: RAISE FND_API.G_EXC_ERROR;
783: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
784: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
785: END IF;
786: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
787: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
788: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
789: FND_MSG_PUB.Add;
790: RAISE FND_API.G_EXC_ERROR;
791: end if;
784: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
785: END IF;
786: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
787: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
788: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
789: FND_MSG_PUB.Add;
790: RAISE FND_API.G_EXC_ERROR;
791: end if;
792:
799: if P_PROMISE_REC.CURRENCY_CODE <> l_fun_currency then
800: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
801: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
802: END IF;
803: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
804: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
805: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
806: FND_MSG_PUB.Add;
807: RAISE FND_API.G_EXC_ERROR;
800: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
801: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
802: END IF;
803: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
804: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
805: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
806: FND_MSG_PUB.Add;
807: RAISE FND_API.G_EXC_ERROR;
808: end if;
801: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
802: END IF;
803: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
804: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
805: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
806: FND_MSG_PUB.Add;
807: RAISE FND_API.G_EXC_ERROR;
808: end if;
809:
818: if P_PROMISE_REC.DELINQUENCY_ID is null then
819: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
820: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
821: END IF;
822: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
823: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
824: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
825: FND_MSG_PUB.Add;
826: RAISE FND_API.G_EXC_ERROR;
819: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
820: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
821: END IF;
822: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
823: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
824: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
825: FND_MSG_PUB.Add;
826: RAISE FND_API.G_EXC_ERROR;
827: end if;
820: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
821: END IF;
822: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
823: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
824: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
825: FND_MSG_PUB.Add;
826: RAISE FND_API.G_EXC_ERROR;
827: end if;
828:
851: if l_cursor%rowcount = 0 or l_result_num > 0 then
852: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
853: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
854: END IF;
855: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
856: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
857: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
858: FND_MSG_PUB.Add;
859: RAISE FND_API.G_EXC_ERROR;
852: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
853: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
854: END IF;
855: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
856: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
857: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
858: FND_MSG_PUB.Add;
859: RAISE FND_API.G_EXC_ERROR;
860: end if;
853: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
854: END IF;
855: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
856: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
857: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
858: FND_MSG_PUB.Add;
859: RAISE FND_API.G_EXC_ERROR;
860: end if;
861:
878: if l_cursor%rowcount = 0 or l_result_varchar is null or l_result_varchar <> P_PROMISE_REC.CURRENCY_CODE then
879: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
880: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
881: END IF;
882: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
883: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
884: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
885: FND_MSG_PUB.Add;
886: RAISE FND_API.G_EXC_ERROR;
879: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
880: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
881: END IF;
882: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
883: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
884: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
885: FND_MSG_PUB.Add;
886: RAISE FND_API.G_EXC_ERROR;
887: end if;
880: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
881: END IF;
882: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
883: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
884: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
885: FND_MSG_PUB.Add;
886: RAISE FND_API.G_EXC_ERROR;
887: end if;
888:
897: if P_PROMISE_REC.CNSLD_INVOICE_ID is null then
898: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
899: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
900: END IF;
901: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
902: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
903: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
904: FND_MSG_PUB.Add;
905: RAISE FND_API.G_EXC_ERROR;
898: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
899: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
900: END IF;
901: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
902: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
903: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
904: FND_MSG_PUB.Add;
905: RAISE FND_API.G_EXC_ERROR;
906: end if;
899: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
900: END IF;
901: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
902: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
903: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
904: FND_MSG_PUB.Add;
905: RAISE FND_API.G_EXC_ERROR;
906: end if;
907:
930: if l_cursor%rowcount = 0 or l_result_num > 0 then
931: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
932: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
933: END IF;
934: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
935: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
936: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
937: FND_MSG_PUB.Add;
938: RAISE FND_API.G_EXC_ERROR;
931: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
932: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
933: END IF;
934: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
935: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
936: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
937: FND_MSG_PUB.Add;
938: RAISE FND_API.G_EXC_ERROR;
939: end if;
932: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
933: END IF;
934: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
935: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
936: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
937: FND_MSG_PUB.Add;
938: RAISE FND_API.G_EXC_ERROR;
939: end if;
940:
957: if l_cursor%rowcount = 0 or l_result_varchar is null or l_result_varchar <> P_PROMISE_REC.CURRENCY_CODE then
958: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
959: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
960: END IF;
961: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
962: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
963: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
964: FND_MSG_PUB.Add;
965: RAISE FND_API.G_EXC_ERROR;
958: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
959: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
960: END IF;
961: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
962: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
963: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
964: FND_MSG_PUB.Add;
965: RAISE FND_API.G_EXC_ERROR;
966: end if;
959: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
960: END IF;
961: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
962: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
963: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
964: FND_MSG_PUB.Add;
965: RAISE FND_API.G_EXC_ERROR;
966: end if;
967:
976: if P_PROMISE_REC.CONTRACT_ID is null then
977: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
978: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
979: END IF;
980: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
981: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
982: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
983: FND_MSG_PUB.Add;
984: RAISE FND_API.G_EXC_ERROR;
977: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
978: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
979: END IF;
980: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
981: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
982: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
983: FND_MSG_PUB.Add;
984: RAISE FND_API.G_EXC_ERROR;
985: end if;
978: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
979: END IF;
980: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
981: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
982: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
983: FND_MSG_PUB.Add;
984: RAISE FND_API.G_EXC_ERROR;
985: end if;
986:
1009: if l_cursor%rowcount = 0 or l_result_num > 0 then
1010: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1011: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
1012: END IF;
1013: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1014: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
1015: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1016: FND_MSG_PUB.Add;
1017: RAISE FND_API.G_EXC_ERROR;
1010: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1011: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
1012: END IF;
1013: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1014: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
1015: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1016: FND_MSG_PUB.Add;
1017: RAISE FND_API.G_EXC_ERROR;
1018: end if;
1011: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
1012: END IF;
1013: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1014: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
1015: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1016: FND_MSG_PUB.Add;
1017: RAISE FND_API.G_EXC_ERROR;
1018: end if;
1019:
1043: if l_cursor%rowcount = 0 or l_result_varchar is null or l_result_varchar <> P_PROMISE_REC.CURRENCY_CODE then
1044: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1045: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
1046: END IF;
1047: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1048: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
1049: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1050: FND_MSG_PUB.Add;
1051: RAISE FND_API.G_EXC_ERROR;
1044: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1045: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
1046: END IF;
1047: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1048: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
1049: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1050: FND_MSG_PUB.Add;
1051: RAISE FND_API.G_EXC_ERROR;
1052: end if;
1045: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' failed validation');
1046: END IF;
1047: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1048: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
1049: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1050: FND_MSG_PUB.Add;
1051: RAISE FND_API.G_EXC_ERROR;
1052: end if;
1053:
1482: if P_PROMISE_REC.PROMISE_ID is null then
1483: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1484: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation');
1485: END IF;
1486: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1487: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1488: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1489: FND_MSG_PUB.Add;
1490: RAISE FND_API.G_EXC_ERROR;
1483: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1484: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation');
1485: END IF;
1486: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1487: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1488: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1489: FND_MSG_PUB.Add;
1490: RAISE FND_API.G_EXC_ERROR;
1491: end if;
1484: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation');
1485: END IF;
1486: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1487: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1488: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1489: FND_MSG_PUB.Add;
1490: RAISE FND_API.G_EXC_ERROR;
1491: end if;
1492:
1499: if P_PROMISE_REC.PROMISE_AMOUNT is null or P_PROMISE_REC.PROMISE_AMOUNT <= 0 then
1500: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1501: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation');
1502: END IF;
1503: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1504: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1505: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1506: FND_MSG_PUB.Add;
1507: RAISE FND_API.G_EXC_ERROR;
1500: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1501: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation');
1502: END IF;
1503: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1504: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1505: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1506: FND_MSG_PUB.Add;
1507: RAISE FND_API.G_EXC_ERROR;
1508: end if;
1501: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation');
1502: END IF;
1503: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1504: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1505: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1506: FND_MSG_PUB.Add;
1507: RAISE FND_API.G_EXC_ERROR;
1508: end if;
1509:
1516: if P_PROMISE_REC.TAKEN_BY_RESOURCE_ID is null then
1517: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1518: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: resource id must be set');
1519: END IF;
1520: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1521: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1522: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1523: FND_MSG_PUB.Add;
1524: RAISE FND_API.G_EXC_ERROR;
1517: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1518: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: resource id must be set');
1519: END IF;
1520: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1521: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1522: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1523: FND_MSG_PUB.Add;
1524: RAISE FND_API.G_EXC_ERROR;
1525: end if;
1518: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: resource id must be set');
1519: END IF;
1520: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1521: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1522: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1523: FND_MSG_PUB.Add;
1524: RAISE FND_API.G_EXC_ERROR;
1525: end if;
1526:
1556: if l_promise_status <> 'COLLECTABLE' then
1557: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1558: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: status is not COLLECTABLE');
1559: END IF;
1560: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1561: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1562: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1563: FND_MSG_PUB.Add;
1564: RAISE FND_API.G_EXC_ERROR;
1557: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1558: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: status is not COLLECTABLE');
1559: END IF;
1560: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1561: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1562: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1563: FND_MSG_PUB.Add;
1564: RAISE FND_API.G_EXC_ERROR;
1565: end if;
1558: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: status is not COLLECTABLE');
1559: END IF;
1560: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1561: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1562: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1563: FND_MSG_PUB.Add;
1564: RAISE FND_API.G_EXC_ERROR;
1565: end if;
1566:
1572: if l_promise_state <> 'PROMISE' then
1573: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1574: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: state is not PROMISE');
1575: END IF;
1576: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1577: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1578: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1579: FND_MSG_PUB.Add;
1580: RAISE FND_API.G_EXC_ERROR;
1573: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1574: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: state is not PROMISE');
1575: END IF;
1576: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1577: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1578: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1579: FND_MSG_PUB.Add;
1580: RAISE FND_API.G_EXC_ERROR;
1581: end if;
1574: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: state is not PROMISE');
1575: END IF;
1576: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1577: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1578: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1579: FND_MSG_PUB.Add;
1580: RAISE FND_API.G_EXC_ERROR;
1581: end if;
1582:
1588: if l_remaining_amount <> l_promise_amount then
1589: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1590: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: remaining amount <> promise amount');
1591: END IF;
1592: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1593: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1594: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1595: FND_MSG_PUB.Add;
1596: RAISE FND_API.G_EXC_ERROR;
1589: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1590: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: remaining amount <> promise amount');
1591: END IF;
1592: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1593: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1594: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1595: FND_MSG_PUB.Add;
1596: RAISE FND_API.G_EXC_ERROR;
1597: end if;
1590: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: remaining amount <> promise amount');
1591: END IF;
1592: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1593: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1594: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1595: FND_MSG_PUB.Add;
1596: RAISE FND_API.G_EXC_ERROR;
1597: end if;
1598:
1605: if P_PROMISE_REC.PROMISE_DATE is null or trunc(P_PROMISE_REC.PROMISE_DATE) < trunc(sysdate) then
1606: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1607: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: promise_date must be >= current date');
1608: END IF;
1609: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1610: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1611: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1612: FND_MSG_PUB.Add;
1613: RAISE FND_API.G_EXC_ERROR;
1606: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1607: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: promise_date must be >= current date');
1608: END IF;
1609: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1610: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1611: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1612: FND_MSG_PUB.Add;
1613: RAISE FND_API.G_EXC_ERROR;
1614: end if;
1607: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: promise_date must be >= current date');
1608: END IF;
1609: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1610: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1611: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1612: FND_MSG_PUB.Add;
1613: RAISE FND_API.G_EXC_ERROR;
1614: end if;
1615:
1662: if l_cursor%rowcount = 0 or l_result_num > 0 then
1663: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1664: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: found promise date duplication');
1665: END IF;
1666: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1667: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1668: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1669: FND_MSG_PUB.Add;
1670: RAISE FND_API.G_EXC_ERROR;
1663: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1664: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: found promise date duplication');
1665: END IF;
1666: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1667: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1668: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1669: FND_MSG_PUB.Add;
1670: RAISE FND_API.G_EXC_ERROR;
1671: end if;
1664: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: found promise date duplication');
1665: END IF;
1666: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1667: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1668: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1669: FND_MSG_PUB.Add;
1670: RAISE FND_API.G_EXC_ERROR;
1671: end if;
1672:
1690: if l_cursor%rowcount = 0 or l_result_varchar is null then
1691: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1692: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: wrong payment method');
1693: END IF;
1694: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1695: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1696: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1697: FND_MSG_PUB.Add;
1698: RAISE FND_API.G_EXC_ERROR;
1691: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1692: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: wrong payment method');
1693: END IF;
1694: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1695: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1696: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1697: FND_MSG_PUB.Add;
1698: RAISE FND_API.G_EXC_ERROR;
1699: end if;
1692: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: wrong payment method');
1693: END IF;
1694: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
1695: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
1696: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
1697: FND_MSG_PUB.Add;
1698: RAISE FND_API.G_EXC_ERROR;
1699: end if;
1700: else
2010: if P_PROMISE_REC.PROMISE_ID is null then
2011: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2012: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation');
2013: END IF;
2014: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2015: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2016: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2017: FND_MSG_PUB.Add;
2018: RAISE FND_API.G_EXC_ERROR;
2011: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2012: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation');
2013: END IF;
2014: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2015: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2016: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2017: FND_MSG_PUB.Add;
2018: RAISE FND_API.G_EXC_ERROR;
2019: end if;
2012: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation');
2013: END IF;
2014: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2015: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2016: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2017: FND_MSG_PUB.Add;
2018: RAISE FND_API.G_EXC_ERROR;
2019: end if;
2020:
2027: if P_PROMISE_REC.TAKEN_BY_RESOURCE_ID is null then
2028: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2029: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: resource id must be set');
2030: END IF;
2031: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2032: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2033: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2034: FND_MSG_PUB.Add;
2035: RAISE FND_API.G_EXC_ERROR;
2028: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2029: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: resource id must be set');
2030: END IF;
2031: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2032: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2033: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2034: FND_MSG_PUB.Add;
2035: RAISE FND_API.G_EXC_ERROR;
2036: end if;
2029: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: resource id must be set');
2030: END IF;
2031: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2032: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2033: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2034: FND_MSG_PUB.Add;
2035: RAISE FND_API.G_EXC_ERROR;
2036: end if;
2037:
2329: if P_MASS_IDS_TBL.COUNT = 0 then
2330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2331: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: no delinquencies were passed');
2332: END IF;
2333: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2334: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2335: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2336: FND_MSG_PUB.Add;
2337: RAISE FND_API.G_EXC_ERROR;
2330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2331: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: no delinquencies were passed');
2332: END IF;
2333: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2334: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2335: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2336: FND_MSG_PUB.Add;
2337: RAISE FND_API.G_EXC_ERROR;
2338: end if;
2331: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: no delinquencies were passed');
2332: END IF;
2333: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2334: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2335: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2336: FND_MSG_PUB.Add;
2337: RAISE FND_API.G_EXC_ERROR;
2338: end if;
2339:
2366: if l_result_num > 1 then
2367: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2368: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: passed delinquencies belong to different accounts');
2369: END IF;
2370: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2371: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2372: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2373: FND_MSG_PUB.Add;
2374: RAISE FND_API.G_EXC_ERROR;
2367: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2368: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: passed delinquencies belong to different accounts');
2369: END IF;
2370: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2371: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2372: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2373: FND_MSG_PUB.Add;
2374: RAISE FND_API.G_EXC_ERROR;
2375: end if;
2368: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: passed delinquencies belong to different accounts');
2369: END IF;
2370: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2371: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2372: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2373: FND_MSG_PUB.Add;
2374: RAISE FND_API.G_EXC_ERROR;
2375: end if;
2376: */
2384: if P_PROMISE_REC.PROMISE_DATE is null or trunc(P_PROMISE_REC.PROMISE_DATE) < trunc(sysdate) then
2385: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2386: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: promise_date must be >= current date');
2387: END IF;
2388: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2389: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2390: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2391: FND_MSG_PUB.Add;
2392: RAISE FND_API.G_EXC_ERROR;
2385: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2386: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: promise_date must be >= current date');
2387: END IF;
2388: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2389: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2390: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2391: FND_MSG_PUB.Add;
2392: RAISE FND_API.G_EXC_ERROR;
2393: end if;
2386: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: promise_date must be >= current date');
2387: END IF;
2388: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2389: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2390: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2391: FND_MSG_PUB.Add;
2392: RAISE FND_API.G_EXC_ERROR;
2393: end if;
2394:
2401: if P_PROMISE_REC.TAKEN_BY_RESOURCE_ID is null then
2402: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2403: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: resource id must be set');
2404: END IF;
2405: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2406: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2407: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2408: FND_MSG_PUB.Add;
2409: RAISE FND_API.G_EXC_ERROR;
2402: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2403: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: resource id must be set');
2404: END IF;
2405: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2406: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2407: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2408: FND_MSG_PUB.Add;
2409: RAISE FND_API.G_EXC_ERROR;
2410: end if;
2403: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: resource id must be set');
2404: END IF;
2405: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2406: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2407: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2408: FND_MSG_PUB.Add;
2409: RAISE FND_API.G_EXC_ERROR;
2410: end if;
2411:
2429: if l_cursor%rowcount = 0 or l_result_varchar is null then
2430: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2431: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: wrong payment method');
2432: END IF;
2433: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2434: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2435: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2436: FND_MSG_PUB.Add;
2437: RAISE FND_API.G_EXC_ERROR;
2430: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2431: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: wrong payment method');
2432: END IF;
2433: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2434: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2435: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2436: FND_MSG_PUB.Add;
2437: RAISE FND_API.G_EXC_ERROR;
2438: end if;
2431: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' failed validation: wrong payment method');
2432: END IF;
2433: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
2434: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_procedure);
2435: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
2436: FND_MSG_PUB.Add;
2437: RAISE FND_API.G_EXC_ERROR;
2438: end if;
2439: else