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

Line 312: x_return_status := fnd_api.g_ret_sts_success;

308: where batch_id = l_transaction_id;
309:
310: BEGIN
311: -- Initialize return status as success
312: x_return_status := fnd_api.g_ret_sts_success;
313: l_debug := inv_label.l_debug;
314: l_label_status := INV_LABEL.G_SUCCESS;
315:
316: IF (l_debug = 1) THEN

Line 428: p_init_msg_list => FND_API.G_FALSE,

424: l_temp_print_count := 0;
425:
426: GMO_LABEL_MGMT_GRP.GET_PRINT_COUNT(
427: p_api_version => 1.0,
428: p_init_msg_list => FND_API.G_FALSE,
429: x_return_status => l_return_status,
430: x_msg_count => l_msg_count,
431: x_msg_data => l_msg_data,
432: P_WMS_BUSINESS_FLOW_CODE => p_label_type_info.business_flow_code,

Line 582: p_init_msg_list => FND_API.G_FALSE,

578: END LOOP;
579: END IF;
580: GMO_LABEL_MGMT_GRP.GET_PRINT_COUNT(
581: p_api_version => 1.0,
582: p_init_msg_list => FND_API.G_FALSE,
583: x_return_status => l_return_status,
584: x_msg_count => l_msg_count,
585: x_msg_data => l_msg_data,
586: P_WMS_BUSINESS_FLOW_CODE => p_label_type_info.business_flow_code,

Line 736: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

732:
733: l_column_name_list := 'Set variables for ';
734:
735: -- CUSTOM SQL
736: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
737: l_CustSqlWarnFlagSet := FALSE;
738: l_CustSqlErrFlagSet := FALSE;
739: l_CustSqlWarnMsg := NULL;
740: l_CustSqlErrMsg := NULL;

Line 787: x_return_status := FND_API.G_RET_STS_SUCCESS;

783: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
784: END LOOP;
785:
786: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
787: x_return_status := FND_API.G_RET_STS_SUCCESS;
788: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
789: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
790: fnd_msg_pub.ADD;
791: -- Fix for bug: 4179593 Start

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

788: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
789: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
790: fnd_msg_pub.ADD;
791: -- Fix for bug: 4179593 Start
792: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
793: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
794: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
795: l_CustSqlWarnFlagSet := TRUE;
796: -- Fix for bug: 4179593 End

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

789: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
790: fnd_msg_pub.ADD;
791: -- Fix for bug: 4179593 Start
792: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
793: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
794: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
795: l_CustSqlWarnFlagSet := TRUE;
796: -- Fix for bug: 4179593 End
797: IF (l_debug = 1) THEN

Line 808: x_return_status := FND_API.G_RET_STS_SUCCESS;

804: IF (l_debug = 1) THEN
805: trace('Custom Labels Trace [INVLA13B.pls]: At Breadcrumb 3');
806: trace('Custom Labels Trace [INVLA13B.pls]: WARNING: No row returned by the Custom SQL query');
807: END IF;
808: x_return_status := FND_API.G_RET_STS_SUCCESS;
809: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
810: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
811: fnd_msg_pub.ADD;
812: -- Fix for bug: 4179593 Start

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

809: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
810: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
811: fnd_msg_pub.ADD;
812: -- Fix for bug: 4179593 Start
813: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
814: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
815: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
816: l_CustSqlWarnFlagSet := TRUE;
817: -- Fix for bug: 4179593 End

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

810: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
811: fnd_msg_pub.ADD;
812: -- Fix for bug: 4179593 Start
813: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
814: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
815: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
816: l_CustSqlWarnFlagSet := TRUE;
817: -- Fix for bug: 4179593 End
818: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 824: x_return_status := FND_API.G_RET_STS_SUCCESS;

820: trace('Custom Labels Trace [INVLA13B.pls]: At Breadcrumb 4');
821: trace('Custom Labels Trace [INVLA13B.pls]: ERROR: Multiple values returned by the Custom SQL query');
822: END IF;
823: l_sql_stmt_result := NULL;
824: x_return_status := FND_API.G_RET_STS_SUCCESS;
825: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
826: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
827: fnd_msg_pub.ADD;
828: -- Fix for bug: 4179593 Start

Line 825: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

821: trace('Custom Labels Trace [INVLA13B.pls]: ERROR: Multiple values returned by the Custom SQL query');
822: END IF;
823: l_sql_stmt_result := NULL;
824: x_return_status := FND_API.G_RET_STS_SUCCESS;
825: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
826: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
827: fnd_msg_pub.ADD;
828: -- Fix for bug: 4179593 Start
829: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

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

825: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
826: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
827: fnd_msg_pub.ADD;
828: -- Fix for bug: 4179593 Start
829: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
830: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
831: l_CustSqlErrMsg := l_custom_sql_ret_msg;
832: l_CustSqlErrFlagSet := TRUE;
833: -- Fix for bug: 4179593 End

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

826: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
827: fnd_msg_pub.ADD;
828: -- Fix for bug: 4179593 Start
829: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
830: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
831: l_CustSqlErrMsg := l_custom_sql_ret_msg;
832: l_CustSqlErrFlagSet := TRUE;
833: -- Fix for bug: 4179593 End
834: END IF;

Line 847: x_return_status := FND_API.G_RET_STS_ERROR;

843: IF (l_debug = 1) THEN
844: trace('Custom Labels Trace [INVLA13B.pls]: At Breadcrumb 5');
845: trace('Custom Labels Trace [INVLA13B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
846: END IF;
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
849: fnd_msg_pub.ADD;
850: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

846: END IF;
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
849: fnd_msg_pub.ADD;
850: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END;
853: IF (l_debug = 1) THEN
854: trace('Custom Labels Trace [INVLA13B.pls]: At Breadcrumb 6');

Line 851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

847: x_return_status := FND_API.G_RET_STS_ERROR;
848: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
849: fnd_msg_pub.ADD;
850: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END;
853: IF (l_debug = 1) THEN
854: trace('Custom Labels Trace [INVLA13B.pls]: At Breadcrumb 6');
855: trace('Custom Labels Trace [INVLA13B.pls]: Before assigning it to l_content_item_data');

Line 1172: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

1168: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
1169: END IF;
1170:
1171: IF (l_CustSqlErrFlagSet) THEN
1172: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1173: l_custom_sql_ret_msg := l_CustSqlErrMsg;
1174: END IF;
1175: -- Fix for bug: 4179593 End
1176: