APPS.RCV_RECEIPTS_QUERY_SV dependencies on FND_API

Line 1101: * x_exist - FND_API.G_TRUE if sql is executed successfully without any error

1097: * Modifies: None
1098: * Effects: Executes a dynamic sql defined in p_query. the value of bind
1099: * variables will be defined in p_val
1100: * Returns:
1101: * x_exist - FND_API.G_TRUE if sql is executed successfully without any error
1102: * FND_API.G_FALSE if sql returns NO_DATA_FOUND
1103: * The procedure raises an exception if p_query returns an error other than
1104: * NO_DATA_FOUND
1105: */

Line 1102: * FND_API.G_FALSE if sql returns NO_DATA_FOUND

1098: * Effects: Executes a dynamic sql defined in p_query. the value of bind
1099: * variables will be defined in p_val
1100: * Returns:
1101: * x_exist - FND_API.G_TRUE if sql is executed successfully without any error
1102: * FND_API.G_FALSE if sql returns NO_DATA_FOUND
1103: * The procedure raises an exception if p_query returns an error other than
1104: * NO_DATA_FOUND
1105: */
1106:

Line 1159: x_exist := FND_API.G_TRUE;

1155: l_progress := '080';
1156: RAISE l_exception;
1157: END IF;
1158:
1159: x_exist := FND_API.G_TRUE;
1160: EXCEPTION
1161: WHEN NO_DATA_FOUND THEN
1162: x_exist := FND_API.G_FALSE;
1163: WHEN OTHERS THEN

Line 1162: x_exist := FND_API.G_FALSE;

1158:
1159: x_exist := FND_API.G_TRUE;
1160: EXCEPTION
1161: WHEN NO_DATA_FOUND THEN
1162: x_exist := FND_API.G_FALSE;
1163: WHEN OTHERS THEN
1164: PO_MESSAGE_S.sql_error('exec_dynamic_sql', l_progress, sqlcode);
1165: RAISE;
1166: END exec_dynamic_sql;