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.OE_VALIDATE dependencies on OE_DEBUG_PUB

Line 5304: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

5300:
5301: FUNCTION Change_Reason_Code(p_Change_Reason_Code IN VARCHAR2) RETURN BOOLEAN
5302: IS
5303: l_dummy VARCHAR2(10);
5304: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
5305: l_lookup_type VARCHAR2(80) :='CANCEL_CODE';
5306: BEGIN
5307:
5308: IF p_Change_Reason_Code IS NULL OR

Line 5329: OE_DEBUG_PUB.add('Change/Cancel Reason Code is invalid ',1);

5325: EXCEPTION
5326:
5327: WHEN NO_DATA_FOUND THEN
5328: IF l_debug_level > 0 THEN
5329: OE_DEBUG_PUB.add('Change/Cancel Reason Code is invalid ',1);
5330: OE_DEBUG_PUB.add('Error Message at 1 : '||sqlerrm,1);
5331: END IF;
5332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
5333: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_CODE');

Line 5330: OE_DEBUG_PUB.add('Error Message at 1 : '||sqlerrm,1);

5326:
5327: WHEN NO_DATA_FOUND THEN
5328: IF l_debug_level > 0 THEN
5329: OE_DEBUG_PUB.add('Change/Cancel Reason Code is invalid ',1);
5330: OE_DEBUG_PUB.add('Error Message at 1 : '||sqlerrm,1);
5331: END IF;
5332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
5333: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHANGE_REASON_CODE');
5334: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

Line 5342: OE_DEBUG_PUB.add('Change/Cancel Reason Code is invalid ',1);

5338: END IF;
5339: RETURN FALSE;
5340: WHEN OTHERS THEN
5341: IF l_debug_level > 0 THEN
5342: OE_DEBUG_PUB.add('Change/Cancel Reason Code is invalid ',1);
5343: OE_DEBUG_PUB.add('Error Message at 2 : '||sqlerrm,1);
5344: END IF;
5345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5346: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'Change_Reason_Code');

Line 5343: OE_DEBUG_PUB.add('Error Message at 2 : '||sqlerrm,1);

5339: RETURN FALSE;
5340: WHEN OTHERS THEN
5341: IF l_debug_level > 0 THEN
5342: OE_DEBUG_PUB.add('Change/Cancel Reason Code is invalid ',1);
5343: OE_DEBUG_PUB.add('Error Message at 2 : '||sqlerrm,1);
5344: END IF;
5345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5346: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'Change_Reason_Code');
5347: END IF;

Line 6009: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

6005: and b.category in ('EMPLOYEE','OTHER','PARTY','PARTNER','SUPPLIER_CONTACT')
6006: and jrs.org_id =l_org_id
6007: and sysdate between nvl(jrs.start_date_active,sysdate)
6008: and nvl(jrs.end_date_active,sysdate);
6009: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6010:
6011: BEGIN
6012: l_org_id :=mo_global.get_current_org_id ; --for MOAC SQL Changes
6013: IF p_salesrep_id IS NULL OR

Line 6044: oe_debug_pub.add(' Checking rtf 1');

6040: -- bug 5022615
6041: IF l_is_salesrep_active = 'VALID' THEN
6042: --Now check for RTF salesrep table
6043: IF l_debug_level > 0 THEN
6044: oe_debug_pub.add(' Checking rtf 1');
6045: END IF;
6046: OPEN c_jtf_salesrep(p_salesrep_id);
6047: FETCH c_jtf_salesrep into l_dummy;
6048: CLOSE c_jtf_salesrep;

Line 6068: oe_debug_pub.add(' rtf failed 1');

6064: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
6065:
6066: END IF;
6067: IF l_debug_level > 0 THEN
6068: oe_debug_pub.add(' rtf failed 1');
6069: END IF;
6070: RETURN FALSE;
6071: END IF;
6072: ELSE -- if salesrep is inactive

Line 6079: oe_debug_pub.add('checking rtf 2');

6075:
6076: Exception
6077: When no_data_found then
6078: IF l_debug_level > 0 THEN
6079: oe_debug_pub.add('checking rtf 2');
6080: END IF;
6081: OPEN c_jtf_salesrep(p_salesrep_id);
6082: FETCH c_jtf_salesrep into l_dummy;
6083: CLOSE c_jtf_salesrep;

Line 6089: oe_debug_pub.add(' rtf failed 2');

6085: IF l_dummy = 'VALID' then
6086: RETURN TRUE;
6087: ELSE
6088: IF l_debug_level > 0 THEN
6089: oe_debug_pub.add(' rtf failed 2');
6090: END IF;
6091: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6092: THEN
6093:

Line 6843: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

6839: FUNCTION Preferred_Grade ( p_preferred_grade IN VARCHAR2 )
6840: RETURN BOOLEAN
6841: IS
6842: l_dummy VARCHAR2(10);
6843: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6844: BEGIN
6845:
6846: IF l_debug_level > 0 THEN
6847: oe_debug_pub.add('OPM preferred_grade val in OEXSVATB', 1);

Line 6847: oe_debug_pub.add('OPM preferred_grade val in OEXSVATB', 1);

6843: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6844: BEGIN
6845:
6846: IF l_debug_level > 0 THEN
6847: oe_debug_pub.add('OPM preferred_grade val in OEXSVATB', 1);
6848: END IF;
6849: IF p_preferred_grade IS NULL OR
6850: p_preferred_grade = FND_API.G_MISS_CHAR
6851: THEN

Line 6891: oe_debug_pub.add('OPM preferred_grade exception in VATB', 1);

6887:
6888: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6889: THEN
6890: IF l_debug_level > 0 THEN
6891: oe_debug_pub.add('OPM preferred_grade exception in VATB', 1);
6892: END IF;
6893: OE_MSG_PUB.Add_Exc_Msg
6894: ( G_PKG_NAME
6895: , 'Preferred_Grade'

Line 16718: OE_DEBUG_PUB.ADD('OEXSVATB:G_RLM_INSTALLED_FLAG:' || G_RLM_INSTALLED_FLAG);

16714:
16715: else
16716: G_RLM_INSTALLED_FLAG := 'N';
16717: end if;
16718: OE_DEBUG_PUB.ADD('OEXSVATB:G_RLM_INSTALLED_FLAG:' || G_RLM_INSTALLED_FLAG);
16719: ***/
16720:
16721: g_context_name := 'INDUSTRY_CONTEXT';
16722: g_attribute1_name := 'INDUSTRY_ATTRIBUTE1';

Line 18433: OE_DEBUG_PUB.add('Error at validation of OE_SALES_CREDITS_ATTRIBUTES ',1);

18429: FND_FLEX_DESCVAL.Set_Context_Value
18430: ( context_value => l_column_value);
18431:
18432: IF NOT OE_Validate.Desc_Flex('OE_SALES_CREDITS_ATTRIBUTES') THEN
18433: OE_DEBUG_PUB.add('Error at validation of OE_SALES_CREDITS_ATTRIBUTES ',1);
18434: RETURN FALSE;
18435: END IF;
18436:
18437:

Line 19024: oe_Debug_Pub.add('Returning True .. ');

19020: IF p_payment_type_code IS NULL OR
19021: p_payment_type_code = FND_API.G_MISS_CHAR OR
19022: p_payment_type_code = 'COMMITMENT' /* Bug #3536642 */
19023: THEN
19024: oe_Debug_Pub.add('Returning True .. ');
19025: RETURN TRUE;
19026: END IF;
19027:
19028: IF OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED THEN

Line 19205: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

19201: RETURN BOOLEAN
19202: IS
19203: l_dummy VARCHAR2(10);
19204: l_lookup_type VARCHAR2(80) :='CREDIT_CARD';
19205: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19206: BEGIN
19207:
19208:
19209: IF p_credit_card_code IS NULL OR

Line 19216: oe_debug_pub.add('Credit card code in oe_validate...'||p_Credit_card_code);

19212:
19213: RETURN TRUE;
19214: END IF;
19215: IF l_debug_level > 0 THEN
19216: oe_debug_pub.add('Credit card code in oe_validate...'||p_Credit_card_code);
19217: END IF;
19218: /*SELECT 'VALID'
19219: INTO l_dummy
19220: FROM OE_LOOKUPS

Line 19234: oe_debug_pub.add('Value returned from iby table...'||l_dummy);

19230: where card_issuer_code = p_credit_card_code
19231: and rownum=1;
19232:
19233: IF l_debug_level > 0 THEN
19234: oe_debug_pub.add('Value returned from iby table...'||l_dummy);
19235: END IF;
19236:
19237: RETURN TRUE;
19238:

Line 19257: oe_debug_pub.add('No data found in Credit card code in oe_validate...'||p_Credit_card_code);

19253:
19254: END IF;
19255:
19256: IF l_debug_level > 0 THEN
19257: oe_debug_pub.add('No data found in Credit card code in oe_validate...'||p_Credit_card_code);
19258: END IF;
19259:
19260: RETURN FALSE;
19261:

Line 19273: oe_debug_pub.add('Others error in Credit card code in oe_validate...'||p_Credit_card_code);

19269: );
19270: END IF;
19271:
19272: IF l_debug_level > 0 THEN
19273: oe_debug_pub.add('Others error in Credit card code in oe_validate...'||p_Credit_card_code);
19274: END IF;
19275:
19276:
19277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 21838: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

21834: FUNCTION Minisite( p_minisite_id IN NUMBER)
21835: RETURN BOOLEAN
21836: IS
21837: l_sql_stat VARCHAR2(500);
21838: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21839: x_return_status VARCHAR2(80);
21840: l_dummy NUMBER;
21841: BEGIN
21842:

Line 21863: oe_debug_pub.add('profuct is not installed');

21859: RETURN TRUE;
21860:
21861: /* ELSE
21862: IF l_debug_level > 0 THEN
21863: oe_debug_pub.add('profuct is not installed');
21864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21865: RETURN FALSE;
21866: END IF; */
21867:

Line 21894: oe_debug_pub.add('error in calling');

21890: RETURN FALSE;
21891:
21892: /* WHEN OTHERS THEN
21893: IF l_debug_level > 0 THEN
21894: oe_debug_pub.add('error in calling');
21895: oe_debug_pub.add(sqlerrm);
21896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21897: RETURN FALSE;
21898: END IF; */

Line 21895: oe_debug_pub.add(sqlerrm);

21891:
21892: /* WHEN OTHERS THEN
21893: IF l_debug_level > 0 THEN
21894: oe_debug_pub.add('error in calling');
21895: oe_debug_pub.add(sqlerrm);
21896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21897: RETURN FALSE;
21898: END IF; */
21899:

Line 21945: OE_DEBUG_PUB.ADD('Validation failed for IB_OWNER in OEXSVATB.pls');

21941:
21942: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
21943: THEN
21944:
21945: OE_DEBUG_PUB.ADD('Validation failed for IB_OWNER in OEXSVATB.pls');
21946: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_OWNER');
21947:
21948: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
21949: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 22006: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEXSVATB.pls');

22002:
22003: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
22004: THEN
22005:
22006: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEXSVATB.pls');
22007: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
22008:
22009: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
22010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 22067: OE_DEBUG_PUB.ADD('Validation failed for IB_CURRENT_LOCATION in OEXSVATB.pls');

22063:
22064: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
22065: THEN
22066:
22067: OE_DEBUG_PUB.ADD('Validation failed for IB_CURRENT_LOCATION in OEXSVATB.pls');
22068: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_CURRENT_LOCATION');
22069:
22070: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
22071: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

Line 22879: OE_DEBUG_PUB.add('Error at validation of OE_PAYMENTS_ATTRIBUTES ',1);

22875: ( context_value => l_column_value);
22876: -- Suppressing the validation as payments flexfield is not registered
22877: /*
22878: IF NOT OE_Validate.Desc_Flex('OE_PAYMENTS_ATTRIBUTES') THEN
22879: OE_DEBUG_PUB.add('Error at validation of OE_PAYMENTS_ATTRIBUTES ',1);
22880: RETURN FALSE;
22881: END IF;
22882: */
22883: RETURN TRUE;

Line 23456: l_debug_level CONSTANT NUMBER := OE_DEBUG_PUB.G_DEBUG_LEVEL;

23452: ( p_charge_periodicity IN VARCHAR2 )
23453: RETURN BOOLEAN
23454: IS
23455: l_uom_class VARCHAR2(10);
23456: l_debug_level CONSTANT NUMBER := OE_DEBUG_PUB.G_DEBUG_LEVEL;
23457: BEGIN
23458:
23459: SELECT uom_class
23460: INTO l_uom_class

Line 23466: OE_DEBUG_PUB.Add ('Entering OE_VALIDATE.Charge_Periodicity',1);

23462: WHERE uom_code = p_charge_periodicity
23463: AND uom_class = FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY');
23464:
23465: IF l_debug_level > 0 THEN
23466: OE_DEBUG_PUB.Add ('Entering OE_VALIDATE.Charge_Periodicity',1);
23467: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23468: OE_DEBUG_PUB.Add ('UOM Class:'||
23469: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23470: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);

Line 23467: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);

23463: AND uom_class = FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY');
23464:
23465: IF l_debug_level > 0 THEN
23466: OE_DEBUG_PUB.Add ('Entering OE_VALIDATE.Charge_Periodicity',1);
23467: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23468: OE_DEBUG_PUB.Add ('UOM Class:'||
23469: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23470: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);
23471: OE_DEBUG_PUB.Add ('Exiting OE_VALIDATE.Charge_Periodicity',1);

Line 23468: OE_DEBUG_PUB.Add ('UOM Class:'||

23464:
23465: IF l_debug_level > 0 THEN
23466: OE_DEBUG_PUB.Add ('Entering OE_VALIDATE.Charge_Periodicity',1);
23467: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23468: OE_DEBUG_PUB.Add ('UOM Class:'||
23469: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23470: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);
23471: OE_DEBUG_PUB.Add ('Exiting OE_VALIDATE.Charge_Periodicity',1);
23472: END IF;

Line 23470: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);

23466: OE_DEBUG_PUB.Add ('Entering OE_VALIDATE.Charge_Periodicity',1);
23467: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23468: OE_DEBUG_PUB.Add ('UOM Class:'||
23469: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23470: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);
23471: OE_DEBUG_PUB.Add ('Exiting OE_VALIDATE.Charge_Periodicity',1);
23472: END IF;
23473:
23474: RETURN TRUE;

Line 23471: OE_DEBUG_PUB.Add ('Exiting OE_VALIDATE.Charge_Periodicity',1);

23467: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23468: OE_DEBUG_PUB.Add ('UOM Class:'||
23469: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23470: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);
23471: OE_DEBUG_PUB.Add ('Exiting OE_VALIDATE.Charge_Periodicity',1);
23472: END IF;
23473:
23474: RETURN TRUE;
23475:

Line 23479: OE_DEBUG_PUB.Add ('Charge Periodicity: NO_DATA_FOUND!!',1);

23475:
23476: EXCEPTION
23477: WHEN NO_DATA_FOUND THEN
23478: IF l_debug_level > 0 THEN
23479: OE_DEBUG_PUB.Add ('Charge Periodicity: NO_DATA_FOUND!!',1);
23480: END IF;
23481: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
23482: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHARGE_PERIODICITY');
23483: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');

Line 23493: OE_DEBUG_PUB.Add ('Charge_Periodicity: OTHERS Exception',1);

23489: RETURN FALSE;
23490:
23491: WHEN OTHERS THEN
23492: IF l_debug_level > 0 THEN
23493: OE_DEBUG_PUB.Add ('Charge_Periodicity: OTHERS Exception',1);
23494: END IF;
23495: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
23496: OE_MSG_PUB.Add_Exc_Msg
23497: ( G_PKG_NAME