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 500: dbms_output.put_line ('Batch is not in WIP/Cert/Close Status');

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

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

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

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

914: batch_id = p_batch_id AND
915: nvl(ing_material_detail_id, -1) = nvl(i.ing_material_detail_id,-1) AND
916: nvl(batchstep_resource_id, -1) = nvl(i.batchstep_resource_id,-1) AND
917: delete_mark = 0;
918: dbms_output.put_line( sql%rowcount || ' rows inserted');
919: EXCEPTION
920: WHEN OTHERS THEN
921: dbms_output.put_line ('Error updating batch requirements');
922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

917: delete_mark = 0;
918: dbms_output.put_line( sql%rowcount || ' rows inserted');
919: EXCEPTION
920: WHEN OTHERS THEN
921: dbms_output.put_line ('Error updating batch requirements');
922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
923: RAISE;
924: END;
925: END LOOP;

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

1138:
1139: IF l_count > 0 THEN
1140: x_return_status := FND_API.G_RET_STS_ERROR ;
1141: x_msg_data := 'VIB Details already exist';
1142: dbms_output.put_line ('VIB Details already exist');
1143: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_VIB_EXIST');
1144: FND_MSG_PUB.Add;
1145: RETURN;
1146: END IF;

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

1923: WHERE batch_id = p_batch_id;
1924:
1925: IF l_batch_status <> 4 THEN
1926: x_return_status := FND_API.G_RET_STS_ERROR ;
1927: --dbms_output.put_line ('Batch is not in CLOSE Status');
1928: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_NOT_CLOSE');
1929: FND_MSG_PUB.Add;
1930: RETURN;
1931: END IF;

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

1949: v.finalize_ind = 1;
1950:
1951: IF l_count > 0 THEN
1952: x_return_status := FND_API.G_RET_STS_ERROR ;
1953: --dbms_output.put_line ('VIB details already exist for this batch');
1954: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_FINAL_VIB_EXIST');
1955: FND_MSG_PUB.Add;
1956: RETURN;
1957: END IF;

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

2562: WHERE batch_id = p_batch_id;
2563:
2564: IF l_batch_status = 4 THEN
2565: x_return_status := FND_API.G_RET_STS_ERROR ;
2566: --dbms_output.put_line ('Cannot revert finalization of a closed batch ');
2567: FND_MESSAGE.SET_NAME('GMF', 'GMF_BATCH_CLOSED');
2568: FND_MSG_PUB.Add;
2569: RETURN;
2570: END IF;

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

2742: FROM mtl_material_transactions pnd
2743: WHERE transaction_id = l_layer_rec.trans_id
2744: ;
2745:
2746: dbms_output.put_line('processing layer_id: ' || l_layer_rec.layer_id);
2747:
2748:
2749: -- Now generate the VIB details for this product transaction.
2750: GMF_VIB.Create_VIB_Details (