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

Line 863: x_return_status := fnd_api.g_ret_sts_success;

859: v_wip_content wip_content_cur%ROWTYPE;
860: BEGIN
861: l_debug := inv_label.l_debug;
862: -- Initialize return status as success
863: x_return_status := fnd_api.g_ret_sts_success;
864:
865: IF (l_debug = 1) THEN
866: TRACE('**In PVT9: Wip Content label**');
867: TRACE(' Business_flow: ' || p_label_type_info.business_flow_code);

Line 1258: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

1254:
1255: l_column_name_list := 'Set variables for ';
1256:
1257: /* Modified for Bug 4072474 -start*/
1258: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
1259: /* Modified for Bug 4072474 -End*/
1260:
1261: -- Fix for bug: 4179593 Start
1262: l_CustSqlWarnFlagSet := FALSE;

Line 1310: x_return_status := FND_API.G_RET_STS_SUCCESS;

1306: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
1307: END LOOP;
1308:
1309: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1312:
1313: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1314: fnd_msg_pub.ADD;

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

1312:
1313: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1314: fnd_msg_pub.ADD;
1315: -- Fix for bug: 4179593 Start
1316: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1317: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1318: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1319: l_CustSqlWarnFlagSet := TRUE;
1320: -- Fix for bug: 4179593 End

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

1313: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
1314: fnd_msg_pub.ADD;
1315: -- Fix for bug: 4179593 Start
1316: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1317: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1318: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1319: l_CustSqlWarnFlagSet := TRUE;
1320: -- Fix for bug: 4179593 End
1321: IF (l_debug = 1) THEN

Line 1332: x_return_status := FND_API.G_RET_STS_SUCCESS;

1328: IF (l_debug = 1) THEN
1329: trace('Custom Labels Trace [INVLAP9B.pls]: At Breadcrumb 3');
1330: trace('Custom Labels Trace [INVLAP9B.pls]: WARNING: No row returned by the Custom SQL query');
1331: END IF;
1332: x_return_status := FND_API.G_RET_STS_SUCCESS;
1333: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
1334:
1335: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
1336: fnd_msg_pub.ADD;

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

1334:
1335: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
1336: fnd_msg_pub.ADD;
1337: /* Replaced following statement for Bug 4207625: Anupam Jain*/
1338: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
1339: -- Fix for bug: 4179593 Start
1340: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1341: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1342: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

1336: fnd_msg_pub.ADD;
1337: /* Replaced following statement for Bug 4207625: Anupam Jain*/
1338: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
1339: -- Fix for bug: 4179593 Start
1340: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1341: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1342: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1343: l_CustSqlWarnFlagSet := TRUE;
1344: -- Fix for bug: 4179593 End

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

1337: /* Replaced following statement for Bug 4207625: Anupam Jain*/
1338: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
1339: -- Fix for bug: 4179593 Start
1340: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1341: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1342: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
1343: l_CustSqlWarnFlagSet := TRUE;
1344: -- Fix for bug: 4179593 End
1345: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 1351: x_return_status := FND_API.G_RET_STS_SUCCESS;

1347: trace('Custom Labels Trace [INVLAP9B.pls]: At Breadcrumb 4');
1348: trace('Custom Labels Trace [INVLAP9B.pls]: ERROR: Multiple values returned by the Custom SQL query');
1349: END IF;
1350: l_sql_stmt_result := NULL;
1351: x_return_status := FND_API.G_RET_STS_SUCCESS;
1352: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1353: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1354: fnd_msg_pub.ADD;
1355: /* Replaced following statement for Bug 4207625: Anupam Jain*/

Line 1352: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

1348: trace('Custom Labels Trace [INVLAP9B.pls]: ERROR: Multiple values returned by the Custom SQL query');
1349: END IF;
1350: l_sql_stmt_result := NULL;
1351: x_return_status := FND_API.G_RET_STS_SUCCESS;
1352: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1353: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1354: fnd_msg_pub.ADD;
1355: /* Replaced following statement for Bug 4207625: Anupam Jain*/
1356: /*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 1356: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

1352: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
1353: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
1354: fnd_msg_pub.ADD;
1355: /* Replaced following statement for Bug 4207625: Anupam Jain*/
1356: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
1357: -- Fix for bug: 4179593 Start
1358: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1359: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1360: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

1354: fnd_msg_pub.ADD;
1355: /* Replaced following statement for Bug 4207625: Anupam Jain*/
1356: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
1357: -- Fix for bug: 4179593 Start
1358: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1359: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1360: l_CustSqlErrMsg := l_custom_sql_ret_msg;
1361: l_CustSqlErrFlagSet := TRUE;
1362: -- Fix for bug: 4179593 End

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

1355: /* Replaced following statement for Bug 4207625: Anupam Jain*/
1356: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
1357: -- Fix for bug: 4179593 Start
1358: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
1359: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1360: l_CustSqlErrMsg := l_custom_sql_ret_msg;
1361: l_CustSqlErrFlagSet := TRUE;
1362: -- Fix for bug: 4179593 End
1363: END IF;

Line 1376: x_return_status := FND_API.G_RET_STS_ERROR;

1372: IF (l_debug = 1) THEN
1373: trace('Custom Labels Trace [INVLAP9B.pls]: At Breadcrumb 5');
1374: trace('Custom Labels Trace [INVLAP9B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
1375: END IF;
1376: x_return_status := FND_API.G_RET_STS_ERROR;
1377: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
1378: fnd_msg_pub.ADD;
1379: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1375: END IF;
1376: x_return_status := FND_API.G_RET_STS_ERROR;
1377: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
1378: fnd_msg_pub.ADD;
1379: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1381: END;
1382: IF (l_debug = 1) THEN
1383: trace('Custom Labels Trace [INVLAP9B.pls]: At Breadcrumb 6');

Line 1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1376: x_return_status := FND_API.G_RET_STS_ERROR;
1377: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
1378: fnd_msg_pub.ADD;
1379: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1381: END;
1382: IF (l_debug = 1) THEN
1383: trace('Custom Labels Trace [INVLAP9B.pls]: At Breadcrumb 6');
1384: trace('Custom Labels Trace [INVLAP9B.pls]: Before assigning it to l_content_item_data');

Line 2739: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

2735: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
2736: END IF;
2737:
2738: IF (l_CustSqlErrFlagSet) THEN
2739: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2740: l_custom_sql_ret_msg := l_CustSqlErrMsg;
2741: END IF;
2742: -- Fix for bug: 4179593 End
2743: