DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on FND_MSG_PUB

Line 1400: FND_MSG_PUB.ADD;

1396:
1397: EXCEPTION
1398: WHEN OTHERS THEN
1399: -- The message is already set, just put it on the stack.
1400: FND_MSG_PUB.ADD;
1401: RAISE FND_API.G_EXC_ERROR;
1402: END;
1403:
1404: IF (l_debug = 'Y') THEN

Line 1604: FND_MSG_PUB.GET(p_msg_index => 1,

1600: --changing the quality status of batch step to 'In Spec'
1601: gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 6, return_status);
1602: -- Bug# 5440347 start
1603: IF (return_status <> 'S') THEN
1604: FND_MSG_PUB.GET(p_msg_index => 1,
1605: p_data => l_data,
1606: p_encoded => FND_API.G_FALSE,
1607: p_msg_index_out => l_dummy_cnt);
1608: x_message_data := substr(x_message_data || l_data,1,2000) ;

Line 1664: FND_MSG_PUB.GET(p_msg_index => 1,

1660: --changing the quality status of batch step to 'Action Required'
1661: gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 5, return_status);
1662: --Bug# 5440347 start
1663: IF (return_status <> 'S') THEN
1664: FND_MSG_PUB.GET(p_msg_index => 1,
1665: p_data => l_data,
1666: p_encoded => FND_API.G_FALSE,
1667: p_msg_index_out => l_dummy_cnt);
1668: x_message_data := substr(x_message_data || l_data,1,2000) ;

Line 1761: FND_MSG_PUB.GET(p_msg_index => 1,

1757: IF (p_to_disposition in ('4A', '5AV')) THEN
1758: --changing the quality status of batch step to 'In Spec'
1759: gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 6, return_status);
1760: IF (return_status <> 'S') THEN
1761: FND_MSG_PUB.GET(p_msg_index => 1,
1762: p_data => l_data,
1763: p_encoded => FND_API.G_FALSE,
1764: p_msg_index_out => l_dummy_cnt);
1765: x_message_data := substr(x_message_data || l_data,1,2000) ;

Line 1814: FND_MSG_PUB.GET(p_msg_index => 1,

1810: ELSIF (p_to_disposition = '6RJ') THEN
1811: --changing the quality status of batch step to 'Action Required'
1812: gme_api_grp.update_step_quality_status(l_step_id, l_batch_organization_id, 5, return_status);
1813: IF (return_status <> 'S') THEN
1814: FND_MSG_PUB.GET(p_msg_index => 1,
1815: p_data => l_data,
1816: p_encoded => FND_API.G_FALSE,
1817: p_msg_index_out => l_dummy_cnt);
1818: x_message_data := substr(x_message_data || l_data,1,2000) ;

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

1946:
1947:
1948: EXCEPTION WHEN REQ_FIELDS_MISSING THEN
1949: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1950: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1951: x_return_status := FND_API.G_RET_STS_ERROR ;
1952: WHEN INVALID_PARAMETER THEN
1953: gmd_api_pub.log_message('GMD_INVALID_PARAM','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1954: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

1950: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1951: x_return_status := FND_API.G_RET_STS_ERROR ;
1952: WHEN INVALID_PARAMETER THEN
1953: gmd_api_pub.log_message('GMD_INVALID_PARAM','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1954: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1955: x_return_status := FND_API.G_RET_STS_ERROR ;
1956: WHEN SAMPLE_SPEC_CHANGED THEN
1957: gmd_api_pub.log_message('GMD_SAMPLE_SPEC_CHANGED','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1958: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

1954: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1955: x_return_status := FND_API.G_RET_STS_ERROR ;
1956: WHEN SAMPLE_SPEC_CHANGED THEN
1957: gmd_api_pub.log_message('GMD_SAMPLE_SPEC_CHANGED','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1958: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1959: x_return_status := FND_API.G_RET_STS_ERROR ;
1960: WHEN SAMPLE_DISP_CHANGED THEN
1961: gmd_api_pub.log_message('GMD_SMPL_DISP_CHANGE','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1962: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

1958: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1959: x_return_status := FND_API.G_RET_STS_ERROR ;
1960: WHEN SAMPLE_DISP_CHANGED THEN
1961: gmd_api_pub.log_message('GMD_SMPL_DISP_CHANGE','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
1962: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1963: x_return_status := FND_API.G_RET_STS_ERROR ;
1964: WHEN OTHERS THEN
1965: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1966: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

1962: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1963: x_return_status := FND_API.G_RET_STS_ERROR ;
1964: WHEN OTHERS THEN
1965: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
1966: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
1967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1968:
1969: END update_sample_comp_disp ;
1970:

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

2072:
2073:
2074: IF SQL%NOTFOUND THEN
2075: gmd_api_pub.log_message('GMD_QM_CHANGE_DISP_ERR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_CHANGE_DISP_TABLE');
2076: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2077: x_return_status := FND_API.G_RET_STS_ERROR ;
2078: END IF; -- SQL%NOTFOUND THEN
2079:
2080:

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

2145: END IF; -- (p_update_change_disp_rec.LOT_NUMBER IS NOT NULL)
2146:
2147: IF SQL%NOTFOUND THEN
2148: gmd_api_pub.log_message('GMD_QM_CHANGE_LOT_ERR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_CHANGE_DISP_TABLE');
2149: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2150: x_return_status := FND_API.G_RET_STS_ERROR ;
2151: END IF; -- SQL%NOTFOUND THEN
2152:
2153: END update_change_disp_table;

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

2454: -- set up constants needed for the inventory API.
2455: -- Bug 4165704- not needed after inventory convergence
2456: --l_tempb := GMIGUTL.SETUP(FND_GLOBAL.USER_NAME);
2457: --IF (NOT l_tempb) THEN
2458: -- x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2459: -- x_return_status := FND_API.G_RET_STS_ERROR ;
2460: -- return;
2461: --END IF;
2462:

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

2900: EXCEPTION
2901: WHEN SAMPLE_DISP_CHANGED THEN
2902: --RLNAGARA B5668965 Changed the message from GMD_SMPL_DISP_CHANGE to GMD_QM_CURRENT_LOT_VALUE_CHANG
2903: gmd_api_pub.log_message('GMD_QM_CURRENT_LOT_VALUE_CHANG','PACKAGE','GMD_SAMPLES_GRP.UPDATE_SAMPLE_COMP_DISP');
2904: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2905: x_return_status := FND_API.G_RET_STS_ERROR ;
2906: WHEN REQ_FIELDS_MISSING THEN
2907: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH');
2908: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

2904: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2905: x_return_status := FND_API.G_RET_STS_ERROR ;
2906: WHEN REQ_FIELDS_MISSING THEN
2907: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH');
2908: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2909: x_return_status := FND_API.G_RET_STS_ERROR ;
2910: WHEN INVALID_SAMPLE THEN
2911: gmd_api_pub.log_message('GMD_QM_INVALID_SAMPLE');
2912: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

2908: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2909: x_return_status := FND_API.G_RET_STS_ERROR ;
2910: WHEN INVALID_SAMPLE THEN
2911: gmd_api_pub.log_message('GMD_QM_INVALID_SAMPLE');
2912: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2913: x_return_status := FND_API.G_RET_STS_ERROR ;
2914: WHEN INVALID_QC_STATUS THEN
2915: gmd_api_pub.log_message('GME_INV_STEP_QUALITY_STATUS');
2916: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);

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

2912: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2913: x_return_status := FND_API.G_RET_STS_ERROR ;
2914: WHEN INVALID_QC_STATUS THEN
2915: gmd_api_pub.log_message('GME_INV_STEP_QUALITY_STATUS');
2916: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2917: x_return_status := FND_API.G_RET_STS_ERROR ;
2918:
2919: WHEN RECORD_LOCK THEN
2920: GMD_API_PUB.Log_Message('GMD_IC_LOTS_CPG_LOCKED');

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

2917: x_return_status := FND_API.G_RET_STS_ERROR ;
2918:
2919: WHEN RECORD_LOCK THEN
2920: GMD_API_PUB.Log_Message('GMD_IC_LOTS_CPG_LOCKED');
2921: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2922: x_return_status := FND_API.G_RET_STS_ERROR ;
2923:
2924: WHEN OTHERS THEN
2925: IF get_curr_grade_cv%ISOPEN THEN

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

2928: IF get_curr_lot_status_cv%ISOPEN THEN
2929: CLOSE get_curr_lot_status_cv;
2930: END IF;
2931: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SAMPLES_GRP.UPDATE_LOT_GRADE_BATCH','ERROR', SUBSTR(SQLERRM,1,100),'POSITION',l_position);
2932: x_message_data := FND_MSG_PUB.GET(FND_MSG_PUB.G_LAST,FND_API.G_FALSE);
2933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2934: END update_lot_grade_batch ;
2935:
2936: