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.IBY_CREDITCARD_PKG dependencies on IBY_DEBUG_PUB

Line 834: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

830:
831: l_dbg_mod VARCHAR2(100) := 'iby.plsql.IBY_CREDITCARD_PKG' || '.' || 'Update_Card';
832:
833: BEGIN
834: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
835: l_allow_invalid_card := NVL(p_allow_invalid_card, 'N');
836: IF (NOT p_pcard_type IS NULL) THEN
837: IF (iby_utility_pvt.check_lookup_val(p_pcard_type,G_LKUP_PCARD_TYPE)) THEN
838: x_result_code := G_RC_INVALID_PCARD_TYPE;

Line 885: /* iby_debug_pub.add('expiry date passed as:'||p_expiry_date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

881: END IF;
882: END IF;
883:
884: -- To be removed
885: /* iby_debug_pub.add('expiry date passed as:'||p_expiry_date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
886: iby_debug_pub.add('holder name:'||p_holder_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
887: IF(p_holder_name = FND_API.G_MISS_CHAR)THEN
888: iby_debug_pub.add('holder name is FND_API.G_MISS_CHAR.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
889: END IF;*/

Line 886: iby_debug_pub.add('holder name:'||p_holder_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

882: END IF;
883:
884: -- To be removed
885: /* iby_debug_pub.add('expiry date passed as:'||p_expiry_date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
886: iby_debug_pub.add('holder name:'||p_holder_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
887: IF(p_holder_name = FND_API.G_MISS_CHAR)THEN
888: iby_debug_pub.add('holder name is FND_API.G_MISS_CHAR.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
889: END IF;*/
890: ---------------------

Line 888: iby_debug_pub.add('holder name is FND_API.G_MISS_CHAR.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

884: -- To be removed
885: /* iby_debug_pub.add('expiry date passed as:'||p_expiry_date,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
886: iby_debug_pub.add('holder name:'||p_holder_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
887: IF(p_holder_name = FND_API.G_MISS_CHAR)THEN
888: iby_debug_pub.add('holder name is FND_API.G_MISS_CHAR.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
889: END IF;*/
890: ---------------------
891:
892: -- Bug 5479785 (Panaraya)

Line 916: IF(iby_debug_pub.G_LEVEL_INFO >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN

912: l_chname_mask_setting, l_chname_unmask_len
913: FROM iby_creditcard
914: WHERE instrid = p_instr_id;
915:
916: IF(iby_debug_pub.G_LEVEL_INFO >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
917: iby_debug_pub.add('expiry_sec_segment_id:'||l_expdate_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
918: iby_debug_pub.add('chname_sec_segment_id:'||l_chname_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
919: iby_debug_pub.add('chname_unmask_length:'||l_chname_unmask_len,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
920: END IF;

Line 917: iby_debug_pub.add('expiry_sec_segment_id:'||l_expdate_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

913: FROM iby_creditcard
914: WHERE instrid = p_instr_id;
915:
916: IF(iby_debug_pub.G_LEVEL_INFO >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
917: iby_debug_pub.add('expiry_sec_segment_id:'||l_expdate_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
918: iby_debug_pub.add('chname_sec_segment_id:'||l_chname_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
919: iby_debug_pub.add('chname_unmask_length:'||l_chname_unmask_len,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
920: END IF;
921:

Line 918: iby_debug_pub.add('chname_sec_segment_id:'||l_chname_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

914: WHERE instrid = p_instr_id;
915:
916: IF(iby_debug_pub.G_LEVEL_INFO >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
917: iby_debug_pub.add('expiry_sec_segment_id:'||l_expdate_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
918: iby_debug_pub.add('chname_sec_segment_id:'||l_chname_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
919: iby_debug_pub.add('chname_unmask_length:'||l_chname_unmask_len,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
920: END IF;
921:
922: -- If a masked chname is passed then ignore this for update

Line 919: iby_debug_pub.add('chname_unmask_length:'||l_chname_unmask_len,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

915:
916: IF(iby_debug_pub.G_LEVEL_INFO >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
917: iby_debug_pub.add('expiry_sec_segment_id:'||l_expdate_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
918: iby_debug_pub.add('chname_sec_segment_id:'||l_chname_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
919: iby_debug_pub.add('chname_unmask_length:'||l_chname_unmask_len,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
920: END IF;
921:
922: -- If a masked chname is passed then ignore this for update
923: l_chname := p_holder_name;

Line 952: iby_debug_pub.add('chname passed: G_MISS_CHAR',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

948: END IF;
949:
950: /*
951: IF (p_holder_name = FND_API.G_MISS_CHAR) THEN
952: iby_debug_pub.add('chname passed: G_MISS_CHAR',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
953: END IF;
954: iby_debug_pub.add('chname passed:'||p_holder_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
955: */
956:

Line 954: iby_debug_pub.add('chname passed:'||p_holder_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

950: /*
951: IF (p_holder_name = FND_API.G_MISS_CHAR) THEN
952: iby_debug_pub.add('chname passed: G_MISS_CHAR',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
953: END IF;
954: iby_debug_pub.add('chname passed:'||p_holder_name,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
955: */
956:
957: -- No need for the http request if the expiry date and chname
958: -- are not expected to be updated

Line 975: iby_debug_pub.add('Error during http call out',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);

971: l_msg_data,
972: l_resp_rec
973: );
974: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
975: iby_debug_pub.add('Error during http call out',iby_debug_pub.G_LEVEL_ERROR,l_dbg_mod);
976: x_result_code := FND_API.G_RET_STS_ERROR;
977: RETURN;
978: END IF;
979:

Line 988: IF(iby_debug_pub.G_LEVEL_INFO >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN

984: l_chname_unmask_len := l_resp_rec.ChnameUnmaskLength;
985:
986: l_expiry_date := NULL;
987:
988: IF(iby_debug_pub.G_LEVEL_INFO >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
989: iby_debug_pub.add('l_masked_chname(2):'||l_masked_chname,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
990: iby_debug_pub.add('expiry_sec_segment_id(2):'||l_chname_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
991: iby_debug_pub.add('chname_sec_segment_id(2):'||l_expdate_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
992: iby_debug_pub.add('chname_unmask_length(2):'||l_chname_unmask_len,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 989: iby_debug_pub.add('l_masked_chname(2):'||l_masked_chname,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

985:
986: l_expiry_date := NULL;
987:
988: IF(iby_debug_pub.G_LEVEL_INFO >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
989: iby_debug_pub.add('l_masked_chname(2):'||l_masked_chname,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
990: iby_debug_pub.add('expiry_sec_segment_id(2):'||l_chname_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
991: iby_debug_pub.add('chname_sec_segment_id(2):'||l_expdate_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
992: iby_debug_pub.add('chname_unmask_length(2):'||l_chname_unmask_len,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
993: END IF;

Line 990: iby_debug_pub.add('expiry_sec_segment_id(2):'||l_chname_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

986: l_expiry_date := NULL;
987:
988: IF(iby_debug_pub.G_LEVEL_INFO >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
989: iby_debug_pub.add('l_masked_chname(2):'||l_masked_chname,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
990: iby_debug_pub.add('expiry_sec_segment_id(2):'||l_chname_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
991: iby_debug_pub.add('chname_sec_segment_id(2):'||l_expdate_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
992: iby_debug_pub.add('chname_unmask_length(2):'||l_chname_unmask_len,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
993: END IF;
994:

Line 991: iby_debug_pub.add('chname_sec_segment_id(2):'||l_expdate_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

987:
988: IF(iby_debug_pub.G_LEVEL_INFO >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
989: iby_debug_pub.add('l_masked_chname(2):'||l_masked_chname,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
990: iby_debug_pub.add('expiry_sec_segment_id(2):'||l_chname_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
991: iby_debug_pub.add('chname_sec_segment_id(2):'||l_expdate_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
992: iby_debug_pub.add('chname_unmask_length(2):'||l_chname_unmask_len,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
993: END IF;
994:
995: ELSE

Line 992: iby_debug_pub.add('chname_unmask_length(2):'||l_chname_unmask_len,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

988: IF(iby_debug_pub.G_LEVEL_INFO >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
989: iby_debug_pub.add('l_masked_chname(2):'||l_masked_chname,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
990: iby_debug_pub.add('expiry_sec_segment_id(2):'||l_chname_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
991: iby_debug_pub.add('chname_sec_segment_id(2):'||l_expdate_sec_segment_id,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
992: iby_debug_pub.add('chname_unmask_length(2):'||l_chname_unmask_len,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
993: END IF;
994:
995: ELSE
996: iby_debug_pub.add('Skipping http callout..',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 996: iby_debug_pub.add('Skipping http callout..',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

992: iby_debug_pub.add('chname_unmask_length(2):'||l_chname_unmask_len,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
993: END IF;
994:
995: ELSE
996: iby_debug_pub.add('Skipping http callout..',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
997: END IF;
998:
999: ELSE
1000: --l_encrypted := 'N';

Line 1129: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

1125: WHERE instrid = ci_instrid
1126: AND c.cc_issuer_range_id = r.cc_issuer_range_id(+);
1127:
1128: BEGIN
1129: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1130:
1131: -- Hold the newly supplied issuer code in a temporary variable
1132: -- and initialize the out parameter to NULL
1133: l_temp_issuer := x_issuer;

Line 1143: iby_debug_pub.add('old invalid_flag:'||x_invalid_flag,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1139: FETCH c_card INTO x_invalid_flag, x_invalidation_reason,
1140: l_expired, l_card_issuer1, l_card_issuer2;
1141: CLOSE c_card;
1142:
1143: iby_debug_pub.add('old invalid_flag:'||x_invalid_flag,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1144: iby_debug_pub.add('old invalidation_reason:'||x_invalidation_reason,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1145:
1146: -- Card number is immutable. So, an invalid card number cannot be corrected.
1147: IF(NVL(x_invalidation_reason, 'VALID') = G_RC_INVALID_CCNUMBER)THEN

Line 1144: iby_debug_pub.add('old invalidation_reason:'||x_invalidation_reason,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1140: l_expired, l_card_issuer1, l_card_issuer2;
1141: CLOSE c_card;
1142:
1143: iby_debug_pub.add('old invalid_flag:'||x_invalid_flag,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1144: iby_debug_pub.add('old invalidation_reason:'||x_invalidation_reason,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1145:
1146: -- Card number is immutable. So, an invalid card number cannot be corrected.
1147: IF(NVL(x_invalidation_reason, 'VALID') = G_RC_INVALID_CCNUMBER)THEN
1148: iby_debug_pub.add('existing record is invalid due to '||x_invalidation_reason,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

Line 1148: iby_debug_pub.add('existing record is invalid due to '||x_invalidation_reason,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1144: iby_debug_pub.add('old invalidation_reason:'||x_invalidation_reason,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1145:
1146: -- Card number is immutable. So, an invalid card number cannot be corrected.
1147: IF(NVL(x_invalidation_reason, 'VALID') = G_RC_INVALID_CCNUMBER)THEN
1148: iby_debug_pub.add('existing record is invalid due to '||x_invalidation_reason,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1149: RETURN;
1150: END IF ;
1151:
1152: -- Re-set the values to null assuming that the record is valid

Line 1156: iby_debug_pub.add('validating card expiry',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1152: -- Re-set the values to null assuming that the record is valid
1153: x_invalid_flag := NULL;
1154: x_invalidation_reason := NULL;
1155:
1156: iby_debug_pub.add('validating card expiry',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1157: IF (NVL(l_expired,'N') = 'Y')THEN
1158: iby_debug_pub.add('card has invalid expiry!',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1159: x_invalid_flag := 'Y';
1160: x_invalidation_reason := G_RC_INVALID_CCEXPIRY;

Line 1158: iby_debug_pub.add('card has invalid expiry!',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1154: x_invalidation_reason := NULL;
1155:
1156: iby_debug_pub.add('validating card expiry',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1157: IF (NVL(l_expired,'N') = 'Y')THEN
1158: iby_debug_pub.add('card has invalid expiry!',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1159: x_invalid_flag := 'Y';
1160: x_invalidation_reason := G_RC_INVALID_CCEXPIRY;
1161: RETURN;
1162: END IF ;

Line 1164: iby_debug_pub.add('validating card issuer',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1160: x_invalidation_reason := G_RC_INVALID_CCEXPIRY;
1161: RETURN;
1162: END IF ;
1163:
1164: iby_debug_pub.add('validating card issuer',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1165: IF (NVL(l_card_issuer1,'UNKNOWN') <> NVL(l_card_issuer2, 'UNKNOWN'))THEN
1166: iby_debug_pub.add('card has invalid issuer!',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1167:
1168: -- Check if a new issuer_code is supplied to the API

Line 1166: iby_debug_pub.add('card has invalid issuer!',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1162: END IF ;
1163:
1164: iby_debug_pub.add('validating card issuer',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1165: IF (NVL(l_card_issuer1,'UNKNOWN') <> NVL(l_card_issuer2, 'UNKNOWN'))THEN
1166: iby_debug_pub.add('card has invalid issuer!',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1167:
1168: -- Check if a new issuer_code is supplied to the API
1169: -- If it is supplied then does it make the record valid
1170: IF (l_temp_issuer IS NOT NULL AND l_temp_issuer <> FND_API.G_MISS_CHAR) THEN

Line 1172: iby_debug_pub.add('New card issuer makes the record valid.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

1168: -- Check if a new issuer_code is supplied to the API
1169: -- If it is supplied then does it make the record valid
1170: IF (l_temp_issuer IS NOT NULL AND l_temp_issuer <> FND_API.G_MISS_CHAR) THEN
1171: IF (l_temp_issuer = NVL(l_card_issuer2, 'UNKNOWN'))THEN
1172: iby_debug_pub.add('New card issuer makes the record valid.',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1173: x_issuer := l_temp_issuer;
1174: ELSE
1175: x_invalid_flag := 'Y';
1176: x_invalidation_reason := G_RC_INVALID_CARD_ISSUER;

Line 1186: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

1182: RETURN;
1183: END IF ;
1184: END IF ;
1185:
1186: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1187: END check_card_validity;
1188:
1189: FUNCTION uncipher_ccnumber
1190: (p_instrid IN iby_creditcard.instrid%TYPE,

Line 1533: iby_debug_pub.add('Could not encrypt the record ' || c_card_rec.instrid,IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);

1529: last_updated_by = fnd_global.user_id,
1530: last_update_login = fnd_global.login_id
1531: WHERE (instrid = c_card_rec.instrid);
1532: ELSE
1533: iby_debug_pub.add('Could not encrypt the record ' || c_card_rec.instrid,IBY_DEBUG_PUB.G_LEVEL_INFO,l_dbg_mod);
1534: END IF;
1535: END LOOP;
1536:
1537: IF FND_API.to_Boolean( p_commit ) THEN

Line 2086: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

2082: SELECT instrid, expirydate, expiry_sec_segment_id
2083: FROM iby_creditcard
2084: WHERE (NVL(expired_flag,'N') <> 'Y');
2085: BEGIN
2086: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2087: IF (c_card%ISOPEN) THEN CLOSE c_card; END IF;
2088: --check_key(p_sys_sec_key);
2089:
2090: FOR c_card_rec IN c_card LOOP

Line 2096: iby_debug_pub.add('At least one encrypted record. Verifying syskey..',

2092: -- Verify the syskey only if there is atleast one
2093: -- encrypted record.
2094: -- Also we require the syskey to be checked only once
2095: IF(syskey_checked = 'N') THEN
2096: iby_debug_pub.add('At least one encrypted record. Verifying syskey..',
2097: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2098: check_key(p_sys_sec_key);
2099: syskey_checked := 'Y';
2100: END IF;

Line 2097: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2093: -- encrypted record.
2094: -- Also we require the syskey to be checked only once
2095: IF(syskey_checked = 'N') THEN
2096: iby_debug_pub.add('At least one encrypted record. Verifying syskey..',
2097: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2098: check_key(p_sys_sec_key);
2099: syskey_checked := 'Y';
2100: END IF;
2101:

Line 2130: iby_debug_pub.add('No. of records updated = '||cnt,

2126: -- This count variable is only for logging purposes
2127: cnt := cnt + 1;
2128:
2129: END LOOP;
2130: iby_debug_pub.add('No. of records updated = '||cnt,
2131: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2132:
2133: IF FND_API.to_Boolean( p_commit ) THEN
2134: COMMIT;

Line 2131: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2127: cnt := cnt + 1;
2128:
2129: END LOOP;
2130: iby_debug_pub.add('No. of records updated = '||cnt,
2131: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2132:
2133: IF FND_API.to_Boolean( p_commit ) THEN
2134: COMMIT;
2135: END IF;

Line 2137: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

2133: IF FND_API.to_Boolean( p_commit ) THEN
2134: COMMIT;
2135: END IF;
2136:
2137: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2138:
2139: END Mark_Expired_Cards;
2140:
2141: PROCEDURE Upgrade_Encrypted_Instruments

Line 2170: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

2166: AND ((expirydate IS NOT NULL)
2167: OR
2168: ((chname IS NOT NULL) AND (chname_sec_segment_id IS NULL)));
2169: BEGIN
2170: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2171:
2172: --No point in running this program when the system security setup doesn't allow
2173: -- this.
2174: IF(Other_CC_Attribs_Encrypted = 'N') THEN

Line 2175: iby_debug_pub.add('The system security options do not allow data to be upgraded. Aborting..'

2171:
2172: --No point in running this program when the system security setup doesn't allow
2173: -- this.
2174: IF(Other_CC_Attribs_Encrypted = 'N') THEN
2175: iby_debug_pub.add('The system security options do not allow data to be upgraded. Aborting..'
2176: ,iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2177: RETURN;
2178: END IF;
2179: IF (c_card%ISOPEN) THEN CLOSE c_card; END IF;

Line 2176: ,iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

2172: --No point in running this program when the system security setup doesn't allow
2173: -- this.
2174: IF(Other_CC_Attribs_Encrypted = 'N') THEN
2175: iby_debug_pub.add('The system security options do not allow data to be upgraded. Aborting..'
2176: ,iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2177: RETURN;
2178: END IF;
2179: IF (c_card%ISOPEN) THEN CLOSE c_card; END IF;
2180: check_key(p_sys_sec_key);

Line 2234: iby_debug_pub.add('No. of records updated = '|| no_cc,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);

2230: l_exp_segment_id := null;
2231: l_expired_flag := null;
2232:
2233: END LOOP;
2234: iby_debug_pub.add('No. of records updated = '|| no_cc,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2235: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2236: END Upgrade_Encrypted_Instruments;
2237:
2238:

Line 2235: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);

2231: l_expired_flag := null;
2232:
2233: END LOOP;
2234: iby_debug_pub.add('No. of records updated = '|| no_cc,iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2235: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2236: END Upgrade_Encrypted_Instruments;
2237:
2238:
2239: PROCEDURE Check_CC_Expiry