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

1280: ', Transaction ID='||p_transaction_id ||
1281: ', Transaction Identifier='||p_transaction_identifier );
1282: END IF;
1283: -- Initialize API return status to success
1284: x_return_status := FND_API.G_RET_STS_SUCCESS;
1285:
1286: IF (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
1287: AND (inv_rcv_common_apis.g_po_patch_level >=inv_rcv_common_apis.g_patchset_j_po) THEN
1288: l_patch_level := 1;

Line 2582: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

2578: trace('Starting assign variables, ');
2579: END IF;
2580: l_column_name_list := 'Set variables for ';
2581:
2582: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
2583:
2584: -- Fix for bug: 4179593 Start
2585: l_CustSqlWarnFlagSet := FALSE;
2586: l_CustSqlErrFlagSet := FALSE;

Line 2632: x_return_status := FND_API.G_RET_STS_SUCCESS;

2628: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
2629: END LOOP;
2630:
2631: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
2632: x_return_status := FND_API.G_RET_STS_SUCCESS;
2633: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2634: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2635: fnd_msg_pub.ADD;
2636: -- Fix for bug: 4179593 Start

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

2633: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2634: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2635: fnd_msg_pub.ADD;
2636: -- Fix for bug: 4179593 Start
2637: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2638: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2639: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2640: l_CustSqlWarnFlagSet := TRUE;
2641: -- Fix for bug: 4179593 End

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

2634: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2635: fnd_msg_pub.ADD;
2636: -- Fix for bug: 4179593 Start
2637: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2638: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2639: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2640: l_CustSqlWarnFlagSet := TRUE;
2641: -- Fix for bug: 4179593 End
2642: IF (l_debug = 1) THEN

Line 2653: x_return_status := FND_API.G_RET_STS_SUCCESS;

2649: IF (l_debug = 1) THEN
2650: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 3');
2651: trace('Custom Labels Trace [INVLAP4B.pls]: WARNING: No row returned by the Custom SQL query');
2652: END IF;
2653: x_return_status := FND_API.G_RET_STS_SUCCESS;
2654: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2655: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2656: fnd_msg_pub.ADD;
2657: /* Replaced following statement for Bug 4207625: Anupam Jain*/

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

2654: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2655: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2656: fnd_msg_pub.ADD;
2657: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2658: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2659: -- Fix for bug: 4179593 Start
2660: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2661: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2662: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

2656: fnd_msg_pub.ADD;
2657: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2658: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2659: -- Fix for bug: 4179593 Start
2660: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2661: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2662: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2663: l_CustSqlWarnFlagSet := TRUE;
2664: -- Fix for bug: 4179593 End

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

2657: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2658: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2659: -- Fix for bug: 4179593 Start
2660: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2661: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2662: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2663: l_CustSqlWarnFlagSet := TRUE;
2664: -- Fix for bug: 4179593 End
2665: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 2671: x_return_status := FND_API.G_RET_STS_SUCCESS;

2667: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 4');
2668: trace('Custom Labels Trace [INVLAP4B.pls]: ERROR: Multiple values returned by the Custom SQL query');
2669: END IF;
2670: l_sql_stmt_result := NULL;
2671: x_return_status := FND_API.G_RET_STS_SUCCESS;
2672: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2673: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2674: fnd_msg_pub.ADD;
2675: /* Replaced following statement for Bug 4207625: Anupam Jain*/

Line 2672: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

2668: trace('Custom Labels Trace [INVLAP4B.pls]: ERROR: Multiple values returned by the Custom SQL query');
2669: END IF;
2670: l_sql_stmt_result := NULL;
2671: x_return_status := FND_API.G_RET_STS_SUCCESS;
2672: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2673: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2674: fnd_msg_pub.ADD;
2675: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2676: /*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 2676: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

2672: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2673: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2674: fnd_msg_pub.ADD;
2675: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2676: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2677: -- Fix for bug: 4179593 Start
2678: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2679: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2680: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

2674: fnd_msg_pub.ADD;
2675: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2676: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2677: -- Fix for bug: 4179593 Start
2678: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2679: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2680: l_CustSqlErrMsg := l_custom_sql_ret_msg;
2681: l_CustSqlErrFlagSet := TRUE;
2682: -- Fix for bug: 4179593 End

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

2675: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2676: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2677: -- Fix for bug: 4179593 Start
2678: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2679: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2680: l_CustSqlErrMsg := l_custom_sql_ret_msg;
2681: l_CustSqlErrFlagSet := TRUE;
2682: -- Fix for bug: 4179593 End
2683: END IF;

Line 2696: x_return_status := FND_API.G_RET_STS_ERROR;

2692: IF (l_debug = 1) THEN
2693: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 5');
2694: trace('Custom Labels Trace [INVLAP4B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
2695: END IF;
2696: x_return_status := FND_API.G_RET_STS_ERROR;
2697: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2698: fnd_msg_pub.ADD;
2699: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

2695: END IF;
2696: x_return_status := FND_API.G_RET_STS_ERROR;
2697: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2698: fnd_msg_pub.ADD;
2699: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2701: END;
2702: IF (l_debug = 1) THEN
2703: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 6');

Line 2700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2696: x_return_status := FND_API.G_RET_STS_ERROR;
2697: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
2698: fnd_msg_pub.ADD;
2699: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
2700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2701: END;
2702: IF (l_debug = 1) THEN
2703: trace('Custom Labels Trace [INVLAP4B.pls]: At Breadcrumb 6');
2704: trace('Custom Labels Trace [INVLAP4B.pls]: Before assigning it to l_content_item_data');

Line 3378: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3374: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3375: END IF;
3376:
3377: IF (l_CustSqlErrFlagSet) THEN
3378: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3379: l_custom_sql_ret_msg := l_CustSqlErrMsg;
3380: END IF;
3381: -- Fix for bug: 4179593 End
3382: