DBA Data[Home] [Help]

APPS.IEX_UTILITIES dependencies on STANDARD

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

37: SAVEPOINT Acct_Balance_Pvt;
38:
39: amount := 0;
40: total := 0;
41: -- Standard call to check for call compatibility.
42: IF NOT FND_API.Compatible_API_Call (l_api_version,
43: p_api_version,
44: l_api_name,
45: G_PKG_NAME) THEN

Line 91: -- Standard check of p_commit

87: --total := total - amount ;
88: total := total + amount ;
89: x_balance := total ;
90:
91: -- Standard check of p_commit
92: IF FND_API.To_Boolean(p_commit) THEN
93: COMMIT WORK;
94: END IF;
95:

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

92: IF FND_API.To_Boolean(p_commit) THEN
93: COMMIT WORK;
94: END IF;
95:
96: -- Standard call to get message count and if count is 1, get message info
97: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
98:
99: EXCEPTION
100: WHEN FND_API.G_EXC_ERROR THEN

Line 151: -- Standard Start of API savepoint

147: vstr7 VARCHAR2(100);
148:
149: BEGIN
150:
151: -- Standard Start of API savepoint
152: SAVEPOINT Validate_any_id_PVT;
153:
154: -- Initialize API return status to SUCCESS
155: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

162: vstr6 := ' Where ' ;
163: vstr7 := ' = :a1)';
164:
165:
166: -- Standard call to check for call compatibility.
167: IF NOT FND_API.Compatible_API_Call (l_api_version,
168: p_api_version,
169: l_api_name,
170: G_PKG_NAME)

Line 275: -- Standard Start of API savepoint

271: vstr7 VARCHAR2(100);
272:
273: BEGIN
274:
275: -- Standard Start of API savepoint
276: SAVEPOINT Validate_any_varchar_PVT;
277:
278: -- Initialize API return status to SUCCESS
279: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

286: vstr5 := ' From ';
287: vstr6 := ' Where ' ;
288: vstr7 := ' = :a1)';
289:
290: -- Standard call to check for call compatibility.
291: IF NOT FND_API.Compatible_API_Call (l_api_version,
292: p_api_version,
293: l_api_name,
294: G_PKG_NAME)

Line 393: -- Standard Start of API savepoint

389: vstr5 varchar2(1000);
390:
391: BEGIN
392:
393: -- Standard Start of API savepoint
394: SAVEPOINT Validate_any_varchar_PVT;
395:
396: -- Initialize API return status to SUCCESS
397: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

401: vstr3 := 'Where LOOKUP_TYPE = :l_lookup_type ' ;
402: vstr4 := ' AND LOOKUP_CODE = :l_lookup_code ';
403: vstr5 := ' AND ENABLED_FLAG = ''Y''';
404:
405: -- Standard call to check for call compatibility.
406: IF NOT FND_API.Compatible_API_Call (l_api_version,
407: p_api_version,
408: l_api_name,
409: G_PKG_NAME)

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

546: 'WHERE source_id = p_person_id');
547: END IF;
548: SAVEPOINT Access_Resources_Pvt;
549:
550: -- Standard call to check for call compatibility.
551: IF NOT FND_API.Compatible_API_Call (l_api_version,
552: p_api_version,
553: l_api_name,
554: G_PKG_NAME) THEN

Line 588: -- Standard check of p_commit

584: END IF;
585: CLOSE c_get_resource;
586: End LOOP;
587:
588: -- Standard check of p_commit
589: IF FND_API.To_Boolean(p_commit) THEN
590: COMMIT WORK;
591: END IF;
592:

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

589: IF FND_API.To_Boolean(p_commit) THEN
590: COMMIT WORK;
591: END IF;
592:
593: -- Standard call to get message count and if count is 1, get message info
594: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
595:
596: IF PG_DEBUG < 10 THEN
597: iex_debug_pub.logmessage ('**** END get_access_resources ************');

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

750: ' group by ac.resource_id, ac.employee_id ');
751:
752: SAVEPOINT get_assign_resources;
753:
754: -- Standard call to check for call compatibility.
755: IF NOT FND_API.Compatible_API_Call (l_api_version,
756: p_api_version,
757: l_api_name,
758: G_PKG_NAME) THEN

Line 786: -- Standard check of p_commit

782: CLOSE c_get_person;
783: */
784:
785: /*
786: -- Standard check of p_commit
787: IF FND_API.To_Boolean(p_commit) THEN
788: COMMIT WORK;
789: END IF;
790:

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

787: IF FND_API.To_Boolean(p_commit) THEN
788: COMMIT WORK;
789: END IF;
790:
791: -- Standard call to get message count and if count is 1, get message info
792: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
793:
794: iex_debug_pub.logmessage ('**** END get_access_resources ************');
795:

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

923: ' group by ac.resource_id, ac.employee_id ');
924:
925: SAVEPOINT get_assign_account_resources;
926:
927: -- Standard call to check for call compatibility.
928: IF NOT FND_API.Compatible_API_Call (l_api_version,
929: p_api_version,
930: l_api_name,
931: G_PKG_NAME) THEN

Line 959: -- Standard check of p_commit

955: CLOSE c_get_person;
956: */
957:
958:
959: -- Standard check of p_commit
960: /* IF FND_API.To_Boolean(p_commit) THEN
961: COMMIT WORK;
962: END IF;
963:

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

960: /* IF FND_API.To_Boolean(p_commit) THEN
961: COMMIT WORK;
962: END IF;
963:
964: -- Standard call to get message count and if count is 1, get message info
965: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
966:
967: iex_debug_pub.logmessage ('**** END get_access_resources ************');
968:

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

1036: group by ac.resource_id, ac.employee_id ORDER BY 3');
1037:
1038: SAVEPOINT get_case_resources;
1039:
1040: -- Standard call to check for call compatibility.
1041: IF NOT FND_API.Compatible_API_Call (l_api_version,
1042: p_api_version,
1043: l_api_name,
1044: G_PKG_NAME) THEN

Line 1063: -- Standard check of p_commit

1059: x_resource_tab(idx).resource_id := r_person.resource_id;
1060: x_resource_tab(idx).person_id := r_person.employee_id;
1061: End LOOP;
1062:
1063: -- Standard check of p_commit
1064: IF FND_API.To_Boolean(p_commit) THEN
1065: COMMIT WORK;
1066: END IF;
1067:

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

1064: IF FND_API.To_Boolean(p_commit) THEN
1065: COMMIT WORK;
1066: END IF;
1067:
1068: -- Standard call to get message count and if count is 1, get message info
1069: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1070:
1071: iex_debug_pub.logmessage ('**** END get_case_resources ************');
1072:

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

1248:
1249:
1250: SAVEPOINT get_assign_resources;
1251:
1252: -- Standard call to check for call compatibility.
1253: IF NOT FND_API.Compatible_API_Call (l_api_version,
1254: p_api_version,
1255: l_api_name,
1256: G_PKG_NAME) THEN

Line 1275: -- Standard check of p_commit

1271: x_resource_tab(idx).resource_id := r_person.resource_id;
1272: x_resource_tab(idx).person_id := r_person.employee_id;
1273: End LOOP;
1274:
1275: -- Standard check of p_commit
1276: IF FND_API.To_Boolean(p_commit) THEN
1277: COMMIT WORK;
1278: END IF;
1279:

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

1276: IF FND_API.To_Boolean(p_commit) THEN
1277: COMMIT WORK;
1278: END IF;
1279:
1280: -- Standard call to get message count and if count is 1, get message info
1281: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1282:
1283: iex_debug_pub.logmessage ('**** END get_billto_resources ************');
1284:

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

2159:
2160:
2161: SAVEPOINT get_assigned_collector;
2162:
2163: -- Standard call to check for call compatibility.
2164: IF NOT FND_API.Compatible_API_Call (l_api_version,
2165: p_api_version,
2166: l_api_name,
2167: G_PKG_NAME) THEN

Line 2387: -- Standard check of p_commit

2383: End LOOP;
2384:
2385: CLOSE c_collector;
2386:
2387: -- Standard check of p_commit
2388: IF FND_API.To_Boolean(p_commit) THEN
2389: COMMIT WORK;
2390: END IF;
2391:

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

2388: IF FND_API.To_Boolean(p_commit) THEN
2389: COMMIT WORK;
2390: END IF;
2391:
2392: -- Standard call to get message count and if count is 1, get message info
2393: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2394:
2395: iex_debug_pub.logmessage ('**** END get_assigned_collector ************');
2396: