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.CSI_ITEM_INSTANCE_PVT dependencies on CSI_INSTANCE_PARTIES_VLD_PVT

Line 23094: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

23090:
23091: -- Start API body
23092: --
23093: -- Check if all the required parameters are passed
23094: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
23095: ( p_version_label_rec.INSTANCE_ID ,
23096: ' p_version_label_rec.INSTANCE_ID ',
23097: l_api_name );
23098:

Line 23099: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char

23095: ( p_version_label_rec.INSTANCE_ID ,
23096: ' p_version_label_rec.INSTANCE_ID ',
23097: l_api_name );
23098:
23099: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_char
23100: ( p_version_label_rec.version_label ,
23101: ' p_version_label_rec.version_label ',
23102: l_api_name );
23103:

Line 23104: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_date

23100: ( p_version_label_rec.version_label ,
23101: ' p_version_label_rec.version_label ',
23102: l_api_name );
23103:
23104: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_date
23105: ( p_version_label_rec.date_time_stamp ,
23106: ' p_version_label_rec.date_time_stamp ',
23107: l_api_name );
23108: -- Validate the Instance id exists in csi_item_instances

Line 23109: IF NOT( CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid

23105: ( p_version_label_rec.date_time_stamp ,
23106: ' p_version_label_rec.date_time_stamp ',
23107: l_api_name );
23108: -- Validate the Instance id exists in csi_item_instances
23109: IF NOT( CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid
23110: (p_version_label_rec.INSTANCE_ID)) THEN
23111: RAISE FND_API.G_EXC_ERROR;
23112: END IF;
23113: -- If active_start_date is null or G_MISS value then assign sysdate

Line 23145: IF NOT(CSI_Instance_parties_vld_pvt.Is_timestamp_Valid

23141:
23142: -- Verify the timestamp is less than the end effective date but greater then
23143: -- the start effective date
23144: IF p_version_label_rec.date_time_stamp is NOT NULL THEN
23145: IF NOT(CSI_Instance_parties_vld_pvt.Is_timestamp_Valid
23146: (p_version_label_rec.date_time_stamp,
23147: p_version_label_rec.INSTANCE_ID )) THEN
23148: RAISE FND_API.G_EXC_ERROR;
23149: END IF;

Line 23159: p_version_label_rec.VERSION_LABEL_ID := CSI_Instance_parties_vld_pvt.gen_ver_label_id;

23155: -- If the vesrion label id passed is null then generate from sequence
23156: -- and check if the value exists . If exists then generate
23157: -- again from the sequence till we get a value that does not exist
23158: while l_process_flag loop
23159: p_version_label_rec.VERSION_LABEL_ID := CSI_Instance_parties_vld_pvt.gen_ver_label_id;
23160: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,
23161: FALSE )) THEN
23162: l_process_flag := FALSE;
23163: END IF;

Line 23160: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,

23156: -- and check if the value exists . If exists then generate
23157: -- again from the sequence till we get a value that does not exist
23158: while l_process_flag loop
23159: p_version_label_rec.VERSION_LABEL_ID := CSI_Instance_parties_vld_pvt.gen_ver_label_id;
23160: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,
23161: FALSE )) THEN
23162: l_process_flag := FALSE;
23163: END IF;
23164: end loop;

Line 23167: IF CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,

23163: END IF;
23164: end loop;
23165: ELSE
23166: -- Validate the version label id if exist then raise CSI_API_INVALID_PRIMARY_KEY error
23167: IF CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,
23168: TRUE ) THEN
23169: RAISE FND_API.G_EXC_ERROR;
23170: END IF;
23171: END IF;

Line 23232: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;

23228: RAISE FND_API.G_EXC_ERROR;
23229: END IF;
23230:
23231: -- Generate a unique instance_party_history_id from the sequence
23232: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;
23233:
23234: -- Call the table handlers to insert into history table
23235:
23236: CSI_I_VERSION_LABELS_H_PKG.Insert_Row

Line 23452: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

23448:
23449: -- Start API body
23450: --
23451: -- Check if all the required parameters are passed
23452: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
23453: ( p_version_label_rec.version_label_id ,
23454: ' p_version_label_rec.version_label_id ',
23455: l_api_name );
23456:

Line 23459: IF NOT( CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid

23455: l_api_name );
23456:
23457: -- Validate the Instance id exists in csi_item_instances
23458: IF p_version_label_rec.INSTANCE_ID <> FND_API.G_MISS_NUM THEN
23459: IF NOT( CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid
23460: (p_version_label_rec.INSTANCE_ID)) THEN
23461: RAISE FND_API.G_EXC_ERROR;
23462: END IF;
23463: END IF;

Line 23468: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,

23464:
23465: IF p_version_label_rec.VERSION_LABEL_ID <> FND_API.G_MISS_NUM THEN
23466:
23467: -- Validate the version label id if exist then raise CSI_API_INVALID_PRIMARY_KEY error
23468: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists(p_version_label_rec.VERSION_LABEL_ID,
23469: FALSE )) THEN
23470: RAISE FND_API.G_EXC_ERROR;
23471: END IF;
23472: END IF;

Line 23553: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;

23549: RAISE FND_API.G_EXC_ERROR;
23550: END IF;
23551: END IF;
23552: -- Generate a unique instance_party_history_id from the sequence
23553: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;
23554:
23555: -- Get the full_dump_frequency from csi_install_parameter
23556: --
23557: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

Line 24564: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

24560:
24561: -- Start API body
24562:
24563: -- Check if all the required parameters are passed
24564: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
24565: ( p_version_label_rec.version_label_id ,
24566: ' p_version_label_rec.version_label_id ',
24567: l_api_name );
24568:

Line 24569: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num

24565: ( p_version_label_rec.version_label_id ,
24566: ' p_version_label_rec.version_label_id ',
24567: l_api_name );
24568:
24569: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_num
24570: ( p_version_label_rec.object_version_number ,
24571: ' p_version_label_rec.object_version_number ',
24572: l_api_name );
24573:

Line 24574: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_date

24570: ( p_version_label_rec.object_version_number ,
24571: ' p_version_label_rec.object_version_number ',
24572: l_api_name );
24573:
24574: CSI_Instance_parties_vld_pvt.Check_Reqd_Param_date
24575: ( p_version_label_rec.active_end_date ,
24576: ' p_version_label_rec.active_end_date ',
24577: l_api_name );
24578:

Line 24581: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists

24577: l_api_name );
24578:
24579: IF p_version_label_rec.version_label_id <> FND_API.G_MISS_NUM THEN
24580: -- Validate the version label id if exist then raise CSI_API_INVALID_PRIMARY_KEY error
24581: IF NOT(CSI_Instance_parties_vld_pvt.Is_Ver_labelID_exists
24582: (p_version_label_rec.version_label_id,
24583: FALSE )) THEN
24584: RAISE FND_API.G_EXC_ERROR;
24585: END IF;

Line 24665: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;

24661: RAISE FND_API.G_EXC_ERROR;
24662: END IF;
24663:
24664: -- Generate a unique instance_party_history_id from the sequence
24665: l_version_label_hist_id := CSI_Instance_parties_vld_pvt.gen_ver_label_hist_id;
24666:
24667: -- Get the full_dump_frequency from csi_install_parameter
24668: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
24669: csi_gen_utility_pvt.populate_install_param_rec;

Line 25842: -- IF CSI_Instance_parties_vld_pvt.Is_Instance_creation_complete( p_ext_attrib_rec.INSTANCE_ID ) THEN

25838: ,1
25839: );
25840:
25841:
25842: -- IF CSI_Instance_parties_vld_pvt.Is_Instance_creation_complete( p_ext_attrib_rec.INSTANCE_ID ) THEN
25843: -- Call create_transaction to create txn log
25844:
25845: CSI_TRANSACTIONS_PVT.Create_transaction
25846: ( p_api_version => p_api_version

Line 26203: -- IF CSI_Instance_parties_vld_pvt.Is_Instance_creation_complete( p_ext_attrib_rec.INSTANCE_ID ) THEN

26199: );
26200:
26201:
26202:
26203: -- IF CSI_Instance_parties_vld_pvt.Is_Instance_creation_complete( p_ext_attrib_rec.INSTANCE_ID ) THEN
26204: -- Call create_transaction to create txn log
26205:
26206: CSI_TRANSACTIONS_PVT.Create_transaction
26207: ( p_api_version => p_api_version