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

Line 194: x_return_status := fnd_api.g_ret_sts_success;

190: v_wip_move_lines_content wip_move_lines_cur%ROWTYPE;
191: BEGIN
192: l_debug := inv_label.l_debug;
193: -- Initialize return status as success
194: x_return_status := fnd_api.g_ret_sts_success;
195:
196: IF (l_debug = 1) THEN
197: TRACE('**In PVT16: Wip Move Content label**');
198: TRACE(' Business_flow: ' || p_label_type_info.business_flow_code);

Line 444: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

440:
441: l_column_name_list := 'Set variables for ';
442:
443: /* Modified for Bug 4072474 -start*/
444: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
445: /* Modified for Bug 4072474 -End*/
446:
447: -- Fix for bug: 4179593 Start
448: l_CustSqlWarnFlagSet := FALSE;

Line 496: x_return_status := FND_API.G_RET_STS_SUCCESS;

492: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
493: END LOOP;
494:
495: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
498:
499: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
500: fnd_msg_pub.ADD;

Line 502: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

498:
499: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
500: fnd_msg_pub.ADD;
501: -- Fix for bug: 4179593 Start
502: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
503: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
504: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
505: l_CustSqlWarnFlagSet := TRUE;
506: -- Fix for bug: 4179593 End

Line 503: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

499: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
500: fnd_msg_pub.ADD;
501: -- Fix for bug: 4179593 Start
502: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
503: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
504: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
505: l_CustSqlWarnFlagSet := TRUE;
506: -- Fix for bug: 4179593 End
507: IF (l_debug = 1) THEN

Line 518: x_return_status := FND_API.G_RET_STS_SUCCESS;

514: IF (l_debug = 1) THEN
515: trace('Custom Labels Trace [INVLA16B.pls]: At Breadcrumb 3');
516: trace('Custom Labels Trace [INVLA16B.pls]: WARNING: No row returned by the Custom SQL query');
517: END IF;
518: x_return_status := FND_API.G_RET_STS_SUCCESS;
519: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
520:
521: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
522: fnd_msg_pub.ADD;

Line 524: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

520:
521: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
522: fnd_msg_pub.ADD;
523: /* Replaced following statement for Bug 4207625: Anupam Jain*/
524: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
525: -- Fix for bug: 4179593 Start
526: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
527: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
528: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

Line 526: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

522: fnd_msg_pub.ADD;
523: /* Replaced following statement for Bug 4207625: Anupam Jain*/
524: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
525: -- Fix for bug: 4179593 Start
526: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
527: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
528: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
529: l_CustSqlWarnFlagSet := TRUE;
530: -- Fix for bug: 4179593 End

Line 527: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

523: /* Replaced following statement for Bug 4207625: Anupam Jain*/
524: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
525: -- Fix for bug: 4179593 Start
526: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
527: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
528: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
529: l_CustSqlWarnFlagSet := TRUE;
530: -- Fix for bug: 4179593 End
531: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 537: x_return_status := FND_API.G_RET_STS_SUCCESS;

533: trace('Custom Labels Trace [INVLA16B.pls]: At Breadcrumb 4');
534: trace('Custom Labels Trace [INVLA16B.pls]: ERROR: Multiple values returned by the Custom SQL query');
535: END IF;
536: l_sql_stmt_result := NULL;
537: x_return_status := FND_API.G_RET_STS_SUCCESS;
538: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
539: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
540: fnd_msg_pub.ADD;
541: /* Replaced following statement for Bug 4207625: Anupam Jain*/

Line 538: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

534: trace('Custom Labels Trace [INVLA16B.pls]: ERROR: Multiple values returned by the Custom SQL query');
535: END IF;
536: l_sql_stmt_result := NULL;
537: x_return_status := FND_API.G_RET_STS_SUCCESS;
538: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
539: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
540: fnd_msg_pub.ADD;
541: /* Replaced following statement for Bug 4207625: Anupam Jain*/
542: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/

Line 542: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

538: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
539: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
540: fnd_msg_pub.ADD;
541: /* Replaced following statement for Bug 4207625: Anupam Jain*/
542: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
543: -- Fix for bug: 4179593 Start
544: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
545: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
546: l_CustSqlErrMsg := l_custom_sql_ret_msg;

Line 544: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

540: fnd_msg_pub.ADD;
541: /* Replaced following statement for Bug 4207625: Anupam Jain*/
542: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
543: -- Fix for bug: 4179593 Start
544: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
545: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
546: l_CustSqlErrMsg := l_custom_sql_ret_msg;
547: l_CustSqlErrFlagSet := TRUE;
548: -- Fix for bug: 4179593 End

Line 545: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

541: /* Replaced following statement for Bug 4207625: Anupam Jain*/
542: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
543: -- Fix for bug: 4179593 Start
544: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
545: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
546: l_CustSqlErrMsg := l_custom_sql_ret_msg;
547: l_CustSqlErrFlagSet := TRUE;
548: -- Fix for bug: 4179593 End
549: END IF;

Line 562: x_return_status := FND_API.G_RET_STS_ERROR;

558: IF (l_debug = 1) THEN
559: trace('Custom Labels Trace [INVLA16B.pls]: At Breadcrumb 5');
560: trace('Custom Labels Trace [INVLA16B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
561: END IF;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
564: fnd_msg_pub.ADD;
565: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 565: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

561: END IF;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
564: fnd_msg_pub.ADD;
565: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567: END;
568: IF (l_debug = 1) THEN
569: trace('Custom Labels Trace [INVLA16B.pls]: At Breadcrumb 6');

Line 566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

562: x_return_status := FND_API.G_RET_STS_ERROR;
563: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
564: fnd_msg_pub.ADD;
565: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567: END;
568: IF (l_debug = 1) THEN
569: trace('Custom Labels Trace [INVLA16B.pls]: At Breadcrumb 6');
570: trace('Custom Labels Trace [INVLA16B.pls]: Before assigning it to l_content_item_data');

Line 829: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

825: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
826: END IF;
827:
828: IF (l_CustSqlErrFlagSet) THEN
829: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
830: l_custom_sql_ret_msg := l_CustSqlErrMsg;
831: END IF;
832: -- Fix for bug: 4179593 End
833: