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

Line 440: x_return_status := FND_API.G_RET_STS_SUCCESS;

436: l_column_name_list LONG;
437:
438: BEGIN
439: -- Initialize return status as success
440: x_return_status := FND_API.G_RET_STS_SUCCESS;
441: -- If the transactions_id is passed, and the business flow code passed is in 6(Cross dock),
442: -- or 19(Pick Drop), then the transactions_id passed is the Delivery_Detail_Id.
443: -- Since we are printing the "Shipping" label here, we will have to derive the delivery_id
444: -- from the delivery_detail_id and print the details for the Delivery Id .

Line 821: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

817:
818: l_column_name_list := 'Set variables for ';
819:
820: /* Modified for Bug 4072474 -start*/
821: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
822: /* Modified for Bug 4072474 -End*/
823:
824: -- Fix for bug: 4179593 Start
825: l_CustSqlWarnFlagSet := FALSE;

Line 874: x_return_status := FND_API.G_RET_STS_SUCCESS;

870: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
871: END LOOP;
872:
873: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
874: x_return_status := FND_API.G_RET_STS_SUCCESS;
875: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
876: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
877: fnd_msg_pub.ADD;
878: -- Fix for bug: 4179593 Start

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

875: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
876: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
877: fnd_msg_pub.ADD;
878: -- Fix for bug: 4179593 Start
879: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
880: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
881: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
882: l_CustSqlWarnFlagSet := TRUE;
883: -- Fix for bug: 4179593 End

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

876: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
877: fnd_msg_pub.ADD;
878: -- Fix for bug: 4179593 Start
879: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
880: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
881: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
882: l_CustSqlWarnFlagSet := TRUE;
883: -- Fix for bug: 4179593 End
884: IF (l_debug = 1) THEN

Line 895: x_return_status := FND_API.G_RET_STS_SUCCESS;

891: IF (l_debug = 1) THEN
892: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 3');
893: trace('Custom Labels Trace [INVLAP7B.pls]: WARNING: No row returned by the Custom SQL query');
894: END IF;
895: x_return_status := FND_API.G_RET_STS_SUCCESS;
896: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
897: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
898: fnd_msg_pub.ADD;
899: /* Replaced following statement for Bug 4207625: Anupam Jain*/

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

896: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
897: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
898: fnd_msg_pub.ADD;
899: /* Replaced following statement for Bug 4207625: Anupam Jain*/
900: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
901: -- Fix for bug: 4179593 Start
902: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
903: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
904: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

898: fnd_msg_pub.ADD;
899: /* Replaced following statement for Bug 4207625: Anupam Jain*/
900: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
901: -- Fix for bug: 4179593 Start
902: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
903: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
904: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
905: l_CustSqlWarnFlagSet := TRUE;
906: -- Fix for bug: 4179593 End

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

899: /* Replaced following statement for Bug 4207625: Anupam Jain*/
900: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
901: -- Fix for bug: 4179593 Start
902: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
903: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
904: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
905: l_CustSqlWarnFlagSet := TRUE;
906: -- Fix for bug: 4179593 End
907: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 913: x_return_status := FND_API.G_RET_STS_SUCCESS;

909: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 4');
910: trace('Custom Labels Trace [INVLAP7B.pls]: ERROR: Multiple values returned by the Custom SQL query');
911: END IF;
912: l_sql_stmt_result := NULL;
913: x_return_status := FND_API.G_RET_STS_SUCCESS;
914: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
915: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
916: fnd_msg_pub.ADD;
917: /* Replaced following statement for Bug 4207625: Anupam Jain*/

Line 914: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

910: trace('Custom Labels Trace [INVLAP7B.pls]: ERROR: Multiple values returned by the Custom SQL query');
911: END IF;
912: l_sql_stmt_result := NULL;
913: x_return_status := FND_API.G_RET_STS_SUCCESS;
914: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
915: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
916: fnd_msg_pub.ADD;
917: /* Replaced following statement for Bug 4207625: Anupam Jain*/
918: /*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 918: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

914: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
915: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
916: fnd_msg_pub.ADD;
917: /* Replaced following statement for Bug 4207625: Anupam Jain*/
918: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
919: -- Fix for bug: 4179593 Start
920: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
921: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
922: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

916: fnd_msg_pub.ADD;
917: /* Replaced following statement for Bug 4207625: Anupam Jain*/
918: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
919: -- Fix for bug: 4179593 Start
920: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
921: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
922: l_CustSqlErrMsg := l_custom_sql_ret_msg;
923: l_CustSqlErrFlagSet := TRUE;
924: -- Fix for bug: 4179593 End

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

917: /* Replaced following statement for Bug 4207625: Anupam Jain*/
918: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
919: -- Fix for bug: 4179593 Start
920: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
921: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
922: l_CustSqlErrMsg := l_custom_sql_ret_msg;
923: l_CustSqlErrFlagSet := TRUE;
924: -- Fix for bug: 4179593 End
925: END IF;

Line 938: x_return_status := FND_API.G_RET_STS_ERROR;

934: IF (l_debug = 1) THEN
935: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 5');
936: trace('Custom Labels Trace [INVLAP7B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
937: END IF;
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
940: fnd_msg_pub.ADD;
941: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

937: END IF;
938: x_return_status := FND_API.G_RET_STS_ERROR;
939: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
940: fnd_msg_pub.ADD;
941: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: END;
944: IF (l_debug = 1) THEN
945: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 6');

Line 942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

938: x_return_status := FND_API.G_RET_STS_ERROR;
939: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
940: fnd_msg_pub.ADD;
941: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: END;
944: IF (l_debug = 1) THEN
945: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 6');
946: trace('Custom Labels Trace [INVLAP7B.pls]: Before assigning it to l_delivery_data');

Line 1247: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

1243: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
1244: END IF;
1245:
1246: IF (l_CustSqlErrFlagSet) THEN
1247: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1248: l_custom_sql_ret_msg := l_CustSqlErrMsg;
1249: END IF;
1250: -- Fix for bug: 4179593 End
1251: