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

Line 7: g_true CONSTANT VARCHAR2(1) := fnd_api.g_true;

3: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_KanbanCard_PKG';
4:
5: TYPE supply_status_change_tbl_type IS TABLE OF VARCHAR2(1);
6:
7: g_true CONSTANT VARCHAR2(1) := fnd_api.g_true;
8: g_false CONSTANT VARCHAR2(1) := fnd_api.g_false;
9: g_supply_status_rows CONSTANT NUMBER := 7;
10: g_supply_status_columns CONSTANT NUMBER := 7;
11: g_supply_status_change_tbl supply_status_change_tbl_type

Line 8: g_false CONSTANT VARCHAR2(1) := fnd_api.g_false;

4:
5: TYPE supply_status_change_tbl_type IS TABLE OF VARCHAR2(1);
6:
7: g_true CONSTANT VARCHAR2(1) := fnd_api.g_true;
8: g_false CONSTANT VARCHAR2(1) := fnd_api.g_false;
9: g_supply_status_rows CONSTANT NUMBER := 7;
10: g_supply_status_columns CONSTANT NUMBER := 7;
11: g_supply_status_change_tbl supply_status_change_tbl_type
12: := supply_status_change_tbl_type(

Line 200: RAISE fnd_api.g_exc_unexpected_error;

196: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
197: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Query_Row');
198: END IF;
199:
200: RAISE fnd_api.g_exc_unexpected_error;
201: END query_row;
202:
203: FUNCTION cell(row_in NUMBER, col_in NUMBER)
204: RETURN NUMBER IS

Line 226: l_result := fnd_api.to_boolean(g_supply_status_change_tbl(cell(p_to_supply_status, p_from_supply_status)));

222: FND_MESSAGE.SET_NAME('INV','INV_NO_ACT_ALLOW_HOLD_CARD');
223: Return False;
224: Else
225: */
226: l_result := fnd_api.to_boolean(g_supply_status_change_tbl(cell(p_to_supply_status, p_from_supply_status)));
227:
228: IF l_result THEN
229: RETURN(l_result);
230: END IF;

Line 486: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

482: ) IS
483: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
484: l_kanban_card_number_ok BOOLEAN := FALSE;
485: l_dummy VARCHAR2(1);
486: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
487: l_current_replnsh_cycle_id NUMBER;
488: l_card_status NUMBER;
489: l_supply_status NUMBER;
490: BEGIN

Line 736: IF l_return_status = fnd_api.g_ret_sts_error THEN

732: ELSE
733: insert_activity_for_card(l_kanban_card_rec);
734: END IF;
735:
736: IF l_return_status = fnd_api.g_ret_sts_error THEN
737: RAISE fnd_api.g_exc_error;
738: END IF;
739:
740: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 737: RAISE fnd_api.g_exc_error;

733: insert_activity_for_card(l_kanban_card_rec);
734: END IF;
735:
736: IF l_return_status = fnd_api.g_ret_sts_error THEN
737: RAISE fnd_api.g_exc_error;
738: END IF;
739:
740: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
741: RAISE fnd_api.g_exc_unexpected_error;

Line 740: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

736: IF l_return_status = fnd_api.g_ret_sts_error THEN
737: RAISE fnd_api.g_exc_error;
738: END IF;
739:
740: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
741: RAISE fnd_api.g_exc_unexpected_error;
742: END IF;
743:
744: x_return_status := l_return_status;

Line 741: RAISE fnd_api.g_exc_unexpected_error;

737: RAISE fnd_api.g_exc_error;
738: END IF;
739:
740: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
741: RAISE fnd_api.g_exc_unexpected_error;
742: END IF;
743:
744: x_return_status := l_return_status;
745: p_kanban_card_number := l_kanban_card_rec.kanban_card_number;

Line 751: WHEN fnd_api.g_exc_error THEN

747: p_supply_status := l_kanban_card_rec.supply_status;
748: p_card_status := l_kanban_card_rec.card_status;
749: p_current_replnsh_cycle_id := l_kanban_card_rec.current_replnsh_cycle_id;
750: EXCEPTION
751: WHEN fnd_api.g_exc_error THEN
752: x_return_status := fnd_api.g_ret_sts_error;
753: WHEN fnd_api.g_exc_unexpected_error THEN
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755: WHEN OTHERS THEN

Line 752: x_return_status := fnd_api.g_ret_sts_error;

748: p_card_status := l_kanban_card_rec.card_status;
749: p_current_replnsh_cycle_id := l_kanban_card_rec.current_replnsh_cycle_id;
750: EXCEPTION
751: WHEN fnd_api.g_exc_error THEN
752: x_return_status := fnd_api.g_ret_sts_error;
753: WHEN fnd_api.g_exc_unexpected_error THEN
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755: WHEN OTHERS THEN
756: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 753: WHEN fnd_api.g_exc_unexpected_error THEN

749: p_current_replnsh_cycle_id := l_kanban_card_rec.current_replnsh_cycle_id;
750: EXCEPTION
751: WHEN fnd_api.g_exc_error THEN
752: x_return_status := fnd_api.g_ret_sts_error;
753: WHEN fnd_api.g_exc_unexpected_error THEN
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755: WHEN OTHERS THEN
756: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
757: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');

Line 754: x_return_status := fnd_api.g_ret_sts_unexp_error;

750: EXCEPTION
751: WHEN fnd_api.g_exc_error THEN
752: x_return_status := fnd_api.g_ret_sts_error;
753: WHEN fnd_api.g_exc_unexpected_error THEN
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755: WHEN OTHERS THEN
756: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
757: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');
758: END IF;

Line 760: x_return_status := fnd_api.g_ret_sts_unexp_error;

756: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
757: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Row');
758: END IF;
759:
760: x_return_status := fnd_api.g_ret_sts_unexp_error;
761: END insert_row;
762:
763: PROCEDURE lock_row(
764: p_kanban_card_id NUMBER

Line 988: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

984: ) IS
985: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
986: l_old_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
987: l_current_replenish_cycle_id NUMBER;
988: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
989: l_supply_status NUMBER;
990: BEGIN
991: fnd_msg_pub.initialize;
992: mydebug('Inside update_row 2');

Line 1074: IF l_return_status = fnd_api.g_ret_sts_error THEN

1070: , x_current_replenish_cycle_id => l_current_replenish_cycle_id
1071: , p_kanban_card_rec => l_kanban_card_rec
1072: );
1073:
1074: IF l_return_status = fnd_api.g_ret_sts_error THEN
1075: RAISE fnd_api.g_exc_error;
1076: END IF;
1077:
1078: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1075: RAISE fnd_api.g_exc_error;

1071: , p_kanban_card_rec => l_kanban_card_rec
1072: );
1073:
1074: IF l_return_status = fnd_api.g_ret_sts_error THEN
1075: RAISE fnd_api.g_exc_error;
1076: END IF;
1077:
1078: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1079: RAISE fnd_api.g_exc_unexpected_error;

Line 1078: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1074: IF l_return_status = fnd_api.g_ret_sts_error THEN
1075: RAISE fnd_api.g_exc_error;
1076: END IF;
1077:
1078: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1079: RAISE fnd_api.g_exc_unexpected_error;
1080: END IF;
1081:
1082: l_kanban_card_rec.supply_status := l_supply_status;

Line 1079: RAISE fnd_api.g_exc_unexpected_error;

1075: RAISE fnd_api.g_exc_error;
1076: END IF;
1077:
1078: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1079: RAISE fnd_api.g_exc_unexpected_error;
1080: END IF;
1081:
1082: l_kanban_card_rec.supply_status := l_supply_status;
1083: l_kanban_card_rec.current_replnsh_cycle_id := l_current_replenish_cycle_id;

Line 1178: WHEN fnd_api.g_exc_error THEN

1174: p_supply_status := l_kanban_card_rec.supply_status;
1175: p_card_status := l_kanban_card_rec.card_status;
1176: p_current_replnsh_cycle_id := l_kanban_card_rec.current_replnsh_cycle_id;
1177: EXCEPTION
1178: WHEN fnd_api.g_exc_error THEN
1179: x_return_status := fnd_api.g_ret_sts_error;
1180: WHEN fnd_api.g_exc_unexpected_error THEN
1181: x_return_status := fnd_api.g_ret_sts_unexp_error;
1182: WHEN OTHERS THEN

Line 1179: x_return_status := fnd_api.g_ret_sts_error;

1175: p_card_status := l_kanban_card_rec.card_status;
1176: p_current_replnsh_cycle_id := l_kanban_card_rec.current_replnsh_cycle_id;
1177: EXCEPTION
1178: WHEN fnd_api.g_exc_error THEN
1179: x_return_status := fnd_api.g_ret_sts_error;
1180: WHEN fnd_api.g_exc_unexpected_error THEN
1181: x_return_status := fnd_api.g_ret_sts_unexp_error;
1182: WHEN OTHERS THEN
1183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1180: WHEN fnd_api.g_exc_unexpected_error THEN

1176: p_current_replnsh_cycle_id := l_kanban_card_rec.current_replnsh_cycle_id;
1177: EXCEPTION
1178: WHEN fnd_api.g_exc_error THEN
1179: x_return_status := fnd_api.g_ret_sts_error;
1180: WHEN fnd_api.g_exc_unexpected_error THEN
1181: x_return_status := fnd_api.g_ret_sts_unexp_error;
1182: WHEN OTHERS THEN
1183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1184: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update_row');

Line 1181: x_return_status := fnd_api.g_ret_sts_unexp_error;

1177: EXCEPTION
1178: WHEN fnd_api.g_exc_error THEN
1179: x_return_status := fnd_api.g_ret_sts_error;
1180: WHEN fnd_api.g_exc_unexpected_error THEN
1181: x_return_status := fnd_api.g_ret_sts_unexp_error;
1182: WHEN OTHERS THEN
1183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1184: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update_row');
1185: END IF;

Line 1187: x_return_status := fnd_api.g_ret_sts_unexp_error;

1183: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1184: fnd_msg_pub.add_exc_msg(g_pkg_name, 'update_row');
1185: END IF;
1186:
1187: x_return_status := fnd_api.g_ret_sts_unexp_error;
1188: END update_row;
1189:
1190: PROCEDURE update_row(p_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type) IS
1191: l_return_status VARCHAR2(1);

Line 1259: IF l_return_status = fnd_api.g_ret_sts_error THEN

1255: , p_need_by_date => p_kanban_card_rec.need_by_date
1256: , p_source_wip_entity_id => p_kanban_card_rec.source_wip_entity_id
1257: );
1258:
1259: IF l_return_status = fnd_api.g_ret_sts_error THEN
1260: RAISE fnd_api.g_exc_error;
1261: END IF;
1262:
1263: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1260: RAISE fnd_api.g_exc_error;

1256: , p_source_wip_entity_id => p_kanban_card_rec.source_wip_entity_id
1257: );
1258:
1259: IF l_return_status = fnd_api.g_ret_sts_error THEN
1260: RAISE fnd_api.g_exc_error;
1261: END IF;
1262:
1263: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1264: RAISE fnd_api.g_exc_unexpected_error;

Line 1263: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1259: IF l_return_status = fnd_api.g_ret_sts_error THEN
1260: RAISE fnd_api.g_exc_error;
1261: END IF;
1262:
1263: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1264: RAISE fnd_api.g_exc_unexpected_error;
1265: END IF;
1266: EXCEPTION
1267: WHEN fnd_api.g_exc_error THEN

Line 1264: RAISE fnd_api.g_exc_unexpected_error;

1260: RAISE fnd_api.g_exc_error;
1261: END IF;
1262:
1263: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1264: RAISE fnd_api.g_exc_unexpected_error;
1265: END IF;
1266: EXCEPTION
1267: WHEN fnd_api.g_exc_error THEN
1268: RAISE fnd_api.g_exc_error;

Line 1267: WHEN fnd_api.g_exc_error THEN

1263: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1264: RAISE fnd_api.g_exc_unexpected_error;
1265: END IF;
1266: EXCEPTION
1267: WHEN fnd_api.g_exc_error THEN
1268: RAISE fnd_api.g_exc_error;
1269: WHEN fnd_api.g_exc_unexpected_error THEN
1270: RAISE fnd_api.g_exc_unexpected_error;
1271: WHEN OTHERS THEN

Line 1268: RAISE fnd_api.g_exc_error;

1264: RAISE fnd_api.g_exc_unexpected_error;
1265: END IF;
1266: EXCEPTION
1267: WHEN fnd_api.g_exc_error THEN
1268: RAISE fnd_api.g_exc_error;
1269: WHEN fnd_api.g_exc_unexpected_error THEN
1270: RAISE fnd_api.g_exc_unexpected_error;
1271: WHEN OTHERS THEN
1272: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1269: WHEN fnd_api.g_exc_unexpected_error THEN

1265: END IF;
1266: EXCEPTION
1267: WHEN fnd_api.g_exc_error THEN
1268: RAISE fnd_api.g_exc_error;
1269: WHEN fnd_api.g_exc_unexpected_error THEN
1270: RAISE fnd_api.g_exc_unexpected_error;
1271: WHEN OTHERS THEN
1272: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1273: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');

Line 1270: RAISE fnd_api.g_exc_unexpected_error;

1266: EXCEPTION
1267: WHEN fnd_api.g_exc_error THEN
1268: RAISE fnd_api.g_exc_error;
1269: WHEN fnd_api.g_exc_unexpected_error THEN
1270: RAISE fnd_api.g_exc_unexpected_error;
1271: WHEN OTHERS THEN
1272: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1273: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');
1274: END IF;

Line 1276: RAISE fnd_api.g_exc_unexpected_error;

1272: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1273: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Row');
1274: END IF;
1275:
1276: RAISE fnd_api.g_exc_unexpected_error;
1277: END update_row;
1278:
1279: PROCEDURE update_card_status(p_kanban_card_rec IN OUT NOCOPY inv_kanban_pvt.kanban_card_rec_type, p_card_status IN NUMBER) IS
1280: l_return_status VARCHAR2(1);

Line 1334: IF l_return_status = fnd_api.g_ret_sts_error THEN

1330: , p_attribute14 => p_kanban_card_rec.attribute14
1331: , p_attribute15 => p_kanban_card_rec.attribute15
1332: );
1333:
1334: IF l_return_status = fnd_api.g_ret_sts_error THEN
1335: RAISE fnd_api.g_exc_error;
1336: END IF;
1337:
1338: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1335: RAISE fnd_api.g_exc_error;

1331: , p_attribute15 => p_kanban_card_rec.attribute15
1332: );
1333:
1334: IF l_return_status = fnd_api.g_ret_sts_error THEN
1335: RAISE fnd_api.g_exc_error;
1336: END IF;
1337:
1338: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1339: RAISE fnd_api.g_exc_unexpected_error;

Line 1338: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1334: IF l_return_status = fnd_api.g_ret_sts_error THEN
1335: RAISE fnd_api.g_exc_error;
1336: END IF;
1337:
1338: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1339: RAISE fnd_api.g_exc_unexpected_error;
1340: END IF;
1341: EXCEPTION
1342: WHEN fnd_api.g_exc_error THEN

Line 1339: RAISE fnd_api.g_exc_unexpected_error;

1335: RAISE fnd_api.g_exc_error;
1336: END IF;
1337:
1338: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1339: RAISE fnd_api.g_exc_unexpected_error;
1340: END IF;
1341: EXCEPTION
1342: WHEN fnd_api.g_exc_error THEN
1343: RAISE fnd_api.g_exc_error;

Line 1342: WHEN fnd_api.g_exc_error THEN

1338: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1339: RAISE fnd_api.g_exc_unexpected_error;
1340: END IF;
1341: EXCEPTION
1342: WHEN fnd_api.g_exc_error THEN
1343: RAISE fnd_api.g_exc_error;
1344: WHEN fnd_api.g_exc_unexpected_error THEN
1345: RAISE fnd_api.g_exc_unexpected_error;
1346: WHEN OTHERS THEN

Line 1343: RAISE fnd_api.g_exc_error;

1339: RAISE fnd_api.g_exc_unexpected_error;
1340: END IF;
1341: EXCEPTION
1342: WHEN fnd_api.g_exc_error THEN
1343: RAISE fnd_api.g_exc_error;
1344: WHEN fnd_api.g_exc_unexpected_error THEN
1345: RAISE fnd_api.g_exc_unexpected_error;
1346: WHEN OTHERS THEN
1347: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1344: WHEN fnd_api.g_exc_unexpected_error THEN

1340: END IF;
1341: EXCEPTION
1342: WHEN fnd_api.g_exc_error THEN
1343: RAISE fnd_api.g_exc_error;
1344: WHEN fnd_api.g_exc_unexpected_error THEN
1345: RAISE fnd_api.g_exc_unexpected_error;
1346: WHEN OTHERS THEN
1347: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1348: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Card_Status');

Line 1345: RAISE fnd_api.g_exc_unexpected_error;

1341: EXCEPTION
1342: WHEN fnd_api.g_exc_error THEN
1343: RAISE fnd_api.g_exc_error;
1344: WHEN fnd_api.g_exc_unexpected_error THEN
1345: RAISE fnd_api.g_exc_unexpected_error;
1346: WHEN OTHERS THEN
1347: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1348: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Card_Status');
1349: END IF;

Line 1351: RAISE fnd_api.g_exc_unexpected_error;

1347: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1348: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Update_Card_Status');
1349: END IF;
1350:
1351: RAISE fnd_api.g_exc_unexpected_error;
1352: END update_card_status;
1353:
1354: PROCEDURE delete_row(x_return_status OUT NOCOPY VARCHAR2, p_kanban_card_id NUMBER) IS
1355: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

Line 1355: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

1351: RAISE fnd_api.g_exc_unexpected_error;
1352: END update_card_status;
1353:
1354: PROCEDURE delete_row(x_return_status OUT NOCOPY VARCHAR2, p_kanban_card_id NUMBER) IS
1355: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1356: BEGIN
1357: DELETE FROM mtl_kanban_cards
1358: WHERE kanban_card_id = p_kanban_card_id;
1359:

Line 1367: WHEN fnd_api.g_exc_error THEN

1363:
1364: delete_activity_for_card(p_kanban_card_id);
1365: x_return_status := l_return_status;
1366: EXCEPTION
1367: WHEN fnd_api.g_exc_error THEN
1368: x_return_status := fnd_api.g_ret_sts_error;
1369: WHEN fnd_api.g_exc_unexpected_error THEN
1370: x_return_status := fnd_api.g_ret_sts_unexp_error;
1371: WHEN OTHERS THEN

Line 1368: x_return_status := fnd_api.g_ret_sts_error;

1364: delete_activity_for_card(p_kanban_card_id);
1365: x_return_status := l_return_status;
1366: EXCEPTION
1367: WHEN fnd_api.g_exc_error THEN
1368: x_return_status := fnd_api.g_ret_sts_error;
1369: WHEN fnd_api.g_exc_unexpected_error THEN
1370: x_return_status := fnd_api.g_ret_sts_unexp_error;
1371: WHEN OTHERS THEN
1372: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1369: WHEN fnd_api.g_exc_unexpected_error THEN

1365: x_return_status := l_return_status;
1366: EXCEPTION
1367: WHEN fnd_api.g_exc_error THEN
1368: x_return_status := fnd_api.g_ret_sts_error;
1369: WHEN fnd_api.g_exc_unexpected_error THEN
1370: x_return_status := fnd_api.g_ret_sts_unexp_error;
1371: WHEN OTHERS THEN
1372: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1373: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');

Line 1370: x_return_status := fnd_api.g_ret_sts_unexp_error;

1366: EXCEPTION
1367: WHEN fnd_api.g_exc_error THEN
1368: x_return_status := fnd_api.g_ret_sts_error;
1369: WHEN fnd_api.g_exc_unexpected_error THEN
1370: x_return_status := fnd_api.g_ret_sts_unexp_error;
1371: WHEN OTHERS THEN
1372: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1373: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');
1374: END IF;

Line 1376: x_return_status := fnd_api.g_ret_sts_unexp_error;

1372: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1373: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Row');
1374: END IF;
1375:
1376: x_return_status := fnd_api.g_ret_sts_unexp_error;
1377: END delete_row;
1378:
1379: PROCEDURE insert_activity_for_card(p_kanban_card_rec IN inv_kanban_pvt.kanban_card_rec_type) IS
1380: BEGIN

Line 1487: WHEN fnd_api.g_exc_error THEN

1483: , p_kanban_card_rec.program_update_date
1484: , p_kanban_card_rec.source_wip_entity_id
1485: );
1486: EXCEPTION
1487: WHEN fnd_api.g_exc_error THEN
1488: RAISE fnd_api.g_exc_error;
1489: WHEN OTHERS THEN
1490: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1491: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Activity_For_Card');

Line 1488: RAISE fnd_api.g_exc_error;

1484: , p_kanban_card_rec.source_wip_entity_id
1485: );
1486: EXCEPTION
1487: WHEN fnd_api.g_exc_error THEN
1488: RAISE fnd_api.g_exc_error;
1489: WHEN OTHERS THEN
1490: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1491: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Activity_For_Card');
1492: END IF;

Line 1494: RAISE fnd_api.g_exc_unexpected_error;

1490: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1491: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Insert_Activity_For_Card');
1492: END IF;
1493:
1494: RAISE fnd_api.g_exc_unexpected_error;
1495: END insert_activity_for_card;
1496:
1497: PROCEDURE delete_cards_for_pull_seq(p_pull_sequence_id NUMBER) IS
1498: BEGIN

Line 1504: WHEN fnd_api.g_exc_error THEN

1500:
1501: DELETE FROM mtl_kanban_cards
1502: WHERE pull_sequence_id = p_pull_sequence_id;
1503: EXCEPTION
1504: WHEN fnd_api.g_exc_error THEN
1505: RAISE fnd_api.g_exc_error;
1506: WHEN OTHERS THEN
1507: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1508: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Cards_For_Pull_Seq');

Line 1505: RAISE fnd_api.g_exc_error;

1501: DELETE FROM mtl_kanban_cards
1502: WHERE pull_sequence_id = p_pull_sequence_id;
1503: EXCEPTION
1504: WHEN fnd_api.g_exc_error THEN
1505: RAISE fnd_api.g_exc_error;
1506: WHEN OTHERS THEN
1507: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1508: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Cards_For_Pull_Seq');
1509: END IF;

Line 1511: RAISE fnd_api.g_exc_unexpected_error;

1507: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1508: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Cards_For_Pull_Seq');
1509: END IF;
1510:
1511: RAISE fnd_api.g_exc_unexpected_error;
1512: END delete_cards_for_pull_seq;
1513:
1514: PROCEDURE delete_activity_for_card(p_kanban_card_id NUMBER) IS
1515: BEGIN

Line 1519: WHEN fnd_api.g_exc_error THEN

1515: BEGIN
1516: DELETE FROM mtl_kanban_card_activity
1517: WHERE kanban_card_id = p_kanban_card_id;
1518: EXCEPTION
1519: WHEN fnd_api.g_exc_error THEN
1520: RAISE fnd_api.g_exc_error;
1521: WHEN OTHERS THEN
1522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1523: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Activity_For_Card');

Line 1520: RAISE fnd_api.g_exc_error;

1516: DELETE FROM mtl_kanban_card_activity
1517: WHERE kanban_card_id = p_kanban_card_id;
1518: EXCEPTION
1519: WHEN fnd_api.g_exc_error THEN
1520: RAISE fnd_api.g_exc_error;
1521: WHEN OTHERS THEN
1522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1523: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Activity_For_Card');
1524: END IF;

Line 1526: RAISE fnd_api.g_exc_unexpected_error;

1522: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1523: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Activity_For_Card');
1524: END IF;
1525:
1526: RAISE fnd_api.g_exc_unexpected_error;
1527: END delete_activity_for_card;
1528:
1529: PROCEDURE delete_activity_for_pull_seq(p_pull_sequence_id NUMBER) IS
1530: BEGIN

Line 1537: WHEN fnd_api.g_exc_error THEN

1533: FROM mtl_kanban_cards crd
1534: WHERE crd.kanban_card_id = act.kanban_card_id
1535: AND crd.pull_sequence_id = p_pull_sequence_id);
1536: EXCEPTION
1537: WHEN fnd_api.g_exc_error THEN
1538: RAISE fnd_api.g_exc_error;
1539: WHEN OTHERS THEN
1540: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1541: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Activity_For_Pull_Seq');

Line 1538: RAISE fnd_api.g_exc_error;

1534: WHERE crd.kanban_card_id = act.kanban_card_id
1535: AND crd.pull_sequence_id = p_pull_sequence_id);
1536: EXCEPTION
1537: WHEN fnd_api.g_exc_error THEN
1538: RAISE fnd_api.g_exc_error;
1539: WHEN OTHERS THEN
1540: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1541: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Activity_For_Pull_Seq');
1542: END IF;

Line 1544: RAISE fnd_api.g_exc_unexpected_error;

1540: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1541: fnd_msg_pub.add_exc_msg(g_pkg_name, 'Delete_Activity_For_Pull_Seq');
1542: END IF;
1543:
1544: RAISE fnd_api.g_exc_unexpected_error;
1545: END delete_activity_for_pull_seq;
1546: END inv_kanbancard_pkg;