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.IEX_PROMISES_PUB dependencies on FND_API

Line 16: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,

12: G_REQUEST_ID NUMBER; -- := FND_GLOBAL.Conc_Request_Id;
13:
14: PROCEDURE SHOW_IN_UWQ(
15: P_API_VERSION IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
18: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
19: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
20: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 17: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,

13:
14: PROCEDURE SHOW_IN_UWQ(
15: P_API_VERSION IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
18: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
19: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
20: X_MSG_COUNT OUT NOCOPY NUMBER,
21: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 18: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,

14: PROCEDURE SHOW_IN_UWQ(
15: P_API_VERSION IN NUMBER,
16: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
17: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
18: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
19: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
20: X_MSG_COUNT OUT NOCOPY NUMBER,
21: X_MSG_DATA OUT NOCOPY VARCHAR2,
22: P_PROMISE_TBL IN DBMS_SQL.NUMBER_TABLE,

Line 54: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

50: -- Standard start of API savepoint
51: SAVEPOINT SHOW_IN_UWQ_PVT;
52:
53: -- Standard call to check for call compatibility
54: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:
58: -- Initialize message list if p_init_msg_list is set to TRUE

Line 55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

51: SAVEPOINT SHOW_IN_UWQ_PVT;
52:
53: -- Standard call to check for call compatibility
54: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:
58: -- Initialize message list if p_init_msg_list is set to TRUE
59: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 59: IF FND_API.To_Boolean(p_init_msg_list) THEN

55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:
58: -- Initialize message list if p_init_msg_list is set to TRUE
59: IF FND_API.To_Boolean(p_init_msg_list) THEN
60: FND_MSG_PUB.initialize;
61: END IF;
62:
63: -- Initialize API return status to success

Line 64: l_return_status := FND_API.G_RET_STS_SUCCESS;

60: FND_MSG_PUB.initialize;
61: END IF;
62:
63: -- Initialize API return status to success
64: l_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: -- START OF BODY OF API
67:
68: -- validating uwq status

Line 82: RAISE FND_API.G_EXC_ERROR;

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:
85: -- validating table of promises
86: l_validation_item := 'P_PROMISE_TBL';

Line 99: RAISE FND_API.G_EXC_ERROR;

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:
102: -- validating p_days
103: l_validation_item := 'P_DAYS';

Line 116: RAISE FND_API.G_EXC_ERROR;

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:
119: -- filter passed promises; we need only BROKEN_PROMISE promises for update
120: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 206: IF FND_API.To_Boolean( p_commit ) THEN

202:
203: -- END OF BODY OF API
204:
205: -- Standard check of p_commit.
206: IF FND_API.To_Boolean( p_commit ) THEN
207: COMMIT WORK;
208: END IF;
209:
210: x_return_status := l_return_status;

Line 213: p_encoded => FND_API.G_FALSE,

209:
210: x_return_status := l_return_status;
211: -- Standard call to get message count and if count is 1, get message info
212: FND_MSG_PUB.Count_And_Get(
213: p_encoded => FND_API.G_FALSE,
214: p_count => x_msg_count,
215: p_data => x_msg_data);
216:
217: EXCEPTION

Line 218: WHEN FND_API.G_EXC_ERROR THEN

214: p_count => x_msg_count,
215: p_data => x_msg_data);
216:
217: EXCEPTION
218: WHEN FND_API.G_EXC_ERROR THEN
219: ROLLBACK TO SHOW_IN_UWQ_PVT;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 220: x_return_status := FND_API.G_RET_STS_ERROR;

216:
217: EXCEPTION
218: WHEN FND_API.G_EXC_ERROR THEN
219: ROLLBACK TO SHOW_IN_UWQ_PVT;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO SHOW_IN_UWQ_PVT;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

218: WHEN FND_API.G_EXC_ERROR THEN
219: ROLLBACK TO SHOW_IN_UWQ_PVT;
220: x_return_status := FND_API.G_RET_STS_ERROR;
221: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO SHOW_IN_UWQ_PVT;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
226: WHEN OTHERS THEN

Line 224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

220: x_return_status := FND_API.G_RET_STS_ERROR;
221: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO SHOW_IN_UWQ_PVT;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
226: WHEN OTHERS THEN
227: ROLLBACK TO SHOW_IN_UWQ_PVT;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
226: WHEN OTHERS THEN
227: ROLLBACK TO SHOW_IN_UWQ_PVT;
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
230: THEN
231: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
232: END IF;

Line 300: RAISE FND_API.G_EXC_ERROR;

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

Line 311: RAISE FND_API.G_EXC_ERROR;

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:
314: --begin bug#2369298 schekuri 24-Feb-2006
315: --get party_id and cust_site_use id also

Line 449: p_init_msg_list => FND_API.G_TRUE,

445: iex_debug_pub.LogMessage(G_PKG_NAME || '.SEND_FFM: Sending ffm ...');
446: END IF;
447: IEX_DUNNING_PVT.CALL_FFM(
448: p_api_version => 1.0,
449: p_init_msg_list => FND_API.G_TRUE,
450: p_commit => FND_API.G_TRUE,
451: p_key_name => 'promise_id',
452: p_key_id => p_promise_id,
453: p_template_id => l_template_id,

Line 450: p_commit => FND_API.G_TRUE,

446: END IF;
447: IEX_DUNNING_PVT.CALL_FFM(
448: p_api_version => 1.0,
449: p_init_msg_list => FND_API.G_TRUE,
450: p_commit => FND_API.G_TRUE,
451: p_key_name => 'promise_id',
452: p_key_id => p_promise_id,
453: p_template_id => l_template_id,
454: p_method => 'EMAIL',

Line 628: RAISE FND_API.G_EXC_ERROR;

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:
631: /* validate promise_amount */
632: l_validation_item := 'P_PROMISE_REC.PROMISE_AMOUNT';

Line 645: RAISE FND_API.G_EXC_ERROR;

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:
648: /* validate promise_date */
649: l_validation_item := 'P_PROMISE_REC.PROMISE_DATE';

Line 662: RAISE FND_API.G_EXC_ERROR;

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:
665: /* validate currency */
666: l_validation_item := 'P_PROMISE_REC.CURRENCY_CODE';

Line 679: RAISE FND_API.G_EXC_ERROR;

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:
682: /* validate resource_id */
683: l_validation_item := 'P_PROMISE_REC.TAKEN_BY_RESOURCE_ID';

Line 696: RAISE FND_API.G_EXC_ERROR;

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:
699: /* get functional currency */
700: IEX_CURRENCY_PVT.GET_FUNCT_CURR(

Line 702: p_init_msg_list => FND_API.G_FALSE,

698:
699: /* get functional currency */
700: IEX_CURRENCY_PVT.GET_FUNCT_CURR(
701: p_api_version => 1.0,
702: p_init_msg_list => FND_API.G_FALSE,
703: p_commit => FND_API.G_FALSE,
704: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
705: x_return_status => l_return_status,
706: x_msg_count => l_msg_count,

Line 703: p_commit => FND_API.G_FALSE,

699: /* get functional currency */
700: IEX_CURRENCY_PVT.GET_FUNCT_CURR(
701: p_api_version => 1.0,
702: p_init_msg_list => FND_API.G_FALSE,
703: p_commit => FND_API.G_FALSE,
704: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
705: x_return_status => l_return_status,
706: x_msg_count => l_msg_count,
707: x_msg_data => l_msg_data,

Line 704: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

700: IEX_CURRENCY_PVT.GET_FUNCT_CURR(
701: p_api_version => 1.0,
702: p_init_msg_list => FND_API.G_FALSE,
703: p_commit => FND_API.G_FALSE,
704: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
705: x_return_status => l_return_status,
706: x_msg_count => l_msg_count,
707: x_msg_data => l_msg_data,
708: x_functional_currency => l_fun_currency);

Line 735: RAISE FND_API.G_EXC_ERROR;

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
738: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
739: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': ' || l_validation_item || ' is null - nothing to validate');

Line 757: RAISE FND_API.G_EXC_ERROR;

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:
760: /* validate promise object */
761: if P_PROMISE_REC.PROMISE_TARGET = 'ACCOUNTS' then

Line 790: RAISE FND_API.G_EXC_ERROR;

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:
793: /* validate promise currency */
794: l_validation_item := 'P_PROMISE_REC.CURRENCY_CODE';

Line 807: RAISE FND_API.G_EXC_ERROR;

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:
810: elsif P_PROMISE_REC.PROMISE_TARGET = 'INVOICES' then
811:

Line 826: RAISE FND_API.G_EXC_ERROR;

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:
829: /* validate promise date */
830: l_validation_item := 'P_PROMISE_REC.PROMISE_DATE';

Line 859: RAISE FND_API.G_EXC_ERROR;

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:
862: /* validate promise currency */
863: l_validation_item := 'P_PROMISE_REC.CURRENCY_CODE';

Line 886: RAISE FND_API.G_EXC_ERROR;

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:
889: elsif P_PROMISE_REC.PROMISE_TARGET = 'CNSLD' then
890:

Line 905: RAISE FND_API.G_EXC_ERROR;

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:
908: /* validate promise date */
909: l_validation_item := 'P_PROMISE_REC.PROMISE_DATE';

Line 938: RAISE FND_API.G_EXC_ERROR;

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:
941: /* validate promise currency */
942: l_validation_item := 'P_PROMISE_REC.CURRENCY_CODE';

Line 965: RAISE FND_API.G_EXC_ERROR;

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:
968: elsif P_PROMISE_REC.PROMISE_TARGET = 'CONTRACTS' then
969:

Line 984: RAISE FND_API.G_EXC_ERROR;

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:
987: /* validate promise date */
988: l_validation_item := 'P_PROMISE_REC.PROMISE_DATE';

Line 1017: RAISE FND_API.G_EXC_ERROR;

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:
1020: /* validate promise currency */
1021: l_validation_item := 'P_PROMISE_REC.CURRENCY_CODE';

Line 1051: RAISE FND_API.G_EXC_ERROR;

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:
1054: end if;
1055:

Line 1060: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,

1056: end;
1057:
1058: PROCEDURE INSERT_PROMISE(
1059: P_API_VERSION IN NUMBER,
1060: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
1061: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
1062: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
1063: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1064: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1061: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,

1057:
1058: PROCEDURE INSERT_PROMISE(
1059: P_API_VERSION IN NUMBER,
1060: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
1061: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
1062: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
1063: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1064: X_MSG_COUNT OUT NOCOPY NUMBER,
1065: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 1062: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,

1058: PROCEDURE INSERT_PROMISE(
1059: P_API_VERSION IN NUMBER,
1060: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
1061: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
1062: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
1063: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1064: X_MSG_COUNT OUT NOCOPY NUMBER,
1065: X_MSG_DATA OUT NOCOPY VARCHAR2,
1066: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_INSRT_REC_TYPE,

Line 1109: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1105: -- Standard start of API savepoint
1106: SAVEPOINT INSERT_PROMISE_PVT;
1107:
1108: -- Standard call to check for call compatibility
1109: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1111: END IF;
1112:
1113: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1106: SAVEPOINT INSERT_PROMISE_PVT;
1107:
1108: -- Standard call to check for call compatibility
1109: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1111: END IF;
1112:
1113: -- Initialize message list if p_init_msg_list is set to TRUE
1114: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1114: IF FND_API.To_Boolean(p_init_msg_list) THEN

1110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1111: END IF;
1112:
1113: -- Initialize message list if p_init_msg_list is set to TRUE
1114: IF FND_API.To_Boolean(p_init_msg_list) THEN
1115: FND_MSG_PUB.initialize;
1116: END IF;
1117:
1118: -- Initialize API return status to success

Line 1119: l_return_status := FND_API.G_RET_STS_SUCCESS;

1115: FND_MSG_PUB.initialize;
1116: END IF;
1117:
1118: -- Initialize API return status to success
1119: l_return_status := FND_API.G_RET_STS_SUCCESS;
1120:
1121: -- START OF BODY OF API
1122: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1123: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Start of body');

Line 1293: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1289: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to update_del_stage_level');
1290: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
1291: END IF;
1292: -- check for errors
1293: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1294: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1295: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': update_del_stage_level failed');
1296: END IF;
1297: RAISE FND_API.G_EXC_ERROR;

Line 1297: RAISE FND_API.G_EXC_ERROR;

1293: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1294: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1295: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': update_del_stage_level failed');
1296: END IF;
1297: RAISE FND_API.G_EXC_ERROR;
1298: END IF;
1299: --end
1300: End If; -- added for bug 14318148
1301: -- inserting a note

Line 1362: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1358: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
1359: END IF;
1360:
1361: -- check for errors
1362: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1363: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1364: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
1365: END IF;
1366: RAISE FND_API.G_EXC_ERROR;

Line 1366: RAISE FND_API.G_EXC_ERROR;

1362: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1363: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1364: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
1365: END IF;
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368: else
1369: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1370: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': no note to save');

Line 1386: IF FND_API.To_Boolean( p_commit ) THEN

1382:
1383: -- END OF BODY OF API
1384:
1385: -- Standard check of p_commit.
1386: IF FND_API.To_Boolean( p_commit ) THEN
1387: COMMIT WORK;
1388: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1389: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': commited');
1390: END IF;

Line 1396: p_encoded => FND_API.G_FALSE,

1392:
1393: x_return_status := l_return_status;
1394: -- Standard call to get message count and if count is 1, get message info
1395: FND_MSG_PUB.Count_And_Get(
1396: p_encoded => FND_API.G_FALSE,
1397: p_count => x_msg_count,
1398: p_data => x_msg_data);
1399:
1400: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1405: WHEN FND_API.G_EXC_ERROR THEN

1401: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': end of API');
1402: END IF;
1403:
1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: ROLLBACK TO INSERT_PROMISE_PVT;
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1407: x_return_status := FND_API.G_RET_STS_ERROR;

1403:
1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: ROLLBACK TO INSERT_PROMISE_PVT;
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO INSERT_PROMISE_PVT;
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1405: WHEN FND_API.G_EXC_ERROR THEN
1406: ROLLBACK TO INSERT_PROMISE_PVT;
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO INSERT_PROMISE_PVT;
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1413: WHEN OTHERS THEN

Line 1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO INSERT_PROMISE_PVT;
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1413: WHEN OTHERS THEN
1414: ROLLBACK TO INSERT_PROMISE_PVT;
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1413: WHEN OTHERS THEN
1414: ROLLBACK TO INSERT_PROMISE_PVT;
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1417: THEN
1418: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1419: END IF;

Line 1490: RAISE FND_API.G_EXC_ERROR;

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:
1493: /* validate promise_amount */
1494: l_validation_item := 'P_PROMISE_REC.PROMISE_AMOUNT';

Line 1507: RAISE FND_API.G_EXC_ERROR;

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:
1510: /* validate resource_id */
1511: l_validation_item := 'P_PROMISE_REC.TAKEN_BY_RESOURCE_ID';

Line 1524: RAISE FND_API.G_EXC_ERROR;

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:
1527: /* pull data from db to do some validation */
1528: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1564: RAISE FND_API.G_EXC_ERROR;

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:
1567: /* validate promise_state */
1568: l_validation_item := 'STATE';

Line 1580: RAISE FND_API.G_EXC_ERROR;

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:
1583: /* validate remaining amount */
1584: l_validation_item := 'AMOUNT_DUE_REMAINING';

Line 1596: RAISE FND_API.G_EXC_ERROR;

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:
1599: /* validate promise_date */
1600: l_validation_item := 'P_PROMISE_REC.PROMISE_DATE';

Line 1613: RAISE FND_API.G_EXC_ERROR;

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:
1616: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1617: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': Validating ' || l_validation_item || ' for dublicates');

Line 1670: RAISE FND_API.G_EXC_ERROR;

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:
1673: /* validate payment_method */
1674: l_validation_item := 'P_PROMISE_REC.PROMISE_PAYMENT_METHOD';

Line 1698: RAISE FND_API.G_EXC_ERROR;

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
1701: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1702: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' is null - nothing to validate');

Line 1710: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,

1706: end;
1707:
1708: PROCEDURE UPDATE_PROMISE(
1709: P_API_VERSION IN NUMBER,
1710: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
1711: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
1712: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
1713: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1714: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 1711: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,

1707:
1708: PROCEDURE UPDATE_PROMISE(
1709: P_API_VERSION IN NUMBER,
1710: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
1711: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
1712: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
1713: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1714: X_MSG_COUNT OUT NOCOPY NUMBER,
1715: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 1712: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,

1708: PROCEDURE UPDATE_PROMISE(
1709: P_API_VERSION IN NUMBER,
1710: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
1711: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
1712: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
1713: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1714: X_MSG_COUNT OUT NOCOPY NUMBER,
1715: X_MSG_DATA OUT NOCOPY VARCHAR2,
1716: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_UPDT_REC_TYPE,

Line 1747: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1743: -- Standard start of API savepoint
1744: SAVEPOINT UPDATE_PROMISE_PVT;
1745:
1746: -- Standard call to check for call compatibility
1747: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1749: END IF;
1750:
1751: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1744: SAVEPOINT UPDATE_PROMISE_PVT;
1745:
1746: -- Standard call to check for call compatibility
1747: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1749: END IF;
1750:
1751: -- Initialize message list if p_init_msg_list is set to TRUE
1752: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1752: IF FND_API.To_Boolean(p_init_msg_list) THEN

1748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1749: END IF;
1750:
1751: -- Initialize message list if p_init_msg_list is set to TRUE
1752: IF FND_API.To_Boolean(p_init_msg_list) THEN
1753: FND_MSG_PUB.initialize;
1754: END IF;
1755:
1756: -- Initialize API return status to success

Line 1757: l_return_status := FND_API.G_RET_STS_SUCCESS;

1753: FND_MSG_PUB.initialize;
1754: END IF;
1755:
1756: -- Initialize API return status to success
1757: l_return_status := FND_API.G_RET_STS_SUCCESS;
1758:
1759: -- START OF BODY OF API
1760: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1761: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Start of body');

Line 1857: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1853: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to update_del_stage_level');
1854: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
1855: END IF;
1856: -- check for errors
1857: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1858: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1859: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': update_del_stage_level failed');
1860: END IF;
1861: RAISE FND_API.G_EXC_ERROR;

Line 1861: RAISE FND_API.G_EXC_ERROR;

1857: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1858: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1859: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': update_del_stage_level failed');
1860: END IF;
1861: RAISE FND_API.G_EXC_ERROR;
1862: END IF;
1863: --end
1864: End If; -- added for bug 14318148
1865: -- inserting a note

Line 1935: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

1931: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
1932: END IF;
1933:
1934: -- check for errors
1935: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1936: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1937: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
1938: END IF;
1939: RAISE FND_API.G_EXC_ERROR;

Line 1939: RAISE FND_API.G_EXC_ERROR;

1935: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
1936: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1937: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
1938: END IF;
1939: RAISE FND_API.G_EXC_ERROR;
1940: END IF;
1941: else
1942: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1943: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': no note to save');

Line 1956: IF FND_API.To_Boolean( p_commit ) THEN

1952: -- setting strategy
1953: --SET_STRATEGY(P_PROMISE_ID => P_PROMISE_REC.PROMISE_ID, P_STATUS => 'ONHOLD');
1954: */
1955: -- commit if promise updated successfully
1956: IF FND_API.To_Boolean( p_commit ) THEN
1957: COMMIT WORK;
1958: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1959: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': commited');
1960: END IF;

Line 1968: p_encoded => FND_API.G_FALSE,

1964:
1965: x_return_status := l_return_status;
1966: -- Standard call to get message count and if count is 1, get message info
1967: FND_MSG_PUB.Count_And_Get(
1968: p_encoded => FND_API.G_FALSE,
1969: p_count => x_msg_count,
1970: p_data => x_msg_data);
1971:
1972: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1977: WHEN FND_API.G_EXC_ERROR THEN

1973: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': end of API');
1974: END IF;
1975:
1976: EXCEPTION
1977: WHEN FND_API.G_EXC_ERROR THEN
1978: ROLLBACK TO UPDATE_PROMISE_PVT;
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1979: x_return_status := FND_API.G_RET_STS_ERROR;

1975:
1976: EXCEPTION
1977: WHEN FND_API.G_EXC_ERROR THEN
1978: ROLLBACK TO UPDATE_PROMISE_PVT;
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1982: ROLLBACK TO UPDATE_PROMISE_PVT;
1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1977: WHEN FND_API.G_EXC_ERROR THEN
1978: ROLLBACK TO UPDATE_PROMISE_PVT;
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1982: ROLLBACK TO UPDATE_PROMISE_PVT;
1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1985: WHEN OTHERS THEN

Line 1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1982: ROLLBACK TO UPDATE_PROMISE_PVT;
1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1985: WHEN OTHERS THEN
1986: ROLLBACK TO UPDATE_PROMISE_PVT;
1987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1984: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1985: WHEN OTHERS THEN
1986: ROLLBACK TO UPDATE_PROMISE_PVT;
1987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1988: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1989: THEN
1990: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1991: END IF;

Line 2018: RAISE FND_API.G_EXC_ERROR;

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:
2021: /* validate resource_id */
2022: l_validation_item := 'P_PROMISE_REC.TAKEN_BY_RESOURCE_ID';

Line 2035: RAISE FND_API.G_EXC_ERROR;

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:
2038: end;
2039:

Line 2042: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,

2038: end;
2039:
2040: PROCEDURE CANCEL_PROMISE(
2041: P_API_VERSION IN NUMBER,
2042: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
2043: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
2044: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
2045: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2046: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2043: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,

2039:
2040: PROCEDURE CANCEL_PROMISE(
2041: P_API_VERSION IN NUMBER,
2042: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
2043: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
2044: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
2045: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2046: X_MSG_COUNT OUT NOCOPY NUMBER,
2047: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 2044: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,

2040: PROCEDURE CANCEL_PROMISE(
2041: P_API_VERSION IN NUMBER,
2042: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
2043: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
2044: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
2045: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2046: X_MSG_COUNT OUT NOCOPY NUMBER,
2047: X_MSG_DATA OUT NOCOPY VARCHAR2,
2048: P_PROMISE_REC IN IEX_PROMISES_PUB.PRO_CNCL_REC_TYPE,

Line 2080: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2076: -- Standard start of API savepoint
2077: SAVEPOINT CANCEL_PROMISE_PVT;
2078:
2079: -- Standard call to check for call compatibility
2080: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2082: END IF;
2083:
2084: -- Initialize message list if p_init_msg_list is set to TRUE

Line 2081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2077: SAVEPOINT CANCEL_PROMISE_PVT;
2078:
2079: -- Standard call to check for call compatibility
2080: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2082: END IF;
2083:
2084: -- Initialize message list if p_init_msg_list is set to TRUE
2085: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 2085: IF FND_API.To_Boolean(p_init_msg_list) THEN

2081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2082: END IF;
2083:
2084: -- Initialize message list if p_init_msg_list is set to TRUE
2085: IF FND_API.To_Boolean(p_init_msg_list) THEN
2086: FND_MSG_PUB.initialize;
2087: END IF;
2088:
2089: -- Initialize API return status to success

Line 2090: l_return_status := FND_API.G_RET_STS_SUCCESS;

2086: FND_MSG_PUB.initialize;
2087: END IF;
2088:
2089: -- Initialize API return status to success
2090: l_return_status := FND_API.G_RET_STS_SUCCESS;
2091:
2092: -- START OF BODY OF API
2093: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2094: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Start of body');

Line 2176: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

2172: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': After call to update_del_stage_level');
2173: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
2174: END IF;
2175: -- check for errors
2176: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2177: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2178: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': update_del_stage_level failed');
2179: END IF;
2180: RAISE FND_API.G_EXC_ERROR;

Line 2180: RAISE FND_API.G_EXC_ERROR;

2176: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2177: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2178: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': update_del_stage_level failed');
2179: END IF;
2180: RAISE FND_API.G_EXC_ERROR;
2181: END IF;
2182: --end
2183: End If; -- added for bug 14318148
2184: -- inserting a note

Line 2253: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

2249: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
2250: END IF;
2251:
2252: -- check for errors
2253: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2254: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2255: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
2256: END IF;
2257: RAISE FND_API.G_EXC_ERROR;

Line 2257: RAISE FND_API.G_EXC_ERROR;

2253: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2254: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2255: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
2256: END IF;
2257: RAISE FND_API.G_EXC_ERROR;
2258: END IF;
2259: else
2260: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2261: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': no note to save');

Line 2266: IF FND_API.To_Boolean( p_commit ) THEN

2262: END IF;
2263: end if;
2264:
2265: -- commit if promise updated successfully
2266: IF FND_API.To_Boolean( p_commit ) THEN
2267: COMMIT WORK;
2268: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2269: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': commited');
2270: END IF;

Line 2278: p_encoded => FND_API.G_FALSE,

2274:
2275: x_return_status := l_return_status;
2276: -- Standard call to get message count and if count is 1, get message info
2277: FND_MSG_PUB.Count_And_Get(
2278: p_encoded => FND_API.G_FALSE,
2279: p_count => x_msg_count,
2280: p_data => x_msg_data);
2281:
2282: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2287: WHEN FND_API.G_EXC_ERROR THEN

2283: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': end of API');
2284: END IF;
2285:
2286: EXCEPTION
2287: WHEN FND_API.G_EXC_ERROR THEN
2288: ROLLBACK TO CANCEL_PROMISE_PVT;
2289: x_return_status := FND_API.G_RET_STS_ERROR;
2290: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2289: x_return_status := FND_API.G_RET_STS_ERROR;

2285:
2286: EXCEPTION
2287: WHEN FND_API.G_EXC_ERROR THEN
2288: ROLLBACK TO CANCEL_PROMISE_PVT;
2289: x_return_status := FND_API.G_RET_STS_ERROR;
2290: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2292: ROLLBACK TO CANCEL_PROMISE_PVT;
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2287: WHEN FND_API.G_EXC_ERROR THEN
2288: ROLLBACK TO CANCEL_PROMISE_PVT;
2289: x_return_status := FND_API.G_RET_STS_ERROR;
2290: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2292: ROLLBACK TO CANCEL_PROMISE_PVT;
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2295: WHEN OTHERS THEN

Line 2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2289: x_return_status := FND_API.G_RET_STS_ERROR;
2290: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2292: ROLLBACK TO CANCEL_PROMISE_PVT;
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2295: WHEN OTHERS THEN
2296: ROLLBACK TO CANCEL_PROMISE_PVT;
2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2295: WHEN OTHERS THEN
2296: ROLLBACK TO CANCEL_PROMISE_PVT;
2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2298: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2299: THEN
2300: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2301: END IF;

Line 2337: RAISE FND_API.G_EXC_ERROR;

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:
2340: --commenting begin for bug 6717279 by gnramasa 25th Aug 08
2341: /* validate that all passed delinquencies belong to the same account */

Line 2374: RAISE FND_API.G_EXC_ERROR;

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: */
2377: --commenting end for bug 6717279 by gnramasa 25th Aug 08
2378: /* validate promise_date */

Line 2392: RAISE FND_API.G_EXC_ERROR;

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:
2395: /* validate resource_id */
2396: l_validation_item := 'P_PROMISE_REC.TAKEN_BY_RESOURCE_ID';

Line 2409: RAISE FND_API.G_EXC_ERROR;

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:
2412: /* validate payment_method */
2413: l_validation_item := 'P_PROMISE_REC.PROMISE_PAYMENT_METHOD';

Line 2437: RAISE FND_API.G_EXC_ERROR;

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
2440: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2441: iex_debug_pub.LogMessage(G_PKG_NAME || '.' ||l_procedure || ': ' || l_validation_item || ' is null - nothing to validate');

Line 2450: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,

2446:
2447:
2448: PROCEDURE MASS_PROMISE(
2449: P_API_VERSION IN NUMBER,
2450: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
2451: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
2452: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
2453: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2454: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 2451: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,

2447:
2448: PROCEDURE MASS_PROMISE(
2449: P_API_VERSION IN NUMBER,
2450: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
2451: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
2452: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
2453: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2454: X_MSG_COUNT OUT NOCOPY NUMBER,
2455: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 2452: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,

2448: PROCEDURE MASS_PROMISE(
2449: P_API_VERSION IN NUMBER,
2450: P_INIT_MSG_LIST IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
2451: P_COMMIT IN VARCHAR2, -- DEFAULT FND_API.G_FALSE,
2452: P_VALIDATION_LEVEL IN NUMBER, -- DEFAULT FND_API.G_VALID_LEVEL_FULL,
2453: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
2454: X_MSG_COUNT OUT NOCOPY NUMBER,
2455: X_MSG_DATA OUT NOCOPY VARCHAR2,
2456: P_MASS_IDS_TBL IN DBMS_SQL.NUMBER_TABLE,

Line 2512: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2508: -- Standard start of API savepoint
2509: SAVEPOINT MASS_PROMISE_PVT;
2510:
2511: -- Standard call to check for call compatibility
2512: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2514: END IF;
2515:
2516: -- Initialize message list if p_init_msg_list is set to TRUE

Line 2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2509: SAVEPOINT MASS_PROMISE_PVT;
2510:
2511: -- Standard call to check for call compatibility
2512: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2514: END IF;
2515:
2516: -- Initialize message list if p_init_msg_list is set to TRUE
2517: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 2517: IF FND_API.To_Boolean(p_init_msg_list) THEN

2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2514: END IF;
2515:
2516: -- Initialize message list if p_init_msg_list is set to TRUE
2517: IF FND_API.To_Boolean(p_init_msg_list) THEN
2518: FND_MSG_PUB.initialize;
2519: END IF;
2520:
2521: -- Initialize API return status to success

Line 2522: l_return_status := FND_API.G_RET_STS_SUCCESS;

2518: FND_MSG_PUB.initialize;
2519: END IF;
2520:
2521: -- Initialize API return status to success
2522: l_return_status := FND_API.G_RET_STS_SUCCESS;
2523:
2524: -- START OF BODY OF API
2525: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2526: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Start of body');

Line 2652: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

2648: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
2649: END IF;
2650:
2651: -- check for errors
2652: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2653: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2654: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': update_del_stage_level failed');
2655: END IF;
2656: RAISE FND_API.G_EXC_ERROR;

Line 2656: RAISE FND_API.G_EXC_ERROR;

2652: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2653: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2654: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': update_del_stage_level failed');
2655: END IF;
2656: RAISE FND_API.G_EXC_ERROR;
2657: END IF;
2658: --end
2659: End If; --added for bug 14318148
2660: END LOOP;

Line 2807: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

2803: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
2804: END IF;
2805:
2806: -- check for errors
2807: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2808: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2809: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': update_del_stage_level failed');
2810: END IF;
2811: RAISE FND_API.G_EXC_ERROR;

Line 2811: RAISE FND_API.G_EXC_ERROR;

2807: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2808: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2809: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': update_del_stage_level failed');
2810: END IF;
2811: RAISE FND_API.G_EXC_ERROR;
2812: END IF;
2813: --end
2814: End If; ---- added for bug 14318148
2815: k := k+1;

Line 2930: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

2926: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Status = ' || L_RETURN_STATUS);
2927: END IF;
2928:
2929: -- check for errors
2930: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2931: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2932: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
2933: END IF;
2934: RAISE FND_API.G_EXC_ERROR;

Line 2934: RAISE FND_API.G_EXC_ERROR;

2930: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
2931: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2932: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': IEX_NOTES_PVT.Create_Note failed');
2933: END IF;
2934: RAISE FND_API.G_EXC_ERROR;
2935: END IF;
2936:
2937: FOR k IN 1..X_MASS_PRORESP_TBL.count LOOP
2938: X_MASS_PRORESP_TBL(k).note_id := l_note_id;

Line 2947: IF FND_API.To_Boolean( p_commit ) THEN

2943: END IF;
2944: end if;
2945:
2946: -- commit if promise updated successfully
2947: IF FND_API.To_Boolean( p_commit ) THEN
2948: COMMIT WORK;
2949: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2950: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': commited');
2951: END IF;

Line 2959: p_encoded => FND_API.G_FALSE,

2955:
2956: x_return_status := l_return_status;
2957: -- Standard call to get message count and if count is 1, get message info
2958: FND_MSG_PUB.Count_And_Get(
2959: p_encoded => FND_API.G_FALSE,
2960: p_count => x_msg_count,
2961: p_data => x_msg_data);
2962:
2963: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2968: WHEN FND_API.G_EXC_ERROR THEN

2964: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': end of API');
2965: END IF;
2966:
2967: EXCEPTION
2968: WHEN FND_API.G_EXC_ERROR THEN
2969: ROLLBACK TO MASS_PROMISE_PVT;
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2970: x_return_status := FND_API.G_RET_STS_ERROR;

2966:
2967: EXCEPTION
2968: WHEN FND_API.G_EXC_ERROR THEN
2969: ROLLBACK TO MASS_PROMISE_PVT;
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2973: ROLLBACK TO MASS_PROMISE_PVT;
2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2968: WHEN FND_API.G_EXC_ERROR THEN
2969: ROLLBACK TO MASS_PROMISE_PVT;
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2973: ROLLBACK TO MASS_PROMISE_PVT;
2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2975: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2976: WHEN OTHERS THEN

Line 2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2972: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2973: ROLLBACK TO MASS_PROMISE_PVT;
2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2975: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2976: WHEN OTHERS THEN
2977: ROLLBACK TO MASS_PROMISE_PVT;
2978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2975: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2976: WHEN OTHERS THEN
2977: ROLLBACK TO MASS_PROMISE_PVT;
2978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2979: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2980: THEN
2981: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2982: END IF;

Line 3009: l_return_status := FND_API.G_RET_STS_SUCCESS;

3005: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3006: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': start');
3007: END IF;
3008: -- Initialize API return status to success
3009: l_return_status := FND_API.G_RET_STS_SUCCESS;
3010: --start
3011: Begin
3012: select delinquency_id into l_promised_delinquency_id
3013: from iex_promise_details

Line 3065: p_encoded => FND_API.G_FALSE,

3061:
3062: x_return_status := l_return_status;
3063: -- Standard call to get message count and if count is 1, get message info
3064: FND_MSG_PUB.Count_And_Get(
3065: p_encoded => FND_API.G_FALSE,
3066: p_count => x_msg_count,
3067: p_data => x_msg_data);
3068:
3069: EXCEPTION

Line 3070: WHEN FND_API.G_EXC_ERROR THEN

3066: p_count => x_msg_count,
3067: p_data => x_msg_data);
3068:
3069: EXCEPTION
3070: WHEN FND_API.G_EXC_ERROR THEN
3071: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3072: x_return_status := FND_API.G_RET_STS_ERROR;
3073: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3072: x_return_status := FND_API.G_RET_STS_ERROR;

3068:
3069: EXCEPTION
3070: WHEN FND_API.G_EXC_ERROR THEN
3071: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3072: x_return_status := FND_API.G_RET_STS_ERROR;
3073: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3075: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3070: WHEN FND_API.G_EXC_ERROR THEN
3071: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3072: x_return_status := FND_API.G_RET_STS_ERROR;
3073: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3075: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3078: WHEN OTHERS THEN

Line 3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3072: x_return_status := FND_API.G_RET_STS_ERROR;
3073: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3075: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3078: WHEN OTHERS THEN
3079: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3077: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3078: WHEN OTHERS THEN
3079: ROLLBACK TO UPDATE_DEL_STAGE_PVT;
3080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3081: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3082: THEN
3083: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3084: END IF;