DBA Data[Home] [Help]

APPS.POS_EXCELASN_PVT dependencies on FND_LOG

Line 1102: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1098: )
1099: where org_id is not null
1100: and po_release_num is null;
1101: EXCEPTION WHEN OTHERS THEN
1102: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1103: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_EXCELASN_PVT.ValidateLines.invoked','Exception');
1104: END IF;
1105: END;
1106: select count(1) into l_error_ln from pos_exasn_lines where po_line_location_id is null;

Line 1103: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_EXCELASN_PVT.ValidateLines.invoked','Exception');

1099: where org_id is not null
1100: and po_release_num is null;
1101: EXCEPTION WHEN OTHERS THEN
1102: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1103: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_EXCELASN_PVT.ValidateLines.invoked','Exception');
1104: END IF;
1105: END;
1106: select count(1) into l_error_ln from pos_exasn_lines where po_line_location_id is null;
1107:

Line 1289: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1285: END LOOP;
1286:
1287: IF(l_vendor_id_not_secured = 'T') THEN
1288:
1289: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1290: FND_LOG.string( LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1291: MODULE =>'pos.plsql.pos_asn_create_pvt.ValidateLines',
1292: MESSAGE => 'Line : ' || l_error_ln || 'Vendor Id: ' ||
1293: l_vendor_id||' is not secured');

Line 1290: FND_LOG.string( LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

1286:
1287: IF(l_vendor_id_not_secured = 'T') THEN
1288:
1289: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1290: FND_LOG.string( LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
1291: MODULE =>'pos.plsql.pos_asn_create_pvt.ValidateLines',
1292: MESSAGE => 'Line : ' || l_error_ln || 'Vendor Id: ' ||
1293: l_vendor_id||' is not secured');
1294: END IF;

Line 1440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1436: end if;
1437: END IF;
1438: END IF;
1439: EXCEPTION WHEN OTHERS THEN
1440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_EXCELASN_PVT.ValidateLines.invoked','Exception');
1442: END IF;
1443: END;
1444:

Line 1441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_EXCELASN_PVT.ValidateLines.invoked','Exception');

1437: END IF;
1438: END IF;
1439: EXCEPTION WHEN OTHERS THEN
1440: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1441: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, 'pos.plsql.POS_EXCELASN_PVT.ValidateLines.invoked','Exception');
1442: END IF;
1443: END;
1444:
1445: if ( l_outsourced_assembly = 1 ) then

Line 4013: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

4009:
4010: x_user_vendor_id_tbl(l_index) := l_user_vendor_id;
4011: l_index := l_index+1;
4012:
4013: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4014: FND_LOG.string( LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
4015: MODULE => 'pos.plsql.pos_asn_create_pvt.CheckSecuringAtt',
4016: MESSAGE => 'Retrieved Vendor Id ' || l_index || ':' ||
4017: l_user_vendor_id);

Line 4014: FND_LOG.string( LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

4010: x_user_vendor_id_tbl(l_index) := l_user_vendor_id;
4011: l_index := l_index+1;
4012:
4013: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4014: FND_LOG.string( LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
4015: MODULE => 'pos.plsql.pos_asn_create_pvt.CheckSecuringAtt',
4016: MESSAGE => 'Retrieved Vendor Id ' || l_index || ':' ||
4017: l_user_vendor_id);
4018: END IF;

Line 4024: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

4020: END LOOP;
4021:
4022: EXCEPTION
4023: WHEN NO_DATA_FOUND THEN
4024: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4025: FND_LOG.string( LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
4026: MODULE => 'pos.plsql.pos_asn_create_pvt.CheckSecuringAtt',
4027: MESSAGE => 'No data found for cursor: l_vendorId_csr');
4028: END IF;

Line 4025: FND_LOG.string( LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,

4021:
4022: EXCEPTION
4023: WHEN NO_DATA_FOUND THEN
4024: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
4025: FND_LOG.string( LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE,
4026: MODULE => 'pos.plsql.pos_asn_create_pvt.CheckSecuringAtt',
4027: MESSAGE => 'No data found for cursor: l_vendorId_csr');
4028: END IF;
4029: