DBA Data[Home] [Help]

APPS.IEX_UTILITIES dependencies on STANDARD

Line 150: -- Standard call to check for call compatibility.

146: SAVEPOINT Acct_Balance_Pvt;
147:
148: amount := 0;
149: total := 0;
150: -- Standard call to check for call compatibility.
151: IF NOT FND_API.Compatible_API_Call (l_api_version,
152: p_api_version,
153: l_api_name,
154: G_PKG_NAME) THEN

Line 200: -- Standard check of p_commit

196: --total := total - amount ;
197: total := total + amount ;
198: x_balance := total ;
199:
200: -- Standard check of p_commit
201: IF FND_API.To_Boolean(p_commit) THEN
202: COMMIT WORK;
203: END IF;
204:

Line 205: -- Standard call to get message count and if count is 1, get message info

201: IF FND_API.To_Boolean(p_commit) THEN
202: COMMIT WORK;
203: END IF;
204:
205: -- Standard call to get message count and if count is 1, get message info
206: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
207:
208: EXCEPTION
209: WHEN FND_API.G_EXC_ERROR THEN

Line 260: -- Standard Start of API savepoint

256: vstr7 VARCHAR2(100);
257:
258: BEGIN
259:
260: -- Standard Start of API savepoint
261: SAVEPOINT Validate_any_id_PVT;
262:
263: -- Initialize API return status to SUCCESS
264: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 275: -- Standard call to check for call compatibility.

271: vstr6 := ' Where ' ;
272: vstr7 := ' = :a1)';
273:
274:
275: -- Standard call to check for call compatibility.
276: IF NOT FND_API.Compatible_API_Call (l_api_version,
277: p_api_version,
278: l_api_name,
279: G_PKG_NAME)

Line 384: -- Standard Start of API savepoint

380: vstr7 VARCHAR2(100);
381:
382: BEGIN
383:
384: -- Standard Start of API savepoint
385: SAVEPOINT Validate_any_varchar_PVT;
386:
387: -- Initialize API return status to SUCCESS
388: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 399: -- Standard call to check for call compatibility.

395: vstr5 := ' From ';
396: vstr6 := ' Where ' ;
397: vstr7 := ' = :a1)';
398:
399: -- Standard call to check for call compatibility.
400: IF NOT FND_API.Compatible_API_Call (l_api_version,
401: p_api_version,
402: l_api_name,
403: G_PKG_NAME)

Line 502: -- Standard Start of API savepoint

498: vstr5 varchar2(1000);
499:
500: BEGIN
501:
502: -- Standard Start of API savepoint
503: SAVEPOINT Validate_any_varchar_PVT;
504:
505: -- Initialize API return status to SUCCESS
506: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 514: -- Standard call to check for call compatibility.

510: vstr3 := 'Where LOOKUP_TYPE = :l_lookup_type ' ;
511: vstr4 := ' AND LOOKUP_CODE = :l_lookup_code ';
512: vstr5 := ' AND ENABLED_FLAG = ''Y''';
513:
514: -- Standard call to check for call compatibility.
515: IF NOT FND_API.Compatible_API_Call (l_api_version,
516: p_api_version,
517: l_api_name,
518: G_PKG_NAME)

Line 659: -- Standard call to check for call compatibility.

655: 'WHERE source_id = p_person_id');
656: END IF;
657: SAVEPOINT Access_Resources_Pvt;
658:
659: -- Standard call to check for call compatibility.
660: IF NOT FND_API.Compatible_API_Call (l_api_version,
661: p_api_version,
662: l_api_name,
663: G_PKG_NAME) THEN

Line 697: -- Standard check of p_commit

693: END IF;
694: CLOSE c_get_resource;
695: End LOOP;
696:
697: -- Standard check of p_commit
698: IF FND_API.To_Boolean(p_commit) THEN
699: COMMIT WORK;
700: END IF;
701:

Line 702: -- Standard call to get message count and if count is 1, get message info

698: IF FND_API.To_Boolean(p_commit) THEN
699: COMMIT WORK;
700: END IF;
701:
702: -- Standard call to get message count and if count is 1, get message info
703: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
704:
705: IF PG_DEBUG < 10 THEN
706: iex_debug_pub.logmessage ('**** END get_access_resources ************');

Line 863: -- Standard call to check for call compatibility.

859: ' group by ac.resource_id, ac.employee_id ');
860:
861: SAVEPOINT get_assign_resources;
862:
863: -- Standard call to check for call compatibility.
864: IF NOT FND_API.Compatible_API_Call (l_api_version,
865: p_api_version,
866: l_api_name,
867: G_PKG_NAME) THEN

Line 895: -- Standard check of p_commit

891: CLOSE c_get_person;
892: */
893:
894: /*
895: -- Standard check of p_commit
896: IF FND_API.To_Boolean(p_commit) THEN
897: COMMIT WORK;
898: END IF;
899:

Line 900: -- Standard call to get message count and if count is 1, get message info

896: IF FND_API.To_Boolean(p_commit) THEN
897: COMMIT WORK;
898: END IF;
899:
900: -- Standard call to get message count and if count is 1, get message info
901: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
902:
903: iex_debug_pub.logmessage ('**** END get_access_resources ************');
904:

Line 1036: -- Standard call to check for call compatibility.

1032: ' group by ac.resource_id, ac.employee_id ');
1033:
1034: SAVEPOINT get_assign_account_resources;
1035:
1036: -- Standard call to check for call compatibility.
1037: IF NOT FND_API.Compatible_API_Call (l_api_version,
1038: p_api_version,
1039: l_api_name,
1040: G_PKG_NAME) THEN

Line 1068: -- Standard check of p_commit

1064: CLOSE c_get_person;
1065: */
1066:
1067:
1068: -- Standard check of p_commit
1069: /* IF FND_API.To_Boolean(p_commit) THEN
1070: COMMIT WORK;
1071: END IF;
1072:

Line 1073: -- Standard call to get message count and if count is 1, get message info

1069: /* IF FND_API.To_Boolean(p_commit) THEN
1070: COMMIT WORK;
1071: END IF;
1072:
1073: -- Standard call to get message count and if count is 1, get message info
1074: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1075:
1076: iex_debug_pub.logmessage ('**** END get_access_resources ************');
1077:

Line 1149: -- Standard call to check for call compatibility.

1145: group by ac.resource_id, ac.employee_id ORDER BY 3');
1146:
1147: SAVEPOINT get_case_resources;
1148:
1149: -- Standard call to check for call compatibility.
1150: IF NOT FND_API.Compatible_API_Call (l_api_version,
1151: p_api_version,
1152: l_api_name,
1153: G_PKG_NAME) THEN

Line 1172: -- Standard check of p_commit

1168: x_resource_tab(idx).resource_id := r_person.resource_id;
1169: x_resource_tab(idx).person_id := r_person.employee_id;
1170: End LOOP;
1171:
1172: -- Standard check of p_commit
1173: IF FND_API.To_Boolean(p_commit) THEN
1174: COMMIT WORK;
1175: END IF;
1176:

Line 1177: -- Standard call to get message count and if count is 1, get message info

1173: IF FND_API.To_Boolean(p_commit) THEN
1174: COMMIT WORK;
1175: END IF;
1176:
1177: -- Standard call to get message count and if count is 1, get message info
1178: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1179:
1180: iex_debug_pub.logmessage ('**** END get_case_resources ************');
1181:

Line 1361: -- Standard call to check for call compatibility.

1357:
1358:
1359: SAVEPOINT get_assign_resources;
1360:
1361: -- Standard call to check for call compatibility.
1362: IF NOT FND_API.Compatible_API_Call (l_api_version,
1363: p_api_version,
1364: l_api_name,
1365: G_PKG_NAME) THEN

Line 1384: -- Standard check of p_commit

1380: x_resource_tab(idx).resource_id := r_person.resource_id;
1381: x_resource_tab(idx).person_id := r_person.employee_id;
1382: End LOOP;
1383:
1384: -- Standard check of p_commit
1385: IF FND_API.To_Boolean(p_commit) THEN
1386: COMMIT WORK;
1387: END IF;
1388:

Line 1389: -- Standard call to get message count and if count is 1, get message info

1385: IF FND_API.To_Boolean(p_commit) THEN
1386: COMMIT WORK;
1387: END IF;
1388:
1389: -- Standard call to get message count and if count is 1, get message info
1390: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1391:
1392: iex_debug_pub.logmessage ('**** END get_billto_resources ************');
1393:

Line 4928: -- Standard call to check for call compatibility.

4924:
4925:
4926: SAVEPOINT get_assigned_collector;
4927:
4928: -- Standard call to check for call compatibility.
4929: IF NOT FND_API.Compatible_API_Call (l_api_version,
4930: p_api_version,
4931: l_api_name,
4932: G_PKG_NAME) THEN

Line 5175: -- Standard check of p_commit

5171: End LOOP;
5172:
5173: CLOSE c_collector;
5174:
5175: -- Standard check of p_commit
5176: IF FND_API.To_Boolean(p_commit) THEN
5177: COMMIT WORK;
5178: END IF;
5179:

Line 5180: -- Standard call to get message count and if count is 1, get message info

5176: IF FND_API.To_Boolean(p_commit) THEN
5177: COMMIT WORK;
5178: END IF;
5179:
5180: -- Standard call to get message count and if count is 1, get message info
5181: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5182:
5183: iex_debug_pub.logmessage ('**** END get_assigned_collector ************');
5184:

Line 5249: -- Standard call to check for call compatibility.

5245:
5246:
5247: SAVEPOINT get_dunning_resource;
5248:
5249: -- Standard call to check for call compatibility.
5250: IF NOT FND_API.Compatible_API_Call (l_api_version,
5251: p_api_version,
5252: l_api_name,
5253: G_PKG_NAME) THEN

Line 5325: -- Standard check of p_commit

5321: End LOOP;
5322:
5323: CLOSE c_collector;
5324:
5325: -- Standard check of p_commit
5326: IF FND_API.To_Boolean(p_commit) THEN
5327: COMMIT WORK;
5328: END IF;
5329:

Line 5330: -- Standard call to get message count and if count is 1, get message info

5326: IF FND_API.To_Boolean(p_commit) THEN
5327: COMMIT WORK;
5328: END IF;
5329:
5330: -- Standard call to get message count and if count is 1, get message info
5331: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5332:
5333: iex_debug_pub.logmessage ('**** END get_dunning_resource ************');
5334:

Line 5408: -- Standard call to check for call compatibility.

5404:
5405:
5406: SAVEPOINT get_grace_days;
5407:
5408: -- Standard call to check for call compatibility.
5409: IF NOT FND_API.Compatible_API_Call (l_api_version,
5410: p_api_version,
5411: l_api_name,
5412: G_PKG_NAME) THEN

Line 5448: -- Standard check of p_commit

5444: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_grace_days: ' || l_grace_days);
5445:
5446: x_grace_days := l_grace_days;
5447:
5448: -- Standard check of p_commit
5449: IF FND_API.To_Boolean(p_commit) THEN
5450: COMMIT WORK;
5451: END IF;
5452:

Line 5453: -- Standard call to get message count and if count is 1, get message info

5449: IF FND_API.To_Boolean(p_commit) THEN
5450: COMMIT WORK;
5451: END IF;
5452:
5453: -- Standard call to get message count and if count is 1, get message info
5454: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
5455:
5456: iex_debug_pub.logmessage ('**** END get_grace_days ************');
5457: