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.

[Home] [Help]

APPS.INV_LABEL_PVT10 dependencies on FND_API

Line 2299: x_return_status := FND_API.G_RET_STS_SUCCESS;

2295: BEGIN
2296: l_debug := INV_LABEL.l_debug;
2297:
2298: -- Initialize return status as success
2299: x_return_status := FND_API.G_RET_STS_SUCCESS;
2300: IF (l_debug = 1) THEN
2301: trace('**In PVT10: Flow Content label**');
2302: trace(' Business_flow: '||p_label_type_info.business_flow_code);
2303: trace(' Transaction ID:'||p_transaction_id);

Line 2316: RAISE FND_API.G_EXC_ERROR;

2312: THEN
2313: IF (l_debug = 1) THEN
2314: trace('Neither p_transaction_id nor p_input_param.transaction_temp_id is passed . ');
2315: END IF;
2316: RAISE FND_API.G_EXC_ERROR;
2317: END IF;
2318: l_counter := 0;
2319: IF p_transaction_identifier IS NULL THEN
2320: l_transaction_identifier := 0;

Line 2614: RAISE FND_API.G_EXC_ERROR;

2610: ELSE
2611: IF (l_debug = 1) THEN
2612: trace(' Invalid transaction_identifier passed '||p_transaction_identifier);
2613: END IF;
2614: RAISE FND_API.G_EXC_ERROR;
2615: END IF;
2616:
2617: IF (l_debug = 1) THEN
2618: trace(' Getting default format selected fields ');

Line 2894: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;

2890: trace('Starting assign variables, ');
2891: END IF;
2892:
2893: /* Modified for Bug 4072474 -start*/
2894: l_custom_sql_ret_status := FND_API.G_RET_STS_SUCCESS;
2895: /* Modified for Bug 4072474 -End*/
2896:
2897: -- Fix for bug: 4179593 Start
2898: l_CustSqlWarnFlagSet := FALSE;

Line 2945: x_return_status := FND_API.G_RET_STS_SUCCESS;

2941: EXIT WHEN c_sql_stmt%notfound OR c_sql_stmt%rowcount >=2;
2942: END LOOP;
2943:
2944: IF (c_sql_stmt%rowcount=1 AND l_sql_stmt_result IS NULL) THEN
2945: x_return_status := FND_API.G_RET_STS_SUCCESS;
2946: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2947: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2948: fnd_msg_pub.ADD;
2949: -- Fix for bug: 4179593 Start

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

2946: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2947: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2948: fnd_msg_pub.ADD;
2949: -- Fix for bug: 4179593 Start
2950: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2951: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2952: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2953: l_CustSqlWarnFlagSet := TRUE;
2954: -- Fix for bug: 4179593 End

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

2947: fnd_message.set_name('WMS','WMS_CS_NULL_VALUE_RETURNED');
2948: fnd_msg_pub.ADD;
2949: -- Fix for bug: 4179593 Start
2950: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2951: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2952: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2953: l_CustSqlWarnFlagSet := TRUE;
2954: -- Fix for bug: 4179593 End
2955:

Line 2967: x_return_status := FND_API.G_RET_STS_SUCCESS;

2963: IF (l_debug = 1) THEN
2964: trace('Custom Labels Trace [INVLA10B.pls]: At Breadcrumb 3');
2965: trace('Custom Labels Trace [INVLA10B.pls]: WARNING: No row returned by the Custom SQL query');
2966: END IF;
2967: x_return_status := FND_API.G_RET_STS_SUCCESS;
2968: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2969: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2970: fnd_msg_pub.ADD;
2971: /* Replaced following statement for Bug 4207625: Anupam Jain*/

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

2968: l_custom_sql_ret_status := INV_LABEL.G_WARNING;
2969: fnd_message.set_name('WMS','WMS_CS_NO_DATA_FOUND');
2970: fnd_msg_pub.ADD;
2971: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2972: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2973: -- Fix for bug: 4179593 Start
2974: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2975: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2976: l_CustSqlWarnMsg := l_custom_sql_ret_msg;

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

2970: fnd_msg_pub.ADD;
2971: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2972: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2973: -- Fix for bug: 4179593 Start
2974: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2975: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2976: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2977: l_CustSqlWarnFlagSet := TRUE;
2978: -- Fix for bug: 4179593 End

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

2971: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2972: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2973: -- Fix for bug: 4179593 Start
2974: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2975: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2976: l_CustSqlWarnMsg := l_custom_sql_ret_msg;
2977: l_CustSqlWarnFlagSet := TRUE;
2978: -- Fix for bug: 4179593 End
2979: ELSIF c_sql_stmt%rowcount>=2 THEN

Line 2985: x_return_status := FND_API.G_RET_STS_SUCCESS;

2981: trace('Custom Labels Trace [INVLA10B.pls]: At Breadcrumb 4');
2982: trace('Custom Labels Trace [INVLA10B.pls]: ERROR: Multiple values returned by the Custom SQL query');
2983: END IF;
2984: l_sql_stmt_result := NULL;
2985: x_return_status := FND_API.G_RET_STS_SUCCESS;
2986: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2987: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2988: fnd_msg_pub.ADD;
2989: /* Replaced following statement for Bug 4207625: Anupam Jain*/

Line 2986: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

2982: trace('Custom Labels Trace [INVLA10B.pls]: ERROR: Multiple values returned by the Custom SQL query');
2983: END IF;
2984: l_sql_stmt_result := NULL;
2985: x_return_status := FND_API.G_RET_STS_SUCCESS;
2986: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2987: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2988: fnd_msg_pub.ADD;
2989: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2990: /*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 2990: /fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);/

2986: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
2987: fnd_message.set_name('WMS','WMS_CS_MULTIPLE_VALUES_RETURN');
2988: fnd_msg_pub.ADD;
2989: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2990: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2991: -- Fix for bug: 4179593 Start
2992: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2993: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2994: l_CustSqlErrMsg := l_custom_sql_ret_msg;

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

2988: fnd_msg_pub.ADD;
2989: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2990: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2991: -- Fix for bug: 4179593 Start
2992: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2993: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2994: l_CustSqlErrMsg := l_custom_sql_ret_msg;
2995: l_CustSqlErrFlagSet := TRUE;
2996: -- Fix for bug: 4179593 End

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

2989: /* Replaced following statement for Bug 4207625: Anupam Jain*/
2990: /*fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_status);*/
2991: -- Fix for bug: 4179593 Start
2992: --fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => l_custom_sql_ret_msg);
2993: l_custom_sql_ret_msg := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2994: l_CustSqlErrMsg := l_custom_sql_ret_msg;
2995: l_CustSqlErrFlagSet := TRUE;
2996: -- Fix for bug: 4179593 End
2997: END IF;

Line 3010: x_return_status := FND_API.G_RET_STS_ERROR;

3006: IF (l_debug = 1) THEN
3007: trace('Custom Labels Trace [INVLA10B.pls]: At Breadcrumb 5');
3008: trace('Custom Labels Trace [INVLA10B.pls]: Unexpected Error has occured in GET_VARIABLES_DATA');
3009: END IF;
3010: x_return_status := FND_API.G_RET_STS_ERROR;
3011: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3012: fnd_msg_pub.ADD;
3013: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

3009: END IF;
3010: x_return_status := FND_API.G_RET_STS_ERROR;
3011: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3012: fnd_msg_pub.ADD;
3013: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3015: END;
3016: IF (l_debug = 1) THEN
3017: trace('Custom Labels Trace [INVLA10B.pls]: At Breadcrumb 6');

Line 3014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3010: x_return_status := FND_API.G_RET_STS_ERROR;
3011: fnd_message.set_name('WMS','WMS_CS_WRONG_SQL_CONSTRUCT');
3012: fnd_msg_pub.ADD;
3013: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
3014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3015: END;
3016: IF (l_debug = 1) THEN
3017: trace('Custom Labels Trace [INVLA10B.pls]: At Breadcrumb 6');
3018: trace('Custom Labels Trace [INVLA10B.pls]: Before assigning it to l_content_item_data');

Line 3074: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;

3070: l_custom_sql_ret_msg := l_CustSqlWarnMsg;
3071: END IF;
3072:
3073: IF (l_CustSqlErrFlagSet) THEN
3074: l_custom_sql_ret_status := FND_API.G_RET_STS_ERROR;
3075: l_custom_sql_ret_msg := l_CustSqlErrMsg;
3076: END IF;
3077: -- Fix for bug: 4179593 End
3078:

Line 3099: WHEN FND_API.G_EXC_ERROR THEN

3095:
3096: END LOOP;
3097:
3098: EXCEPTION
3099: WHEN FND_API.G_EXC_ERROR THEN
3100: x_return_status := FND_API.G_RET_STS_ERROR;
3101:
3102: WHEN SERIAL_EXCEPTION THEN
3103: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3100: x_return_status := FND_API.G_RET_STS_ERROR;

3096: END LOOP;
3097:
3098: EXCEPTION
3099: WHEN FND_API.G_EXC_ERROR THEN
3100: x_return_status := FND_API.G_RET_STS_ERROR;
3101:
3102: WHEN SERIAL_EXCEPTION THEN
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104:

Line 3103: x_return_status := FND_API.G_RET_STS_ERROR;

3099: WHEN FND_API.G_EXC_ERROR THEN
3100: x_return_status := FND_API.G_RET_STS_ERROR;
3101:
3102: WHEN SERIAL_EXCEPTION THEN
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104:
3105: WHEN NO_FLOW_DATA_FOUND_X THEN
3106: x_return_status := FND_API.G_RET_STS_ERROR;
3107:

Line 3106: x_return_status := FND_API.G_RET_STS_ERROR;

3102: WHEN SERIAL_EXCEPTION THEN
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104:
3105: WHEN NO_FLOW_DATA_FOUND_X THEN
3106: x_return_status := FND_API.G_RET_STS_ERROR;
3107:
3108: WHEN NO_LABEL_FORMAT_FOUND_X THEN
3109: FND_MESSAGE.SET_NAME('WMS', 'WMS_LABL_NO_LABEL_CREATED');
3110: FND_MSG_PUB.ADD;

Line 3111: x_return_status := FND_API.G_RET_STS_ERROR;

3107:
3108: WHEN NO_LABEL_FORMAT_FOUND_X THEN
3109: FND_MESSAGE.SET_NAME('WMS', 'WMS_LABL_NO_LABEL_CREATED');
3110: FND_MSG_PUB.ADD;
3111: x_return_status := FND_API.G_RET_STS_ERROR;
3112:
3113:
3114:
3115: END get_variable_data;