DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on FND_MESSAGE

Line 347: -- set the fnd message for acceptance clause

343: END IF;
344:
345: CLOSE csr_vendor_token_exists;
346:
347: -- set the fnd message for acceptance clause
348: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_CLAUSE');
349:
350: IF l_customer_token_exists = 'Y' THEN
351: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);

Line 348: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_CLAUSE');

344:
345: CLOSE csr_vendor_token_exists;
346:
347: -- set the fnd message for acceptance clause
348: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_CLAUSE');
349:
350: IF l_customer_token_exists = 'Y' THEN
351: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);
352: END IF;

Line 351: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);

347: -- set the fnd message for acceptance clause
348: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_CLAUSE');
349:
350: IF l_customer_token_exists = 'Y' THEN
351: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);
352: END IF;
353:
354: IF l_vendor_token_exists = 'Y' THEN
355: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);

Line 355: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);

351: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);
352: END IF;
353:
354: IF l_vendor_token_exists = 'Y' THEN
355: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);
356: END IF;
357:
358: l_contract_accept_clause := fnd_message.get;
359:

Line 358: l_contract_accept_clause := fnd_message.get;

354: IF l_vendor_token_exists = 'Y' THEN
355: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);
356: END IF;
357:
358: l_contract_accept_clause := fnd_message.get;
359:
360: -- end debug log
361: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
362: fnd_log.STRING (fnd_log.level_procedure,

Line 498: -- set the fnd message for decline clause

494: END IF;
495:
496: CLOSE csr_vendor_token_exists;
497:
498: -- set the fnd message for decline clause
499: fnd_message.set_name ('OKS', 'OKS_CUST_DECLINE_CLAUSE');
500:
501: IF l_customer_token_exists = 'Y' THEN
502: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);

Line 499: fnd_message.set_name ('OKS', 'OKS_CUST_DECLINE_CLAUSE');

495:
496: CLOSE csr_vendor_token_exists;
497:
498: -- set the fnd message for decline clause
499: fnd_message.set_name ('OKS', 'OKS_CUST_DECLINE_CLAUSE');
500:
501: IF l_customer_token_exists = 'Y' THEN
502: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);
503: END IF;

Line 502: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);

498: -- set the fnd message for decline clause
499: fnd_message.set_name ('OKS', 'OKS_CUST_DECLINE_CLAUSE');
500:
501: IF l_customer_token_exists = 'Y' THEN
502: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);
503: END IF;
504:
505: IF l_vendor_token_exists = 'Y' THEN
506: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);

Line 506: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);

502: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);
503: END IF;
504:
505: IF l_vendor_token_exists = 'Y' THEN
506: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);
507: END IF;
508:
509: l_contract_decline_clause := fnd_message.get;
510:

Line 509: l_contract_decline_clause := fnd_message.get;

505: IF l_vendor_token_exists = 'Y' THEN
506: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);
507: END IF;
508:
509: l_contract_decline_clause := fnd_message.get;
510:
511: -- end debug log
512: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
513: fnd_log.STRING (fnd_log.level_procedure,

Line 1128: -- set the fnd message for email subject

1124:
1125: CLOSE csr_k_number;
1126:
1127: -- build the email subject message
1128: -- set the fnd message for email subject
1129: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_EMAIL_SUB');
1130: fnd_message.set_token ('CONTRACT_NUM', l_contract_number);
1131: l_email_subject := fnd_message.get;
1132:

Line 1129: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_EMAIL_SUB');

1125: CLOSE csr_k_number;
1126:
1127: -- build the email subject message
1128: -- set the fnd message for email subject
1129: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_EMAIL_SUB');
1130: fnd_message.set_token ('CONTRACT_NUM', l_contract_number);
1131: l_email_subject := fnd_message.get;
1132:
1133: -- end debug log

Line 1130: fnd_message.set_token ('CONTRACT_NUM', l_contract_number);

1126:
1127: -- build the email subject message
1128: -- set the fnd message for email subject
1129: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_EMAIL_SUB');
1130: fnd_message.set_token ('CONTRACT_NUM', l_contract_number);
1131: l_email_subject := fnd_message.get;
1132:
1133: -- end debug log
1134: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 1131: l_email_subject := fnd_message.get;

1127: -- build the email subject message
1128: -- set the fnd message for email subject
1129: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_EMAIL_SUB');
1130: fnd_message.set_token ('CONTRACT_NUM', l_contract_number);
1131: l_email_subject := fnd_message.get;
1132:
1133: -- end debug log
1134: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1135: fnd_log.STRING (fnd_log.level_procedure,

Line 2025: fnd_message.set_name (g_app_name, 'OKS_CC_INVALID_DATA');

2021: -- this is a new credit card, check if all info is entered from UI
2022: IF (p_card_number IS NULL)
2023: OR (p_expiration_month IS NULL)
2024: OR (p_expiration_year IS NULL) THEN
2025: fnd_message.set_name (g_app_name, 'OKS_CC_INVALID_DATA');
2026: fnd_msg_pub.ADD;
2027: RAISE fnd_api.g_exc_unexpected_error;
2028: END IF; -- cc info invalid
2029: END IF; -- p_instr_assignment_id is null

Line 3199: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3195: );
3196: END IF;
3197:
3198: IF (x_return_status = g_ret_sts_unexp_error) THEN
3199: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3200: fnd_message.set_token
3201: ('IBY_API_NAME',
3202: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3203: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

Line 3200: fnd_message.set_token

3196: END IF;
3197:
3198: IF (x_return_status = g_ret_sts_unexp_error) THEN
3199: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3200: fnd_message.set_token
3201: ('IBY_API_NAME',
3202: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3203: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3204: fnd_msg_pub.ADD;

Line 3203: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3199: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3200: fnd_message.set_token
3201: ('IBY_API_NAME',
3202: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3203: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3204: fnd_msg_pub.ADD;
3205: RAISE fnd_api.g_exc_unexpected_error;
3206: ELSIF (x_return_status = g_ret_sts_error) THEN
3207: /*

Line 3214: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3210: If QA check is run on the contract, then delete will fail and iby will return an error
3211: We will ignore Error from iby when delete txn is called.
3212:
3213:
3214: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3215: fnd_message.set_token
3216: ('IBY_API_NAME',
3217: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3218: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

Line 3215: fnd_message.set_token

3211: We will ignore Error from iby when delete txn is called.
3212:
3213:
3214: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3215: fnd_message.set_token
3216: ('IBY_API_NAME',
3217: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3218: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3219: fnd_msg_pub.ADD;

Line 3218: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3214: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3215: fnd_message.set_token
3216: ('IBY_API_NAME',
3217: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3218: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3219: fnd_msg_pub.ADD;
3220: RAISE fnd_api.g_exc_error;
3221: */
3222: null; -- error is ignored

Line 3373: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3369: );
3370: END IF;
3371:
3372: IF (x_return_status = g_ret_sts_unexp_error) THEN
3373: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3374: fnd_message.set_token ('IBY_API_NAME',
3375: 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card');
3376: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3377: fnd_msg_pub.ADD;

Line 3374: fnd_message.set_token ('IBY_API_NAME',

3370: END IF;
3371:
3372: IF (x_return_status = g_ret_sts_unexp_error) THEN
3373: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3374: fnd_message.set_token ('IBY_API_NAME',
3375: 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card');
3376: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3377: fnd_msg_pub.ADD;
3378: RAISE fnd_api.g_exc_unexpected_error;

Line 3376: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3372: IF (x_return_status = g_ret_sts_unexp_error) THEN
3373: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3374: fnd_message.set_token ('IBY_API_NAME',
3375: 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card');
3376: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3377: fnd_msg_pub.ADD;
3378: RAISE fnd_api.g_exc_unexpected_error;
3379: ELSIF (x_return_status = g_ret_sts_error) THEN
3380: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

Line 3380: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3376: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3377: fnd_msg_pub.ADD;
3378: RAISE fnd_api.g_exc_unexpected_error;
3379: ELSIF (x_return_status = g_ret_sts_error) THEN
3380: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3381: fnd_message.set_token ('IBY_API_NAME',
3382: 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card');
3383: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3384: fnd_msg_pub.ADD;

Line 3381: fnd_message.set_token ('IBY_API_NAME',

3377: fnd_msg_pub.ADD;
3378: RAISE fnd_api.g_exc_unexpected_error;
3379: ELSIF (x_return_status = g_ret_sts_error) THEN
3380: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3381: fnd_message.set_token ('IBY_API_NAME',
3382: 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card');
3383: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3384: fnd_msg_pub.ADD;
3385: RAISE fnd_api.g_exc_error;

Line 3383: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3379: ELSIF (x_return_status = g_ret_sts_error) THEN
3380: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3381: fnd_message.set_token ('IBY_API_NAME',
3382: 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card');
3383: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3384: fnd_msg_pub.ADD;
3385: RAISE fnd_api.g_exc_error;
3386: END IF;
3387: ELSE

Line 3549: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3545: );
3546: END IF;
3547:
3548: IF (x_return_status = g_ret_sts_unexp_error) THEN
3549: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3550: fnd_message.set_token
3551: ('IBY_API_NAME',
3552: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension');
3553: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

Line 3550: fnd_message.set_token

3546: END IF;
3547:
3548: IF (x_return_status = g_ret_sts_unexp_error) THEN
3549: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3550: fnd_message.set_token
3551: ('IBY_API_NAME',
3552: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension');
3553: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3554: fnd_msg_pub.ADD;

Line 3553: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3549: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3550: fnd_message.set_token
3551: ('IBY_API_NAME',
3552: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension');
3553: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3554: fnd_msg_pub.ADD;
3555: RAISE fnd_api.g_exc_unexpected_error;
3556: ELSIF (x_return_status = g_ret_sts_error) THEN
3557: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

Line 3557: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3553: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3554: fnd_msg_pub.ADD;
3555: RAISE fnd_api.g_exc_unexpected_error;
3556: ELSIF (x_return_status = g_ret_sts_error) THEN
3557: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3558: fnd_message.set_token
3559: ('IBY_API_NAME',
3560: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension');
3561: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

Line 3558: fnd_message.set_token

3554: fnd_msg_pub.ADD;
3555: RAISE fnd_api.g_exc_unexpected_error;
3556: ELSIF (x_return_status = g_ret_sts_error) THEN
3557: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3558: fnd_message.set_token
3559: ('IBY_API_NAME',
3560: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension');
3561: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3562: fnd_msg_pub.ADD;

Line 3561: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3557: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3558: fnd_message.set_token
3559: ('IBY_API_NAME',
3560: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension');
3561: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3562: fnd_msg_pub.ADD;
3563: RAISE fnd_api.g_exc_error;
3564: END IF;
3565:

Line 4024: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

4020: );
4021: END IF; -- debug log
4022:
4023: IF (x_return_status = g_ret_sts_unexp_error) THEN
4024: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
4025: fnd_message.set_token
4026: ('IBY_API_NAME',
4027: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
4028: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

Line 4025: fnd_message.set_token

4021: END IF; -- debug log
4022:
4023: IF (x_return_status = g_ret_sts_unexp_error) THEN
4024: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
4025: fnd_message.set_token
4026: ('IBY_API_NAME',
4027: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
4028: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
4029: fnd_msg_pub.ADD;

Line 4028: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

4024: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
4025: fnd_message.set_token
4026: ('IBY_API_NAME',
4027: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
4028: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
4029: fnd_msg_pub.ADD;
4030: RAISE fnd_api.g_exc_unexpected_error;
4031: ELSIF (x_return_status = g_ret_sts_error) THEN
4032: /*

Line 4039: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

4035: In OKS QA check, we get a authorization from iby to validate credit card
4036: If QA check is run on the contract, then delete will fail and iby will return an error
4037: We will ignore Error from iby when delete txn is called.
4038:
4039: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
4040: fnd_message.set_token
4041: ('IBY_API_NAME',
4042: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
4043: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

Line 4040: fnd_message.set_token

4036: If QA check is run on the contract, then delete will fail and iby will return an error
4037: We will ignore Error from iby when delete txn is called.
4038:
4039: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
4040: fnd_message.set_token
4041: ('IBY_API_NAME',
4042: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
4043: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
4044: fnd_msg_pub.ADD;

Line 4043: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

4039: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
4040: fnd_message.set_token
4041: ('IBY_API_NAME',
4042: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
4043: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
4044: fnd_msg_pub.ADD;
4045: RAISE fnd_api.g_exc_error;
4046: */
4047: x_return_status := fnd_api.g_ret_sts_success; -- initialize