2352: PROCEDURE Complete_RetOrder_Validate
2353: ( P_order_header_id IN NUMBER,
2354: p_user_type IN VARCHAR2,
2355: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2356: X_failed_line_ids OUT NOCOPY JTF_VARCHAR2_TABLE_300,
2357: X_return_status OUT NOCOPY VARCHAR2,
2358: X_msg_count OUT NOCOPY NUMBER,
2359: X_msg_data OUT NOCOPY VARCHAR2
2360: )
2383: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2384: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:Complete_RetLine_Validation()');
2385: END IF;
2386:
2387: X_failed_line_ids := JTF_VARCHAR2_TABLE_300();
2388:
2389: -- Initialize API return status to success
2390: x_return_status := FND_API.G_RET_STS_SUCCESS;
2391:
2707: ,x_order_header_id OUT NOCOPY NUMBER
2708: ,x_order_number OUT NOCOPY NUMBER
2709: ,x_flow_status_code OUT NOCOPY VARCHAR2
2710: ,x_last_update_date OUT NOCOPY DATE
2711: ,X_failed_line_ids OUT NOCOPY JTF_VARCHAR2_TABLE_300
2712: )
2713: IS
2714:
2715: cursor c_holdid is
2785: l_parseNum NUMBER :=5;
2786: l_parseKey varchar2(40) :='ORDER_SAVE_LINE_IDS';
2787:
2788: /****TEMP***/
2789: --X_failed_line_ids JTF_VARCHAR2_TABLE_300;
2790: /******/
2791: BEGIN
2792:
2793: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3468: ,p_party_id IN NUMBER
3469: ,x_return_status OUT NOCOPY VARCHAR2
3470: ,x_msg_count OUT NOCOPY NUMBER
3471: ,x_msg_data OUT NOCOPY VARCHAR2
3472: ,x_error_lineids OUT NOCOPY JTF_VARCHAR2_TABLE_300
3473: ,x_last_update_date OUT NOCOPY DATE
3474: )
3475: IS
3476:
3549:
3550:
3551: BEGIN
3552:
3553: x_error_lineids := JTF_VARCHAR2_TABLE_300();
3554:
3555: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
3556: IBE_Util.Debug('Begin IBE_ORDER_SAVE_PVT:CheckConstraints()');
3557: END IF;
3805: , x_Lot_Serial_val_tbl => l_lot_serial_val_tbl
3806: , x_action_request_tbl => l_action_request_tbl
3807: );
3808:
3809: x_error_lineids := JTF_VARCHAR2_TABLE_300();
3810:
3811: for j in 1..lx_line_tbl.count
3812: loop
3813: l_line_id := lx_line_tbl(j).line_id;