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.

[Home] [Help]

APPS.GMD_COA_DATA_OM_NEW dependencies on FND_API

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

187: EXCEPTION
188: WHEN OTHERS THEN
189: PrintLn('When Others in GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
190: log_msg('GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
192: END insert_hdr_rec;
193:
194: -- Bug # 4260445 Added this procedure to populate data into gmd_coa_spec_hdr_text
195:

Line 232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

228: EXCEPTION
229: WHEN OTHERS THEN
230: PrintLn('GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
231: log_msg('GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
233:
234: END populate_hdr_text; -- Bug # 4260445
235:
236:

Line 291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

287: EXCEPTION
288: WHEN OTHERS THEN
289: PrintLn('GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
290: log_msg('GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
292: END populate_text;
293:
294:
295:

Line 345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

341: EXCEPTION
342: WHEN OTHERS THEN
343: PrintLn('GMD_COA_DATA.INSERT_DTL_REC '|| SUBSTR(SQLERRM,1,100));
344: log_msg('GMD_COA_DATA.INSERT_DTL_REC '|| SUBSTR(SQLERRM,1,100));
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
346:
347: END insert_dtl_rec;
348:
349: PROCEDURE populate_result(p_detail_rec IN OUT NOCOPY t_coa_dtl_rec,

Line 419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

415: EXCEPTION
416: WHEN OTHERS THEN
417: PrintLn('GMD_COA_DATA.POPULATE_RESULT '|| SUBSTR(SQLERRM,1,100));
418: log_msg('GMD_COA_DATA.POPULATE_RESULT '|| SUBSTR(SQLERRM,1,100));
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
420: END populate_result;
421:
422: PROCEDURE populate_composite_results(p_detail_rec IN OUT NOCOPY t_coa_dtl_rec ,
423: p_event_spec_disp_id IN NUMBER,

Line 484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

480: EXCEPTION
481: WHEN OTHERS THEN
482: PrintLn('GMD_COA_DATA.POPULATE_COMPOSITE_RESULTS '|| SUBSTR(SQLERRM,1,100));
483: log_msg('GMD_COA_DATA.POPULATE_COMPOSITE_RESULTS '|| SUBSTR(SQLERRM,1,100));
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
485: END populate_composite_results;
486:
487: PROCEDURE populate_spec(p_spec_id IN NUMBER,
488: p_cust_id IN NUMBER,

Line 646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

642: EXCEPTION
643: WHEN OTHERS THEN
644: PrintLn('GMD_COA_DATA.POPULATE_SPEC '|| SUBSTR(SQLERRM,1,100));
645: log_msg('GMD_COA_DATA.POPULATE_SPEC '|| SUBSTR(SQLERRM,1,100));
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
647: END populate_spec;
648:
649:
650:

Line 730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

726: EXCEPTION
727: WHEN OTHERS THEN
728: PrintLn('GMD_COA_DATA.GET_FOREIGN_KEYS '|| SUBSTR(SQLERRM,1,100));
729: log_msg('GMD_COA_DATA.GET_FOREIGN_KEYS '|| SUBSTR(SQLERRM,1,100));
730: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
731:
732: END get_foreign_keys;
733:
734:

Line 765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

761: EXCEPTION
762: WHEN OTHERS THEN
763: PrintLn('GMD_COA_DATA.GETPRECISION '|| SUBSTR(SQLERRM,1,100));
764: log_msg('GMD_COA_DATA.GETPRECISION '|| SUBSTR(SQLERRM,1,100));
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
766: END getprecision;
767:
768:
769: PROCEDURE log_msg(p_msg_text IN VARCHAR2) IS

Line 803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

799: EXCEPTION
800: WHEN OTHERS THEN
801: PrintLn('GMD_COA_DATA.PUT_SPEC_IN_LOG '|| SUBSTR(SQLERRM,1,100));
802: log_msg('GMD_COA_DATA.PUT_SPEC_IN_LOG '|| SUBSTR(SQLERRM,1,100));
803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
804: END put_spec_in_log;
805:
806: -- added parent_lot_number to param list 9655426
807: PROCEDURE getLatestSample(p_spec_id IN NUMBER,

Line 1021: x_return_status := FND_API.G_RET_STS_SUCCESS;

1017: l_in_spec VARCHAR2(1); -- returned by the results API
1018: BEGIN
1019: PrintLn('Begin Procedure get_result_match_for_spec');
1020: PrintLn('p_spec_id = '||p_spec_id);
1021: x_return_status := FND_API.G_RET_STS_SUCCESS;
1022: --FND_MSG_PUB.initialize;
1023:
1024: l_position := '010';
1025: PrintLn('l_position = '||l_position);

Line 1203: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

1199: EXCEPTION
1200: WHEN REQ_FIELDS_MISSING THEN
1201: PrintLn('GMD_REQ_FIELD_MIS , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1202: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1203: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1204: x_return_status := FND_API.G_RET_STS_ERROR ;
1205: WHEN INVALID_LOT THEN
1206: PrintLn('GMD_INVALID_LOT , LOT_NUMBER = '||p_lots(l_lot_counter).lot_number);
1207: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));

Line 1204: x_return_status := FND_API.G_RET_STS_ERROR ;

1200: WHEN REQ_FIELDS_MISSING THEN
1201: PrintLn('GMD_REQ_FIELD_MIS , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1202: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1203: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1204: x_return_status := FND_API.G_RET_STS_ERROR ;
1205: WHEN INVALID_LOT THEN
1206: PrintLn('GMD_INVALID_LOT , LOT_NUMBER = '||p_lots(l_lot_counter).lot_number);
1207: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));
1208: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 1208: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

1204: x_return_status := FND_API.G_RET_STS_ERROR ;
1205: WHEN INVALID_LOT THEN
1206: PrintLn('GMD_INVALID_LOT , LOT_NUMBER = '||p_lots(l_lot_counter).lot_number);
1207: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));
1208: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1209: x_return_status := FND_API.G_RET_STS_ERROR ;
1210: WHEN OTHERS THEN
1211: PrintLn('GMD_API_ERROR , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC , ERROR '||SUBSTR(SQLERRM,1,100)||' l_position = '||l_position);
1212: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);

Line 1209: x_return_status := FND_API.G_RET_STS_ERROR ;

1205: WHEN INVALID_LOT THEN
1206: PrintLn('GMD_INVALID_LOT , LOT_NUMBER = '||p_lots(l_lot_counter).lot_number);
1207: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));
1208: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1209: x_return_status := FND_API.G_RET_STS_ERROR ;
1210: WHEN OTHERS THEN
1211: PrintLn('GMD_API_ERROR , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC , ERROR '||SUBSTR(SQLERRM,1,100)||' l_position = '||l_position);
1212: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1213: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

Line 1213: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

1209: x_return_status := FND_API.G_RET_STS_ERROR ;
1210: WHEN OTHERS THEN
1211: PrintLn('GMD_API_ERROR , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC , ERROR '||SUBSTR(SQLERRM,1,100)||' l_position = '||l_position);
1212: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1213: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1215: END get_result_match_for_spec ;
1216:
1217:

Line 1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1210: WHEN OTHERS THEN
1211: PrintLn('GMD_API_ERROR , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC , ERROR '||SUBSTR(SQLERRM,1,100)||' l_position = '||l_position);
1212: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1213: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1215: END get_result_match_for_spec ;
1216:
1217:
1218:

Line 1524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: PrintLn('GMD_COA_DATA.CALL_SPEC_MATCH '|| SUBSTR(SQLERRM,1,100));
1523: log_msg('GMD_COA_DATA.CALL_SPEC_MATCH '|| SUBSTR(SQLERRM,1,100));
1524: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1525: END call_spec_match;
1526:
1527: PROCEDURE get_order_params ( p_param_rec t_coa_parameters,
1528: x_return_status OUT NOCOPY VARCHAR2) IS

Line 2197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2193:
2194: WHEN OTHERS THEN
2195: PrintLn('GMD_COA_DATA.GET_ORDER_PARAMS '|| SUBSTR(SQLERRM,1,100));
2196: log_msg('GMD_COA_DATA.GET_ORDER_PARAMS '|| SUBSTR(SQLERRM,1,100));
2197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2198:
2199: END get_order_params;
2200:
2201: PROCEDURE populate_coa_data(

Line 2203: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

2199: END get_order_params;
2200:
2201: PROCEDURE populate_coa_data(
2202: p_api_version IN NUMBER
2203: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2204: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2205: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
2206: , x_return_status OUT NOCOPY VARCHAR2
2207: , x_msg_count OUT NOCOPY NUMBER

Line 2204: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

2200:
2201: PROCEDURE populate_coa_data(
2202: p_api_version IN NUMBER
2203: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2204: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2205: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
2206: , x_return_status OUT NOCOPY VARCHAR2
2207: , x_msg_count OUT NOCOPY NUMBER
2208: , x_msg_data OUT NOCOPY VARCHAR2

Line 2205: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

2201: PROCEDURE populate_coa_data(
2202: p_api_version IN NUMBER
2203: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
2204: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
2205: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
2206: , x_return_status OUT NOCOPY VARCHAR2
2207: , x_msg_count OUT NOCOPY NUMBER
2208: , x_msg_data OUT NOCOPY VARCHAR2
2209: , param_rec IN t_coa_parameters) IS

Line 2239: IF FND_API.to_boolean(p_init_msg_list) THEN

2235: PrintLn('param_rec.sampling_event_id = '||param_rec.sampling_event_id);
2236: PrintLn('param_rec.spec_id = '||param_rec.spec_id);
2237: PrintLn('param_rec.ship_to_site_id = '||param_rec.ship_to_site_id); -- Bug# 5399406
2238:
2239: IF FND_API.to_boolean(p_init_msg_list) THEN
2240: FND_MSG_PUB.Initialize;
2241: END IF;
2242:
2243: -- Standard call to check for call compatibility.

Line 2244: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

2240: FND_MSG_PUB.Initialize;
2241: END IF;
2242:
2243: -- Standard call to check for call compatibility.
2244: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2245: p_api_version ,
2246: l_api_name ,
2247: G_PKG_NAME ) THEN
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2244: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2245: p_api_version ,
2246: l_api_name ,
2247: G_PKG_NAME ) THEN
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: END IF;
2250:
2251: x_return_status :=FND_API.G_RET_STS_SUCCESS;
2252:

Line 2251: x_return_status :=FND_API.G_RET_STS_SUCCESS;

2247: G_PKG_NAME ) THEN
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: END IF;
2250:
2251: x_return_status :=FND_API.G_RET_STS_SUCCESS;
2252:
2253: IF (param_rec.delivery_id IS NOT NULL or param_rec.order_id IS NOT NULL) THEN
2254: PrintLn('Calling Procedure get_order_params');
2255: get_order_params(param_rec,

Line 2287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2283: PrintLn('End Procedure populate_coa_data');
2284: EXCEPTION
2285:
2286: WHEN OTHERS THEN
2287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2288: PrintLn('GMD_COA_DATA.POPULATE_COA_DATA '|| SUBSTR(SQLERRM,1,100));
2289: log_msg('GMD_COA_DATA.POPULATE_COA_DATA '|| SUBSTR(SQLERRM,1,100));
2290: FND_MSG_PUB.Count_AND_GET
2291: (p_count => x_msg_count, p_data => x_msg_data);