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: --open cursor
144: l_cursor := dbms_sql.open_cursor;
145: --parse cursor

Line 166: x_return_status := fnd_api.g_ret_sts_unexp_error;

162: IF p_package_body THEN
163: OPEN c_package_body_status;
164: FETCH c_package_body_status INTO l_error;
165: IF c_package_body_status%FOUND THEN
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167: ELSE
168: x_return_status := fnd_api.g_ret_sts_success;
169: END IF;
170: CLOSE c_package_body_status;

Line 168: x_return_status := fnd_api.g_ret_sts_success;

164: FETCH c_package_body_status INTO l_error;
165: IF c_package_body_status%FOUND THEN
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167: ELSE
168: x_return_status := fnd_api.g_ret_sts_success;
169: END IF;
170: CLOSE c_package_body_status;
171: ELSE
172: OPEN c_package_status;

Line 175: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 177: x_return_status := fnd_api.g_ret_sts_success;

173: FETCH c_package_status INTO l_error;
174: IF c_package_status%FOUND THEN
175: x_return_status := fnd_api.g_ret_sts_unexp_error;
176: ELSE
177: x_return_status := fnd_api.g_ret_sts_success;
178: END IF;
179: CLOSE c_package_status;
180: END IF;
181: EXCEPTION

Line 183: x_return_status := fnd_api.g_ret_sts_unexp_error;

179: CLOSE c_package_status;
180: END IF;
181: EXCEPTION
182: WHEN OTHERS THEN
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: END CreatePackage;
185:
186:
187: PROCEDURE GenerateSQL

Line 1181: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1177: if inv_pp_debug.is_debug_mode then
1178: inv_pp_debug.send_long_to_pipe('x_return_status : '|| x_return_status);
1179: end if;
1180:
1181: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1182: RAISE fnd_api.g_exc_unexpected_error;
1183: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1184: RAISE fnd_api.g_exc_error;
1185: END IF;

Line 1182: RAISE fnd_api.g_exc_unexpected_error;

1178: inv_pp_debug.send_long_to_pipe('x_return_status : '|| x_return_status);
1179: end if;
1180:
1181: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1182: RAISE fnd_api.g_exc_unexpected_error;
1183: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1184: RAISE fnd_api.g_exc_error;
1185: END IF;
1186: END IF ;

Line 1183: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1179: end if;
1180:
1181: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1182: RAISE fnd_api.g_exc_unexpected_error;
1183: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1184: RAISE fnd_api.g_exc_error;
1185: END IF;
1186: END IF ;
1187: --------

Line 1184: RAISE fnd_api.g_exc_error;

1180:
1181: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1182: RAISE fnd_api.g_exc_unexpected_error;
1183: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1184: RAISE fnd_api.g_exc_error;
1185: END IF;
1186: END IF ;
1187: --------
1188: ---------

Line 1296: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1292: end if;
1293: --create the package body
1294: CreatePackage(x_return_status, l_package_name, FALSE);
1295:
1296: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1297: RAISE fnd_api.g_exc_unexpected_error;
1298: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1299: RAISE fnd_api.g_exc_error;
1300: END IF;

Line 1297: RAISE fnd_api.g_exc_unexpected_error;

1293: --create the package body
1294: CreatePackage(x_return_status, l_package_name, FALSE);
1295:
1296: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1297: RAISE fnd_api.g_exc_unexpected_error;
1298: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1299: RAISE fnd_api.g_exc_error;
1300: END IF;
1301:

Line 1298: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1294: CreatePackage(x_return_status, l_package_name, FALSE);
1295:
1296: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1297: RAISE fnd_api.g_exc_unexpected_error;
1298: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1299: RAISE fnd_api.g_exc_error;
1300: END IF;
1301:
1302: END IF;

Line 1299: RAISE fnd_api.g_exc_error;

1295:
1296: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1297: RAISE fnd_api.g_exc_unexpected_error;
1298: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1299: RAISE fnd_api.g_exc_error;
1300: END IF;
1301:
1302: END IF;
1303: COMMIT;

Line 1393: RAISE fnd_api.g_exc_error;

1389: (p_CG_code IS NULL ) AND
1390: (p_op_code IS NULL ) THEN
1391: fnd_message.set_name('WMS', 'WMS_INVALID_TYPE');
1392: FND_MSG_PUB.ADD;
1393: RAISE fnd_api.g_exc_error;
1394:
1395: END IF;
1396:
1397: --- Pick

Line 1420: p_init_msg_list => fnd_api.g_false ,

1416: if (l_counter <> -1 ) then
1417:
1418: if (l_no_pick_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1419: GenerateSQL(p_api_version => 1.0,
1420: p_init_msg_list => fnd_api.g_false ,
1421: p_validation_level => fnd_api.g_valid_level_full ,
1422: x_return_status => x_return_status,
1423: x_msg_count => x_msg_count,
1424: x_msg_data => x_msg_data ,

Line 1421: p_validation_level => fnd_api.g_valid_level_full ,

1417:
1418: if (l_no_pick_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1419: GenerateSQL(p_api_version => 1.0,
1420: p_init_msg_list => fnd_api.g_false ,
1421: p_validation_level => fnd_api.g_valid_level_full ,
1422: x_return_status => x_return_status,
1423: x_msg_count => x_msg_count,
1424: x_msg_data => x_msg_data ,
1425: p_type_code => p_pick_code,

Line 1462: p_init_msg_list => fnd_api.g_false ,

1458:
1459: if (l_no_put_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1460:
1461: GenerateSQL(p_api_version => 1.0,
1462: p_init_msg_list => fnd_api.g_false ,
1463: p_validation_level => fnd_api.g_valid_level_full ,
1464: x_return_status => x_return_status,
1465: x_msg_count => x_msg_count,
1466: x_msg_data => x_msg_data,

Line 1463: p_validation_level => fnd_api.g_valid_level_full ,

1459: if (l_no_put_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1460:
1461: GenerateSQL(p_api_version => 1.0,
1462: p_init_msg_list => fnd_api.g_false ,
1463: p_validation_level => fnd_api.g_valid_level_full ,
1464: x_return_status => x_return_status,
1465: x_msg_count => x_msg_count,
1466: x_msg_data => x_msg_data,
1467: p_type_code => p_put_code,

Line 1501: p_init_msg_list => fnd_api.g_false ,

1497:
1498: if (l_no_task_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1499:
1500: GenerateSQL(p_api_version => 1.0,
1501: p_init_msg_list => fnd_api.g_false ,
1502: p_validation_level => fnd_api.g_valid_level_full ,
1503: x_return_status => x_return_status,
1504: x_msg_count => x_msg_count,
1505: x_msg_data => x_msg_data,

Line 1502: p_validation_level => fnd_api.g_valid_level_full ,

1498: if (l_no_task_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1499:
1500: GenerateSQL(p_api_version => 1.0,
1501: p_init_msg_list => fnd_api.g_false ,
1502: p_validation_level => fnd_api.g_valid_level_full ,
1503: x_return_status => x_return_status,
1504: x_msg_count => x_msg_count,
1505: x_msg_data => x_msg_data,
1506: p_type_code => p_task_code,

Line 1543: p_init_msg_list => fnd_api.g_false ,

1539:
1540: if (l_no_label_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1541:
1542: GenerateSQL(p_api_version => 1.0,
1543: p_init_msg_list => fnd_api.g_false ,
1544: p_validation_level => fnd_api.g_valid_level_full ,
1545: x_return_status => x_return_status,
1546: x_msg_count => x_msg_count,
1547: x_msg_data => x_msg_data,

Line 1544: p_validation_level => fnd_api.g_valid_level_full ,

1540: if (l_no_label_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1541:
1542: GenerateSQL(p_api_version => 1.0,
1543: p_init_msg_list => fnd_api.g_false ,
1544: p_validation_level => fnd_api.g_valid_level_full ,
1545: x_return_status => x_return_status,
1546: x_msg_count => x_msg_count,
1547: x_msg_data => x_msg_data,
1548: p_type_code => p_label_code,

Line 1584: p_init_msg_list => fnd_api.g_false ,

1580:
1581: if (l_no_cg_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1582:
1583: GenerateSQL(p_api_version => 1.0,
1584: p_init_msg_list => fnd_api.g_false ,
1585: p_validation_level => fnd_api.g_valid_level_full ,
1586: x_return_status => x_return_status,
1587: x_msg_count => x_msg_count,
1588: x_msg_data => x_msg_data,

Line 1585: p_validation_level => fnd_api.g_valid_level_full ,

1581: if (l_no_cg_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1582:
1583: GenerateSQL(p_api_version => 1.0,
1584: p_init_msg_list => fnd_api.g_false ,
1585: p_validation_level => fnd_api.g_valid_level_full ,
1586: x_return_status => x_return_status,
1587: x_msg_count => x_msg_count,
1588: x_msg_data => x_msg_data,
1589: p_type_code => p_CG_code,

Line 1623: p_init_msg_list => fnd_api.g_false ,

1619:
1620: if (l_no_op_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1621:
1622: GenerateSQL(p_api_version => 1.0,
1623: p_init_msg_list => fnd_api.g_false ,
1624: p_validation_level => fnd_api.g_valid_level_full ,
1625: x_return_status => x_return_status,
1626: x_msg_count => x_msg_count,
1627: x_msg_data => x_msg_data,

Line 1624: p_validation_level => fnd_api.g_valid_level_full ,

1620: if (l_no_op_rules > 0 and p_pkg_type = 'B' ) or (p_pkg_type = 'S' ) then
1621:
1622: GenerateSQL(p_api_version => 1.0,
1623: p_init_msg_list => fnd_api.g_false ,
1624: p_validation_level => fnd_api.g_valid_level_full ,
1625: x_return_status => x_return_status,
1626: x_msg_count => x_msg_count,
1627: x_msg_data => x_msg_data,
1628: p_type_code => p_OP_code,

Line 1648: WHEN FND_API.G_EXC_ERROR THEN

1644:
1645:
1646: EXCEPTION
1647:
1648: WHEN FND_API.G_EXC_ERROR THEN
1649: x_return_status := FND_API.G_RET_STS_ERROR;
1650: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
1651:
1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1649: x_return_status := FND_API.G_RET_STS_ERROR;

1645:
1646: EXCEPTION
1647:
1648: WHEN FND_API.G_EXC_ERROR THEN
1649: x_return_status := FND_API.G_RET_STS_ERROR;
1650: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
1651:
1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1648: WHEN FND_API.G_EXC_ERROR THEN
1649: x_return_status := FND_API.G_RET_STS_ERROR;
1650: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
1651:
1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
1655: END GenerateRuleExecPkgs;
1656: ----------------

Line 1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1649: x_return_status := FND_API.G_RET_STS_ERROR;
1650: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
1651:
1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1654: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data );
1655: END GenerateRuleExecPkgs;
1656: ----------------
1657: FUNCTION get_count_with_lock(P_RULE_TYPE IN VARCHAR2 )