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

Line 41: l_msg_data := fnd_msg_pub.GET(l_msg_index,fnd_api.g_false);

37: l_msg_index := 1;
38: l_msg_count := fnd_msg_pub.COUNT_MSG();
39: DEBUG(p_prefix||' '||TO_CHAR(l_msg_count)||' error messages .');
40: WHILE l_msg_count > 0 LOOP
41: l_msg_data := fnd_msg_pub.GET(l_msg_index,fnd_api.g_false);
42: DEBUG(p_prefix||l_msg_data);
43: l_msg_index := l_msg_index + 1;
44: l_msg_count := l_msg_count - 1;
45: END LOOP;

Line 61: * @param x_validation_status Returns either fnd_api.g_true IF configuration IS valid

57: * @param p_locked_instance_rev_nbr Identifies locked revision OF returned config item
58: * IF it IS NULL THEN this means that config item was NOT locked ( no pending orders WITH this item )
59: * @param p_application_id - application Id OF caller ( IF NULL THEN by defualt it's 542(IB))
60: * @p_config_eff_date - configuration effectivity date ( if NULL then by default it's SYSDATE )
61: * @param x_validation_status Returns either fnd_api.g_true IF configuration IS valid
62: * OR fnd_api.g_false IF configuration IS NOT valid
63: * @param x_return_status Returns one of three values :
64: * FND_API.G_RET_STS_SUCCESS IF no errors occurred
65: * FND_API.G_RET_STS_ERROR IF AT LEAST one error occurred

Line 62: * OR fnd_api.g_false IF configuration IS NOT valid

58: * IF it IS NULL THEN this means that config item was NOT locked ( no pending orders WITH this item )
59: * @param p_application_id - application Id OF caller ( IF NULL THEN by defualt it's 542(IB))
60: * @p_config_eff_date - configuration effectivity date ( if NULL then by default it's SYSDATE )
61: * @param x_validation_status Returns either fnd_api.g_true IF configuration IS valid
62: * OR fnd_api.g_false IF configuration IS NOT valid
63: * @param x_return_status Returns one of three values :
64: * FND_API.G_RET_STS_SUCCESS IF no errors occurred
65: * FND_API.G_RET_STS_ERROR IF AT LEAST one error occurred
66: * FND_API.G_RET_STS_UNEXP_ERROR IF AT LEAST one unexpected error occurred

Line 64: * FND_API.G_RET_STS_SUCCESS IF no errors occurred

60: * @p_config_eff_date - configuration effectivity date ( if NULL then by default it's SYSDATE )
61: * @param x_validation_status Returns either fnd_api.g_true IF configuration IS valid
62: * OR fnd_api.g_false IF configuration IS NOT valid
63: * @param x_return_status Returns one of three values :
64: * FND_API.G_RET_STS_SUCCESS IF no errors occurred
65: * FND_API.G_RET_STS_ERROR IF AT LEAST one error occurred
66: * FND_API.G_RET_STS_UNEXP_ERROR IF AT LEAST one unexpected error occurred
67: * @param x_msg_count Indicates how many messages exist ON ERROR_HANDLER
68: * message stack upon completion OF processing.

Line 65: * FND_API.G_RET_STS_ERROR IF AT LEAST one error occurred

61: * @param x_validation_status Returns either fnd_api.g_true IF configuration IS valid
62: * OR fnd_api.g_false IF configuration IS NOT valid
63: * @param x_return_status Returns one of three values :
64: * FND_API.G_RET_STS_SUCCESS IF no errors occurred
65: * FND_API.G_RET_STS_ERROR IF AT LEAST one error occurred
66: * FND_API.G_RET_STS_UNEXP_ERROR IF AT LEAST one unexpected error occurred
67: * @param x_msg_count Indicates how many messages exist ON ERROR_HANDLER
68: * message stack upon completion OF processing.
69: * @param x_msg_data IF exactly one message EXISTS ON ERROR_HANDLER

Line 66: * FND_API.G_RET_STS_UNEXP_ERROR IF AT LEAST one unexpected error occurred

62: * OR fnd_api.g_false IF configuration IS NOT valid
63: * @param x_return_status Returns one of three values :
64: * FND_API.G_RET_STS_SUCCESS IF no errors occurred
65: * FND_API.G_RET_STS_ERROR IF AT LEAST one error occurred
66: * FND_API.G_RET_STS_UNEXP_ERROR IF AT LEAST one unexpected error occurred
67: * @param x_msg_count Indicates how many messages exist ON ERROR_HANDLER
68: * message stack upon completion OF processing.
69: * @param x_msg_data IF exactly one message EXISTS ON ERROR_HANDLER
70: * message stack upon completion OF processing, this parameter contains

Line 149: x_return_status := FND_API.G_RET_STS_SUCCESS;

145:
146: --
147: -- initialize OUT variables
148: --
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150: x_msg_count := 0;
151: x_msg_data := NULL;
152:
153: --

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Config item instance_hdr_id/instance_rev_nbr/config_item_id = '||
169: to_char(p_instance_hdr_id)||'/'||to_char(p_instance_rev_nbr)||'/'||to_char(p_returned_config_item_id)||
170: ' is not tangible.');
171:
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: fnd_msg_pub.count_and_get(p_count => x_msg_count,
174: p_data => x_msg_data);
175:
176: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193: WHEN NO_DATA_FOUND THEN
194: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Config item instance_hdr_id/instance_rev_nbr/config_item_id = '||
195: to_char(p_instance_hdr_id)||'/'||to_char(p_instance_rev_nbr)||'/'||to_char(p_returned_config_item_id)||
196: ' does not exist.');
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: fnd_msg_pub.count_and_get(p_count => x_msg_count,
199: p_data => x_msg_data);
200:
201: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

229: WHEN NO_DATA_FOUND THEN
230: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Config item instance_hdr_id/instance_rev_nbr/config_item_id = '||
231: to_char(p_instance_hdr_id)||'/'||to_char(p_locked_instance_rev_nbr)||'/'||to_char(p_returned_config_item_id)||
232: ' does not exist.');
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: fnd_msg_pub.count_and_get(p_count => x_msg_count,
235: p_data => x_msg_data);
236:
237: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 344: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

340: END IF;
341:
342: EXCEPTION
343: WHEN OTHERS THEN
344: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Fatal error : cz_network_api_pub.generate_config_trees() : '||SQLERRM);
346: fnd_msg_pub.count_and_get(p_count => x_msg_count,
347: p_data => x_msg_data);
348: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 355: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

351: FND_LOG.LEVEL_ERROR);
352: END IF;
353: END;
354:
355: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
356:
357: UPDATE CZ_CONFIG_ITEMS
358: SET returned_flag = l_returned_flag
359: WHERE instance_hdr_id=p_instance_hdr_id AND

Line 371: x_validation_status := fnd_api.g_false;

367: instance_rev_nbr= p_locked_instance_rev_nbr AND
368: config_item_id=p_returned_config_item_id AND
369: NVL(returned_flag, '0') <> l_locked_item_returned_flag;
370:
371: x_validation_status := fnd_api.g_false;
372:
373: x_return_status := FND_API.G_RET_STS_ERROR;
374: x_msg_count := x_msg_count + l_msg_count;
375: x_msg_data := l_msg_data;

Line 373: x_return_status := FND_API.G_RET_STS_ERROR;

369: NVL(returned_flag, '0') <> l_locked_item_returned_flag;
370:
371: x_validation_status := fnd_api.g_false;
372:
373: x_return_status := FND_API.G_RET_STS_ERROR;
374: x_msg_count := x_msg_count + l_msg_count;
375: x_msg_data := l_msg_data;
376:
377: ELSE

Line 382: -- convert config status into fnd_api.g_true/ fnd_api.g_false OUT parameter x_validation_status

378: -- query for config status
379: SELECT config_status INTO l_config_status FROM CZ_CONFIG_HDRS
380: WHERE config_hdr_id=l_config_model_tbl(1).config_hdr_id AND
381: config_rev_nbr=l_config_model_tbl(1).config_rev_nbr;
382: -- convert config status into fnd_api.g_true/ fnd_api.g_false OUT parameter x_validation_status
383: --
384: IF l_config_status<>'2' THEN -- '2' means that BATCH validation complete
385: x_validation_status := fnd_api.g_false;
386: ELSE

Line 385: x_validation_status := fnd_api.g_false;

381: config_rev_nbr=l_config_model_tbl(1).config_rev_nbr;
382: -- convert config status into fnd_api.g_true/ fnd_api.g_false OUT parameter x_validation_status
383: --
384: IF l_config_status<>'2' THEN -- '2' means that BATCH validation complete
385: x_validation_status := fnd_api.g_false;
386: ELSE
387: BEGIN
388: SELECT 'F' INTO x_validation_status FROM dual
389: WHERE EXISTS(SELECT NULL FROM CZ_CONFIG_MESSAGES

Line 392: x_validation_status := fnd_api.g_false;

388: SELECT 'F' INTO x_validation_status FROM dual
389: WHERE EXISTS(SELECT NULL FROM CZ_CONFIG_MESSAGES
390: WHERE config_hdr_id=l_config_model_tbl(1).config_hdr_id AND
391: config_rev_nbr=l_config_model_tbl(1).config_rev_nbr);
392: x_validation_status := fnd_api.g_false;
393: EXCEPTION
394: WHEN NO_DATA_FOUND THEN
395: x_validation_status := fnd_api.g_true;
396: END;

Line 395: x_validation_status := fnd_api.g_true;

391: config_rev_nbr=l_config_model_tbl(1).config_rev_nbr);
392: x_validation_status := fnd_api.g_false;
393: EXCEPTION
394: WHEN NO_DATA_FOUND THEN
395: x_validation_status := fnd_api.g_true;
396: END;
397: END IF;
398:
399: END IF;

Line 407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

403: EXCEPTION
404: WHEN OTHERS THEN
405: -- raise fatal error (unexpected error ) , add a corresponding FND error message to error stack,
406: -- populate x_msg_count and x_msg_data
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name, 'Fatal error : '||SQLERRM);
409: fnd_msg_pub.count_and_get(p_count => x_msg_count,
410: p_data => x_msg_data);
411: END remove_Returned_Config_Item;