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

Line 152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

148: EXCEPTION
149: WHEN OTHERS THEN
150: PrintLn('When Others in GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
151: log_msg('GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
153: END insert_hdr_rec;
154:
155: -- Bug # 4260445 Added this procedure to populate data into gmd_coa_spec_hdr_text
156:

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

189: EXCEPTION
190: WHEN OTHERS THEN
191: PrintLn('GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
192: log_msg('GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
194:
195: END populate_hdr_text; -- Bug # 4260445
196:
197:

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

248: EXCEPTION
249: WHEN OTHERS THEN
250: PrintLn('GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
251: log_msg('GMD_COA_DATA.INSERT_HDR_REC '|| SUBSTR(SQLERRM,1,100));
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
253: END populate_text;
254:
255:
256:

Line 306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

302: EXCEPTION
303: WHEN OTHERS THEN
304: PrintLn('GMD_COA_DATA.INSERT_DTL_REC '|| SUBSTR(SQLERRM,1,100));
305: log_msg('GMD_COA_DATA.INSERT_DTL_REC '|| SUBSTR(SQLERRM,1,100));
306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
307:
308: END insert_dtl_rec;
309:
310: PROCEDURE populate_result(p_detail_rec IN OUT NOCOPY t_coa_dtl_rec,

Line 378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

374: EXCEPTION
375: WHEN OTHERS THEN
376: PrintLn('GMD_COA_DATA.POPULATE_RESULT '|| SUBSTR(SQLERRM,1,100));
377: log_msg('GMD_COA_DATA.POPULATE_RESULT '|| SUBSTR(SQLERRM,1,100));
378: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
379: END populate_result;
380:
381: PROCEDURE populate_composite_results(p_detail_rec IN OUT NOCOPY t_coa_dtl_rec ,
382: p_event_spec_disp_id IN NUMBER,

Line 441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

437: EXCEPTION
438: WHEN OTHERS THEN
439: PrintLn('GMD_COA_DATA.POPULATE_COMPOSITE_RESULTS '|| SUBSTR(SQLERRM,1,100));
440: log_msg('GMD_COA_DATA.POPULATE_COMPOSITE_RESULTS '|| SUBSTR(SQLERRM,1,100));
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
442: END populate_composite_results;
443:
444: PROCEDURE populate_spec(p_spec_id IN NUMBER,
445: p_cust_id IN NUMBER,

Line 603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

599: EXCEPTION
600: WHEN OTHERS THEN
601: PrintLn('GMD_COA_DATA.POPULATE_SPEC '|| SUBSTR(SQLERRM,1,100));
602: log_msg('GMD_COA_DATA.POPULATE_SPEC '|| SUBSTR(SQLERRM,1,100));
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
604: END populate_spec;
605:
606:
607:

Line 687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

683: EXCEPTION
684: WHEN OTHERS THEN
685: PrintLn('GMD_COA_DATA.GET_FOREIGN_KEYS '|| SUBSTR(SQLERRM,1,100));
686: log_msg('GMD_COA_DATA.GET_FOREIGN_KEYS '|| SUBSTR(SQLERRM,1,100));
687: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
688:
689: END get_foreign_keys;
690:
691:

Line 722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

718: EXCEPTION
719: WHEN OTHERS THEN
720: PrintLn('GMD_COA_DATA.GETPRECISION '|| SUBSTR(SQLERRM,1,100));
721: log_msg('GMD_COA_DATA.GETPRECISION '|| SUBSTR(SQLERRM,1,100));
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
723: END getprecision;
724:
725:
726: PROCEDURE log_msg(p_msg_text IN VARCHAR2) IS

Line 760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

756: EXCEPTION
757: WHEN OTHERS THEN
758: PrintLn('GMD_COA_DATA.PUT_SPEC_IN_LOG '|| SUBSTR(SQLERRM,1,100));
759: log_msg('GMD_COA_DATA.PUT_SPEC_IN_LOG '|| SUBSTR(SQLERRM,1,100));
760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
761: END put_spec_in_log;
762:
763: PROCEDURE getLatestSample(p_spec_id IN NUMBER,
764: p_lot_number IN VARCHAR2,

Line 954: x_return_status := FND_API.G_RET_STS_SUCCESS;

950: l_in_spec VARCHAR2(1); -- returned by the results API
951: BEGIN
952: PrintLn('Begin Procedure get_result_match_for_spec');
953: PrintLn('p_spec_id = '||p_spec_id);
954: x_return_status := FND_API.G_RET_STS_SUCCESS;
955: --FND_MSG_PUB.initialize;
956:
957: l_position := '010';
958: PrintLn('l_position = '||l_position);

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

1128: EXCEPTION
1129: WHEN REQ_FIELDS_MISSING THEN
1130: PrintLn('GMD_REQ_FIELD_MIS , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1131: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1132: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1133: x_return_status := FND_API.G_RET_STS_ERROR ;
1134: WHEN INVALID_LOT THEN
1135: PrintLn('GMD_INVALID_LOT , LOT_NUMBER = '||p_lots(l_lot_counter).lot_number);
1136: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));

Line 1133: x_return_status := FND_API.G_RET_STS_ERROR ;

1129: WHEN REQ_FIELDS_MISSING THEN
1130: PrintLn('GMD_REQ_FIELD_MIS , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1131: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC');
1132: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1133: x_return_status := FND_API.G_RET_STS_ERROR ;
1134: WHEN INVALID_LOT THEN
1135: PrintLn('GMD_INVALID_LOT , LOT_NUMBER = '||p_lots(l_lot_counter).lot_number);
1136: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));
1137: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

1133: x_return_status := FND_API.G_RET_STS_ERROR ;
1134: WHEN INVALID_LOT THEN
1135: PrintLn('GMD_INVALID_LOT , LOT_NUMBER = '||p_lots(l_lot_counter).lot_number);
1136: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));
1137: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1138: x_return_status := FND_API.G_RET_STS_ERROR ;
1139: WHEN OTHERS THEN
1140: PrintLn('GMD_API_ERROR , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC , ERROR '||SUBSTR(SQLERRM,1,100)||' l_position = '||l_position);
1141: 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 1138: x_return_status := FND_API.G_RET_STS_ERROR ;

1134: WHEN INVALID_LOT THEN
1135: PrintLn('GMD_INVALID_LOT , LOT_NUMBER = '||p_lots(l_lot_counter).lot_number);
1136: gmd_api_pub.log_message('GMD_INVALID_LOT','LOT',to_char(p_lots(l_lot_counter).lot_number));
1137: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1138: x_return_status := FND_API.G_RET_STS_ERROR ;
1139: WHEN OTHERS THEN
1140: PrintLn('GMD_API_ERROR , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC , ERROR '||SUBSTR(SQLERRM,1,100)||' l_position = '||l_position);
1141: 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);
1142: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

1138: x_return_status := FND_API.G_RET_STS_ERROR ;
1139: WHEN OTHERS THEN
1140: PrintLn('GMD_API_ERROR , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC , ERROR '||SUBSTR(SQLERRM,1,100)||' l_position = '||l_position);
1141: 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);
1142: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1144: END get_result_match_for_spec ;
1145:
1146:

Line 1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1139: WHEN OTHERS THEN
1140: PrintLn('GMD_API_ERROR , PACKAGE , GMD_SPEC_MATCH_GRP.GET_RESULT_MATCH_FOR_SPEC , ERROR '||SUBSTR(SQLERRM,1,100)||' l_position = '||l_position);
1141: 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);
1142: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1144: END get_result_match_for_spec ;
1145:
1146:
1147:

Line 1434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1430: EXCEPTION
1431: WHEN OTHERS THEN
1432: PrintLn('GMD_COA_DATA.CALL_SPEC_MATCH '|| SUBSTR(SQLERRM,1,100));
1433: log_msg('GMD_COA_DATA.CALL_SPEC_MATCH '|| SUBSTR(SQLERRM,1,100));
1434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1435: END call_spec_match;
1436:
1437: PROCEDURE get_order_params ( p_param_rec t_coa_parameters,
1438: x_return_status OUT NOCOPY VARCHAR2) IS

Line 1842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1838:
1839: WHEN OTHERS THEN
1840: PrintLn('GMD_COA_DATA.GET_ORDER_PARAMS '|| SUBSTR(SQLERRM,1,100));
1841: log_msg('GMD_COA_DATA.GET_ORDER_PARAMS '|| SUBSTR(SQLERRM,1,100));
1842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1843:
1844: END get_order_params;
1845:
1846: PROCEDURE populate_coa_data(

Line 1848: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1844: END get_order_params;
1845:
1846: PROCEDURE populate_coa_data(
1847: p_api_version IN NUMBER
1848: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1849: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1850: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
1851: , x_return_status OUT NOCOPY VARCHAR2
1852: , x_msg_count OUT NOCOPY NUMBER

Line 1849: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

1845:
1846: PROCEDURE populate_coa_data(
1847: p_api_version IN NUMBER
1848: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1849: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1850: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
1851: , x_return_status OUT NOCOPY VARCHAR2
1852: , x_msg_count OUT NOCOPY NUMBER
1853: , x_msg_data OUT NOCOPY VARCHAR2

Line 1850: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL

1846: PROCEDURE populate_coa_data(
1847: p_api_version IN NUMBER
1848: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
1849: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
1850: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
1851: , x_return_status OUT NOCOPY VARCHAR2
1852: , x_msg_count OUT NOCOPY NUMBER
1853: , x_msg_data OUT NOCOPY VARCHAR2
1854: , param_rec IN t_coa_parameters) IS

Line 1884: IF FND_API.to_boolean(p_init_msg_list) THEN

1880: PrintLn('param_rec.sampling_event_id = '||param_rec.sampling_event_id);
1881: PrintLn('param_rec.spec_id = '||param_rec.spec_id);
1882: PrintLn('param_rec.ship_to_site_id = '||param_rec.ship_to_site_id); -- Bug# 5399406
1883:
1884: IF FND_API.to_boolean(p_init_msg_list) THEN
1885: FND_MSG_PUB.Initialize;
1886: END IF;
1887:
1888: -- Standard call to check for call compatibility.

Line 1889: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1885: FND_MSG_PUB.Initialize;
1886: END IF;
1887:
1888: -- Standard call to check for call compatibility.
1889: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1890: p_api_version ,
1891: l_api_name ,
1892: G_PKG_NAME ) THEN
1893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1889: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1890: p_api_version ,
1891: l_api_name ,
1892: G_PKG_NAME ) THEN
1893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1894: END IF;
1895:
1896: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1897:

Line 1896: x_return_status :=FND_API.G_RET_STS_SUCCESS;

1892: G_PKG_NAME ) THEN
1893: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1894: END IF;
1895:
1896: x_return_status :=FND_API.G_RET_STS_SUCCESS;
1897:
1898: IF (param_rec.delivery_id IS NOT NULL or param_rec.order_id IS NOT NULL) THEN
1899: PrintLn('Calling Procedure get_order_params');
1900: get_order_params(param_rec,

Line 1932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1928: PrintLn('End Procedure populate_coa_data');
1929: EXCEPTION
1930:
1931: WHEN OTHERS THEN
1932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1933: PrintLn('GMD_COA_DATA.POPULATE_COA_DATA '|| SUBSTR(SQLERRM,1,100));
1934: log_msg('GMD_COA_DATA.POPULATE_COA_DATA '|| SUBSTR(SQLERRM,1,100));
1935: FND_MSG_PUB.Count_AND_GET
1936: (p_count => x_msg_count, p_data => x_msg_data);