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 460: x_return_status := FND_API.G_RET_STS_SUCCESS;

456: l_column_name_list LONG;
457:
458: BEGIN
459: -- Initialize return status as success
460: x_return_status := FND_API.G_RET_STS_SUCCESS;
461: -- If the transactions_id is passed, and the business flow code passed is in 6(Cross dock),
462: -- or 19(Pick Drop), then the transactions_id passed is the Delivery_Detail_Id.
463: -- Since we are printing the "Shipping" label here, we will have to derive the delivery_id
464: -- from the delivery_detail_id and print the details for the Delivery Id .

Line 842: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

838:
839: l_column_name_list := 'Set variables for ';
840:
841: /* Modified for Bug 4072474 -start*/
842: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
843: /* Modified for Bug 4072474 -End*/
844:
845: -- Fix for bug: 4179593 Start
846: l_CustSqlWarnFlagSet := FALSE;

Line 895: x_return_status := FND_API.G_RET_STS_SUCCESS;

891: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
892: END LOOP;
893:
894: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
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_NULL_VALUE_RETURNED');
898: fnd_msg_pub.ADD;
899: -- Fix for bug: 4179593 Start

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_msg);

896: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
897: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
898: fnd_msg_pub.ADD;
899: -- Fix for bug: 4179593 Start
900: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
901: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
902: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
903: l_CustSqlWarnFlagSet := TRUE;
904: -- Fix for bug: 4179593 End

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

897: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
898: fnd_msg_pub.ADD;
899: -- Fix for bug: 4179593 Start
900: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
901: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
902: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
903: l_CustSqlWarnFlagSet := TRUE;
904: -- Fix for bug: 4179593 End
905: IF (l_debug = 1) THEN

Line 916: x_return_status := FND_API.G_RET_STS_SUCCESS;

912: IF (l_debug = 1) THEN
913: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 3');
914: trace('Custom Labels Trace [INVLAP7B.pls]: WARNING: No row returned by the Custom SQL query');
915: END IF;
916: x_return_status := FND_API.G_RET_STS_SUCCESS;
917: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
918: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
919: fnd_msg_pub.ADD;
920: /* Replaced following statement for Bug 4207625: Anupam Jain*/

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

917: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
918: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
919: fnd_msg_pub.ADD;
920: /* Replaced following statement for Bug 4207625: Anupam Jain*/
921: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
922: -- Fix for bug: 4179593 Start
923: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
924: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
925: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

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

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

920: /* Replaced following statement for Bug 4207625: Anupam Jain*/
921: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
922: -- Fix for bug: 4179593 Start
923: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
924: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
925: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
926: l_CustSqlWarnFlagSet := TRUE;
927: -- Fix for bug: 4179593 End
928: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 934: x_return_status := FND_API.G_RET_STS_SUCCESS;

930: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 4');
931: trace('Custom Labels Trace [INVLAP7B.pls]: ERROR: Multiple values returned by the Custom SQL query');
932: END IF;
933: l_sql_stmt_result := NULL;
934: x_return_status := FND_API.G_RET_STS_SUCCESS;
935: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
936: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
937: fnd_msg_pub.ADD;
938: /* Replaced following statement for Bug 4207625: Anupam Jain*/

Line 935: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

931: trace('Custom Labels Trace [INVLAP7B.pls]: ERROR: Multiple values returned by the Custom SQL query');
932: END IF;
933: l_sql_stmt_result := NULL;
934: x_return_status := FND_API.G_RET_STS_SUCCESS;
935: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
936: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
937: fnd_msg_pub.ADD;
938: /* Replaced following statement for Bug 4207625: Anupam Jain*/
939: /*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 939: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

935: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
936: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
937: fnd_msg_pub.ADD;
938: /* Replaced following statement for Bug 4207625: Anupam Jain*/
939: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
940: -- Fix for bug: 4179593 Start
941: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
942: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
943: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

937: fnd_msg_pub.ADD;
938: /* Replaced following statement for Bug 4207625: Anupam Jain*/
939: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
940: -- Fix for bug: 4179593 Start
941: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
942: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
943: l_CustSqlErrMsg := l_custom_sql_ret_msg;
944: l_CustSqlErrFlagSet := TRUE;
945: -- Fix for bug: 4179593 End

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

938: /* Replaced following statement for Bug 4207625: Anupam Jain*/
939: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
940: -- Fix for bug: 4179593 Start
941: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
942: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
943: l_CustSqlErrMsg := l_custom_sql_ret_msg;
944: l_CustSqlErrFlagSet := TRUE;
945: -- Fix for bug: 4179593 End
946: END IF;

Line 959: x_return_status := FND_API.G_RET_STS_ERROR;

955: IF (l_debug = 1) THEN
956: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 5');
957: trace('Custom Labels Trace [INVLAP7B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
958: END IF;
959: x_return_status := FND_API.G_RET_STS_ERROR;
960: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
961: fnd_msg_pub.ADD;
962: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

958: END IF;
959: x_return_status := FND_API.G_RET_STS_ERROR;
960: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
961: fnd_msg_pub.ADD;
962: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END;
965: IF (l_debug = 1) THEN
966: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 6');

Line 963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

959: x_return_status := FND_API.G_RET_STS_ERROR;
960: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
961: fnd_msg_pub.ADD;
962: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END;
965: IF (l_debug = 1) THEN
966: trace('Custom Labels Trace [INVLAP7B.pls]: At Breadcrumb 6');
967: trace('Custom Labels Trace [INVLAP7B.pls]: Before assigning it to l_delivery_data');

Line 1268: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

1264: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
1265: END IF;
1266:
1267: IF (l_CustSqlErrFlagSet) THEN
1268: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1269: l_custom_sql_ret_msg := l_CustSqlErrMsg;
1270: END IF;
1271: -- Fix for bug: 4179593 End
1272: