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

Line 141: x_return_status := fnd_api.g_ret_sts_unexp_error;

137: AND status <> 'VALID'
138: AND owner = g_owner);
139: BEGIN
140:
141: x_return_status := fnd_api.g_ret_sts_unexp_error;
142:
143: if ad_zd.get_edition('PATCH') is not null then
144: -- an online patch is in progress, return error
145: fnd_message.set_name('FND', 'AD_ZD_DISABLED_FEATURE');

Line 172: x_return_status := fnd_api.g_ret_sts_unexp_error;

168: IF p_package_body THEN
169: OPEN c_package_body_status;
170: FETCH c_package_body_status INTO l_error;
171: IF c_package_body_status%FOUND THEN
172: x_return_status := fnd_api.g_ret_sts_unexp_error;
173: ELSE
174: x_return_status := fnd_api.g_ret_sts_success;
175: END IF;
176: CLOSE c_package_body_status;

Line 174: x_return_status := fnd_api.g_ret_sts_success;

170: FETCH c_package_body_status INTO l_error;
171: IF c_package_body_status%FOUND THEN
172: x_return_status := fnd_api.g_ret_sts_unexp_error;
173: ELSE
174: x_return_status := fnd_api.g_ret_sts_success;
175: END IF;
176: CLOSE c_package_body_status;
177: ELSE
178: OPEN c_package_status;

Line 181: x_return_status := fnd_api.g_ret_sts_unexp_error;

177: ELSE
178: OPEN c_package_status;
179: FETCH c_package_status INTO l_error;
180: IF c_package_status%FOUND THEN
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: ELSE
183: x_return_status := fnd_api.g_ret_sts_success;
184: END IF;
185: CLOSE c_package_status;

Line 183: x_return_status := fnd_api.g_ret_sts_success;

179: FETCH c_package_status INTO l_error;
180: IF c_package_status%FOUND THEN
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: ELSE
183: x_return_status := fnd_api.g_ret_sts_success;
184: END IF;
185: CLOSE c_package_status;
186: END IF;
187: EXCEPTION

Line 189: x_return_status := fnd_api.g_ret_sts_unexp_error;

185: CLOSE c_package_status;
186: END IF;
187: EXCEPTION
188: WHEN OTHERS THEN
189: x_return_status := fnd_api.g_ret_sts_unexp_error;
190: END CreatePackage;
191:
192:
193: PROCEDURE GenerateSQL

Line 1188: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1184: if inv_pp_debug.is_debug_mode then
1185: inv_pp_debug.send_long_to_pipe('x_return_status : '|| x_return_status);
1186: end if;
1187:
1188: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1189: RAISE fnd_api.g_exc_unexpected_error;
1190: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1191: RAISE fnd_api.g_exc_error;
1192: END IF;

Line 1189: RAISE fnd_api.g_exc_unexpected_error;

1185: inv_pp_debug.send_long_to_pipe('x_return_status : '|| x_return_status);
1186: end if;
1187:
1188: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1189: RAISE fnd_api.g_exc_unexpected_error;
1190: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1191: RAISE fnd_api.g_exc_error;
1192: END IF;
1193: END IF ;

Line 1190: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1186: end if;
1187:
1188: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1189: RAISE fnd_api.g_exc_unexpected_error;
1190: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1191: RAISE fnd_api.g_exc_error;
1192: END IF;
1193: END IF ;
1194: --------

Line 1191: RAISE fnd_api.g_exc_error;

1187:
1188: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1189: RAISE fnd_api.g_exc_unexpected_error;
1190: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1191: RAISE fnd_api.g_exc_error;
1192: END IF;
1193: END IF ;
1194: --------
1195: ---------

Line 1303: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1299: end if;
1300: --create the package body
1301: CreatePackage(x_return_status, l_package_name, FALSE);
1302:
1303: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1304: RAISE fnd_api.g_exc_unexpected_error;
1305: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1306: RAISE fnd_api.g_exc_error;
1307: END IF;

Line 1304: RAISE fnd_api.g_exc_unexpected_error;

1300: --create the package body
1301: CreatePackage(x_return_status, l_package_name, FALSE);
1302:
1303: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1304: RAISE fnd_api.g_exc_unexpected_error;
1305: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1306: RAISE fnd_api.g_exc_error;
1307: END IF;
1308:

Line 1305: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1301: CreatePackage(x_return_status, l_package_name, FALSE);
1302:
1303: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1304: RAISE fnd_api.g_exc_unexpected_error;
1305: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1306: RAISE fnd_api.g_exc_error;
1307: END IF;
1308:
1309: END IF;

Line 1306: RAISE fnd_api.g_exc_error;

1302:
1303: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1304: RAISE fnd_api.g_exc_unexpected_error;
1305: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1306: RAISE fnd_api.g_exc_error;
1307: END IF;
1308:
1309: END IF;
1310: COMMIT;

Line 1400: RAISE fnd_api.g_exc_error;

1396: (p_CG_code IS NULL ) AND
1397: (p_op_code IS NULL ) THEN
1398: fnd_message.set_name('WMS', 'WMS_INVALID_TYPE');
1399: FND_MSG_PUB.ADD;
1400: RAISE fnd_api.g_exc_error;
1401:
1402: END IF;
1403:
1404: --- Pick

Line 1427: p_init_msg_list => fnd_api.g_false ,

1423: if (l_counter <> -1 ) then
1424:
1425: if (l_no_pick_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1426: GenerateSQL(p_api_version => 1.0,
1427: p_init_msg_list => fnd_api.g_false ,
1428: p_validation_level => fnd_api.g_valid_level_full ,
1429: x_return_status => x_return_status,
1430: x_msg_count => x_msg_count,
1431: x_msg_data => x_msg_data ,

Line 1428: p_validation_level => fnd_api.g_valid_level_full ,

1424:
1425: if (l_no_pick_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1426: GenerateSQL(p_api_version => 1.0,
1427: p_init_msg_list => fnd_api.g_false ,
1428: p_validation_level => fnd_api.g_valid_level_full ,
1429: x_return_status => x_return_status,
1430: x_msg_count => x_msg_count,
1431: x_msg_data => x_msg_data ,
1432: p_type_code => p_pick_code,

Line 1469: p_init_msg_list => fnd_api.g_false ,

1465:
1466: if (l_no_put_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1467:
1468: GenerateSQL(p_api_version => 1.0,
1469: p_init_msg_list => fnd_api.g_false ,
1470: p_validation_level => fnd_api.g_valid_level_full ,
1471: x_return_status => x_return_status,
1472: x_msg_count => x_msg_count,
1473: x_msg_data => x_msg_data,

Line 1470: p_validation_level => fnd_api.g_valid_level_full ,

1466: if (l_no_put_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1467:
1468: GenerateSQL(p_api_version => 1.0,
1469: p_init_msg_list => fnd_api.g_false ,
1470: p_validation_level => fnd_api.g_valid_level_full ,
1471: x_return_status => x_return_status,
1472: x_msg_count => x_msg_count,
1473: x_msg_data => x_msg_data,
1474: p_type_code => p_put_code,

Line 1508: p_init_msg_list => fnd_api.g_false ,

1504:
1505: if (l_no_task_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1506:
1507: GenerateSQL(p_api_version => 1.0,
1508: p_init_msg_list => fnd_api.g_false ,
1509: p_validation_level => fnd_api.g_valid_level_full ,
1510: x_return_status => x_return_status,
1511: x_msg_count => x_msg_count,
1512: x_msg_data => x_msg_data,

Line 1509: p_validation_level => fnd_api.g_valid_level_full ,

1505: if (l_no_task_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1506:
1507: GenerateSQL(p_api_version => 1.0,
1508: p_init_msg_list => fnd_api.g_false ,
1509: p_validation_level => fnd_api.g_valid_level_full ,
1510: x_return_status => x_return_status,
1511: x_msg_count => x_msg_count,
1512: x_msg_data => x_msg_data,
1513: p_type_code => p_task_code,

Line 1550: p_init_msg_list => fnd_api.g_false ,

1546:
1547: if (l_no_label_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1548:
1549: GenerateSQL(p_api_version => 1.0,
1550: p_init_msg_list => fnd_api.g_false ,
1551: p_validation_level => fnd_api.g_valid_level_full ,
1552: x_return_status => x_return_status,
1553: x_msg_count => x_msg_count,
1554: x_msg_data => x_msg_data,

Line 1551: p_validation_level => fnd_api.g_valid_level_full ,

1547: if (l_no_label_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1548:
1549: GenerateSQL(p_api_version => 1.0,
1550: p_init_msg_list => fnd_api.g_false ,
1551: p_validation_level => fnd_api.g_valid_level_full ,
1552: x_return_status => x_return_status,
1553: x_msg_count => x_msg_count,
1554: x_msg_data => x_msg_data,
1555: p_type_code => p_label_code,

Line 1591: p_init_msg_list => fnd_api.g_false ,

1587:
1588: if (l_no_cg_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1589:
1590: GenerateSQL(p_api_version => 1.0,
1591: p_init_msg_list => fnd_api.g_false ,
1592: p_validation_level => fnd_api.g_valid_level_full ,
1593: x_return_status => x_return_status,
1594: x_msg_count => x_msg_count,
1595: x_msg_data => x_msg_data,

Line 1592: p_validation_level => fnd_api.g_valid_level_full ,

1588: if (l_no_cg_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1589:
1590: GenerateSQL(p_api_version => 1.0,
1591: p_init_msg_list => fnd_api.g_false ,
1592: p_validation_level => fnd_api.g_valid_level_full ,
1593: x_return_status => x_return_status,
1594: x_msg_count => x_msg_count,
1595: x_msg_data => x_msg_data,
1596: p_type_code => p_CG_code,

Line 1630: p_init_msg_list => fnd_api.g_false ,

1626:
1627: if (l_no_op_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1628:
1629: GenerateSQL(p_api_version => 1.0,
1630: p_init_msg_list => fnd_api.g_false ,
1631: p_validation_level => fnd_api.g_valid_level_full ,
1632: x_return_status => x_return_status,
1633: x_msg_count => x_msg_count,
1634: x_msg_data => x_msg_data,

Line 1631: p_validation_level => fnd_api.g_valid_level_full ,

1627: if (l_no_op_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1628:
1629: GenerateSQL(p_api_version => 1.0,
1630: p_init_msg_list => fnd_api.g_false ,
1631: p_validation_level => fnd_api.g_valid_level_full ,
1632: x_return_status => x_return_status,
1633: x_msg_count => x_msg_count,
1634: x_msg_data => x_msg_data,
1635: p_type_code => p_OP_code,

Line 1655: WHEN FND_API.G_EXC_ERROR THEN

1651:
1652:
1653: EXCEPTION
1654:
1655: WHEN FND_API.G_EXC_ERROR THEN
1656: x_return_status := FND_API.G_RET_STS_ERROR;
1657: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
1658:
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1656: x_return_status := FND_API.G_RET_STS_ERROR;

1652:
1653: EXCEPTION
1654:
1655: WHEN FND_API.G_EXC_ERROR THEN
1656: x_return_status := FND_API.G_RET_STS_ERROR;
1657: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
1658:
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1655: WHEN FND_API.G_EXC_ERROR THEN
1656: x_return_status := FND_API.G_RET_STS_ERROR;
1657: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
1658:
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1661: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
1662: END GenerateRuleExecPkgs;
1663: ----------------

Line 1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1656: x_return_status := FND_API.G_RET_STS_ERROR;
1657: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
1658:
1659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1661: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
1662: END GenerateRuleExecPkgs;
1663: ----------------
1664: FUNCTION get_count_with_lock(P_RULE_TYPE IN VARCHAR2 )