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

Line 1579: x_return_status := FND_API.G_RET_STS_SUCCESS;

1575: ', Transaction ID='||p_transaction_id ||
1576: ', Transaction Identifier='||p_transaction_identifier );
1577: END IF;
1578: -- Initialize API return status to success
1579: x_return_status := FND_API.G_RET_STS_SUCCESS;
1580:
1581: IF (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
1582: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po) THEN
1583: l_patch_level := 1;

Line 2396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2392: WHEN OTHERS THEN
2393: trace('Exception raised in custom code in WMS_LABEL_CUSTOM_PKG.custom_restrict_labels');
2394: trace('SQLCODE::'||SQLCODE);
2395: trace('SQLERRM::'||SQLERRM);
2396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2397: END;
2398:
2399: --First validate that the table returned from custom code has not introduced any new LPNs
2400: --If there are new LPNs, then first remove them from the list and proceed

Line 3363: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

3359: trace('Starting assign variables, ');
3360: END IF;
3361: l_column_name_list := 'Set variables for ';
3362:
3363: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
3364:
3365: -- Fix for bug: 4179593 Start
3366: l_CustSqlWarnFlagSet := FALSE;
3367: l_CustSqlErrFlagSet := FALSE;

Line 3413: x_return_status := FND_API.G_RET_STS_SUCCESS;

3409: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
3410: END LOOP;
3411:
3412: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
3413: x_return_status := FND_API.G_RET_STS_SUCCESS;
3414: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3415: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3416: fnd_msg_pub.ADD;
3417: -- Fix for bug: 4179593 Start

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

3414: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3415: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3416: fnd_msg_pub.ADD;
3417: -- Fix for bug: 4179593 Start
3418: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3419: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3420: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3421: l_CustSqlWarnFlagSet := TRUE;
3422: -- Fix for bug: 4179593 End

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

3415: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
3416: fnd_msg_pub.ADD;
3417: -- Fix for bug: 4179593 Start
3418: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3419: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3420: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3421: l_CustSqlWarnFlagSet := TRUE;
3422: -- Fix for bug: 4179593 End
3423: IF (l_debug = 1) THEN

Line 3434: x_return_status := FND_API.G_RET_STS_SUCCESS;

3430: IF (l_debug = 1) THEN
3431: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 3');
3432: trace('Custom Labels Trace [INVLAP4B.pls]: WARNING: No row returned by the Custom SQL query');
3433: END IF;
3434: x_return_status := FND_API.G_RET_STS_SUCCESS;
3435: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3436: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3437: fnd_msg_pub.ADD;
3438: /* Replaced following statement for Bug 4207625: Anupam Jain*/

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

3435: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
3436: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
3437: fnd_msg_pub.ADD;
3438: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3439: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3440: -- Fix for bug: 4179593 Start
3441: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3442: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3443: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

3437: fnd_msg_pub.ADD;
3438: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3439: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3440: -- Fix for bug: 4179593 Start
3441: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3442: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3443: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3444: l_CustSqlWarnFlagSet := TRUE;
3445: -- Fix for bug: 4179593 End

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

3438: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3439: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3440: -- Fix for bug: 4179593 Start
3441: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3442: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3443: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
3444: l_CustSqlWarnFlagSet := TRUE;
3445: -- Fix for bug: 4179593 End
3446: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 3452: x_return_status := FND_API.G_RET_STS_SUCCESS;

3448: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 4');
3449: trace('Custom Labels Trace [INVLAP4B.pls]: ERROR: Multiple values returned by the Custom SQL query');
3450: END IF;
3451: l_sql_stmt_result := NULL;
3452: x_return_status := FND_API.G_RET_STS_SUCCESS;
3453: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3454: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3455: fnd_msg_pub.ADD;
3456: /* Replaced following statement for Bug 4207625: Anupam Jain*/

Line 3453: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3449: trace('Custom Labels Trace [INVLAP4B.pls]: ERROR: Multiple values returned by the Custom SQL query');
3450: END IF;
3451: l_sql_stmt_result := NULL;
3452: x_return_status := FND_API.G_RET_STS_SUCCESS;
3453: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3454: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3455: fnd_msg_pub.ADD;
3456: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3457: /*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 3457: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

3453: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3454: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
3455: fnd_msg_pub.ADD;
3456: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3457: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3458: -- Fix for bug: 4179593 Start
3459: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3460: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3461: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

3455: fnd_msg_pub.ADD;
3456: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3457: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3458: -- Fix for bug: 4179593 Start
3459: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3460: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3461: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3462: l_CustSqlErrFlagSet := TRUE;
3463: -- Fix for bug: 4179593 End

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

3456: /* Replaced following statement for Bug 4207625: Anupam Jain*/
3457: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
3458: -- Fix for bug: 4179593 Start
3459: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
3460: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
3461: l_CustSqlErrMsg := l_custom_sql_ret_msg;
3462: l_CustSqlErrFlagSet := TRUE;
3463: -- Fix for bug: 4179593 End
3464: END IF;

Line 3477: x_return_status := FND_API.G_RET_STS_ERROR;

3473: IF (l_debug = 1) THEN
3474: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 5');
3475: trace('Custom Labels Trace [INVLAP4B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
3476: END IF;
3477: x_return_status := FND_API.G_RET_STS_ERROR;
3478: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3479: fnd_msg_pub.ADD;
3480: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3476: END IF;
3477: x_return_status := FND_API.G_RET_STS_ERROR;
3478: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3479: fnd_msg_pub.ADD;
3480: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3482: END;
3483: IF (l_debug = 1) THEN
3484: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 6');

Line 3481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3477: x_return_status := FND_API.G_RET_STS_ERROR;
3478: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3479: fnd_msg_pub.ADD;
3480: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3482: END;
3483: IF (l_debug = 1) THEN
3484: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 6');
3485: trace('Custom Labels Trace [INVLAP4B.pls]: Before assigning it to l_content_item_data');

Line 4389: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

4385: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
4386: END IF;
4387:
4388: IF (l_CustSqlErrFlagSet) THEN
4389: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
4390: l_custom_sql_ret_msg := l_CustSqlErrMsg;
4391: END IF;
4392: -- Fix for bug: 4179593 End
4393: