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 321: x_return_status := fnd_api.g_ret_sts_success;

317: where batch_id = l_transaction_id;
318:
319: BEGIN
320: -- Initialize return status as success
321: x_return_status := fnd_api.g_ret_sts_success;
322: l_debug := inv_label.l_debug;
323: l_label_status := INV_LABEL.G_SUCCESS;
324:
325: IF (l_debug = 1) THEN

Line 437: p_init_msg_list => FND_API.G_FALSE,

433: l_temp_print_count := 0;
434:
435: GMO_LABEL_MGMT_GRP.GET_PRINT_COUNT(
436: p_api_version => 1.0,
437: p_init_msg_list => FND_API.G_FALSE,
438: x_return_status => l_return_status,
439: x_msg_count => l_msg_count,
440: x_msg_data => l_msg_data,
441: P_WMS_BUSINESS_FLOW_CODE => p_label_type_info.business_flow_code,

Line 597: p_init_msg_list => FND_API.G_FALSE,

593: END LOOP;
594: END IF;
595: GMO_LABEL_MGMT_GRP.GET_PRINT_COUNT(
596: p_api_version => 1.0,
597: p_init_msg_list => FND_API.G_FALSE,
598: x_return_status => l_return_status,
599: x_msg_count => l_msg_count,
600: x_msg_data => l_msg_data,
601: P_WMS_BUSINESS_FLOW_CODE => p_label_type_info.business_flow_code,

Line 754: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

750:
751: l_column_name_list := 'Set variables for ';
752:
753: -- CUSTOM SQL
754: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
755: l_CustSqlWarnFlagSet := FALSE;
756: l_CustSqlErrFlagSet := FALSE;
757: l_CustSqlWarnMsg := NULL;
758: l_CustSqlErrMsg := NULL;

Line 805: x_return_status := FND_API.G_RET_STS_SUCCESS;

801: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
802: END LOOP;
803:
804: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
805: x_return_status := FND_API.G_RET_STS_SUCCESS;
806: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
807: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
808: fnd_msg_pub.ADD;
809: -- Fix for bug: 4179593 Start

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

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

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

807: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
808: fnd_msg_pub.ADD;
809: -- Fix for bug: 4179593 Start
810: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
811: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
812: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
813: l_CustSqlWarnFlagSet := TRUE;
814: -- Fix for bug: 4179593 End
815: IF (l_debug = 1) THEN

Line 826: x_return_status := FND_API.G_RET_STS_SUCCESS;

822: IF (l_debug = 1) THEN
823: trace('Custom Labels Trace [INVLA13B.pls]: At Breadcrumb 3');
824: trace('Custom Labels Trace [INVLA13B.pls]: WARNING: No row returned by the Custom SQL query');
825: END IF;
826: x_return_status := FND_API.G_RET_STS_SUCCESS;
827: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
828: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
829: fnd_msg_pub.ADD;
830: -- Fix for bug: 4179593 Start

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

827: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
828: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
829: fnd_msg_pub.ADD;
830: -- Fix for bug: 4179593 Start
831: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
832: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
833: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
834: l_CustSqlWarnFlagSet := TRUE;
835: -- Fix for bug: 4179593 End

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

828: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
829: fnd_msg_pub.ADD;
830: -- Fix for bug: 4179593 Start
831: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
832: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
833: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
834: l_CustSqlWarnFlagSet := TRUE;
835: -- Fix for bug: 4179593 End
836: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 842: x_return_status := FND_API.G_RET_STS_SUCCESS;

838: trace('Custom Labels Trace [INVLA13B.pls]: At Breadcrumb 4');
839: trace('Custom Labels Trace [INVLA13B.pls]: ERROR: Multiple values returned by the Custom SQL query');
840: END IF;
841: l_sql_stmt_result := NULL;
842: x_return_status := FND_API.G_RET_STS_SUCCESS;
843: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
844: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
845: fnd_msg_pub.ADD;
846: -- Fix for bug: 4179593 Start

Line 843: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

839: trace('Custom Labels Trace [INVLA13B.pls]: ERROR: Multiple values returned by the Custom SQL query');
840: END IF;
841: l_sql_stmt_result := NULL;
842: x_return_status := FND_API.G_RET_STS_SUCCESS;
843: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
844: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
845: fnd_msg_pub.ADD;
846: -- Fix for bug: 4179593 Start
847: --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 847: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

843: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
844: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
845: fnd_msg_pub.ADD;
846: -- Fix for bug: 4179593 Start
847: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
848: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
849: l_CustSqlErrMsg := l_custom_sql_ret_msg;
850: l_CustSqlErrFlagSet := TRUE;
851: -- Fix for bug: 4179593 End

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

844: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
845: fnd_msg_pub.ADD;
846: -- Fix for bug: 4179593 Start
847: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
848: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
849: l_CustSqlErrMsg := l_custom_sql_ret_msg;
850: l_CustSqlErrFlagSet := TRUE;
851: -- Fix for bug: 4179593 End
852: END IF;

Line 865: x_return_status := FND_API.G_RET_STS_ERROR;

861: IF (l_debug = 1) THEN
862: trace('Custom Labels Trace [INVLA13B.pls]: At Breadcrumb 5');
863: trace('Custom Labels Trace [INVLA13B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
864: END IF;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
867: fnd_msg_pub.ADD;
868: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

864: END IF;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
867: fnd_msg_pub.ADD;
868: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
870: END;
871: IF (l_debug = 1) THEN
872: trace('Custom Labels Trace [INVLA13B.pls]: At Breadcrumb 6');

Line 869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

865: x_return_status := FND_API.G_RET_STS_ERROR;
866: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
867: fnd_msg_pub.ADD;
868: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
870: END;
871: IF (l_debug = 1) THEN
872: trace('Custom Labels Trace [INVLA13B.pls]: At Breadcrumb 6');
873: trace('Custom Labels Trace [INVLA13B.pls]: Before assigning it to l_content_item_data');

Line 1190: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

1186: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
1187: END IF;
1188:
1189: IF (l_CustSqlErrFlagSet) THEN
1190: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1191: l_custom_sql_ret_msg := l_CustSqlErrMsg;
1192: END IF;
1193: -- Fix for bug: 4179593 End
1194: