APPS.GMF_VIB dependencies on DBMS_OUTPUT

Line 91: dbms_output.put_line ('Batch requirement already exist for the batch');

87: WHERE batch_id = p_batch_id AND
88: delete_mark = 0;
89:
90: IF l_count > 0 THEN
91: dbms_output.put_line ('Batch requirement already exist for the batch');
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_REQ_EXISTS');
94: FND_MSG_PUB.Add;
95: RETURN;

Line 362: dbms_output.put_line ('Batch is not in PENDING Status');

358: WHERE batch_id = p_batch_id;
359:
360: IF l_batch_status <> 1 THEN
361: x_return_status := FND_API.G_RET_STS_ERROR ;
362: dbms_output.put_line ('Batch is not in PENDING Status');
363: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_NOT_PENDING');
364: FND_MSG_PUB.Add;
365: RETURN;
366: END IF;

Line 502: dbms_output.put_line ('Batch is not in WIP/Cert/Close Status');

498: */
499: /* Bug 9441550 . Added status -1. */
500: IF l_batch_status not in (-1,2, 3, 4) THEN
501: -- x_return_status := FND_API.G_RET_STS_ERROR ;
502: dbms_output.put_line ('Batch is not in WIP/Cert/Close Status');
503: -- FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_NOT_WIP');
504: -- FND_MSG_PUB.Add;
505: x_return_status := FND_API.G_RET_STS_SUCCESS ;
506: RETURN;

Line 529: dbms_output.put_line ('Invalid Batch ID');

525: /* Bug 6125370 - End */
526: EXCEPTION
527: WHEN OTHERS THEN
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
529: dbms_output.put_line ('Invalid Batch ID');
530: FND_MESSAGE.SET_NAME('GMF', 'G_RET_STS_UNEXP_ERROR');
531: FND_MSG_PUB.Add;
532: RAISE;
533: END;

Line 933: dbms_output.put_line( sql%rowcount || ' rows inserted');

929: batch_id = p_batch_id AND
930: nvl(ing_material_detail_id, -1) = nvl(i.ing_material_detail_id,-1) AND
931: nvl(batchstep_resource_id, -1) = nvl(i.batchstep_resource_id,-1) AND
932: delete_mark = 0;
933: dbms_output.put_line( sql%rowcount || ' rows inserted');
934: EXCEPTION
935: WHEN OTHERS THEN
936: dbms_output.put_line ('Error updating batch requirements');
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 936: dbms_output.put_line ('Error updating batch requirements');

932: delete_mark = 0;
933: dbms_output.put_line( sql%rowcount || ' rows inserted');
934: EXCEPTION
935: WHEN OTHERS THEN
936: dbms_output.put_line ('Error updating batch requirements');
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
938: RAISE;
939: END;
940: END LOOP;

Line 1179: dbms_output.put_line ('VIB Details already exist');

1175:
1176: IF l_count > 0 THEN
1177: x_return_status := FND_API.G_RET_STS_ERROR ;
1178: x_msg_data := 'VIB Details already exist';
1179: dbms_output.put_line ('VIB Details already exist');
1180: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_VIB_EXIST');
1181: FND_MSG_PUB.Add;
1182: RETURN;
1183: END IF;

Line 1990: --dbms_output.put_line ('Batch is not in CLOSE Status');

1986: WHERE batch_id = p_batch_id;
1987:
1988: IF l_batch_status <> 4 THEN
1989: x_return_status := FND_API.G_RET_STS_ERROR ;
1990: --dbms_output.put_line ('Batch is not in CLOSE Status');
1991: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_NOT_CLOSE');
1992: FND_MSG_PUB.Add;
1993: RETURN;
1994: END IF;

Line 2016: --dbms_output.put_line ('VIB details already exist for this batch');

2012: v.finalize_ind = 1;
2013:
2014: IF l_count > 0 THEN
2015: x_return_status := FND_API.G_RET_STS_ERROR ;
2016: --dbms_output.put_line ('VIB details already exist for this batch');
2017: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_FINAL_VIB_EXIST');
2018: FND_MSG_PUB.Add;
2019: RETURN;
2020: END IF;

Line 2650: --dbms_output.put_line ('Cannot revert finalization of a closed batch ');

2646: WHERE batch_id = p_batch_id;
2647:
2648: IF l_batch_status = 4 THEN
2649: x_return_status := FND_API.G_RET_STS_ERROR ;
2650: --dbms_output.put_line ('Cannot revert finalization of a closed batch ');
2651: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_CLOSED');
2652: FND_MSG_PUB.Add;
2653: RETURN;
2654: END IF;

Line 2921: dbms_output.put_line('processing layer_id: ' || l_layer_rec.layer_id);

2917: FROM mtl_material_transactions pnd
2918: WHERE transaction_id = l_layer_rec.trans_id
2919: ;
2920:
2921: dbms_output.put_line('processing layer_id: ' || l_layer_rec.layer_id);
2922:
2923:
2924: -- Now generate the VIB details for this product transaction.
2925: GMF_VIB.Create_VIB_Details (