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 trunc(sysdate) between nvl(jrs.start_date_active,trunc(sysdate)) --12675100, added trunc on sysdate
6008: and nvl(jrs.end_date_active,trunc(sysdate)); --12675100, added trunc on 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 6024: oe_debug_pub.add('OEXSVATB: p_salesrep_id- '||p_salesrep_id);

6020: Begin
6021:
6022: -- added for bug 12675100, debug messages
6023: if l_debug_level > 0 THEN
6024: oe_debug_pub.add('OEXSVATB: p_salesrep_id- '||p_salesrep_id);
6025: end if;
6026:
6027: --added for bug 4200055
6028: l_salesrep_rec_type := OE_Order_Cache.Load_Salesrep_Rec(p_salesrep_id);

Line 6037: oe_debug_pub.add('OEXSVATB: Salesrep Active');

6033: then
6034: l_is_salesrep_active := 'VALID' ;
6035: -- start debug add 12675100
6036: if l_debug_level > 0 THEN
6037: oe_debug_pub.add('OEXSVATB: Salesrep Active');
6038: end if;-- end debug add 12675100
6039: end if ;
6040: END IF ;
6041:

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

6049: -- bug 5022615
6050: IF l_is_salesrep_active = 'VALID' THEN
6051: --Now check for RTF salesrep table
6052: IF l_debug_level > 0 THEN
6053: oe_debug_pub.add(' Checking rtf 1');
6054: END IF;
6055: OPEN c_jtf_salesrep(p_salesrep_id);
6056: FETCH c_jtf_salesrep into l_dummy;
6057: CLOSE c_jtf_salesrep;

Line 6064: oe_debug_pub.add('OEXSVATB: Salesrep Valid');

6060: IF l_dummy = 'VALID' then
6061:
6062: -- start debug add 12675100
6063: if l_debug_level > 0 THEN
6064: oe_debug_pub.add('OEXSVATB: Salesrep Valid');
6065: end if;
6066:
6067: RETURN TRUE;
6068: ELSE

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

6078: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
6079:
6080: END IF;
6081: IF l_debug_level > 0 THEN
6082: oe_debug_pub.add(' rtf failed 1');
6083: oe_debug_pub.add('OEXSVATB: Salesrep Invalid');
6084: END IF;
6085: RETURN FALSE;
6086: END IF;

Line 6083: oe_debug_pub.add('OEXSVATB: Salesrep Invalid');

6079:
6080: END IF;
6081: IF l_debug_level > 0 THEN
6082: oe_debug_pub.add(' rtf failed 1');
6083: oe_debug_pub.add('OEXSVATB: Salesrep Invalid');
6084: END IF;
6085: RETURN FALSE;
6086: END IF;
6087: ELSE -- if salesrep is inactive

Line 6091: oe_debug_pub.add('Return False, Sales Rep Not Active');

6087: ELSE -- if salesrep is inactive
6088:
6089: -- 12675100 added debug
6090: IF l_debug_level > 0 THEN
6091: oe_debug_pub.add('Return False, Sales Rep Not Active');
6092: end if;
6093: ---start bug# 13657183
6094: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6095: THEN

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

6111:
6112: Exception
6113: When no_data_found then
6114: IF l_debug_level > 0 THEN
6115: oe_debug_pub.add('checking rtf 2');
6116: END IF;
6117: OPEN c_jtf_salesrep(p_salesrep_id);
6118: FETCH c_jtf_salesrep into l_dummy;
6119: CLOSE c_jtf_salesrep;

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

6121: IF l_dummy = 'VALID' then
6122: RETURN TRUE;
6123: ELSE
6124: IF l_debug_level > 0 THEN
6125: oe_debug_pub.add(' rtf failed 2');
6126: END IF;
6127: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
6128: THEN
6129:

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

6875: FUNCTION Preferred_Grade ( p_preferred_grade IN VARCHAR2 )
6876: RETURN BOOLEAN
6877: IS
6878: l_dummy VARCHAR2(10);
6879: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6880: BEGIN
6881:
6882: IF l_debug_level > 0 THEN
6883: oe_debug_pub.add('OPM preferred_grade val in OEXSVATB', 1);

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

6879: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
6880: BEGIN
6881:
6882: IF l_debug_level > 0 THEN
6883: oe_debug_pub.add('OPM preferred_grade val in OEXSVATB', 1);
6884: END IF;
6885: IF p_preferred_grade IS NULL OR
6886: p_preferred_grade = FND_API.G_MISS_CHAR
6887: THEN

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

6923:
6924: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6925: THEN
6926: IF l_debug_level > 0 THEN
6927: oe_debug_pub.add('OPM preferred_grade exception in VATB', 1);
6928: END IF;
6929: OE_MSG_PUB.Add_Exc_Msg
6930: ( G_PKG_NAME
6931: , 'Preferred_Grade'

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

16908:
16909: else
16910: G_RLM_INSTALLED_FLAG := 'N';
16911: end if;
16912: OE_DEBUG_PUB.ADD('OEXSVATB:G_RLM_INSTALLED_FLAG:' || G_RLM_INSTALLED_FLAG);
16913: ***/
16914:
16915: g_context_name := 'INDUSTRY_CONTEXT';
16916: g_attribute1_name := 'INDUSTRY_ATTRIBUTE1';

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

18623: FND_FLEX_DESCVAL.Set_Context_Value
18624: ( context_value => l_column_value);
18625:
18626: IF NOT OE_Validate.Desc_Flex('OE_SALES_CREDITS_ATTRIBUTES') THEN
18627: OE_DEBUG_PUB.add('Error at validation of OE_SALES_CREDITS_ATTRIBUTES ',1);
18628: RETURN FALSE;
18629: END IF;
18630:
18631:

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

19214: IF p_payment_type_code IS NULL OR
19215: p_payment_type_code = FND_API.G_MISS_CHAR OR
19216: p_payment_type_code = 'COMMITMENT' /* Bug #3536642 */
19217: THEN
19218: oe_Debug_Pub.add('Returning True .. ');
19219: RETURN TRUE;
19220: END IF;
19221:
19222: IF OE_PrePayment_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED THEN

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

19395: RETURN BOOLEAN
19396: IS
19397: l_dummy VARCHAR2(10);
19398: l_lookup_type VARCHAR2(80) :='CREDIT_CARD';
19399: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19400: BEGIN
19401:
19402:
19403: IF p_credit_card_code IS NULL OR

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

19406:
19407: RETURN TRUE;
19408: END IF;
19409: --IF l_debug_level > 0 THEN
19410: --oe_debug_pub.add('Credit card code in oe_validate...'||p_Credit_card_code);
19411: --END IF;
19412: /*SELECT 'VALID'
19413: INTO l_dummy
19414: FROM OE_LOOKUPS

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

19424: where card_issuer_code = p_credit_card_code
19425: and rownum=1;
19426:
19427: IF l_debug_level > 0 THEN
19428: oe_debug_pub.add('Value returned from iby table...'||l_dummy);
19429: END IF;
19430:
19431: RETURN TRUE;
19432:

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

19447:
19448: END IF;
19449:
19450: --IF l_debug_level > 0 THEN
19451: --oe_debug_pub.add('No data found in Credit card code in oe_validate...'||p_Credit_card_code);
19452: --END IF;
19453:
19454: RETURN FALSE;
19455:

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

19463: );
19464: END IF;
19465:
19466: --IF l_debug_level > 0 THEN
19467: --oe_debug_pub.add('Others error in Credit card code in oe_validate...'||p_Credit_card_code);
19468: --END IF;
19469:
19470:
19471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

22028: FUNCTION Minisite( p_minisite_id IN NUMBER)
22029: RETURN BOOLEAN
22030: IS
22031: l_sql_stat VARCHAR2(500);
22032: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
22033: x_return_status VARCHAR2(80);
22034: l_dummy NUMBER;
22035: BEGIN
22036:

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

22053: RETURN TRUE;
22054:
22055: /* ELSE
22056: IF l_debug_level > 0 THEN
22057: oe_debug_pub.add('profuct is not installed');
22058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22059: RETURN FALSE;
22060: END IF; */
22061:

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

22084: RETURN FALSE;
22085:
22086: /* WHEN OTHERS THEN
22087: IF l_debug_level > 0 THEN
22088: oe_debug_pub.add('error in calling');
22089: oe_debug_pub.add(sqlerrm);
22090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22091: RETURN FALSE;
22092: END IF; */

Line 22089: oe_debug_pub.add(sqlerrm);

22085:
22086: /* WHEN OTHERS THEN
22087: IF l_debug_level > 0 THEN
22088: oe_debug_pub.add('error in calling');
22089: oe_debug_pub.add(sqlerrm);
22090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22091: RETURN FALSE;
22092: END IF; */
22093:

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

22135:
22136: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
22137: THEN
22138:
22139: OE_DEBUG_PUB.ADD('Validation failed for IB_OWNER in OEXSVATB.pls');
22140: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_OWNER');
22141:
22142: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
22143: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

22196:
22197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
22198: THEN
22199:
22200: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEXSVATB.pls');
22201: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
22202:
22203: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
22204: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

22257:
22258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
22259: THEN
22260:
22261: OE_DEBUG_PUB.ADD('Validation failed for IB_CURRENT_LOCATION in OEXSVATB.pls');
22262: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_CURRENT_LOCATION');
22263:
22264: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
22265: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

23069: ( context_value => l_column_value);
23070: -- Suppressing the validation as payments flexfield is not registered
23071: /*
23072: IF NOT OE_Validate.Desc_Flex('OE_PAYMENTS_ATTRIBUTES') THEN
23073: OE_DEBUG_PUB.add('Error at validation of OE_PAYMENTS_ATTRIBUTES ',1);
23074: RETURN FALSE;
23075: END IF;
23076: */
23077: RETURN TRUE;

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

23646: ( p_charge_periodicity IN VARCHAR2 )
23647: RETURN BOOLEAN
23648: IS
23649: l_uom_class VARCHAR2(10);
23650: l_debug_level CONSTANT NUMBER := OE_DEBUG_PUB.G_DEBUG_LEVEL;
23651: BEGIN
23652:
23653: SELECT uom_class
23654: INTO l_uom_class

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

23656: WHERE uom_code = p_charge_periodicity
23657: AND uom_class = FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY');
23658:
23659: IF l_debug_level > 0 THEN
23660: OE_DEBUG_PUB.Add ('Entering OE_VALIDATE.Charge_Periodicity',1);
23661: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23662: OE_DEBUG_PUB.Add ('UOM Class:'||
23663: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23664: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);

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

23657: AND uom_class = FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY');
23658:
23659: IF l_debug_level > 0 THEN
23660: OE_DEBUG_PUB.Add ('Entering OE_VALIDATE.Charge_Periodicity',1);
23661: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23662: OE_DEBUG_PUB.Add ('UOM Class:'||
23663: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23664: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);
23665: OE_DEBUG_PUB.Add ('Exiting OE_VALIDATE.Charge_Periodicity',1);

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

23658:
23659: IF l_debug_level > 0 THEN
23660: OE_DEBUG_PUB.Add ('Entering OE_VALIDATE.Charge_Periodicity',1);
23661: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23662: OE_DEBUG_PUB.Add ('UOM Class:'||
23663: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23664: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);
23665: OE_DEBUG_PUB.Add ('Exiting OE_VALIDATE.Charge_Periodicity',1);
23666: END IF;

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

23660: OE_DEBUG_PUB.Add ('Entering OE_VALIDATE.Charge_Periodicity',1);
23661: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23662: OE_DEBUG_PUB.Add ('UOM Class:'||
23663: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23664: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);
23665: OE_DEBUG_PUB.Add ('Exiting OE_VALIDATE.Charge_Periodicity',1);
23666: END IF;
23667:
23668: RETURN TRUE;

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

23661: OE_DEBUG_PUB.Add ('Charge Periodicity:'||p_charge_periodicity,3);
23662: OE_DEBUG_PUB.Add ('UOM Class:'||
23663: FND_PROFILE.Value('ONT_UOM_CLASS_CHARGE_PERIODICITY'));
23664: OE_DEBUG_PUB.Add ('Uom class:'||l_uom_class||',returning TRUE',3);
23665: OE_DEBUG_PUB.Add ('Exiting OE_VALIDATE.Charge_Periodicity',1);
23666: END IF;
23667:
23668: RETURN TRUE;
23669:

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

23669:
23670: EXCEPTION
23671: WHEN NO_DATA_FOUND THEN
23672: IF l_debug_level > 0 THEN
23673: OE_DEBUG_PUB.Add ('Charge Periodicity: NO_DATA_FOUND!!',1);
23674: END IF;
23675: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR) THEN
23676: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'CHARGE_PERIODICITY');
23677: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');

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

23683: RETURN FALSE;
23684:
23685: WHEN OTHERS THEN
23686: IF l_debug_level > 0 THEN
23687: OE_DEBUG_PUB.Add ('Charge_Periodicity: OTHERS Exception',1);
23688: END IF;
23689: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
23690: OE_MSG_PUB.Add_Exc_Msg
23691: ( G_PKG_NAME