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

Line 182: x_return_status := fnd_api.g_ret_sts_success;

178:
179:
180: BEGIN
181: -- Initialize return status as success
182: x_return_status := fnd_api.g_ret_sts_success;
183: l_debug := inv_label.l_debug;
184: l_label_status := INV_LABEL.G_SUCCESS;
185:
186: IF (l_debug = 1) THEN

Line 307: p_init_msg_list => FND_API.G_FALSE,

303: END IF;
304:
305: GMO_LABEL_MGMT_GRP.GET_PRINT_COUNT(
306: p_api_version => 1.0,
307: p_init_msg_list => FND_API.G_FALSE,
308: x_return_status => l_return_status,
309: x_msg_count => l_msg_count,
310: x_msg_data => l_msg_data,
311: P_WMS_BUSINESS_FLOW_CODE => p_label_type_info.business_flow_code,

Line 441: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

437:
438: l_column_name_list := 'Set variables for ';
439:
440: -- CUSTOM SQL
441: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
442: l_CustSqlWarnFlagSet := FALSE;
443: l_CustSqlErrFlagSet := FALSE;
444: l_CustSqlWarnMsg := NULL;
445: l_CustSqlErrMsg := NULL;

Line 492: x_return_status := FND_API.G_RET_STS_SUCCESS;

488: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
489: END LOOP;
490:
491: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
492: x_return_status := FND_API.G_RET_STS_SUCCESS;
493: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
494: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
495: fnd_msg_pub.ADD;
496: -- Fix for bug: 4179593 Start

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

493: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
494: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
495: fnd_msg_pub.ADD;
496: -- Fix for bug: 4179593 Start
497: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
498: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
499: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
500: l_CustSqlWarnFlagSet := TRUE;
501: -- Fix for bug: 4179593 End

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

494: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
495: fnd_msg_pub.ADD;
496: -- Fix for bug: 4179593 Start
497: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
498: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
499: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
500: l_CustSqlWarnFlagSet := TRUE;
501: -- Fix for bug: 4179593 End
502: IF (l_debug = 1) THEN

Line 513: x_return_status := FND_API.G_RET_STS_SUCCESS;

509: IF (l_debug = 1) THEN
510: trace('Custom Labels Trace [INVLA15B.pls]: At Breadcrumb 3');
511: trace('Custom Labels Trace [INVLA15B.pls]: WARNING: No row returned by the Custom SQL query');
512: END IF;
513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
515: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
516: fnd_msg_pub.ADD;
517: -- Fix for bug: 4179593 Start

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

514: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
515: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
516: fnd_msg_pub.ADD;
517: -- Fix for bug: 4179593 Start
518: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
519: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
520: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
521: l_CustSqlWarnFlagSet := TRUE;
522: -- Fix for bug: 4179593 End

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

515: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
516: fnd_msg_pub.ADD;
517: -- Fix for bug: 4179593 Start
518: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
519: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
520: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
521: l_CustSqlWarnFlagSet := TRUE;
522: -- Fix for bug: 4179593 End
523: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 529: x_return_status := FND_API.G_RET_STS_SUCCESS;

525: trace('Custom Labels Trace [INVLA15B.pls]: At Breadcrumb 4');
526: trace('Custom Labels Trace [INVLA15B.pls]: ERROR: Multiple values returned by the Custom SQL query');
527: END IF;
528: l_sql_stmt_result := NULL;
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
531: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
532: fnd_msg_pub.ADD;
533: -- Fix for bug: 4179593 Start

Line 530: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

526: trace('Custom Labels Trace [INVLA15B.pls]: ERROR: Multiple values returned by the Custom SQL query');
527: END IF;
528: l_sql_stmt_result := NULL;
529: x_return_status := FND_API.G_RET_STS_SUCCESS;
530: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
531: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
532: fnd_msg_pub.ADD;
533: -- Fix for bug: 4179593 Start
534: --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 534: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);

530: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
531: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
532: fnd_msg_pub.ADD;
533: -- Fix for bug: 4179593 Start
534: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
535: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
536: l_CustSqlErrMsg := l_custom_sql_ret_msg;
537: l_CustSqlErrFlagSet := TRUE;
538: -- Fix for bug: 4179593 End

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

531: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
532: fnd_msg_pub.ADD;
533: -- Fix for bug: 4179593 Start
534: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
535: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
536: l_CustSqlErrMsg := l_custom_sql_ret_msg;
537: l_CustSqlErrFlagSet := TRUE;
538: -- Fix for bug: 4179593 End
539: END IF;

Line 552: x_return_status := FND_API.G_RET_STS_ERROR;

548: IF (l_debug = 1) THEN
549: trace('Custom Labels Trace [INVLA15B.pls]: At Breadcrumb 5');
550: trace('Custom Labels Trace [INVLA15B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
551: END IF;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
554: fnd_msg_pub.ADD;
555: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

551: END IF;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
554: fnd_msg_pub.ADD;
555: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END;
558: IF (l_debug = 1) THEN
559: trace('Custom Labels Trace [INVLA15B.pls]: At Breadcrumb 6');

Line 556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

552: x_return_status := FND_API.G_RET_STS_ERROR;
553: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
554: fnd_msg_pub.ADD;
555: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: END;
558: IF (l_debug = 1) THEN
559: trace('Custom Labels Trace [INVLA15B.pls]: At Breadcrumb 6');
560: trace('Custom Labels Trace [INVLA15B.pls]: Before assigning it to l_content_item_data');

Line 811: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

807: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
808: END IF;
809:
810: IF (l_CustSqlErrFlagSet) THEN
811: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
812: l_custom_sql_ret_msg := l_CustSqlErrMsg;
813: END IF;
814: -- Fix for bug: 4179593 End
815: