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.CSD_UPDATE_PROGRAMS_PVT dependencies on FND_GLOBAL

Line 553: p_CREATED_BY => fnd_global.user_id,

549: p_REQUEST_ID => p_activity_rec.request_id,
550: p_PROGRAM_ID => p_activity_rec.program_id,
551: p_PROGRAM_APPLICATION_ID => p_activity_rec.program_application_id,
552: p_PROGRAM_UPDATE_DATE => p_activity_rec.program_update_date,
553: p_CREATED_BY => fnd_global.user_id,
554: p_CREATION_DATE => sysdate,
555: p_LAST_UPDATED_BY => fnd_global.user_id,
556: p_LAST_UPDATE_DATE => sysdate,
557: p_REPAIR_LINE_ID => p_activity_rec.repair_line_id,

Line 555: p_LAST_UPDATED_BY => fnd_global.user_id,

551: p_PROGRAM_APPLICATION_ID => p_activity_rec.program_application_id,
552: p_PROGRAM_UPDATE_DATE => p_activity_rec.program_update_date,
553: p_CREATED_BY => fnd_global.user_id,
554: p_CREATION_DATE => sysdate,
555: p_LAST_UPDATED_BY => fnd_global.user_id,
556: p_LAST_UPDATE_DATE => sysdate,
557: p_REPAIR_LINE_ID => p_activity_rec.repair_line_id,
558: p_EVENT_CODE => p_activity_rec.event_code,
559: p_EVENT_DATE => p_activity_rec.event_date,

Line 967: last_updated_by = fnd_global.user_id,

963: update csd_repair_job_xref
964: set quantity_completed = nvl(quantity_completed,0) + 1,
965: object_version_number = object_version_number+1,
966: last_update_date = sysdate,
967: last_updated_by = fnd_global.user_id,
968: last_update_login = fnd_global.login_id
969: where repair_job_xref_id = JOB.repair_job_xref_id;
970: IF SQL%NOTFOUND THEN
971: IF ( l_error_level >= G_debug_level) THEN

Line 968: last_update_login = fnd_global.login_id

964: set quantity_completed = nvl(quantity_completed,0) + 1,
965: object_version_number = object_version_number+1,
966: last_update_date = sysdate,
967: last_updated_by = fnd_global.user_id,
968: last_update_login = fnd_global.login_id
969: where repair_job_xref_id = JOB.repair_job_xref_id;
970: IF SQL%NOTFOUND THEN
971: IF ( l_error_level >= G_debug_level) THEN
972: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1090: last_updated_by = fnd_global.user_id,

1086: update csd_repair_job_xref
1087: set quantity_completed = nvl(quantity_completed,0) + 1,
1088: object_version_number = object_version_number+1,
1089: last_update_date = sysdate,
1090: last_updated_by = fnd_global.user_id,
1091: last_update_login = fnd_global.login_id
1092: where repair_job_xref_id = JOB.repair_job_xref_id;
1093: IF SQL%NOTFOUND THEN
1094: IF ( l_error_level >= G_debug_level) THEN

Line 1091: last_update_login = fnd_global.login_id

1087: set quantity_completed = nvl(quantity_completed,0) + 1,
1088: object_version_number = object_version_number+1,
1089: last_update_date = sysdate,
1090: last_updated_by = fnd_global.user_id,
1091: last_update_login = fnd_global.login_id
1092: where repair_job_xref_id = JOB.repair_job_xref_id;
1093: IF SQL%NOTFOUND THEN
1094: IF ( l_error_level >= G_debug_level) THEN
1095: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1222: last_updated_by = fnd_global.user_id,

1218: update csd_repair_job_xref
1219: set quantity_completed = nvl(quantity_completed,0) + 1,
1220: object_version_number = object_version_number+1,
1221: last_update_date = sysdate,
1222: last_updated_by = fnd_global.user_id,
1223: last_update_login = fnd_global.login_id
1224: where repair_job_xref_id = JOB.repair_job_xref_id;
1225: IF SQL%NOTFOUND THEN
1226: IF ( l_error_level >= G_debug_level) THEN

Line 1223: last_update_login = fnd_global.login_id

1219: set quantity_completed = nvl(quantity_completed,0) + 1,
1220: object_version_number = object_version_number+1,
1221: last_update_date = sysdate,
1222: last_updated_by = fnd_global.user_id,
1223: last_update_login = fnd_global.login_id
1224: where repair_job_xref_id = JOB.repair_job_xref_id;
1225: IF SQL%NOTFOUND THEN
1226: IF ( l_error_level >= G_debug_level) THEN
1227: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1339: last_updated_by = fnd_global.user_id,

1335: update csd_repair_job_xref
1336: set quantity_completed = nvl(quantity_completed,0) + NVL(l_update_qty,0),
1337: object_version_number = object_version_number+1,
1338: last_update_date = sysdate,
1339: last_updated_by = fnd_global.user_id,
1340: last_update_login = fnd_global.login_id
1341: where repair_job_xref_id = JOB.repair_job_xref_id;
1342: IF SQL%NOTFOUND THEN
1343: IF ( l_error_level >= G_debug_level) THEN

Line 1340: last_update_login = fnd_global.login_id

1336: set quantity_completed = nvl(quantity_completed,0) + NVL(l_update_qty,0),
1337: object_version_number = object_version_number+1,
1338: last_update_date = sysdate,
1339: last_updated_by = fnd_global.user_id,
1340: last_update_login = fnd_global.login_id
1341: where repair_job_xref_id = JOB.repair_job_xref_id;
1342: IF SQL%NOTFOUND THEN
1343: IF ( l_error_level >= G_debug_level) THEN
1344: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1714: last_updated_by = fnd_global.user_id,

1710: Update csd_repair_job_xref
1711: set wip_entity_id = K.wip_entity_id,
1712: object_version_number = object_version_number+1,
1713: last_update_date = sysdate,
1714: last_updated_by = fnd_global.user_id,
1715: last_update_login = fnd_global.login_id
1716: where repair_job_xref_id = K.repair_job_xref_id;
1717: IF SQL%NOTFOUND THEN
1718: IF ( l_error_level >= G_debug_level) THEN

Line 1715: last_update_login = fnd_global.login_id

1711: set wip_entity_id = K.wip_entity_id,
1712: object_version_number = object_version_number+1,
1713: last_update_date = sysdate,
1714: last_updated_by = fnd_global.user_id,
1715: last_update_login = fnd_global.login_id
1716: where repair_job_xref_id = K.repair_job_xref_id;
1717: IF SQL%NOTFOUND THEN
1718: IF ( l_error_level >= G_debug_level) THEN
1719: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_XREF_UPD_FAILED');

Line 1734: last_updated_by = fnd_global.user_id,

1730: -- Updating repair order with the Job allocated qty
1731: Update csd_repairs
1732: set quantity_in_wip = NVL(quantity_in_wip,0) + K.allocated_job_qty,
1733: last_update_date = sysdate,
1734: last_updated_by = fnd_global.user_id,
1735: object_version_number = object_version_number+1,
1736: last_update_login = fnd_global.login_id
1737: where repair_line_id = K.repair_line_id;
1738: IF SQL%NOTFOUND THEN

Line 1736: last_update_login = fnd_global.login_id

1732: set quantity_in_wip = NVL(quantity_in_wip,0) + K.allocated_job_qty,
1733: last_update_date = sysdate,
1734: last_updated_by = fnd_global.user_id,
1735: object_version_number = object_version_number+1,
1736: last_update_login = fnd_global.login_id
1737: where repair_line_id = K.repair_line_id;
1738: IF SQL%NOTFOUND THEN
1739: IF ( l_error_level >= G_debug_level) THEN
1740: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 2906: last_updated_by = fnd_global.user_id,

2902: object_version_number = object_version_number+1,
2903: customer_product_id = l_instance_id,
2904: serial_number = l_st_serial_num,
2905: last_update_date = sysdate,
2906: last_updated_by = fnd_global.user_id,
2907: last_update_login = fnd_global.login_id
2908: where repair_line_id = I.repair_line_id;
2909: IF SQL%NOTFOUND THEN
2910: IF ( l_error_level >= G_debug_level) THEN

Line 2907: last_update_login = fnd_global.login_id

2903: customer_product_id = l_instance_id,
2904: serial_number = l_st_serial_num,
2905: last_update_date = sysdate,
2906: last_updated_by = fnd_global.user_id,
2907: last_update_login = fnd_global.login_id
2908: where repair_line_id = I.repair_line_id;
2909: IF SQL%NOTFOUND THEN
2910: IF ( l_error_level >= G_debug_level) THEN
2911: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 2929: last_updated_by = fnd_global.user_id,

2925: update csd_repairs
2926: set quantity_rcvd = nvl(quantity_rcvd,0)+ l_result_quantity,
2927: object_version_number = object_version_number+1,
2928: last_update_date = sysdate,
2929: last_updated_by = fnd_global.user_id,
2930: last_update_login = fnd_global.login_id
2931: where repair_line_id = I.repair_line_id;
2932: IF SQL%NOTFOUND THEN
2933: IF ( l_error_level >= G_debug_level) THEN

Line 2930: last_update_login = fnd_global.login_id

2926: set quantity_rcvd = nvl(quantity_rcvd,0)+ l_result_quantity,
2927: object_version_number = object_version_number+1,
2928: last_update_date = sysdate,
2929: last_updated_by = fnd_global.user_id,
2930: last_update_login = fnd_global.login_id
2931: where repair_line_id = I.repair_line_id;
2932: IF SQL%NOTFOUND THEN
2933: IF ( l_error_level >= G_debug_level) THEN
2934: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 2965: last_updated_by = fnd_global.user_id,

2961: quantity_received = nvl(quantity_received,0) + nvl(I.received_quantity,0),
2962: prod_txn_status = l_prod_txn_status,
2963: object_version_number = object_version_number+1,
2964: last_update_date = sysdate,
2965: last_updated_by = fnd_global.user_id,
2966: last_update_login = fnd_global.login_id
2967: WHERE product_transaction_id = i.product_transaction_id;
2968: IF SQL%NOTFOUND THEN
2969: IF ( l_error_level >= G_debug_level) THEN

Line 2966: last_update_login = fnd_global.login_id

2962: prod_txn_status = l_prod_txn_status,
2963: object_version_number = object_version_number+1,
2964: last_update_date = sysdate,
2965: last_updated_by = fnd_global.user_id,
2966: last_update_login = fnd_global.login_id
2967: WHERE product_transaction_id = i.product_transaction_id;
2968: IF SQL%NOTFOUND THEN
2969: IF ( l_error_level >= G_debug_level) THEN
2970: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 3800: last_updated_by = fnd_global.user_id,

3796: quantity_rcvd = nvl(quantity_rcvd,0) + l_rcvd_qty,
3797: customer_product_id = l_instance_id,
3798: object_version_number = object_version_number+1,
3799: last_update_date = sysdate,
3800: last_updated_by = fnd_global.user_id,
3801: last_update_login = fnd_global.login_id
3802: WHERE repair_line_id = RO.repair_line_id;
3803: IF SQL%NOTFOUND THEN
3804: IF ( l_error_level >= G_debug_level) THEN

Line 3801: last_update_login = fnd_global.login_id

3797: customer_product_id = l_instance_id,
3798: object_version_number = object_version_number+1,
3799: last_update_date = sysdate,
3800: last_updated_by = fnd_global.user_id,
3801: last_update_login = fnd_global.login_id
3802: WHERE repair_line_id = RO.repair_line_id;
3803: IF SQL%NOTFOUND THEN
3804: IF ( l_error_level >= G_debug_level) THEN
3805: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 3829: last_updated_by = fnd_global.user_id,

3825: QUANTITY_RECEIVED = NVL(QUANTITY_RECEIVED,0) + l_rcvd_qty,
3826: SUB_INVENTORY_RCVD = DEL.subinventory,
3827: object_version_number = object_version_number+1,
3828: last_update_date = sysdate,
3829: last_updated_by = fnd_global.user_id,
3830: last_update_login = fnd_global.login_id
3831: WHERE product_transaction_id = RO.product_transaction_id;
3832: IF SQL%NOTFOUND THEN
3833: IF ( l_error_level >= G_debug_level) THEN

Line 3830: last_update_login = fnd_global.login_id

3826: SUB_INVENTORY_RCVD = DEL.subinventory,
3827: object_version_number = object_version_number+1,
3828: last_update_date = sysdate,
3829: last_updated_by = fnd_global.user_id,
3830: last_update_login = fnd_global.login_id
3831: WHERE product_transaction_id = RO.product_transaction_id;
3832: IF SQL%NOTFOUND THEN
3833: IF ( l_error_level >= G_debug_level) THEN
3834: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 3850: last_updated_by = fnd_global.user_id,

3846: UPDATE CSD_PRODUCT_TRANSACTIONS
3847: SET prod_txn_status = 'RECEIVED',
3848: object_version_number = object_version_number+1,
3849: last_update_date = sysdate,
3850: last_updated_by = fnd_global.user_id,
3851: last_update_login = fnd_global.login_id
3852: WHERE product_transaction_id = RO.product_transaction_id;
3853: ELSE
3854: UPDATE CSD_PRODUCT_TRANSACTIONS

Line 3851: last_update_login = fnd_global.login_id

3847: SET prod_txn_status = 'RECEIVED',
3848: object_version_number = object_version_number+1,
3849: last_update_date = sysdate,
3850: last_updated_by = fnd_global.user_id,
3851: last_update_login = fnd_global.login_id
3852: WHERE product_transaction_id = RO.product_transaction_id;
3853: ELSE
3854: UPDATE CSD_PRODUCT_TRANSACTIONS
3855: SET prod_txn_status = 'RECEIVED',

Line 3858: last_updated_by = fnd_global.user_id,

3854: UPDATE CSD_PRODUCT_TRANSACTIONS
3855: SET prod_txn_status = 'RECEIVED',
3856: object_version_number = object_version_number+1,
3857: last_update_date = sysdate,
3858: last_updated_by = fnd_global.user_id,
3859: last_update_login = fnd_global.login_id
3860: WHERE quantity_received = RO.ordered_quantity
3861: and product_transaction_id = RO.product_transaction_id;
3862: END IF;

Line 3859: last_update_login = fnd_global.login_id

3855: SET prod_txn_status = 'RECEIVED',
3856: object_version_number = object_version_number+1,
3857: last_update_date = sysdate,
3858: last_updated_by = fnd_global.user_id,
3859: last_update_login = fnd_global.login_id
3860: WHERE quantity_received = RO.ordered_quantity
3861: and product_transaction_id = RO.product_transaction_id;
3862: END IF;
3863:

Line 4168: last_updated_by = fnd_global.user_id,

4164: quantity_rcvd = nvl(quantity_rcvd,0) + l_rcvd_qty,
4165: customer_product_id = l_instance_id,
4166: object_version_number = object_version_number+1,
4167: last_update_date = sysdate,
4168: last_updated_by = fnd_global.user_id,
4169: last_update_login = fnd_global.login_id
4170: WHERE repair_line_id = RO.repair_line_id;
4171: IF SQL%NOTFOUND THEN
4172: IF ( l_error_level >= G_debug_level) THEN

Line 4169: last_update_login = fnd_global.login_id

4165: customer_product_id = l_instance_id,
4166: object_version_number = object_version_number+1,
4167: last_update_date = sysdate,
4168: last_updated_by = fnd_global.user_id,
4169: last_update_login = fnd_global.login_id
4170: WHERE repair_line_id = RO.repair_line_id;
4171: IF SQL%NOTFOUND THEN
4172: IF ( l_error_level >= G_debug_level) THEN
4173: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 4198: last_updated_by = fnd_global.user_id,

4194: QUANTITY_RECEIVED = NVL(QUANTITY_RECEIVED,0) + l_rcvd_qty,
4195: SUB_INVENTORY_RCVD = DEL.subinventory,
4196: object_version_number = object_version_number+1,
4197: last_update_date = sysdate,
4198: last_updated_by = fnd_global.user_id,
4199: last_update_login = fnd_global.login_id
4200: WHERE product_transaction_id = RO.product_transaction_id;
4201: IF SQL%NOTFOUND THEN
4202: IF ( l_error_level >= G_debug_level) THEN

Line 4199: last_update_login = fnd_global.login_id

4195: SUB_INVENTORY_RCVD = DEL.subinventory,
4196: object_version_number = object_version_number+1,
4197: last_update_date = sysdate,
4198: last_updated_by = fnd_global.user_id,
4199: last_update_login = fnd_global.login_id
4200: WHERE product_transaction_id = RO.product_transaction_id;
4201: IF SQL%NOTFOUND THEN
4202: IF ( l_error_level >= G_debug_level) THEN
4203: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 4219: last_updated_by = fnd_global.user_id,

4215: UPDATE CSD_PRODUCT_TRANSACTIONS
4216: SET prod_txn_status = 'RECEIVED',
4217: object_version_number = object_version_number+1,
4218: last_update_date = sysdate,
4219: last_updated_by = fnd_global.user_id,
4220: last_update_login = fnd_global.login_id
4221: WHERE product_transaction_id = RO.product_transaction_id;
4222:
4223: ELSE

Line 4220: last_update_login = fnd_global.login_id

4216: SET prod_txn_status = 'RECEIVED',
4217: object_version_number = object_version_number+1,
4218: last_update_date = sysdate,
4219: last_updated_by = fnd_global.user_id,
4220: last_update_login = fnd_global.login_id
4221: WHERE product_transaction_id = RO.product_transaction_id;
4222:
4223: ELSE
4224: UPDATE CSD_PRODUCT_TRANSACTIONS

Line 4228: last_updated_by = fnd_global.user_id,

4224: UPDATE CSD_PRODUCT_TRANSACTIONS
4225: SET prod_txn_status = 'RECEIVED',
4226: object_version_number = object_version_number+1,
4227: last_update_date = sysdate,
4228: last_updated_by = fnd_global.user_id,
4229: last_update_login = fnd_global.login_id
4230: WHERE quantity_received = RO.ordered_quantity
4231: and product_transaction_id = RO.product_transaction_id;
4232: END IF;

Line 4229: last_update_login = fnd_global.login_id

4225: SET prod_txn_status = 'RECEIVED',
4226: object_version_number = object_version_number+1,
4227: last_update_date = sysdate,
4228: last_updated_by = fnd_global.user_id,
4229: last_update_login = fnd_global.login_id
4230: WHERE quantity_received = RO.ordered_quantity
4231: and product_transaction_id = RO.product_transaction_id;
4232: END IF;
4233:

Line 4443: last_updated_by = fnd_global.user_id,

4439: quantity_rcvd = nvl(quantity_rcvd,0) + l_rcvd_qty,
4440: customer_product_id = l_instance_id,
4441: object_version_number = object_version_number+1,
4442: last_update_date = sysdate,
4443: last_updated_by = fnd_global.user_id,
4444: last_update_login = fnd_global.login_id
4445: WHERE repair_line_id = RO.repair_line_id;
4446: IF SQL%NOTFOUND THEN
4447: IF ( l_error_level >= G_debug_level) THEN

Line 4444: last_update_login = fnd_global.login_id

4440: customer_product_id = l_instance_id,
4441: object_version_number = object_version_number+1,
4442: last_update_date = sysdate,
4443: last_updated_by = fnd_global.user_id,
4444: last_update_login = fnd_global.login_id
4445: WHERE repair_line_id = RO.repair_line_id;
4446: IF SQL%NOTFOUND THEN
4447: IF ( l_error_level >= G_debug_level) THEN
4448: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 4471: last_updated_by = fnd_global.user_id,

4467: SUB_INVENTORY_RCVD= RCV.subinventory,
4468: LOCATOR_ID = RCV.locator_id,
4469: object_version_number = object_version_number+1,
4470: last_update_date = sysdate,
4471: last_updated_by = fnd_global.user_id,
4472: last_update_login = fnd_global.login_id
4473: WHERE product_transaction_id = RO.product_transaction_id;
4474: IF SQL%NOTFOUND THEN
4475: IF ( l_error_level >= G_debug_level) THEN

Line 4472: last_update_login = fnd_global.login_id

4468: LOCATOR_ID = RCV.locator_id,
4469: object_version_number = object_version_number+1,
4470: last_update_date = sysdate,
4471: last_updated_by = fnd_global.user_id,
4472: last_update_login = fnd_global.login_id
4473: WHERE product_transaction_id = RO.product_transaction_id;
4474: IF SQL%NOTFOUND THEN
4475: IF ( l_error_level >= G_debug_level) THEN
4476: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 4492: last_updated_by = fnd_global.user_id,

4488: UPDATE CSD_PRODUCT_TRANSACTIONS
4489: SET prod_txn_status = 'RECEIVED',
4490: object_version_number = object_version_number+1,
4491: last_update_date = sysdate,
4492: last_updated_by = fnd_global.user_id,
4493: last_update_login = fnd_global.login_id
4494: WHERE product_transaction_id = RO.product_transaction_id;
4495: ELSE
4496: UPDATE CSD_PRODUCT_TRANSACTIONS

Line 4493: last_update_login = fnd_global.login_id

4489: SET prod_txn_status = 'RECEIVED',
4490: object_version_number = object_version_number+1,
4491: last_update_date = sysdate,
4492: last_updated_by = fnd_global.user_id,
4493: last_update_login = fnd_global.login_id
4494: WHERE product_transaction_id = RO.product_transaction_id;
4495: ELSE
4496: UPDATE CSD_PRODUCT_TRANSACTIONS
4497: SET prod_txn_status = 'RECEIVED',

Line 4500: last_updated_by = fnd_global.user_id,

4496: UPDATE CSD_PRODUCT_TRANSACTIONS
4497: SET prod_txn_status = 'RECEIVED',
4498: object_version_number = object_version_number+1,
4499: last_update_date = sysdate,
4500: last_updated_by = fnd_global.user_id,
4501: last_update_login = fnd_global.login_id
4502: WHERE quantity_received = RO.ordered_quantity
4503: and product_transaction_id = RO.product_transaction_id;
4504: END IF;

Line 4501: last_update_login = fnd_global.login_id

4497: SET prod_txn_status = 'RECEIVED',
4498: object_version_number = object_version_number+1,
4499: last_update_date = sysdate,
4500: last_updated_by = fnd_global.user_id,
4501: last_update_login = fnd_global.login_id
4502: WHERE quantity_received = RO.ordered_quantity
4503: and product_transaction_id = RO.product_transaction_id;
4504: END IF;
4505:

Line 5221: last_updated_by = fnd_global.user_id,

5217: quantity_rcvd = nvl(quantity_rcvd,0) + l_rcvd_qty,
5218: customer_product_id = l_instance_id,
5219: object_version_number = object_version_number+1,
5220: last_update_date = sysdate,
5221: last_updated_by = fnd_global.user_id,
5222: last_update_login = fnd_global.login_id
5223: WHERE repair_line_id = RO.repair_line_id;
5224: IF SQL%NOTFOUND THEN
5225: IF ( l_error_level >= G_debug_level) THEN

Line 5222: last_update_login = fnd_global.login_id

5218: customer_product_id = l_instance_id,
5219: object_version_number = object_version_number+1,
5220: last_update_date = sysdate,
5221: last_updated_by = fnd_global.user_id,
5222: last_update_login = fnd_global.login_id
5223: WHERE repair_line_id = RO.repair_line_id;
5224: IF SQL%NOTFOUND THEN
5225: IF ( l_error_level >= G_debug_level) THEN
5226: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 5250: last_updated_by = fnd_global.user_id,

5246: QUANTITY_RECEIVED = NVL(QUANTITY_RECEIVED,0) + l_rcvd_qty,
5247: SUB_INVENTORY_RCVD = DEL.subinventory,
5248: object_version_number = object_version_number+1,
5249: last_update_date = sysdate,
5250: last_updated_by = fnd_global.user_id,
5251: last_update_login = fnd_global.login_id
5252: WHERE product_transaction_id = RO.product_transaction_id;
5253: IF SQL%NOTFOUND THEN
5254: IF ( l_error_level >= G_debug_level) THEN

Line 5251: last_update_login = fnd_global.login_id

5247: SUB_INVENTORY_RCVD = DEL.subinventory,
5248: object_version_number = object_version_number+1,
5249: last_update_date = sysdate,
5250: last_updated_by = fnd_global.user_id,
5251: last_update_login = fnd_global.login_id
5252: WHERE product_transaction_id = RO.product_transaction_id;
5253: IF SQL%NOTFOUND THEN
5254: IF ( l_error_level >= G_debug_level) THEN
5255: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 5271: last_updated_by = fnd_global.user_id,

5267: UPDATE CSD_PRODUCT_TRANSACTIONS
5268: SET prod_txn_status = 'RECEIVED',
5269: object_version_number = object_version_number+1,
5270: last_update_date = sysdate,
5271: last_updated_by = fnd_global.user_id,
5272: last_update_login = fnd_global.login_id
5273: WHERE product_transaction_id = RO.product_transaction_id;
5274: ELSE
5275: UPDATE CSD_PRODUCT_TRANSACTIONS

Line 5272: last_update_login = fnd_global.login_id

5268: SET prod_txn_status = 'RECEIVED',
5269: object_version_number = object_version_number+1,
5270: last_update_date = sysdate,
5271: last_updated_by = fnd_global.user_id,
5272: last_update_login = fnd_global.login_id
5273: WHERE product_transaction_id = RO.product_transaction_id;
5274: ELSE
5275: UPDATE CSD_PRODUCT_TRANSACTIONS
5276: SET prod_txn_status = 'RECEIVED',

Line 5279: last_updated_by = fnd_global.user_id,

5275: UPDATE CSD_PRODUCT_TRANSACTIONS
5276: SET prod_txn_status = 'RECEIVED',
5277: object_version_number = object_version_number+1,
5278: last_update_date = sysdate,
5279: last_updated_by = fnd_global.user_id,
5280: last_update_login = fnd_global.login_id
5281: WHERE quantity_received = RO.ordered_quantity
5282: and product_transaction_id = RO.product_transaction_id;
5283: END IF;

Line 5280: last_update_login = fnd_global.login_id

5276: SET prod_txn_status = 'RECEIVED',
5277: object_version_number = object_version_number+1,
5278: last_update_date = sysdate,
5279: last_updated_by = fnd_global.user_id,
5280: last_update_login = fnd_global.login_id
5281: WHERE quantity_received = RO.ordered_quantity
5282: and product_transaction_id = RO.product_transaction_id;
5283: END IF;
5284:

Line 5594: last_updated_by = fnd_global.user_id,

5590: quantity_rcvd = nvl(quantity_rcvd,0) + l_rcvd_qty,
5591: customer_product_id = l_instance_id,
5592: object_version_number = object_version_number+1,
5593: last_update_date = sysdate,
5594: last_updated_by = fnd_global.user_id,
5595: last_update_login = fnd_global.login_id
5596: WHERE repair_line_id = RO.repair_line_id;
5597: IF SQL%NOTFOUND THEN
5598: IF ( l_error_level >= G_debug_level) THEN

Line 5595: last_update_login = fnd_global.login_id

5591: customer_product_id = l_instance_id,
5592: object_version_number = object_version_number+1,
5593: last_update_date = sysdate,
5594: last_updated_by = fnd_global.user_id,
5595: last_update_login = fnd_global.login_id
5596: WHERE repair_line_id = RO.repair_line_id;
5597: IF SQL%NOTFOUND THEN
5598: IF ( l_error_level >= G_debug_level) THEN
5599: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 5624: last_updated_by = fnd_global.user_id,

5620: QUANTITY_RECEIVED = NVL(QUANTITY_RECEIVED,0) + l_rcvd_qty,
5621: SUB_INVENTORY_RCVD = DEL.subinventory,
5622: object_version_number = object_version_number+1,
5623: last_update_date = sysdate,
5624: last_updated_by = fnd_global.user_id,
5625: last_update_login = fnd_global.login_id
5626: WHERE product_transaction_id = RO.product_transaction_id;
5627: IF SQL%NOTFOUND THEN
5628: IF ( l_error_level >= G_debug_level) THEN

Line 5625: last_update_login = fnd_global.login_id

5621: SUB_INVENTORY_RCVD = DEL.subinventory,
5622: object_version_number = object_version_number+1,
5623: last_update_date = sysdate,
5624: last_updated_by = fnd_global.user_id,
5625: last_update_login = fnd_global.login_id
5626: WHERE product_transaction_id = RO.product_transaction_id;
5627: IF SQL%NOTFOUND THEN
5628: IF ( l_error_level >= G_debug_level) THEN
5629: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 5645: last_updated_by = fnd_global.user_id,

5641: UPDATE CSD_PRODUCT_TRANSACTIONS
5642: SET prod_txn_status = 'RECEIVED',
5643: object_version_number = object_version_number+1,
5644: last_update_date = sysdate,
5645: last_updated_by = fnd_global.user_id,
5646: last_update_login = fnd_global.login_id
5647: WHERE product_transaction_id = RO.product_transaction_id;
5648:
5649: ELSE

Line 5646: last_update_login = fnd_global.login_id

5642: SET prod_txn_status = 'RECEIVED',
5643: object_version_number = object_version_number+1,
5644: last_update_date = sysdate,
5645: last_updated_by = fnd_global.user_id,
5646: last_update_login = fnd_global.login_id
5647: WHERE product_transaction_id = RO.product_transaction_id;
5648:
5649: ELSE
5650: UPDATE CSD_PRODUCT_TRANSACTIONS

Line 5654: last_updated_by = fnd_global.user_id,

5650: UPDATE CSD_PRODUCT_TRANSACTIONS
5651: SET prod_txn_status = 'RECEIVED',
5652: object_version_number = object_version_number+1,
5653: last_update_date = sysdate,
5654: last_updated_by = fnd_global.user_id,
5655: last_update_login = fnd_global.login_id
5656: WHERE quantity_received = RO.ordered_quantity
5657: and product_transaction_id = RO.product_transaction_id;
5658: END IF;

Line 5655: last_update_login = fnd_global.login_id

5651: SET prod_txn_status = 'RECEIVED',
5652: object_version_number = object_version_number+1,
5653: last_update_date = sysdate,
5654: last_updated_by = fnd_global.user_id,
5655: last_update_login = fnd_global.login_id
5656: WHERE quantity_received = RO.ordered_quantity
5657: and product_transaction_id = RO.product_transaction_id;
5658: END IF;
5659:

Line 5882: last_updated_by = fnd_global.user_id,

5878: quantity_rcvd = nvl(quantity_rcvd,0) + l_rcvd_qty,
5879: customer_product_id = l_instance_id,
5880: object_version_number = object_version_number+1,
5881: last_update_date = sysdate,
5882: last_updated_by = fnd_global.user_id,
5883: last_update_login = fnd_global.login_id
5884: WHERE repair_line_id = RO.repair_line_id;
5885: IF SQL%NOTFOUND THEN
5886: IF ( l_error_level >= G_debug_level) THEN

Line 5883: last_update_login = fnd_global.login_id

5879: customer_product_id = l_instance_id,
5880: object_version_number = object_version_number+1,
5881: last_update_date = sysdate,
5882: last_updated_by = fnd_global.user_id,
5883: last_update_login = fnd_global.login_id
5884: WHERE repair_line_id = RO.repair_line_id;
5885: IF SQL%NOTFOUND THEN
5886: IF ( l_error_level >= G_debug_level) THEN
5887: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 5910: last_updated_by = fnd_global.user_id,

5906: SUB_INVENTORY_RCVD= RCV.subinventory,
5907: LOCATOR_ID = RCV.locator_id,
5908: object_version_number = object_version_number+1,
5909: last_update_date = sysdate,
5910: last_updated_by = fnd_global.user_id,
5911: last_update_login = fnd_global.login_id
5912: WHERE product_transaction_id = RO.product_transaction_id;
5913: IF SQL%NOTFOUND THEN
5914: IF ( l_error_level >= G_debug_level) THEN

Line 5911: last_update_login = fnd_global.login_id

5907: LOCATOR_ID = RCV.locator_id,
5908: object_version_number = object_version_number+1,
5909: last_update_date = sysdate,
5910: last_updated_by = fnd_global.user_id,
5911: last_update_login = fnd_global.login_id
5912: WHERE product_transaction_id = RO.product_transaction_id;
5913: IF SQL%NOTFOUND THEN
5914: IF ( l_error_level >= G_debug_level) THEN
5915: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 5931: last_updated_by = fnd_global.user_id,

5927: UPDATE CSD_PRODUCT_TRANSACTIONS
5928: SET prod_txn_status = 'RECEIVED',
5929: object_version_number = object_version_number+1,
5930: last_update_date = sysdate,
5931: last_updated_by = fnd_global.user_id,
5932: last_update_login = fnd_global.login_id
5933: WHERE product_transaction_id = RO.product_transaction_id;
5934: ELSE
5935: UPDATE CSD_PRODUCT_TRANSACTIONS

Line 5932: last_update_login = fnd_global.login_id

5928: SET prod_txn_status = 'RECEIVED',
5929: object_version_number = object_version_number+1,
5930: last_update_date = sysdate,
5931: last_updated_by = fnd_global.user_id,
5932: last_update_login = fnd_global.login_id
5933: WHERE product_transaction_id = RO.product_transaction_id;
5934: ELSE
5935: UPDATE CSD_PRODUCT_TRANSACTIONS
5936: SET prod_txn_status = 'RECEIVED',

Line 5939: last_updated_by = fnd_global.user_id,

5935: UPDATE CSD_PRODUCT_TRANSACTIONS
5936: SET prod_txn_status = 'RECEIVED',
5937: object_version_number = object_version_number+1,
5938: last_update_date = sysdate,
5939: last_updated_by = fnd_global.user_id,
5940: last_update_login = fnd_global.login_id
5941: WHERE quantity_received = RO.ordered_quantity
5942: and product_transaction_id = RO.product_transaction_id;
5943: END IF;

Line 5940: last_update_login = fnd_global.login_id

5936: SET prod_txn_status = 'RECEIVED',
5937: object_version_number = object_version_number+1,
5938: last_update_date = sysdate,
5939: last_updated_by = fnd_global.user_id,
5940: last_update_login = fnd_global.login_id
5941: WHERE quantity_received = RO.ordered_quantity
5942: and product_transaction_id = RO.product_transaction_id;
5943: END IF;
5944:

Line 6782: last_updated_by = fnd_global.user_id,

6778: set prod_txn_status = 'RELEASED',
6779: release_sales_order_flag = 'Y',
6780: object_version_number = object_version_number+1,
6781: last_update_date = sysdate,
6782: last_updated_by = fnd_global.user_id,
6783: last_update_login = fnd_global.login_id
6784: where product_transaction_id = I.product_transaction_id ;
6785: End if;
6786: --bug#14657082 --15859195

Line 6783: last_update_login = fnd_global.login_id

6779: release_sales_order_flag = 'Y',
6780: object_version_number = object_version_number+1,
6781: last_update_date = sysdate,
6782: last_updated_by = fnd_global.user_id,
6783: last_update_login = fnd_global.login_id
6784: where product_transaction_id = I.product_transaction_id ;
6785: End if;
6786: --bug#14657082 --15859195
6787:

Line 6914: last_updated_by = fnd_global.user_id,

6910: update csd_repairs
6911: set quantity_shipped = nvl(quantity_shipped,0)+l_result_ship_qty,
6912: object_version_number = object_version_number+1,
6913: last_update_date = sysdate,
6914: last_updated_by = fnd_global.user_id,
6915: last_update_login = fnd_global.login_id
6916: where repair_line_id = I.repair_line_id;
6917: IF SQL%NOTFOUND THEN
6918: IF ( l_error_level >= G_debug_level) THEN

Line 6915: last_update_login = fnd_global.login_id

6911: set quantity_shipped = nvl(quantity_shipped,0)+l_result_ship_qty,
6912: object_version_number = object_version_number+1,
6913: last_update_date = sysdate,
6914: last_updated_by = fnd_global.user_id,
6915: last_update_login = fnd_global.login_id
6916: where repair_line_id = I.repair_line_id;
6917: IF SQL%NOTFOUND THEN
6918: IF ( l_error_level >= G_debug_level) THEN
6919: fnd_message.set_name('CSD','CSD_RO_UPD_FAILED');

Line 7020: last_updated_by = fnd_global.user_id,

7016: source_serial_number = i.shipped_serial_num,
7017: source_instance_id = l_instance_id,
7018: object_version_number = object_version_number+1,
7019: last_update_date = sysdate,
7020: last_updated_by = fnd_global.user_id,
7021: last_update_login = fnd_global.login_id
7022: where product_transaction_id = i.product_transaction_id ;
7023: IF SQL%NOTFOUND THEN
7024: IF ( l_error_level >= G_debug_level) THEN

Line 7021: last_update_login = fnd_global.login_id

7017: source_instance_id = l_instance_id,
7018: object_version_number = object_version_number+1,
7019: last_update_date = sysdate,
7020: last_updated_by = fnd_global.user_id,
7021: last_update_login = fnd_global.login_id
7022: where product_transaction_id = i.product_transaction_id ;
7023: IF SQL%NOTFOUND THEN
7024: IF ( l_error_level >= G_debug_level) THEN
7025: fnd_message.set_name('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 7042: last_updated_by = fnd_global.user_id,

7038: update csd_product_transactions
7039: set prod_txn_status = 'SHIPPED',
7040: object_version_number = object_version_number+1,
7041: last_update_date = sysdate,
7042: last_updated_by = fnd_global.user_id,
7043: last_update_login = fnd_global.login_id
7044: where nvl(quantity_shipped,0) = I.estimate_quantity
7045: and product_transaction_id = i.product_transaction_id ;
7046:

Line 7043: last_update_login = fnd_global.login_id

7039: set prod_txn_status = 'SHIPPED',
7040: object_version_number = object_version_number+1,
7041: last_update_date = sysdate,
7042: last_updated_by = fnd_global.user_id,
7043: last_update_login = fnd_global.login_id
7044: where nvl(quantity_shipped,0) = I.estimate_quantity
7045: and product_transaction_id = i.product_transaction_id ;
7046:
7047: --bug#7572853 begin

Line 7678: last_updated_by = fnd_global.user_id,

7674: ship_sales_order_flag = l_ship_so_flag,
7675: prod_txn_status = l_prod_txn_status,
7676: object_version_number = object_version_number+1,
7677: last_update_date = sysdate,
7678: last_updated_by = fnd_global.user_id,
7679: last_update_login = fnd_global.login_id
7680: WHERE product_transaction_id = l_prod_txn_id;
7681: IF SQL%NOTFOUND THEN
7682: IF ( l_error_level >= G_debug_level) THEN

Line 7679: last_update_login = fnd_global.login_id

7675: prod_txn_status = l_prod_txn_status,
7676: object_version_number = object_version_number+1,
7677: last_update_date = sysdate,
7678: last_updated_by = fnd_global.user_id,
7679: last_update_login = fnd_global.login_id
7680: WHERE product_transaction_id = l_prod_txn_id;
7681: IF SQL%NOTFOUND THEN
7682: IF ( l_error_level >= G_debug_level) THEN
7683: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');

Line 7737: p_LAST_UPDATED_BY => fnd_global.user_id,

7733: p_PROD_TXN_STATUS => l_prod_txn_status,
7734: p_PROD_TXN_CODE => '',
7735: p_LAST_UPDATE_DATE => sysdate,
7736: p_CREATION_DATE => sysdate,
7737: p_LAST_UPDATED_BY => fnd_global.user_id,
7738: p_CREATED_BY => fnd_global.user_id,
7739: p_LAST_UPDATE_LOGIN => null,
7740: p_ATTRIBUTE1 => '',
7741: p_ATTRIBUTE2 => '',

Line 7738: p_CREATED_BY => fnd_global.user_id,

7734: p_PROD_TXN_CODE => '',
7735: p_LAST_UPDATE_DATE => sysdate,
7736: p_CREATION_DATE => sysdate,
7737: p_LAST_UPDATED_BY => fnd_global.user_id,
7738: p_CREATED_BY => fnd_global.user_id,
7739: p_LAST_UPDATE_LOGIN => null,
7740: p_ATTRIBUTE1 => '',
7741: p_ATTRIBUTE2 => '',
7742: p_ATTRIBUTE3 => '',

Line 7830: last_updated_by = fnd_global.user_id,

7826: lot_number = DEL.lot_number,
7827: locator_id = DEL.locator_id,
7828: object_version_number = object_version_number+1,
7829: last_update_date = sysdate,
7830: last_updated_by = fnd_global.user_id,
7831: last_update_login = fnd_global.login_id
7832: WHERE order_header_id = DEL.header_id
7833: and order_line_id = DEL.line_id
7834: and action_type = l_action_type

Line 7831: last_update_login = fnd_global.login_id

7827: locator_id = DEL.locator_id,
7828: object_version_number = object_version_number+1,
7829: last_update_date = sysdate,
7830: last_updated_by = fnd_global.user_id,
7831: last_update_login = fnd_global.login_id
7832: WHERE order_header_id = DEL.header_id
7833: and order_line_id = DEL.line_id
7834: and action_type = l_action_type
7835: and action_code = l_action_code

Line 7862: last_updated_by = fnd_global.user_id,

7858: lot_number = DEL.lot_number,
7859: locator_id = DEL.locator_id,
7860: object_version_number = object_version_number+1,
7861: last_update_date = sysdate,
7862: last_updated_by = fnd_global.user_id,
7863: last_update_login = fnd_global.login_id
7864: WHERE order_header_id = DEL.header_id
7865: and action_type = l_action_type
7866: and action_code = l_action_code

Line 7863: last_update_login = fnd_global.login_id

7859: locator_id = DEL.locator_id,
7860: object_version_number = object_version_number+1,
7861: last_update_date = sysdate,
7862: last_updated_by = fnd_global.user_id,
7863: last_update_login = fnd_global.login_id
7864: WHERE order_header_id = DEL.header_id
7865: and action_type = l_action_type
7866: and action_code = l_action_code
7867: and prod_txn_status in ('BOOKED','RELEASED')

Line 7993: last_updated_by = fnd_global.user_id,

7989: ship_sales_order_flag = l_ship_so_flag,
7990: prod_txn_status = l_prod_txn_status,
7991: object_version_number = object_version_number+1,
7992: last_update_date = sysdate,
7993: last_updated_by = fnd_global.user_id,
7994: last_update_login = fnd_global.login_id
7995: WHERE product_transaction_id = l_prod_txn_id;
7996: IF SQL%NOTFOUND THEN
7997: IF ( l_error_level >= G_debug_level) THEN

Line 7994: last_update_login = fnd_global.login_id

7990: prod_txn_status = l_prod_txn_status,
7991: object_version_number = object_version_number+1,
7992: last_update_date = sysdate,
7993: last_updated_by = fnd_global.user_id,
7994: last_update_login = fnd_global.login_id
7995: WHERE product_transaction_id = l_prod_txn_id;
7996: IF SQL%NOTFOUND THEN
7997: IF ( l_error_level >= G_debug_level) THEN
7998: fnd_message.set_name('CSD','CSD_INV_PROD_TXN_ID');

Line 8052: p_LAST_UPDATED_BY => fnd_global.user_id,

8048: p_PROD_TXN_STATUS => l_prod_txn_status,
8049: p_PROD_TXN_CODE => '',
8050: p_LAST_UPDATE_DATE => sysdate,
8051: p_CREATION_DATE => sysdate,
8052: p_LAST_UPDATED_BY => fnd_global.user_id,
8053: p_CREATED_BY => fnd_global.user_id,
8054: p_LAST_UPDATE_LOGIN => null,
8055: p_ATTRIBUTE1 => '',
8056: p_ATTRIBUTE2 => '',

Line 8053: p_CREATED_BY => fnd_global.user_id,

8049: p_PROD_TXN_CODE => '',
8050: p_LAST_UPDATE_DATE => sysdate,
8051: p_CREATION_DATE => sysdate,
8052: p_LAST_UPDATED_BY => fnd_global.user_id,
8053: p_CREATED_BY => fnd_global.user_id,
8054: p_LAST_UPDATE_LOGIN => null,
8055: p_ATTRIBUTE1 => '',
8056: p_ATTRIBUTE2 => '',
8057: p_ATTRIBUTE3 => '',

Line 8110: last_updated_by = fnd_global.user_id,

8106: Update csd_repairs
8107: set quantity_shipped = nvl(quantity_shipped,0) + DEL.shipped_quantity,
8108: object_version_number = object_version_number+1,
8109: last_update_date = sysdate,
8110: last_updated_by = fnd_global.user_id,
8111: last_update_login = fnd_global.login_id
8112: where repair_line_id = l_rep_line_id;
8113: IF SQL%NOTFOUND THEN
8114: IF ( l_error_level >= G_debug_level) THEN

Line 8111: last_update_login = fnd_global.login_id

8107: set quantity_shipped = nvl(quantity_shipped,0) + DEL.shipped_quantity,
8108: object_version_number = object_version_number+1,
8109: last_update_date = sysdate,
8110: last_updated_by = fnd_global.user_id,
8111: last_update_login = fnd_global.login_id
8112: where repair_line_id = l_rep_line_id;
8113: IF SQL%NOTFOUND THEN
8114: IF ( l_error_level >= G_debug_level) THEN
8115: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 8239: last_updated_by = fnd_global.user_id,

8235: order_line_id = DEL.line_id,
8236: source_serial_number = UT.serial_number,
8237: object_version_number = object_version_number+1,
8238: last_update_date = sysdate,
8239: last_updated_by = fnd_global.user_id,
8240: last_update_login = fnd_global.login_id
8241: where product_transaction_id = l_prod_txn_id;
8242: IF SQL%NOTFOUND THEN
8243: IF ( l_error_level >= G_debug_level) THEN

Line 8240: last_update_login = fnd_global.login_id

8236: source_serial_number = UT.serial_number,
8237: object_version_number = object_version_number+1,
8238: last_update_date = sysdate,
8239: last_updated_by = fnd_global.user_id,
8240: last_update_login = fnd_global.login_id
8241: where product_transaction_id = l_prod_txn_id;
8242: IF SQL%NOTFOUND THEN
8243: IF ( l_error_level >= G_debug_level) THEN
8244: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');

Line 8260: last_updated_by = fnd_global.user_id,

8256: Update csd_repairs
8257: set quantity_shipped = 1,
8258: object_version_number = object_version_number+1,
8259: last_update_date = sysdate,
8260: last_updated_by = fnd_global.user_id,
8261: last_update_login = fnd_global.login_id
8262: where repair_line_id = l_rep_line_id;
8263: IF SQL%NOTFOUND THEN
8264: IF ( l_error_level >= G_debug_level) THEN

Line 8261: last_update_login = fnd_global.login_id

8257: set quantity_shipped = 1,
8258: object_version_number = object_version_number+1,
8259: last_update_date = sysdate,
8260: last_updated_by = fnd_global.user_id,
8261: last_update_login = fnd_global.login_id
8262: where repair_line_id = l_rep_line_id;
8263: IF SQL%NOTFOUND THEN
8264: IF ( l_error_level >= G_debug_level) THEN
8265: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 8358: last_updated_by = fnd_global.user_id,

8354: order_line_id = DEL.line_id,
8355: source_serial_number = UT.serial_number,
8356: object_version_number = object_version_number+1,
8357: last_update_date = sysdate,
8358: last_updated_by = fnd_global.user_id,
8359: last_update_login = fnd_global.login_id
8360: where product_transaction_id = l_prod_txn_id;
8361: IF SQL%NOTFOUND THEN
8362: IF ( l_error_level >= G_debug_level) THEN

Line 8359: last_update_login = fnd_global.login_id

8355: source_serial_number = UT.serial_number,
8356: object_version_number = object_version_number+1,
8357: last_update_date = sysdate,
8358: last_updated_by = fnd_global.user_id,
8359: last_update_login = fnd_global.login_id
8360: where product_transaction_id = l_prod_txn_id;
8361: IF SQL%NOTFOUND THEN
8362: IF ( l_error_level >= G_debug_level) THEN
8363: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 8379: last_updated_by = fnd_global.user_id,

8375: Update csd_repairs
8376: set quantity_shipped = 1,
8377: object_version_number = object_version_number+1,
8378: last_update_date = sysdate,
8379: last_updated_by = fnd_global.user_id,
8380: last_update_login = fnd_global.login_id
8381: where repair_line_id = l_rep_line_id;
8382: IF SQL%NOTFOUND THEN
8383: IF ( l_error_level >= G_debug_level) THEN

Line 8380: last_update_login = fnd_global.login_id

8376: set quantity_shipped = 1,
8377: object_version_number = object_version_number+1,
8378: last_update_date = sysdate,
8379: last_updated_by = fnd_global.user_id,
8380: last_update_login = fnd_global.login_id
8381: where repair_line_id = l_rep_line_id;
8382: IF SQL%NOTFOUND THEN
8383: IF ( l_error_level >= G_debug_level) THEN
8384: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 8495: last_updated_by = fnd_global.user_id,

8491: order_line_id = DEL.line_id,
8492: source_serial_number = UT.serial_number,
8493: object_version_number = object_version_number+1,
8494: last_update_date = sysdate,
8495: last_updated_by = fnd_global.user_id,
8496: last_update_login = fnd_global.login_id
8497: where product_transaction_id = l_prod_txn_id;
8498: IF SQL%NOTFOUND THEN
8499: IF ( l_error_level >= G_debug_level) THEN

Line 8496: last_update_login = fnd_global.login_id

8492: source_serial_number = UT.serial_number,
8493: object_version_number = object_version_number+1,
8494: last_update_date = sysdate,
8495: last_updated_by = fnd_global.user_id,
8496: last_update_login = fnd_global.login_id
8497: where product_transaction_id = l_prod_txn_id;
8498: IF SQL%NOTFOUND THEN
8499: IF ( l_error_level >= G_debug_level) THEN
8500: FND_MESSAGE.SET_NAME('CSD','CSD_INV_PROD_TXN_ID');

Line 8516: last_updated_by = fnd_global.user_id,

8512: Update csd_repairs
8513: set quantity_shipped = 1,
8514: object_version_number = object_version_number+1,
8515: last_update_date = sysdate,
8516: last_updated_by = fnd_global.user_id,
8517: last_update_login = fnd_global.login_id
8518: where repair_line_id = l_rep_line_id;
8519: IF SQL%NOTFOUND THEN
8520: IF ( l_error_level >= G_debug_level) THEN

Line 8517: last_update_login = fnd_global.login_id

8513: set quantity_shipped = 1,
8514: object_version_number = object_version_number+1,
8515: last_update_date = sysdate,
8516: last_updated_by = fnd_global.user_id,
8517: last_update_login = fnd_global.login_id
8518: where repair_line_id = l_rep_line_id;
8519: IF SQL%NOTFOUND THEN
8520: IF ( l_error_level >= G_debug_level) THEN
8521: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 8614: last_updated_by = fnd_global.user_id,

8610: order_line_id = DEL.line_id,
8611: source_serial_number = UT.serial_number,
8612: object_version_number = object_version_number+1,
8613: last_update_date = sysdate,
8614: last_updated_by = fnd_global.user_id,
8615: last_update_login = fnd_global.login_id
8616: where product_transaction_id = l_prod_txn_id;
8617: IF SQL%NOTFOUND THEN
8618: IF ( l_error_level >= G_debug_level) THEN

Line 8615: last_update_login = fnd_global.login_id

8611: source_serial_number = UT.serial_number,
8612: object_version_number = object_version_number+1,
8613: last_update_date = sysdate,
8614: last_updated_by = fnd_global.user_id,
8615: last_update_login = fnd_global.login_id
8616: where product_transaction_id = l_prod_txn_id;
8617: IF SQL%NOTFOUND THEN
8618: IF ( l_error_level >= G_debug_level) THEN
8619: FND_MESSAGE.SET_NAME('CSD','CSD_PROD_TXN_UPD_FAILED');

Line 8635: last_updated_by = fnd_global.user_id,

8631: Update csd_repairs
8632: set quantity_shipped = 1,
8633: object_version_number = object_version_number+1,
8634: last_update_date = sysdate,
8635: last_updated_by = fnd_global.user_id,
8636: last_update_login = fnd_global.login_id
8637: where repair_line_id = l_rep_line_id;
8638: IF SQL%NOTFOUND THEN
8639: IF ( l_error_level >= G_debug_level) THEN

Line 8636: last_update_login = fnd_global.login_id

8632: set quantity_shipped = 1,
8633: object_version_number = object_version_number+1,
8634: last_update_date = sysdate,
8635: last_updated_by = fnd_global.user_id,
8636: last_update_login = fnd_global.login_id
8637: where repair_line_id = l_rep_line_id;
8638: IF SQL%NOTFOUND THEN
8639: IF ( l_error_level >= G_debug_level) THEN
8640: FND_MESSAGE.SET_NAME('CSD','CSD_RO_UPD_FAILED');

Line 9568: p_CREATED_BY => FND_GLOBAL.USER_ID,

9564: p_REQUEST_ID => null,
9565: p_PROGRAM_ID => null,
9566: p_PROGRAM_APPLICATION_ID => null,
9567: p_PROGRAM_UPDATE_DATE => null,
9568: p_CREATED_BY => FND_GLOBAL.USER_ID,
9569: p_CREATION_DATE => sysdate,
9570: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
9571: p_LAST_UPDATE_DATE => sysdate,
9572: p_repair_line_id => l_repair_line_id,

Line 9570: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,

9566: p_PROGRAM_APPLICATION_ID => null,
9567: p_PROGRAM_UPDATE_DATE => null,
9568: p_CREATED_BY => FND_GLOBAL.USER_ID,
9569: p_CREATION_DATE => sysdate,
9570: p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
9571: p_LAST_UPDATE_DATE => sysdate,
9572: p_repair_line_id => l_repair_line_id,
9573: p_EVENT_CODE => l_event_code,
9574: p_EVENT_DATE => sysdate,

Line 9585: p_PARAMN10 => FND_GLOBAL.USER_ID,

9581: p_PARAMN6 => null,
9582: p_PARAMN7 => null,
9583: p_PARAMN8 => null,
9584: p_PARAMN9 => null,
9585: p_PARAMN10 => FND_GLOBAL.USER_ID,
9586: p_PARAMC1 => l_paramc1,
9587: p_PARAMC2 => l_paramc2,
9588: p_PARAMC3 => l_paramc3,
9589: p_PARAMC4 => l_paramc4,

Line 9622: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

9618: p_ATTRIBUTE12 => null,
9619: p_ATTRIBUTE13 => null,
9620: p_ATTRIBUTE14 => null,
9621: p_ATTRIBUTE15 => null,
9622: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
9623: X_Return_Status => x_return_status,
9624: X_Msg_Count => x_msg_count,
9625: X_Msg_Data => x_msg_data
9626: );

Line 9813: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

9809: BEGIN
9810: UPDATE CSD_PRODUCT_TRANSACTIONS
9811: SET PROD_TXN_STATUS = C_PRODTXN_CANCELLED,
9812: LAST_UPDATE_DATE = SYSDATE,
9813: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
9814: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
9815: WHERE PRODUCT_TRANSACTION_ID = l_product_txn_id;
9816: EXCEPTION
9817: WHEN OTHERS THEN

Line 9814: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

9810: UPDATE CSD_PRODUCT_TRANSACTIONS
9811: SET PROD_TXN_STATUS = C_PRODTXN_CANCELLED,
9812: LAST_UPDATE_DATE = SYSDATE,
9813: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
9814: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
9815: WHERE PRODUCT_TRANSACTION_ID = l_product_txn_id;
9816: EXCEPTION
9817: WHEN OTHERS THEN
9818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;