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_PVT6 dependencies on FND_API

Line 477: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

473:
474: l_column_name_list := 'Set variables for ';
475:
476: /* Modified for Bug 4072474 -start*/
477: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
478: /* Modified for Bug 4072474 -End*/
479:
480: -- Fix for bug: 4179593 Start
481: l_CustSqlWarnFlagSet := FALSE;

Line 529: x_return_status := FND_API.G_RET_STS_SUCCESS;

525: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
526: END LOOP;
527:
528: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
531: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
532: fnd_msg_pub.ADD;
533: -- Fix for bug: 4179593 Start

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

530: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
531: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
532: fnd_msg_pub.ADD;
533: -- Fix for bug: 4179593 Start
534: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
535: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
536: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
537: l_CustSqlWarnFlagSet := TRUE;
538: -- Fix for bug: 4179593 End

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

531: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
532: fnd_msg_pub.ADD;
533: -- Fix for bug: 4179593 Start
534: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
535: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
536: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
537: l_CustSqlWarnFlagSet := TRUE;
538: -- Fix for bug: 4179593 End
539: IF (l_debug = 1) THEN

Line 550: x_return_status := FND_API.G_RET_STS_SUCCESS;

546: IF (l_debug = 1) THEN
547: trace('Custom Labels Trace [INVLAP6B.pls]: At Breadcrumb 3');
548: trace('Custom Labels Trace [INVLAP6B.pls]: WARNING: No row returned by the Custom SQL query');
549: END IF;
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
552: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
553: fnd_msg_pub.ADD;
554: /* Replaced following statement for Bug 4207625: Anupam Jain*/

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

551: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
552: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
553: fnd_msg_pub.ADD;
554: /* Replaced following statement for Bug 4207625: Anupam Jain*/
555: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
556: -- Fix for bug: 4179593 Start
557: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
558: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
559: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

553: fnd_msg_pub.ADD;
554: /* Replaced following statement for Bug 4207625: Anupam Jain*/
555: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
556: -- Fix for bug: 4179593 Start
557: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
558: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
559: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
560: l_CustSqlWarnFlagSet := TRUE;
561: -- Fix for bug: 4179593 End

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

554: /* Replaced following statement for Bug 4207625: Anupam Jain*/
555: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
556: -- Fix for bug: 4179593 Start
557: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
558: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
559: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
560: l_CustSqlWarnFlagSet := TRUE;
561: -- Fix for bug: 4179593 End
562: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 568: x_return_status := FND_API.G_RET_STS_SUCCESS;

564: trace('Custom Labels Trace [INVLAP6B.pls]: At Breadcrumb 4');
565: trace('Custom Labels Trace [INVLAP6B.pls]: ERROR: Multiple values returned by the Custom SQL query');
566: END IF;
567: l_sql_stmt_result := NULL;
568: x_return_status := FND_API.G_RET_STS_SUCCESS;
569: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
570: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
571: fnd_msg_pub.ADD;
572: /* Replaced following statement for Bug 4207625: Anupam Jain*/

Line 569: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

565: trace('Custom Labels Trace [INVLAP6B.pls]: ERROR: Multiple values returned by the Custom SQL query');
566: END IF;
567: l_sql_stmt_result := NULL;
568: x_return_status := FND_API.G_RET_STS_SUCCESS;
569: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
570: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
571: fnd_msg_pub.ADD;
572: /* Replaced following statement for Bug 4207625: Anupam Jain*/
573: /*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 573: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

569: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
570: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
571: fnd_msg_pub.ADD;
572: /* Replaced following statement for Bug 4207625: Anupam Jain*/
573: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
574: -- Fix for bug: 4179593 Start
575: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
576: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
577: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

571: fnd_msg_pub.ADD;
572: /* Replaced following statement for Bug 4207625: Anupam Jain*/
573: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
574: -- Fix for bug: 4179593 Start
575: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
576: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
577: l_CustSqlErrMsg := l_custom_sql_ret_msg;
578: l_CustSqlErrFlagSet := TRUE;
579: -- Fix for bug: 4179593 End

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

572: /* Replaced following statement for Bug 4207625: Anupam Jain*/
573: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
574: -- Fix for bug: 4179593 Start
575: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
576: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
577: l_CustSqlErrMsg := l_custom_sql_ret_msg;
578: l_CustSqlErrFlagSet := TRUE;
579: -- Fix for bug: 4179593 End
580: END IF;

Line 593: x_return_status := FND_API.G_RET_STS_ERROR;

589: IF (l_debug = 1) THEN
590: trace('Custom Labels Trace [INVLAP6B.pls]: At Breadcrumb 5');
591: trace('Custom Labels Trace [INVLAP6B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
592: END IF;
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
595: fnd_msg_pub.ADD;
596: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

592: END IF;
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
595: fnd_msg_pub.ADD;
596: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END;
599: IF (l_debug = 1) THEN
600: trace('Custom Labels Trace [INVLAP6B.pls]: At Breadcrumb 6');

Line 597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

593: x_return_status := FND_API.G_RET_STS_ERROR;
594: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
595: fnd_msg_pub.ADD;
596: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: END;
599: IF (l_debug = 1) THEN
600: trace('Custom Labels Trace [INVLAP6B.pls]: At Breadcrumb 6');
601: trace('Custom Labels Trace [INVLAP6B.pls]: Before assigning it to l_location_data');

Line 687: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

683: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
684: END IF;
685:
686: IF (l_CustSqlErrFlagSet) THEN
687: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
688: l_custom_sql_ret_msg := l_CustSqlErrMsg;
689: END IF;
690: -- Fix for bug: 4179593 End
691: