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

Line 130: raise fnd_api.g_exc_unexpected_error;

126: WHEN OTHERS then
127: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
128: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
129: ec_debug.pop ('ECE_RULES_PKG.UPDATE_STATUS');
130: raise fnd_api.g_exc_unexpected_error;
131:
132: END Update_Status;
133:
134:

Line 137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

133:
134:
135: PROCEDURE Validate_Process_Rules(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: x_return_status OUT NOCOPY VARCHAR2,

Line 138: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

134:
135: PROCEDURE Validate_Process_Rules(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,

Line 139: p_commit IN VARCHAR2 := FND_API.G_FALSE,

135: PROCEDURE Validate_Process_Rules(
136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,

Line 140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

136: p_api_version_number IN NUMBER,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_transaction_type IN VARCHAR2,

Line 198: if not fnd_api.compatible_api_call (l_api_version_number,

194: ec_debug.pl (3, 'p_map_id', p_map_id);
195: end if;
196:
197: -- Standard call to check for call compatibility.
198: if not fnd_api.compatible_api_call (l_api_version_number,
199: p_api_version_number, l_api_name,
200: g_pkg_name) then
201: raise fnd_api.g_exc_unexpected_error;
202: end if;

Line 201: raise fnd_api.g_exc_unexpected_error;

197: -- Standard call to check for call compatibility.
198: if not fnd_api.compatible_api_call (l_api_version_number,
199: p_api_version_number, l_api_name,
200: g_pkg_name) then
201: raise fnd_api.g_exc_unexpected_error;
202: end if;
203:
204: -- Initialize message list if p_init_msg_list is set to TRUE.
205: if fnd_api.to_boolean(p_init_msg_list) then

Line 205: if fnd_api.to_boolean(p_init_msg_list) then

201: raise fnd_api.g_exc_unexpected_error;
202: end if;
203:
204: -- Initialize message list if p_init_msg_list is set to TRUE.
205: if fnd_api.to_boolean(p_init_msg_list) then
206: fnd_msg_pub.initialize;
207: end if;
208:
209: -- Initialize API return status to success

Line 210: x_return_status := fnd_api.g_ret_sts_success;

206: fnd_msg_pub.initialize;
207: end if;
208:
209: -- Initialize API return status to success
210: x_return_status := fnd_api.g_ret_sts_success;
211:
212: xProgress := 'ECERULEB-20-1000';
213: l_rule_type := g_p_trading_partner;
214:

Line 296: if (fnd_api.to_boolean(p_simulate)) then

292:
293: end if;
294: end if;
295:
296: if (fnd_api.to_boolean(p_simulate)) then
297: null;
298: elsif (fnd_api.to_boolean(p_commit)) then
299: commit work;
300: end if;

Line 298: elsif (fnd_api.to_boolean(p_commit)) then

294: end if;
295:
296: if (fnd_api.to_boolean(p_simulate)) then
297: null;
298: elsif (fnd_api.to_boolean(p_commit)) then
299: commit work;
300: end if;
301:
302: -- Standard call to get message count and if count is 1, get message info.

Line 310: WHEN fnd_api.g_exc_error then

306: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');
307: end if;
308:
309: EXCEPTION
310: WHEN fnd_api.g_exc_error then
311: x_return_status := fnd_api.g_ret_sts_error;
312: fnd_msg_pub.count_and_get (p_count => x_msg_count,
313: p_data => x_msg_data);
314: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');

Line 311: x_return_status := fnd_api.g_ret_sts_error;

307: end if;
308:
309: EXCEPTION
310: WHEN fnd_api.g_exc_error then
311: x_return_status := fnd_api.g_ret_sts_error;
312: fnd_msg_pub.count_and_get (p_count => x_msg_count,
313: p_data => x_msg_data);
314: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');
315:

Line 316: WHEN fnd_api.g_exc_unexpected_error then

312: fnd_msg_pub.count_and_get (p_count => x_msg_count,
313: p_data => x_msg_data);
314: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');
315:
316: WHEN fnd_api.g_exc_unexpected_error then
317: x_return_status := fnd_api.g_ret_sts_error;
318: fnd_msg_pub.count_and_get (p_count => x_msg_count,
319: p_data => x_msg_data);
320: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');

Line 317: x_return_status := fnd_api.g_ret_sts_error;

313: p_data => x_msg_data);
314: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');
315:
316: WHEN fnd_api.g_exc_unexpected_error then
317: x_return_status := fnd_api.g_ret_sts_error;
318: fnd_msg_pub.count_and_get (p_count => x_msg_count,
319: p_data => x_msg_data);
320: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');
321:

Line 329: x_return_status := fnd_api.g_ret_sts_error;

325: end if;
326: ec_debug.pl (0, 'EC', 'ECE_NO_PROCESS_RULE',
327: 'TRANSACTION_TYPE', p_transaction_type,
328: 'RULE_TYPE', l_rule_type);
329: x_return_status := fnd_api.g_ret_sts_error;
330: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_PROCESS_RULES');
331:
332: WHEN OTHERS THEN
333: if (c_rule_info%ISOPEN) then

Line 341: x_return_status := fnd_api.g_ret_sts_unexp_error;

337: close c_ignore_flag;
338: end if;
339: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
340: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
341: x_return_status := fnd_api.g_ret_sts_unexp_error;
342: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
343: fnd_msg_pub.add_exc_msg(g_file_name, g_pkg_name, l_api_name);
344: end if;
345: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 604: raise fnd_api.g_exc_unexpected_error;

600:
601: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL',xProgress);
602: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
603: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_TRADING_PARTNER');
604: raise fnd_api.g_exc_unexpected_error;
605:
606: END Validate_Trading_Partner;
607:
608:

Line 685: raise fnd_api.g_exc_error;

681: 'PROGRESS_LEVEL', xProgress,
682: 'INFO', 'TEST_FLAG',
683: 'TABLE_NAME', 'ECE_TP_DETAILS');
684: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_TEST_PROD');
685: raise fnd_api.g_exc_error;
686:
687: WHEN OTHERS THEN
688: if (c_test_flag%ISOPEN) then
689: close c_test_flag;

Line 694: raise fnd_api.g_exc_unexpected_error;

690: end if;
691: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
692: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
693: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_TEST_PROD');
694: raise fnd_api.g_exc_unexpected_error;
695:
696: END Validate_Test_Prod;
697:
698:

Line 701: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

697:
698:
699: PROCEDURE Validate_Column_Rules(
700: p_api_version_number IN NUMBER,
701: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
702: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
703: p_commit IN VARCHAR2 := FND_API.G_FALSE,
704: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
705: x_return_status OUT NOCOPY VARCHAR2,

Line 702: p_simulate IN VARCHAR2 := FND_API.G_FALSE,

698:
699: PROCEDURE Validate_Column_Rules(
700: p_api_version_number IN NUMBER,
701: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
702: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
703: p_commit IN VARCHAR2 := FND_API.G_FALSE,
704: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
705: x_return_status OUT NOCOPY VARCHAR2,
706: x_msg_count OUT NOCOPY NUMBER,

Line 703: p_commit IN VARCHAR2 := FND_API.G_FALSE,

699: PROCEDURE Validate_Column_Rules(
700: p_api_version_number IN NUMBER,
701: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
702: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
703: p_commit IN VARCHAR2 := FND_API.G_FALSE,
704: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
705: x_return_status OUT NOCOPY VARCHAR2,
706: x_msg_count OUT NOCOPY NUMBER,
707: x_msg_data OUT NOCOPY VARCHAR2,

Line 704: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

700: p_api_version_number IN NUMBER,
701: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
702: p_simulate IN VARCHAR2 := FND_API.G_FALSE,
703: p_commit IN VARCHAR2 := FND_API.G_FALSE,
704: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
705: x_return_status OUT NOCOPY VARCHAR2,
706: x_msg_count OUT NOCOPY NUMBER,
707: x_msg_data OUT NOCOPY VARCHAR2,
708: p_transaction_type IN VARCHAR2,

Line 767: if not fnd_api.compatible_api_call (l_api_version_number,

763: ec_debug.pl (3, 'p_level', p_level);
764: end if;
765:
766: -- Standard call to check for call compatibility.
767: if not fnd_api.compatible_api_call (l_api_version_number,
768: p_api_version_number, l_api_name,
769: g_pkg_name) then
770: raise fnd_api.g_exc_unexpected_error;
771: end if;

Line 770: raise fnd_api.g_exc_unexpected_error;

766: -- Standard call to check for call compatibility.
767: if not fnd_api.compatible_api_call (l_api_version_number,
768: p_api_version_number, l_api_name,
769: g_pkg_name) then
770: raise fnd_api.g_exc_unexpected_error;
771: end if;
772:
773: -- Initialize message list if p_init_msg_list is set to TRUE.
774: if fnd_api.to_boolean(p_init_msg_list) then

Line 774: if fnd_api.to_boolean(p_init_msg_list) then

770: raise fnd_api.g_exc_unexpected_error;
771: end if;
772:
773: -- Initialize message list if p_init_msg_list is set to TRUE.
774: if fnd_api.to_boolean(p_init_msg_list) then
775: fnd_msg_pub.initialize;
776: end if;
777:
778: -- Initialize API return status to success

Line 779: x_return_status := fnd_api.g_ret_sts_success;

775: fnd_msg_pub.initialize;
776: end if;
777:
778: -- Initialize API return status to success
779: x_return_status := fnd_api.g_ret_sts_success;
780:
781: xProgress := 'ECERULEB-50-1000';
782:
783: /* bug 2500898

Line 952: if (fnd_api.to_boolean(p_simulate)) then

948: i := ec_utils.g_column_rule_tbl.NEXT(i); -- Bug 2708573
949:
950: end loop;
951:
952: if (fnd_api.to_boolean(p_simulate)) then
953: null;
954: elsif (fnd_api.to_boolean(p_commit)) then
955: commit work;
956: end if;

Line 954: elsif (fnd_api.to_boolean(p_commit)) then

950: end loop;
951:
952: if (fnd_api.to_boolean(p_simulate)) then
953: null;
954: elsif (fnd_api.to_boolean(p_commit)) then
955: commit work;
956: end if;
957:
958: -- Standard call to get message count and if count is 1, get message info.

Line 968: WHEN fnd_api.g_exc_error then

964: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_COLUMN_RULES');
965: end if;
966:
967: EXCEPTION
968: WHEN fnd_api.g_exc_error then
969: /* Bug 2708573
970: if (c_col_rule_info%ISOPEN) then
971: close c_col_rule_info;
972: end if;

Line 977: x_return_status := fnd_api.g_ret_sts_error;

973: */
974: -- if (c_ignore_flag%ISOPEN) then
975: -- close c_ignore_flag;
976: -- end if;
977: x_return_status := fnd_api.g_ret_sts_error;
978: fnd_msg_pub.count_and_get (p_count => x_msg_count,
979: p_data => x_msg_data);
980: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_COLUMN_RULES');
981:

Line 982: WHEN fnd_api.g_exc_unexpected_error then

978: fnd_msg_pub.count_and_get (p_count => x_msg_count,
979: p_data => x_msg_data);
980: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_COLUMN_RULES');
981:
982: WHEN fnd_api.g_exc_unexpected_error then
983: /* Bug 2708573
984: if (c_col_rule_info%ISOPEN) then
985: close c_col_rule_info;
986: end if;

Line 992: x_return_status := fnd_api.g_ret_sts_error;

988:
989: /* if (c_ignore_flag%ISOPEN) then
990: close c_ignore_flag;
991: end if; */
992: x_return_status := fnd_api.g_ret_sts_error;
993: fnd_msg_pub.count_and_get (p_count => x_msg_count,
994: p_data => x_msg_data);
995: ec_debug.pop ('ECE_RULES_PKG.VALIDATE_COLUMN_RULES');
996:

Line 1009: x_return_status := fnd_api.g_ret_sts_unexp_error;

1005: close c_ignore_flag;
1006: end if; */
1007: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
1008: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1011: fnd_msg_pub.add_exc_msg(g_file_name, g_pkg_name, l_api_name);
1012: end if;
1013: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 1060: raise fnd_api.g_exc_unexpected_error;

1056: WHEN OTHERS THEN
1057: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
1058: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
1059: ec_debug.pop ('ECE_RULES_PKG.VALUE_REQUIRED_RULE');
1060: raise fnd_api.g_exc_unexpected_error;
1061:
1062: END Value_Required_Rule;
1063:
1064:

Line 1194: raise fnd_api.g_exc_unexpected_error;

1190: end if;
1191: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
1192: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
1193: ec_debug.pop ('ECE_RULES_PKG.SIMPLE_LOOKUP_RULE');
1194: raise fnd_api.g_exc_unexpected_error;
1195:
1196: END Simple_Lookup_Rule;
1197:
1198:

Line 1327: raise fnd_api.g_exc_error;

1323: end if;
1324: ec_debug.pl (0, 'EC', 'ECE_VALUESET_NOT_FOUND',
1325: 'VALUESET', l_valueset_name);
1326: ec_debug.pop ('ECE_RULES_PKG.VALUESET_RULE');
1327: raise fnd_api.g_exc_error;
1328:
1329: WHEN OTHERS THEN
1330: if (c_valueset%ISOPEN) then
1331: close c_valueset;

Line 1339: raise fnd_api.g_exc_unexpected_error;

1335: end if;
1336: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
1337: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
1338: ec_debug.pop ('ECE_RULES_PKG.VALUESET_RULE');
1339: raise fnd_api.g_exc_unexpected_error;
1340:
1341: END Valueset_Rule;
1342:
1343:

Line 1495: raise fnd_api.g_exc_unexpected_error;

1491: end if;
1492: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
1493: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
1494: ec_debug.pop ('ECE_RULES_PKG.NULL_DEPENDENCY_RULE');
1495: raise fnd_api.g_exc_unexpected_error;
1496:
1497: END Null_Dependency_Rule;
1498:
1499:

Line 1597: raise fnd_api.g_exc_unexpected_error;

1593: end if;
1594: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
1595: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
1596: ec_debug.pop ('ECE_RULES_PKG.PREDEFINED_LIST_RULE');
1597: raise fnd_api.g_exc_unexpected_error;
1598:
1599: END Predefined_List_Rule;
1600:
1601:

Line 1707: raise fnd_api.g_exc_unexpected_error;

1703: end if;
1704: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
1705: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
1706: ec_debug.pop ('ECE_RULES_PKG.NULL_DEFAULT_RULE');
1707: raise fnd_api.g_exc_unexpected_error;
1708:
1709: END Null_Default_Rule;
1710:
1711:

Line 1775: raise fnd_api.g_exc_unexpected_error;

1771: WHEN OTHERS THEN
1772: ec_debug.pl (0, 'EC', 'ECE_PROGRAM_ERROR','PROGRESS_LEVEL', xProgress);
1773: ec_debug.pl (0, 'EC', 'ECE_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM);
1774: ec_debug.pop ('ECE_RULES_PKG.DATATYPE_CHECKING_RULE');
1775: raise fnd_api.g_exc_unexpected_error;
1776:
1777: END Datatype_Checking_Rule;
1778:
1779:

Line 2110: l_return_status := fnd_api.G_RET_STS_SUCCESS;

2106: x_country :=g_address_tbl(k).country;
2107: x_region1 :=g_address_tbl(k).region_1;
2108: x_region2 :=g_address_tbl(k).region_2;
2109: x_region3 :=g_address_tbl(k).region_3;
2110: l_return_status := fnd_api.G_RET_STS_SUCCESS;
2111: l_status_code := 0;
2112: l_found_on_tbl := 'Y';
2113: exit;
2114: END if;

Line 2155: l_return_status := fnd_api.G_RET_STS_SUCCESS;

2151: x_country :=g_address_tbl(k).country;
2152: x_region1 :=g_address_tbl(k).region_1;
2153: x_region2 :=g_address_tbl(k).region_2;
2154: x_region3 :=g_address_tbl(k).region_3;
2155: l_return_status := fnd_api.G_RET_STS_SUCCESS;
2156: l_status_code := 0;
2157: l_found_on_tbl := 'Y';
2158: exit;
2159: END if;

Line 2192: l_return_status := fnd_api.G_RET_STS_SUCCESS;

2188: x_country :=g_address_tbl(k).country;
2189: x_region1 :=g_address_tbl(k).region_1;
2190: x_region2 :=g_address_tbl(k).region_2;
2191: x_region3 :=g_address_tbl(k).region_3;
2192: l_return_status := fnd_api.G_RET_STS_SUCCESS;
2193: l_status_code := 0;
2194: l_found_on_tbl := 'Y';
2195: exit;
2196: END if;

Line 2284: if (l_return_status = fnd_api.g_ret_sts_success) then

2280: end if;
2281: end if;
2282:
2283: xProgress := 'ECERULEB-130-1230';
2284: if (l_return_status = fnd_api.g_ret_sts_success) then
2285:
2286: -- assign the address info that got from address derivation to
2287: -- pl/sql table.
2288: xProgress := 'ECERULEB-130-1240';